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
19 lines
551 B
Markdown
19 lines
551 B
Markdown
# DELETE Records Example
|
|
|
|
This example shows how to delete records from a Notion database.
|
|
|
|
```sql
|
|
DELETE FROM Tasks WHERE Status = 'Archived' AND Created < '2024-01-01';
|
|
```
|
|
|
|
This query:
|
|
- Deletes records from the Tasks database
|
|
- Only deletes archived records created before January 1, 2024
|
|
|
|
Run with:
|
|
```bash
|
|
notion-sql query --database-id YOUR_DATABASE_ID --sql "DELETE FROM Tasks WHERE Status = 'Archived' AND Created < '2024-01-01';" --execute
|
|
```
|
|
|
|
⚠️ Warning: Deletions are permanent. Always backup your data before running DELETE queries!
|