Skip to content

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

6.9 KB
Raw Blame
- input: |-
    UPDATE test SET test.c1 = 1 WHERE test.b1 = 1;
    UPDATE test SET test.c1 = 2 WHERE test.b1 = 2;
    UPDATE test11 SET test11.c1 = 2 WHERE test11.b1 = 2;
    UPDATE test SET test.c1 = 3 WHERE test.b1 = 3;
    UPDATE test SET test.c1 = 4 WHERE test.b1 = 4;
    UPDATE test11 SET test11.c1 = 2 WHERE test11.b1 = 4;
    UPDATE test SET test.c1 = 5 WHERE test.b1 = 5;
    UPDATE test SET test.c1 = 6 WHERE test.b1 = 6;
    UPDATE test11 SET test11.c1 = 2 WHERE test11.b1 = 6;
    UPDATE test SET test.c1 = 7 WHERE test.b1 = 7;
  result:
    - statement: |-
        CREATE TABLE "backupDB"."rollback_TEST11_DB" AS
          SELECT "DB"."TEST11".* FROM "DB"."TEST11" WHERE ROWID IN (
            SELECT "TEST11".ROWID FROM test11 WHERE test11.b1 = 2
            UNION
            SELECT "TEST11".ROWID FROM test11 WHERE test11.b1 = 4
            UNION
            SELECT "TEST11".ROWID FROM test11 WHERE test11.b1 = 6
          );
      sourceschema: DB
      sourcetablename: TEST11
      targettablename: rollback_TEST11_DB
      startposition:
        line: 3
        column: 0
      endposition:
        line: 9
        column: 50
    - statement: |-
        CREATE TABLE "backupDB"."rollback_TEST_DB" AS
          SELECT "DB"."TEST".* FROM "DB"."TEST" WHERE ROWID IN (
            SELECT "TEST".ROWID FROM test WHERE test.b1 = 1
            UNION
            SELECT "TEST".ROWID FROM test WHERE test.b1 = 2
            UNION
            SELECT "TEST".ROWID FROM test WHERE test.b1 = 3
            UNION
            SELECT "TEST".ROWID FROM test WHERE test.b1 = 4
            UNION
            SELECT "TEST".ROWID FROM test WHERE test.b1 = 5
            UNION
            SELECT "TEST".ROWID FROM test WHERE test.b1 = 6
            UNION
            SELECT "TEST".ROWID FROM test WHERE test.b1 = 7
          );
      sourceschema: DB
      sourcetablename: TEST
      targettablename: rollback_TEST_DB
      startposition:
        line: 1
        column: 0
      endposition:
        line: 10
        column: 44
- input: |-
    DELETE FROM db.test1 WHERE c1 = 1;
    UPDATE db.test SET test.c1 = 2 WHERE test.c1 = 1;
  result:
    - statement: |-
        CREATE TABLE "backupDB"."rollback_TEST1_DB" AS
          SELECT "DB"."TEST1".* FROM db.test1 WHERE c1 = 1;
      sourceschema: DB
      sourcetablename: TEST1
      targettablename: rollback_TEST1_DB
      startposition:
        line: 1
        column: 0
      endposition:
        line: 1
        column: 32
    - statement: |-
        CREATE TABLE "backupDB"."rollback_TEST_DB" AS
          SELECT "DB"."TEST".* FROM db.test WHERE test.c1 = 1;
      sourceschema: DB
      sourcetablename: TEST
      targettablename: rollback_TEST_DB
      startposition:
        line: 2
        column: 0
      endposition:
        line: 2
        column: 47
- input: UPDATE test  t SET t.c1 = 1 WHERE t.c1=2;
  result:
    - statement: |-
        CREATE TABLE "backupDB"."rollback_TEST_DB" AS
          SELECT "T".* FROM test  t WHERE t.c1=2;
      sourceschema: DB
      sourcetablename: TEST
      targettablename: rollback_TEST_DB
      startposition:
        line: 1
        column: 0
      endposition:
        line: 1
        column: 39
- input: DELETE FROM test  t WHERE t.c1 = 1;
  result:
    - statement: |-
        CREATE TABLE "backupDB"."rollback_TEST_DB" AS
          SELECT "T".* FROM test  t WHERE t.c1 = 1;
      sourceschema: DB
      sourcetablename: TEST
      targettablename: rollback_TEST_DB
      startposition:
        line: 1
        column: 0
      endposition:
        line: 1
        column: 33
