james.maes
fb10ae20c3
- Fix clippy warnings in test code by adding #[allow(dead_code)] - Move all unit tests from source files to tests/ directory - Add integration tests for SQL parsing and schema operations - Create examples directory with 5 SQL query examples - Add Windows CI job to ci.yml for cross-platform coverage - Update Cargo.toml with documentation and readme fields - Add comprehensive clean room audit documentation All 39 tests passing, clippy clean, formatting verified
537 B
537 B
Basic SELECT Query
This example shows how to query a Notion database and retrieve specific columns.
SELECT Name, Status, Priority FROM Tasks WHERE Status = 'Active' ORDER BY Priority DESC;
This query:
- Selects three columns: Name, Status, and Priority
- Filters for records where Status equals 'Active'
- Orders results by Priority in descending order
Run with:
notion-sql query --database-id YOUR_DATABASE_ID --sql "SELECT Name, Status, Priority FROM Tasks WHERE Status = 'Active' ORDER BY Priority DESC;"