interface CreateTableParams {
  database: string;
  table: string;
  columns: ColumnDef[];
  description?: string;
}

interface DeleteTableParams {
  database: string;
  table: string;
  confirm: boolean;
}

interface TableQueryParams {
  database: string;
  table: string;
}

interface CreateTableResult {
  success: boolean;
  database: string;
  table: string;
  columnCount: number;
}

interface DeleteTableResult {
  success: boolean;
  deletedFiles: string[];
}

interface SchemaResult {
  database: string;
  table: string;
  columns: ColumnDef[];
  createdAt: string;
  description?: string;
}

import {
  createTableTool,
  listTablesTool,
  deleteTableTool,
  getTableSchemaTool,
} from "./table.tool";

// create_table
const result = await createTableTool.handler({
  database: "breaking-bad",
  table: "walter-white",
  columns: [
    { name: "id", type: "string", primaryKey: true },
    { name: "name", type: "string", required: true },
    { name: "age", type: "number" },
    { name: "occupation", type: "string" },
  ],
  description: "Główny bohater Breaking Bad",
});
// → { success: true, database: "breaking-bad", table: "walter-white", columnCount: 4 }

// list_tables
const tables = await listTablesTool.handler({ database: "breaking-bad" });
// → { database: "breaking-bad", tables: [...], total: 2 }

// get_table_schema
const schema = await getTableSchemaTool.handler({
  database: "breaking-bad",
  table: "walter-white",
});
// → { database: "breaking-bad", table: "walter-white", columns: [...], createdAt: "..." }

stateDiagram-v2
    [*] -→ Registered
    Registered -→ Invoked
    Invoked -→ Validating
    Validating -→ Executing
    Validating -→ ParamError: invalid params
    Executing -→ NotFound: DB_TABLE not found
    Executing -→ Duplicate: table exists
    Executing -→ Success
    Success -→ Registered
    NotFound -→ Registered: error response
    ParamError -→ Registered: error response
    Duplicate -→ Registered: error response