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
544 B
544 B
UPDATE Records Example
This example shows how to update multiple records in a Notion database.
UPDATE Tasks SET Status = 'Done' WHERE Priority = 'Low';
This query:
- Updates all records in the Tasks database where Priority is 'Low'
- Sets their Status to 'Done'
Run with:
notion-sql query --database-id YOUR_DATABASE_ID --sql "UPDATE Tasks SET Status = 'Done' WHERE Priority = 'Low';" --execute
⚠️ Warning: Always test your WHERE clause first with a SELECT query to ensure you're updating the correct records!