Database

From GUI

The Data Console in the GUI handles data upload and exporting annotations. We can also view the data and annotations and download them directly from the Data Console.

From terminal

If you want to manipulate the database directly with SQL commands, it can be found at ./instance/database.sqlite . We also have some pre-defined command line functions that can take care of some basic actions:

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 then be found in ./output/

Remove all annotations for a given data id

flask remove-annotation-data -dataid <data id>

Remove a single annotation given the annotation id

remove-annotation -id <annotation id>