summaryrefslogtreecommitdiffstats
path: root/docker/init-invidious-db.sh
diff options
context:
space:
mode:
authorSandro Jäckel <sandro.jaeckel@gmail.com>2020-05-31 10:02:05 +0200
committerSandro Jäckel <sandro.jaeckel@gmail.com>2020-07-25 21:51:57 +0200
commit0b52d52f4aee4484c272a7bce21b7286115234e5 (patch)
tree537595dfb6194553bb3d7360d6d2cd6b9e047cae /docker/init-invidious-db.sh
parent6901d10d54c51f8e4038e6c6d850a86cecf2e885 (diff)
downloadinvidious-0b52d52f4aee4484c272a7bce21b7286115234e5.tar.gz
invidious-0b52d52f4aee4484c272a7bce21b7286115234e5.tar.bz2
invidious-0b52d52f4aee4484c272a7bce21b7286115234e5.zip
Use inbuilt init script
Diffstat (limited to 'docker/init-invidious-db.sh')
-rwxr-xr-xdocker/init-invidious-db.sh12
1 files changed, 12 insertions, 0 deletions
diff --git a/docker/init-invidious-db.sh b/docker/init-invidious-db.sh
new file mode 100755
index 00000000..c07c7770
--- /dev/null
+++ b/docker/init-invidious-db.sh
@@ -0,0 +1,12 @@
+#!/bin/sh
+set -eou pipefail
+
+psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/channels.sql
+psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/videos.sql
+psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/channel_videos.sql
+psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/users.sql
+psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/session_ids.sql
+psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/nonces.sql
+psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/annotations.sql
+psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/playlists.sql
+psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/playlist_videos.sql