Database

Database models and helpers working with SQLAlchemy.

Create (or drop) database

First have an empty database according to configured connection string. Then generate the schema in any of the following ways.

Using plain SQLAlchemy

$ . env/bin/activate
$ python
>>> from database import db
>>> db.create_all() # or db.drop_all()

Using Alembic migrations

$ . env/bin/activate
$ # alembic init migrations # done
$ # alembic revision --autogenerate -m "Initial revision" # done
$ alembic upgrade head

Running migrations

~ Perform any detectable model changes and run

$ . env/bin/activate
$ alembic revision --autogenerate -m "Model change description"
$ alembic upgrade head