From 4daf68a98418f2231a91a693eeb39ab639324a0c Mon Sep 17 00:00:00 2001 From: Yoan Le Clanche Date: Tue, 6 Dec 2022 13:47:43 +0100 Subject: [PATCH] Add readme for pilotsystems --- README_pilot.rst | 58 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 58 insertions(+) create mode 100644 README_pilot.rst diff --git a/README_pilot.rst b/README_pilot.rst new file mode 100644 index 00000000..743d3fe5 --- /dev/null +++ b/README_pilot.rst @@ -0,0 +1,58 @@ +Lancer en runserver: +> run-container-fg app + +Se connecter en bash +> docker exec -it teleforma_app_1 bash + +Lancer en bash +> run-container-fg app bash + +Lancer tout +> docker-compose up -d +Pour lancer juste postgres / redis (mais mieux vaut tout lancer et eteindre teleforma_app_1) +> docker-compose up -d redis db channels apache + +Nettoyage après un run-container : +> docker-compose down +> docker kill teleforma_app_1 +> docker rm teleforma_app_1 +> docker-compose down +> docker-compose up -d + + +Requete pour lancer un message de chat +> requests.post('http://localhost:8000/chat/messages', headers={'Authorization': 'Token 133d15a2e6c9e0171329d2327e8ec96446716115'}, data={'conference_id':7815}) + +DATABASE +======== + +Invite de commande SQL +> docker exec -it teleforma_db_1 psql -U teleforma + +Copier prod sur dockdev : +> scp pilot@malcom.parisson.com:/srv/crfpa-docker/var/backup/postgres.dump . +> cat postgres.dump | docker exec -i teleforma_db_1 pg_restore -U teleforma -d teleforma --clean + +Dump : +> docker exec teleforma_db_1 pg_dump -c -U teleforma teleforma | gzip > /path/to/dump.sql.gz + +Load : +> cat /path/to/dump.dump | docker exec -i teleforma_db_1 pg_restore -U teleforma -d teleforma --clean + +Drop DB : +> docker exec -it teleforma_db_1 dropdb --force -U teleforma teleforma + +Create DB +> docker exec -it teleforma_db_1 createdb -U teleforma teleforma -E utf-8 + +Importer DB : + +> docker exec -it teleforma_db_1 bash + +> bzip2 -d XXX.sql.bz2 si c'est une archive bz2 (apt-get update + apt-get install bzip2) + +> psql -dteleforma -Uteleforma < postgres.sql +(mot de passe : mysecretpassword) + +Pas nécessaire ? +> dropdb teleforma -U teleforma -- 2.39.5