database
Perform direct database operations on contest logging records, including add, delete, and SQL queries, with safeguards against unintended data wipe.
Instructions
Direct database operations on individual records.
These are ordinary writes (the Needs Approval tier — same as logging), so they can be globally allowed in the client for automation. The ONLY hard block is a whole-database wipe/overwrite, gated by N3FJP_ALLOW_DB_WIPE.
operations:
add_direct (fields={fldCall:..., fldBand:...}, exclude_dupes): insert a record directly, bypassing N3FJP's scoring. Prefer log's log_qso/ENTER.
delete (where="fldPrimaryID=123"): delete matching records. A missing or empty WHERE would clear the whole table and is refused unless N3FJP_ALLOW_DB_WIPE is on.
sql (sql="..."): run a raw SQL statement against the Access database. Only statements that could wipe/overwrite the whole database (DROP, TRUNCATE, unscoped DELETE/UPDATE) are refused unless N3FJP_ALLOW_DB_WIPE is on; scoped statements run normally.
checklog / openlog: ask N3FJP to reload new / all records.
sqlclose: close the SQL connection.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | No | ||
| where | No | ||
| fields | No | ||
| operation | Yes | ||
| exclude_dupes | No |