entrouvert
/
misc-cazino
17
0
Fork 0
Code Issues Pull Requests Releases Activity

metz: do not rename schemas

This commit is contained in:
Emmanuel Cazenave 2021-10-21 17:30:46 +02:00
parent f0a71ccc98
commit 159e68d94f
1 changed files with 0 additions and 22 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

22
metz/restore_from_prod.sh Normal file → Executable file
View File

@ -3,25 +3,15 @@
set -xe
# DROP LOCAL schemas
psql -c "DROP SCHEMA IF EXISTS authentic_dev_publik_love CASCADE;" authentic2_multitenant
psql -c "DROP SCHEMA IF EXISTS connexion_services_metzmetropole_fr CASCADE;" authentic2_multitenant
psql -c "DROP SCHEMA IF EXISTS bijoe_dev_publik_love CASCADE;" bijoe
psql -c "DROP SCHEMA IF EXISTS wcs_dev_publik_love CASCADE;" bijoe
psql -c "DROP SCHEMA IF EXISTS statistiques_services_metzmetropole_fr CASCADE;" bijoe
psql -c "DROP SCHEMA IF EXISTS demarches_services_metzmetropole_fr CASCADE;" bijoe
psql -c "DROP SCHEMA IF EXISTS chrono_dev_publik_love CASCADE;" chrono
psql -c "DROP SCHEMA IF EXISTS agendas_services_metzmetropole_fr CASCADE;" chrono
psql -c "DROP SCHEMA IF EXISTS agent_combo_dev_publik_love CASCADE;" combo
psql -c "DROP SCHEMA IF EXISTS combo_dev_publik_love CASCADE;" combo
psql -c "DROP SCHEMA IF EXISTS agents_services_metzmetropole_fr CASCADE;" combo
psql -c "DROP SCHEMA IF EXISTS services_metzmetropole_fr CASCADE;" combo
psql -c "DROP SCHEMA IF EXISTS fargo_dev_publik_love CASCADE;" fargo
psql -c "DROP SCHEMA IF EXISTS porte_doc_services_metzmetropole_fr CASCADE;" fargo
psql -c "DROP SCHEMA IF EXISTS hobo_dev_publik_love CASCADE;" hobo
psql -c "DROP SCHEMA IF EXISTS hobo_services_metzmetropole_fr CASCADE;" hobo
psql -c "DROP SCHEMA IF EXISTS passerelle_dev_publik_love CASCADE;" passerelle
psql -c "DROP SCHEMA IF EXISTS passerelle_services_metzmetropole_fr CASCADE;" passerelle
psql -c "DROP DATABASE IF EXISTS wcs_wcs_dev_publik_love;"
psql -c "DROP DATABASE IF EXISTS wcs_demarches_services_metzmetropole_fr;"
@ -59,15 +49,3 @@ pg_restore --dbname=hobo --no-owner /tmp/hobo_services_metzmetropole_fr.dump
pg_restore --dbname=passerelle --no-owner /tmp/passerelle_services_metzmetropole_fr.dump
psql -c "CREATE DATABASE wcs_demarches_services_metzmetropole_fr WITH OWNER = cazino;"
pg_restore --dbname=wcs_demarches_services_metzmetropole_fr --no-owner /tmp/wcs_demarches_services_metzmetropole_fr.dump
# rename schemas
psql -c "ALTER SCHEMA connexion_services_metzmetropole_fr RENAME TO authentic_dev_publik_love;" authentic2_multitenant
psql -c "ALTER SCHEMA statistiques_services_metzmetropole_fr RENAME TO bijoe_dev_publik_love;" bijoe
psql -c "ALTER SCHEMA demarches_services_metzmetropole_fr RENAME TO wcs_dev_publik_love;" bijoe
psql -c "ALTER SCHEMA agendas_services_metzmetropole_fr RENAME TO chrono_dev_publik_love;" chrono
psql -c "ALTER SCHEMA agents_services_metzmetropole_fr RENAME TO agent_combo_dev_publik_love;" combo
psql -c "ALTER SCHEMA services_metzmetropole_fr RENAME TO combo_dev_publik_love;" combo
psql -c "ALTER SCHEMA porte_doc_services_metzmetropole_fr RENAME TO fargo_dev_publik_love;" fargo
psql -c "ALTER SCHEMA hobo_services_metzmetropole_fr RENAME TO hobo_dev_publik_love;" hobo
psql -c "ALTER SCHEMA passerelle_services_metzmetropole_fr RENAME TO passerelle_dev_publik_love;" passerelle
psql -c "ALTER DATABASE wcs_demarches_services_metzmetropole_fr RENAME TO wcs_wcs_dev_publik_love;"