Skip to content

Command Line

claude edited this page Nov 18, 2026 · 1 revision

Command line

For AIs that run commands (and for people who like a terminal): src/db.py reads and changes the database with plain SQL. In a download it is app/src/db.py, run with the bundled Python. Writes must set updated_by (see Rules-and-Invariants); the full column list is in Table-Reference.

usage: db.py [-h] [--file FILE] [--db DB] [--init] [sql]

Read or change the Job-O-Matic database.

    python3 src/db.py "SELECT id, name FROM people"
    python3 src/db.py "UPDATE people SET headline='x', updated_by='ai' WHERE id=1"
    python3 src/db.py --file changes.sql     (all statements saved together, or none)
    python3 src/db.py --init                 (create a blank database)

Every write must set updated_by to user, ai or app.

positional arguments:
  sql

options:
  -h, --help   show this help message and exit
  --file FILE
  --db DB
  --init

Clone this wiki locally