Context
FR-4.1.1: "Connection > Database > [Tables, Views, Stored Procedures, Functions, Triggers, Events]". FR-4.1.4: "Drag any object (table, column, function) into the SQL editor". FR-4.1.6: "Toggle to show/hide system databases".
Problem
No Events folder or backend event query exists. System databases are always hidden with no toggle. No schema object is draggable (only double-click insertion exists for tables/views, not functions). Columns are not tree nodes. The schema browser skips ~30% of the documented surface.
Files
- src/components/schema/SchemaTree.tsx:293
- src-tauri/crates/mas-core/src/schema/inspector.rs (no event query)
- src/lib/tauri-api.ts (no event command, no system-db toggle)
Repro
Inspect the schema tree — no Events. Search for "system database toggle" — none. Try to drag a users table to the editor — it inserts on double-click but cannot be dragged.
Expected
Tree includes Events (with edit/drop), system-DB toggle in settings, columns are child nodes, all object types have drag payloads consumed by Monaco.
Proposed fix
Scope L. Add get_events, get_event_ddl backend IPC; column child nodes; system-DB visibility state in useSchemaCache; drag payload API on FolderNode; Monaco onDrop consumer.
Acceptance
Tree includes events, optionally shows all four system DBs, and any object can be dragged into the editor with its escaped name inserted at drop position.
Needs human verify
No.
Context
FR-4.1.1: "Connection > Database > [Tables, Views, Stored Procedures, Functions, Triggers, Events]". FR-4.1.4: "Drag any object (table, column, function) into the SQL editor". FR-4.1.6: "Toggle to show/hide system databases".
Problem
No Events folder or backend event query exists. System databases are always hidden with no toggle. No schema object is draggable (only double-click insertion exists for tables/views, not functions). Columns are not tree nodes. The schema browser skips ~30% of the documented surface.
Files
Repro
Inspect the schema tree — no Events. Search for "system database toggle" — none. Try to drag a
userstable to the editor — it inserts on double-click but cannot be dragged.Expected
Tree includes Events (with edit/drop), system-DB toggle in settings, columns are child nodes, all object types have drag payloads consumed by Monaco.
Proposed fix
Scope L. Add
get_events,get_event_ddlbackend IPC; column child nodes; system-DB visibility state inuseSchemaCache; drag payload API onFolderNode; MonacoonDropconsumer.Acceptance
Tree includes events, optionally shows all four system DBs, and any object can be dragged into the editor with its escaped name inserted at drop position.
Needs human verify
No.