interface QueryFilter {
  column: string;
  operator:
    | "eq"
    | "neq"
    | "gt"
    | "gte"
    | "lt"
    | "lte"
    | "in"
    | "contains"
    | "startsWith"
    | "endsWith";
  value: any;
}

interface SearchCondition {
  column: string;
  query: string; // Substring do wyszukania
  caseSensitive?: boolean; // Domyślnie false
}

interface SortCondition {
  column: string;
  direction: "asc" | "desc";
}

interface QueryParams {
  database: string;
  table: string;
  filters?: QueryFilter[];
  search?: SearchCondition;
  sort?: SortCondition;
  limit?: number;
  offset?: number;
}

interface AggregateParams {
  database: string;
  table: string;
  column: string;
  operation: "count" | "sum" | "avg" | "min" | "max";
  filter?: Record<string, any>;
}

interface QueryResult {
  rows: Record<string, any>[];
  total: number;
  filteredTotal: number;
  page: number;
  totalPages: number;
}

interface AggregateResult {
  operation: string;
  column: string;
  result: number;
  count: number;
}

import { queryTableTool, aggregateTableTool } from "./query.tool";

// query_table — złożone zapytanie
const result = await queryTableTool.handler({
  database: "breaking-bad",
  table: "characters",
  filters: [
    { column: "age", operator: "gte", value: 30 },
    { column: "isAlive", operator: "eq", value: true },
  ],
  search: { column: "name", query: "white", caseSensitive: false },
  sort: { column: "age", direction: "desc" },
  limit: 20,
  offset: 0,
});
// → { rows: [{ name: "Walter White", age: 50, isAlive: false }, ...],
//     total: 12, filteredTotal: 2, page: 1, totalPages: 1 }

// aggregate_table — średnia wieku
const avg = await aggregateTableTool.handler({
  database: "breaking-bad",
  table: "characters",
  column: "age",
  operation: "avg",
});
// → { operation: "avg", column: "age", result: 38.5, count: 12 }

// aggregate_table — max wieku
const max = await aggregateTableTool.handler({
  database: "breaking-bad",
  table: "characters",
  column: "age",
  operation: "max",
});
// → { operation: "max", column: "age", result: 50, count: 12 }

stateDiagram-v2
    [*] -→ Registered
    Registered -→ Querying: query_table
    Querying -→ Loading: parseCSV
    Loading -→ Filtering: apply filters
    Filtering -→ Searching: apply search
    Searching -→ Sorting: apply sort
    Sorting -→ Paginating: limit/offset
    Paginating -→ Success: return results

    Registered -→ Aggregating: aggregate_table
    Aggregating -→ Loading
    Loading -→ ApplyingFilter: optional filter
    ApplyingFilter -→ Computing: count/sum/avg/min/max
    Computing -→ Success