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
743 B
743 B
INSERT Record Example
This example shows how to insert a new record into a Notion database.
INSERT INTO Tasks (Name, Status, Priority) VALUES ('Review PR', 'Active', 'High');
This query:
- Inserts a new record into the Tasks database
- Sets Name to 'Review PR', Status to 'Active', and Priority to 'High'
Run with:
notion-sql query --database-id YOUR_DATABASE_ID --sql "INSERT INTO Tasks (Name, Status, Priority) VALUES ('Review PR', 'Active', 'High');"
Note: By default, notion-sql runs in dry-run mode. Add --execute to actually create the record:
notion-sql query --database-id YOUR_DATABASE_ID --sql "INSERT INTO Tasks (Name, Status, Priority) VALUES ('Review PR', 'Active', 'High');" --execute