## Reboot the API from DB backup

Download from https://framagit.org/anthologie-palatine/anthologyontology/-/pipelines (dernier en date : https://framagit.org/anthologie-palatine/anthologyontology/-/jobs/1760822 )

$ export POSTGRES_DB=anthology
$ export POSTGRES_USER=anthology_django
$ export POSTGRES_PASSWORD=password

$ dropdb $POSTGRES_DB
$ createdb $POSTGRES_DB --owner=$POSTGRES_USER
$ psql --username "david" --dbname "$POSTGRES_DB"
ALTER USER "anthology_django" CREATEDB;

$ psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB"
ALTER ROLE "anthology_django" SET client_encoding TO 'utf8';
ALTER ROLE "anthology_django" SET default_transaction_isolation TO 'read committed';
ALTER ROLE "anthology_django" SET timezone TO 'UTC-4';
GRANT ALL PRIVILEGES ON DATABASE "anthology" TO "anthology_django";

$ psql $POSTGRES_DB < ../anthologyontology-misc/ap-prod-db-2022-….sql (dernier dump)
$ DJANGO_SETTINGS_MODULE=anthology.settings.local python manage.py migrate

$ DJANGO_SETTINGS_MODULE=anthology.settings.local python manage.py shell_plus
>>> user = User.objects.create_user(username='david', email='[e-mail]', password='password')
>>> perm_can_add = Permission.objects.get(codename="can_add_mlgr")
>>> perm_own_passages = Permission.objects.get(codename="manage_own_passages")
>>> perm_own_mlgr = Permission.objects.get(codename="manage_own_mlgr")
>>> editors, _ = Group.objects.get_or_create(name="Editors")
>>> editors.permissions.add(perm_own_passages, perm_own_mlgr, perm_can_add)
>>> user.groups.add(editors)

>>> admin = User.objects.all()[0]
>>> admin.set_password("password")
>>> admin.save()