Mercurial > libervia-backend
annotate docker/pubsub/entrypoint.sh @ 3582:71516731d0aa
core (memory/sqla): database migration using Alembic:
Alembic database migration tool, which is the recommended one for SQLAlchemy has been
integrated. When a database is created, it will be used to stamp to current (head)
revision, otherwise, DB will be checked to see if it needs to be updated, and upgrade will
be triggered if necessary.
| author | Goffi <goffi@goffi.org> |
|---|---|
| date | Fri, 25 Jun 2021 17:55:23 +0200 |
| parents | 73e04040d577 |
| children | 31c84a32c897 |
| rev | line source |
|---|---|
| 3381 | 1 #!/bin/bash |
| 2 | |
| 3 # we first need to wait for PostgreSQL | |
| 4 # cf. https://stackoverflow.com/a/39028690 (thanks!) | |
| 5 | |
| 6 RETRIES=5 | |
| 7 | |
| 8 until psql -c "select 1" > /dev/null 2>&1 || [ $RETRIES -eq 0 ]; do | |
| 9 echo "Waiting for postgres server, $((RETRIES--)) remaining attempts…" | |
| 10 sleep 1 | |
| 11 done | |
| 12 | |
| 13 ori_dir=${PWD} | |
| 14 cd /src/sat_pubsub/db | |
| 15 | |
| 16 # PG should be OK, we now initialize the database. If it's already done, it will fail | |
| 17 # with exit code 3 | |
| 18 psql -v ON_ERROR_STOP=1 pubsub < pubsub.sql 2>/dev/null | |
| 19 case $? in | |
| 20 0) printf "database initialized\n" ;; | |
| 21 3) printf "database already exists\n" ;; | |
| 22 *) printf "can't initialize database, please check PostgreSQL container parameters\n" >&2 | |
| 23 exit 1 | |
| 24 ;; | |
| 25 esac | |
| 26 | |
| 27 cd $ori_dir | |
| 28 | |
|
3497
73e04040d577
docker: update following name changes:
Goffi <goffi@goffi.org>
parents:
3381
diff
changeset
|
29 exec /home/libervia/libervia_env/bin/twistd -n libervia-pubsub "$@" |