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
18 lines
537 B
Markdown
18 lines
537 B
Markdown
# Basic SELECT Query
|
|
|
|
This example shows how to query a Notion database and retrieve specific columns.
|
|
|
|
```sql
|
|
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:
|
|
```bash
|
|
notion-sql query --database-id YOUR_DATABASE_ID --sql "SELECT Name, Status, Priority FROM Tasks WHERE Status = 'Active' ORDER BY Priority DESC;"
|
|
```
|