Magical real-time suggestions ready for you
Just run sh create_functions.sh and all functions will be added (I hope)
To start a freshly new database:
- Start the postgres container
docker compose up -d
It will automatically create the databases with postgis extensions in some of them
- From the main flask folder run the alembic upgrade
flask db upgrade
It will create all the tables and relationships
- From the db folder restore all the data
./restore_data.sh
It will restore all the data
If you want to dump all the data it is necessary to dump with the data-only flag! Otherwise there are problems with alembic since it will delete and recreate all the tables!
If you want you can run the script
./backup_data.sh
which will dump all the data of the different databases in the folder db_dump!
Evviva!