#!/bin/sh

cp cof/settings/secret.py gestioCOF/settings/secret.py

# Exit on error
set -e

. provisioning/move_apps_helpers.sh

echo "-----"

echo "»»» Stopping services…"
systemctl stop daphne
systemctl stop worker

echo "»»» Updating database…"
_psql <<SQL
BEGIN;
\echo Updating 'migrations' table…
UPDATE django_migrations SET app='cof' WHERE app='gestioncof';

\echo Updating 'content_type' table…
UPDATE django_content_type SET app_label='cof' WHERE app_label='gestioncof';

\echo Renaming gestioncof tables…
DO
\$\$
DECLARE
    r record;
BEGIN
    FOR r IN
        SELECT tablename FROM pg_tables
        WHERE schemaname='public' AND tablename LIKE 'gestioncof_%'
    LOOP
        EXECUTE '
            ALTER TABLE ' || quote_ident(r.tablename) || '
            RENAME TO ' || quote_ident(replace(r.tablename, 'gestioncof', 'cof'))
        ;
    END LOOP;
END
\$\$;
COMMIT;
SQL

echo "»»» Symlink secrets…"

echo "»»» Updating services…"
sed -i.bak -e 's/cof.settings/gestioCOF.settings/g; s/cof.asgi/gestioCOF.asgi/g' ${SERVICE_DAPHNE}
sed -i.bak -e 's/cof.settings/gestioCOF.settings/g' ${SERVICE_WORKER}

echo "»»» Restarting services…"
systemctl daemon-reload
systemctl start worker
systemctl start daphne

echo "-----"

echo "Looks Good To Me!!"

echo "If ok, you can delete '${SERVICE_DAPHNE}.bak' and '${SERVICE_WORKER}.bak'."