- input: |-
    UPDATE test  t SET t.c1 = 2 WHERE t.c1 = 1 ;
    UPDATE test  t SET t.c1 = 3 WHERE t.c1 = 5 ;
  result:
    - statement: |-
        CREATE TABLE "backupDB"."rollback_TEST_DB" AS
          SELECT "DB"."TEST".* FROM "DB"."TEST" WHERE ROWID IN (
            SELECT "T".ROWID FROM test  t WHERE t.c1 = 1
            UNION
            SELECT "T".ROWID FROM test  t WHERE t.c1 = 5
          );
      sourceschema: DB
      sourcetablename: TEST
      targettablename: rollback_TEST_DB
      startposition:
        line: 1
        column: 0
      endposition:
        line: 2
        column: 41
- input: |-
    DELETE FROM test1  t WHERE t.c1 = 1;
    UPDATE test  t SET t.c1 = 2 WHERE t.c1 = 1;
  result:
    - statement: |-
        CREATE TABLE "backupDB"."rollback_TEST1_DB" AS
          SELECT "T".* FROM test1  t WHERE t.c1 = 1;
      sourceschema: DB
      sourcetablename: TEST1
      targettablename: rollback_TEST1_DB
      startposition:
        line: 1
        column: 0
      endposition:
        line: 1
        column: 34
    - statement: |-
        CREATE TABLE "backupDB"."rollback_TEST_DB" AS
          SELECT "T".* FROM test  t WHERE t.c1 = 1;
      sourceschema: DB
      sourcetablename: TEST
      targettablename: rollback_TEST_DB
      startposition:
        line: 2
        column: 0
      endposition:
        line: 2
        column: 41
- input: |-
    DELETE FROM test1 WHERE c1 = 1;
    UPDATE test SET test.c1 = 2 WHERE test.c1 = 1;
  result:
    - statement: |-
        CREATE TABLE "backupDB"."rollback_TEST1_DB" AS
          SELECT "TEST1".* FROM test1 WHERE c1 = 1;
      sourceschema: DB
      sourcetablename: TEST1
      targettablename: rollback_TEST1_DB
      startposition:
        line: 1
        column: 0
      endposition:
        line: 1
        column: 29
    - statement: |-
        CREATE TABLE "backupDB"."rollback_TEST_DB" AS
          SELECT "TEST".* FROM test WHERE test.c1 = 1;
      sourceschema: DB
      sourcetablename: TEST
      targettablename: rollback_TEST_DB
      startposition:
        line: 2
        column: 0
      endposition:
        line: 2
        column: 44
- input: DELETE FROM test WHERE c1 = 1;
  result:
    - statement: |-
        CREATE TABLE "backupDB"."rollback_TEST_DB" AS
          SELECT "TEST".* FROM test WHERE c1 = 1;
      sourceschema: DB
      sourcetablename: TEST
      targettablename: rollback_TEST_DB
      startposition:
        line: 1
        column: 0
      endposition:
        line: 1
        column: 28
- input: UPDATE test SET c1 = 1 WHERE c1=2;
  result:
    - statement: |-
        CREATE TABLE "backupDB"."rollback_TEST_DB" AS
          SELECT "TEST".* FROM test WHERE c1=2;
      sourceschema: DB
      sourcetablename: TEST
      targettablename: rollback_TEST_DB
      startposition:
        line: 1
        column: 0
      endposition:
        line: 1
        column: 32
- input: |-
    UPDATE test SET test.c1 = 2 WHERE test.c1 = 1 ;
    UPDATE test SET test.c1 = 3 WHERE test.c1 = 5 ;
  result:
    - statement: |-
        CREATE TABLE "backupDB"."rollback_TEST_DB" AS
          SELECT "DB"."TEST".* FROM "DB"."TEST" WHERE ROWID IN (
            SELECT "TEST".ROWID FROM test WHERE test.c1 = 1
            UNION
            SELECT "TEST".ROWID FROM test WHERE test.c1 = 5
          );
      sourceschema: DB
      sourcetablename: TEST
      targettablename: rollback_TEST_DB
      startposition:
        line: 1
        column: 0
      endposition:
        line: 2
        column: 44