60 lines
1.3 KiB
Bash
Executable file
60 lines
1.3 KiB
Bash
Executable file
#!/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'."
|