Skip to content

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

2.2 KB
Raw Blame
- description: multiple statements on multiple lines
  input: "SELECT * FROM users;\n\tSELECT * FROM orders;\n\tSELECT * FROM products;"
  result:
    - text: SELECT * FROM users;
      baseline: 0
      start:
        line: 1
        column: 1
      end:
        line: 1
        column: 21
      range:
        start: 0
        end: 20
      empty: false
    - text: "\n\tSELECT * FROM orders;"
      baseline: 0
      start:
        line: 1
        column: 21
      end:
        line: 2
        column: 23
      range:
        start: 20
        end: 43
      empty: false
    - text: "\n\tSELECT * FROM products;"
      baseline: 1
      start:
        line: 2
        column: 23
      end:
        line: 3
        column: 25
      range:
        start: 43
        end: 68
      empty: false
- description: single statement
  input: SELECT * FROM users;
  result:
    - text: SELECT * FROM users;
      baseline: 0
      start:
        line: 1
        column: 1
      end:
        line: 1
        column: 21
      range:
        start: 0
        end: 20
      empty: false
- description: 'position semantic: leading newlines'
  input: "\n\nSELECT 1;"
  result:
    - text: "\n\nSELECT 1;"
      baseline: 0
      start:
        line: 1
        column: 1
      end:
        line: 3
        column: 10
      range:
        start: 0
        end: 11
      empty: false
- description: 'position semantic: leading spaces and newlines'
  input: "\n  \n  SELECT 1;"
  result:
    - text: "\n  \n  SELECT 1;"
      baseline: 0
      start:
        line: 1
        column: 1
      end:
        line: 3
        column: 12
      range:
        start: 0
        end: 15
      empty: false
- description: 'position semantic: multi-statement with leading whitespace'
  input: "SELECT 1;\n\n  SELECT 2;"
  result:
    - text: SELECT 1;
      baseline: 0
      start:
        line: 1
        column: 1
      end:
        line: 1
        column: 10
      range:
        start: 0
        end: 9
      empty: false
    - text: "\n\n  SELECT 2;"
      baseline: 0
      start:
        line: 1
        column: 10
      end:
        line: 3
        column: 12
      range:
        start: 9
        end: 22
      empty: false