Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- 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