SQL-S6 — SQLite Test Coverage & Verification

[ZhuchkaTriplesix]

Epic: #194
Depends on: #198, #199, #200, #201, #202 (SQL-S1 to SQL-S5)
Source: docs/planned-0.4.5.md

Goal

Write unit, widget, and integration tests to ensure robustness and high reliability of SQLite features.

Files

• test/core/database/drivers/sqlite/ (add tests)
• test/features/workspace/sqlite_workspace_test.dart (new)

Implementation

• Unit tests for SQLite catalog parsing with various tables, views, and complex types.
• Unit tests for read-only constraint (asserting writes fail when enabled).
• Widget tests for connection form, file selection path binding, and workspace query executions.
• Ensure zero regression in other drivers.

Acceptance Criteria

• High test coverage on SQLite driver and catalog resolver (>85%).
• All tests run and pass locally.
• Test coverage checks are added/updated.
• Code is clean and passes flutter analyze.