Anthology Django

    sudo su postgres (login as the user "postgres", if normal user havent the right to access the database)
    psql

   CREATE DATABASE anthology;
   CREATE USER anthology_django WITH PASSWORD 'password';
   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';
   ALTER USER anthology_django CREATEDB;
   GRANT ALL PRIVILEGES ON DATABASE anthology TO anthology_django;
   CREATE EXTENSION postgis;

   psql
   DROP DATABASE anthology;
   CREATE DATABASE anthology;
   GRANT ALL PRIVILEGES ON DATABASE anthology TO anthology_django;

ALTER ROLE anthology_django SUPERUSER;

DATABASES = {
    'default': {
        'ENGINE': 'django.contrib.gis.db.backends.postgis',
        'NAME': 'anthology',
        'USER': 'anthology_django',
        'PASSWORD': 'password',
        'HOST': 'localhost',
        'PORT': 5432,
    }
}

$ git clone git@framagit.org:anthologie-palatine/anthologyontology.git
$ cd anthologyontology

$ python3 -m venv venv
$ source venv/bin/activate
$ pip install -r requirements.txt

$ brew install postgis
$ brew services start postgresql

$ pg_isready

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

$ createuser $POSTGRES_USER
$ createdb $POSTGRES_DB --owner=$POSTGRES_USER

$ psql --username "david" --dbname "$POSTGRES_DB"
=# ALTER USER "anthology_django" CREATEDB;
=# CREATE EXTENSION postgis;

$ 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 < ap_db_2021….sql

$ python django/manage.py migrate

$ python django/manage.py shell_plus
>>> user = User.objects.create_user(username='david', email='david@example.org', 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)

$ python django/manage.py shell_plus
>>> admin = User.objects.all()[0]
>>> admin.set_password("password")
>>> admin.save()

$ python django/manage.py runserver