| 447 | // ==================== Debug ==================== |
| 448 | |
| 449 | getAiSchema(): Array<{ |
| 450 | name: string |
| 451 | columns: Array<{ name: string; type: string; notnull: boolean; pk: boolean }> |
| 452 | }> { |
| 453 | const db = this.getDb() |
| 454 | const tables = db |
| 455 | .prepare("SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%'") |
| 456 | .all() as Array<{ name: string }> |
| 457 | |
| 458 | return tables.map((t) => { |
| 459 | const columns = db.pragma(`table_info("${t.name}")`) as Array<{ |
| 460 | name: string |
| 461 | type: string |
| 462 | notnull: number |
| 463 | pk: number |
| 464 | }> |
| 465 | return { |
| 466 | name: t.name, |
| 467 | columns: columns.map((c) => ({ |
| 468 | name: c.name, |
| 469 | type: c.type, |
| 470 | notnull: !!c.notnull, |
| 471 | pk: !!c.pk, |
| 472 | })), |
| 473 | } |
| 474 | }) |
| 475 | } |
| 476 | |
| 477 | executeAiSQL(sql: string): { |
| 478 | columns: string[] |