Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

5.1 KB
Raw Blame
- statement: CREATE TABLE book(id int, creatorId int);
  want:
    - status: 2
      code: 302
      title: NAMING_COLUMN
      content: '`book`.`creatorId` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: CREATE TABLE book(id int, gbhzmtchhsjzyrhdroxmyouwloxqezowdvhcbqalqcgqhfbjnvmhwrbggezmzeusx int);
  want:
    - status: 2
      code: 302
      title: NAMING_COLUMN
      content: '`book`.`gbhzmtchhsjzyrhdroxmyouwloxqezowdvhcbqalqcgqhfbjnvmhwrbggezmzeusx` mismatches column naming convention, its length should be within 64 characters'
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: CREATE TABLE book(id int, creator_id int);
- statement: |-
    CREATE TABLE book(id int, creator_id int);
    ALTER TABLE book RENAME COLUMN creator_id TO creatorId;
    ALTER TABLE book CHANGE COLUMN creatorId gbhzmtchhsjzyrhdroxmyouwloxqezowdvhcbqalqcgqhfbjnvmhwrbggezmzeusx int;
  want:
    - status: 2
      code: 302
      title: NAMING_COLUMN
      content: '`book`.`creatorId` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
      startposition:
        line: 2
        column: 0
      endposition: null
    - status: 2
      code: 302
      title: NAMING_COLUMN
      content: '`book`.`gbhzmtchhsjzyrhdroxmyouwloxqezowdvhcbqalqcgqhfbjnvmhwrbggezmzeusx` mismatches column naming convention, its length should be within 64 characters'
      startposition:
        line: 3
        column: 0
      endposition: null
- statement: |
    ALTER TABLE tech_book RENAME COLUMN id TO creator_id;
    ALTER TABLE tech_book RENAME COLUMN creator_id TO gbhzmtchhsjzyrhdroxmyouwloxqezowdvhcbqalqcgqhfbjnvmhwrbggezmzeusx;
  want:
    - status: 2
      code: 302
      title: NAMING_COLUMN
      content: '`tech_book`.`gbhzmtchhsjzyrhdroxmyouwloxqezowdvhcbqalqcgqhfbjnvmhwrbggezmzeusx` mismatches column naming convention, its length should be within 64 characters'
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE book(
      id int,
      creator_id int,
      created_ts timestamp,
      updater_id int,
      updated_ts timestamp);
    ALTER TABLE book CHANGE COLUMN creator_id creatorId int;
  want:
    - status: 2
      code: 302
      title: NAMING_COLUMN
      content: '`book`.`creatorId` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
      startposition:
        line: 7
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE book (id INT);
    ALTER TABLE book CHANGE COLUMN id creator_id int;
- statement: ALTER TABLE tech_book DROP COLUMN id;
- statement: |-
    CREATE TABLE book(
      id int,
      creator_id int,
      created_ts timestamp,
      updated_ts timestamp);
    ALTER TABLE book ADD COLUMN contentString varchar(255);
  want:
    - status: 2
      code: 302
      title: NAMING_COLUMN
      content: '`book`.`contentString` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
      startposition:
        line: 6
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE book(
      id int,
      creator_id int,
      created_ts timestamp,
      updated_ts timestamp);
    ALTER TABLE book ADD COLUMN (personAge INT, contentString varchar(255));
  want:
    - status: 2
      code: 302
      title: NAMING_COLUMN
      content: '`book`.`contentString` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
      startposition:
        line: 6
        column: 0
      endposition: null
    - status: 2
      code: 302
      title: NAMING_COLUMN
      content: '`book`.`personAge` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
      startposition:
        line: 6
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE book(
      id int,
      createdTs timestamp,
      updaterId int,
      updated_ts timestamp);
    CREATE TABLE student(
      id int,
      createdTs timestamp,
      updatedTs timestamp);
  want:
    - status: 2
      code: 302
      title: NAMING_COLUMN
      content: '`book`.`createdTs` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
      startposition:
        line: 3
        column: 0
      endposition: null
    - status: 2
      code: 302
      title: NAMING_COLUMN
      content: '`book`.`updaterId` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
      startposition:
        line: 4
        column: 0
      endposition: null
    - status: 2
      code: 302
      title: NAMING_COLUMN
      content: '`student`.`createdTs` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
      startposition:
        line: 8
        column: 0
      endposition: null
    - status: 2
      code: 302
      title: NAMING_COLUMN
      content: '`student`.`updatedTs` mismatches column naming convention, naming format should be "^[a-z]+(_[a-z]+)*$"'
      startposition:
        line: 9
        column: 0
      endposition: null