TypeScript Lab: SQL Safety Gate

LAB / EXPLORATION

TypeScript Lab: SQL Safety Gate

Planned

LAB 110 — Validation & Safety
Reject transaction-control commands from editor SQL batches.

LAB TypeScript Lab: SQL Safety Gate Preview coming soon

LAB 110

TypeScript Lab: SQL Safety Gate

Concept

Input inspection protects transaction boundaries managed by the application.

Concept

Input inspection protects transaction boundaries managed by the application.

Objective & Explanation

What the project should make visible and why the concept matters.

Learning Target

Objective

Reject transaction-control commands from editor SQL batches.

Explanation

Input inspection protects transaction boundaries managed by the application.

Project Plan

Structure, technologies, data boundary, and source connection.

Structure

project/
├── package.json
├── tsconfig.json
├── index.html
├── styles.css
└── src/
    └── app.ts

Technologies

TypeScript
HTML
CSS

Data Layer

No persistent data layer. Keep all demonstration values inside the standalone project.

Sandbox Source

src/local-editor/server.ts → assertSafeBatchSql()

Build Instructions

Build only the focused behavior, then use the visual layer to inspect it.

Setup

Create the standalone project folder and listed files.

Implement

Implement the smallest version that demonstrates the concept.

Run & Inspect

Change one input and observe the visible output change.

Code & Configuration

Starter configuration plus the focused implementation example.

Focused TypeScript

Implement this behavior first, then alter the input.

function assertSafeBatchSql(sql: string): void {
  const transaction = sql.match(
    /\b(BEGIN|COMMIT|ROLLBACK|SAVEPOINT|RELEASE)\b/i
  );

  if (transaction) {
    throw new Error("Transaction control is not allowed here.");
  }
}

Starter Configuration

Keep the project independently buildable.

package.json

{
  "type": "module",
  "scripts": { "build": "tsc" },
  "devDependencies": { "typescript": "^7.0.2" }
}

tsconfig.json

{
  "compilerOptions": {
    "rootDir": "./src",
    "outDir": "./dist",
    "target": "ES2022",
    "module": "ES2022",
    "lib": ["ES2022", "DOM"],
    "strict": true,
    "sourceMap": true
  },
  "include": ["src/**/*.ts"]
}

Expected Visual Result

The output is the proof that the concept is working.

Visible Proof

The browser should visibly demonstrate: reject transaction-control commands from editor SQL batches.

Data: None