SiennaGridDB

Schema for the SQL database for Sienna Applications

Set pre-commit environment

Install a virtual environment

python -m venv .venv

Setup the python environment

python -m pip install -r requirements.txt

Setup pre-commit to run automatically on each commit.

pre-commit install

How to create the Schema

To create a database with the schema use the following command:

sqlite3 test.db < schema.sql

Testing data with some basic queries:

sqlite3 -table < dummy_data.sql