Skip to content

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

6.3 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 test SET test.c1 = 3 WHERE test.b1 = 3;
    UPDATE test SET test.c1 = 4 WHERE test.b1 = 4;
    UPDATE test SET test.c1 = 5 WHERE test.b1 = 5;
    UPDATE test SET test.c1 = 6 WHERE test.b1 = 6;
    UPDATE test SET test.c1 = 7 WHERE test.b1 = 7;
  result:
    - statement: |-
        SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
          SELECT [db].[dbo].[test].* FROM test WHERE test.b1 = 1
          UNION
          SELECT [db].[dbo].[test].* FROM test WHERE test.b1 = 2
          UNION
          SELECT [db].[dbo].[test].* FROM test WHERE test.b1 = 3
          UNION
          SELECT [db].[dbo].[test].* FROM test WHERE test.b1 = 4
          UNION
          SELECT [db].[dbo].[test].* FROM test WHERE test.b1 = 5
          UNION
          SELECT [db].[dbo].[test].* FROM test WHERE test.b1 = 6
          UNION
          SELECT [db].[dbo].[test].* FROM test WHERE test.b1 = 7) AS backup_table;
      sourceschema: dbo
      sourcetablename: test
      targettablename: rollback_test_db
      startposition:
        line: 1
        column: 0
      endposition:
        line: 7
        column: 45
- input: |-
    DELETE FROM t_alias
    FROM test AS t_alias
    WHERE t_alias.c1 = 1;
  result:
    - statement: |-
        SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
          SELECT [t_alias].* FROM test AS t_alias WHERE t_alias.c1 = 1) AS backup_table;
      sourceschema: dbo
      sourcetablename: test
      targettablename: rollback_test_db
      startposition:
        line: 1
        column: 0
      endposition:
        line: 3
        column: 20
- input: |-
    UPDATE t_alias
    SET t_alias.c1 = 2
    FROM test AS t_alias
    WHERE t_alias.c1 = 1;
  result:
    - statement: |-
        SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
          SELECT [t_alias].* FROM test AS t_alias WHERE t_alias.c1 = 1) AS backup_table;
      sourceschema: dbo
      sourcetablename: test
      targettablename: rollback_test_db
      startposition:
        line: 1
        column: 0
      endposition:
        line: 4
        column: 20
- input: |-
    DELETE FROM test
    FROM test JOIN test2 ON test.c1 = test2.c1
    WHERE test.c1 = 1;
  result:
    - statement: |-
        SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
          SELECT [db].[dbo].[test].* FROM test JOIN test2 ON test.c1 = test2.c1 WHERE test.c1 = 1) AS backup_table;
      sourceschema: dbo
      sourcetablename: test
      targettablename: rollback_test_db
      startposition:
        line: 1
        column: 0
      endposition:
        line: 3
        column: 17
- input: |-
    UPDATE test
    SET test.c1 = 2
    FROM test JOIN test2 ON test.c1 = test2.c1
    WHERE test.c1 = 1;
  result:
    - statement: |-
        SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
          SELECT [db].[dbo].[test].* FROM test JOIN test2 ON test.c1 = test2.c1 WHERE test.c1 = 1) AS backup_table;
      sourceschema: dbo
      sourcetablename: test
      targettablename: rollback_test_db
      startposition:
        line: 1
        column: 0
      endposition:
        line: 4
        column: 17
- input: |-
    DELETE FROM test1 WHERE c1 = 1;
    UPDATE test SET test.c1 = 2 WHERE test.c1 = 1;
  result:
    - statement: |-
        SELECT * INTO [backupDB].[dbo].[rollback_test1_db] FROM (
          SELECT [db].[dbo].[test1].* FROM test1 WHERE c1 = 1) AS backup_table;
      sourceschema: dbo
      sourcetablename: test1
      targettablename: rollback_test1_db
      startposition:
        line: 1
        column: 0
      endposition:
        line: 1
        column: 30
    - statement: |-
        SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
          SELECT [db].[dbo].[test].* FROM test WHERE test.c1 = 1) AS backup_table;
      sourceschema: dbo
      sourcetablename: test
      targettablename: rollback_test_db
      startposition:
        line: 2
        column: 0
      endposition:
        line: 2
        column: 45
- input: DELETE FROM test WHERE c1 = 1;
  result:
    - statement: |-
        SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
          SELECT [db].[dbo].[test].* FROM test WHERE c1 = 1) AS backup_table;
      sourceschema: dbo
      sourcetablename: test
      targettablename: rollback_test_db
      startposition:
        line: 1
        column: 0
      endposition:
        line: 1
        column: 29
- input: UPDATE test SET c1 = 1 WHERE c1=2;
  result:
    - statement: |-
        SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
          SELECT [db].[dbo].[test].* FROM test WHERE c1=2) AS backup_table;
      sourceschema: dbo
      sourcetablename: test
      targettablename: rollback_test_db
      startposition:
        line: 1
        column: 0
      endposition:
        line: 1
        column: 33
- input: |-
    UPDATE test SET test.c1 = 2 WHERE test.c1 = 1;
    UPDATE test SET test.c1 = 3 WHERE test.c1 = 5;
  result:
    - statement: |-
        SELECT * INTO [backupDB].[dbo].[rollback_test_db] FROM (
          SELECT [db].[dbo].[test].* FROM test WHERE test.c1 = 1
          UNION
          SELECT [db].[dbo].[test].* FROM test WHERE test.c1 = 5) AS backup_table;
      sourceschema: dbo
      sourcetablename: test
      targettablename: rollback_test_db
      startposition:
        line: 1
        column: 0
      endposition:
        line: 2
        column: 45
- input: DELETE FROM employees WHERE department_id = 10;
  result:
    - statement: |-
        SELECT * INTO [backupDB].[dbo].[rollback_employees_db] FROM (
          SELECT [db].[dbo].[employees].* FROM employees WHERE department_id = 10) AS backup_table;
      sourceschema: dbo
      sourcetablename: employees
      targettablename: rollback_employees_db
      startposition:
        line: 1
        column: 0
      endposition:
        line: 1
        column: 46
- input: UPDATE positions SET title = 'Senior Engineer' WHERE position_id = 1;
  result:
    - statement: |-
        SELECT * INTO [backupDB].[dbo].[rollback_positions_db] FROM (
          SELECT [db].[dbo].[positions].* FROM positions WHERE position_id = 1) AS backup_table;
      sourceschema: dbo
      sourcetablename: positions
      targettablename: rollback_positions_db
      startposition:
        line: 1
        column: 0
      endposition:
        line: 1
        column: 68