Database

The Data Console in the GUI handles data upload and exporting annotations. Sometimes, we want to manipulate the database directly. This can be done with SQL commands on the database, we also have some pre-defined functions that can take care of some basic actions.

The sqlite database can be found at ./instance/database.sqlite.

Reset and rebuild db from schema:

flask init-db

Add an admin account to the db:

flask add-admin

Save db tables to csv files:

flask save-db

the output can be found in ./output/