interface InsertParams {
  database: string;
  table: string;
  data: Record<string, any>;
}

interface InsertBatchParams {
  database: string;
  table: string;
  rows: Record<string, any>[];
}

interface SelectParams {
  database: string;
  table: string;
  filter?: Record<string, any>;
  limit?: number;
  offset?: number;
}

interface UpdateParams {
  database: string;
  table: string;
  id: string;
  data: Partial<Record<string, any>>;
}

interface DeleteParams {
  database: string;
  table: string;
  id: string;
}

interface SelectResult {
  rows: Record<string, any>[];
  total: number; // Wszystkie wiersze w tabeli
  filteredTotal: number; // Wiersze po filtrze
}

interface UpdateResult {
  success: boolean;
  id: string;
  updated: string[]; // Nazwy zaktualizowanych pól
}

import {
  insertRowTool,
  selectRowsTool,
  updateRowTool,
  deleteRowTool,
} from "./crud.tool";

// INSERT
const inserted = await insertRowTool.handler({
  database: "breaking-bad",
  table: "walter-white",
  data: { name: "Walter White", age: 50, occupation: "Chemistry teacher" },
});
// → { success: true, id: "a1b2c3d4-...", table: "walter-white" }

// SELECT z filtrem
const result = await selectRowsTool.handler({
  database: "breaking-bad",
  table: "walter-white",
  filter: { age: 50 },
  limit: 10,
});
// → { rows: [{ id: "a1b2...", name: "Walter White", ... }], total: 1, filteredTotal: 1 }

// UPDATE
const updated = await updateRowTool.handler({
  database: "breaking-bad",
  table: "walter-white",
  id: "a1b2c3d4-...",
  data: { occupation: "Meth manufacturer" },
});
// → { success: true, id: "a1b2c3d4-...", updated: ["occupation"] }

// DELETE
const deleted = await deleteRowTool.handler({
  database: "breaking-bad",
  table: "walter-white",
  id: "a1b2c3d4-...",
});
// → { success: true, id: "a1b2c3d4-..." }

stateDiagram-v2
    [*] -→ Registered
    Registered -→ Inserting: insert_row
    Inserting -→ Validating: validate against schema
    Validating -→ Appending: appendToCSV
    Validating -→ ValidationError: invalid data
    Appending -→ UpdatingIndex: success
    UpdatingIndex -→ Success
    Success -→ Registered

    Registered -→ Reading: select_rows
    Reading -→ Parsing: parseCSV
    Parsing -→ Filtering: apply filter
    Filtering -→ Success: return rows

    Registered -→ Updating: update_row
    Updating -→ Reading
    Reading -→ Merging: merge data
    Merging -→ Writing: writeCSV
    Writing -→ Success