Mercurial > libervia-backend
annotate docker/pubsub/entrypoint.sh @ 4212:5f2d496c633f
core: get rid of `pickle`:
Use of `pickle` to serialise data was a technical legacy that was causing trouble to store
in database, to update (if a class was serialised, a change could break update), and to
security (pickle can lead to code execution).
This patch remove all use of Pickle in favour in JSON, notably:
- for caching data, a Pydantic model is now used instead
- for SQLAlchemy model, the LegacyPickle is replaced by JSON serialisation
- in XEP-0373 a class `PublicKeyMetadata` was serialised. New method `from_dict` and
`to_dict` method have been implemented to do serialisation.
- new methods to (de)serialise data can now be specified with Identity data types. It is
notably used to (de)serialise `path` of avatars.
A migration script has been created to convert data (for upgrade or downgrade), with
special care for XEP-0373 case. Depending of size of database, this migration script can
be long to run.
rel 443
| author | Goffi <goffi@goffi.org> |
|---|---|
| date | Fri, 23 Feb 2024 13:31:04 +0100 |
| 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 "$@" |