Server default values for booleans in the database schema
The server_default
values of booleans are set to 'f'
in the database schema. The correct value is 0
for SQLite, SQLAlchemy provides false()
for this. Currently, we don't notice this mistake since we do not rely on the database engine to set our defaults, but rather on SQLAlchemy. Still, we should use fix our current schema to set the correct defaults. For this we need to:
-
Add a migration script for this -
Change the values in database.py
-
Check if this change does not cause unintended behavior