forked from mtusi2026/mtusi2026lab7
27 lines
1.5 KiB
Bash
27 lines
1.5 KiB
Bash
#!/bin/sh
|
|
set -eu
|
|
|
|
: "${API_DB_USER:?API_DB_USER is required}"
|
|
: "${API_DB_PASSWORD:?API_DB_PASSWORD is required}"
|
|
: "${WORKER_DB_USER:?WORKER_DB_USER is required}"
|
|
: "${WORKER_DB_PASSWORD:?WORKER_DB_PASSWORD is required}"
|
|
: "${OUTBOX_DB_USER:?OUTBOX_DB_USER is required}"
|
|
: "${OUTBOX_DB_PASSWORD:?OUTBOX_DB_PASSWORD is required}"
|
|
|
|
psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" --set ON_ERROR_STOP=1 \
|
|
--set api_user="$API_DB_USER" --set api_password="$API_DB_PASSWORD" \
|
|
--set worker_user="$WORKER_DB_USER" --set worker_password="$WORKER_DB_PASSWORD" \
|
|
--set outbox_user="$OUTBOX_DB_USER" --set outbox_password="$OUTBOX_DB_PASSWORD" <<'SQL'
|
|
SELECT format('CREATE ROLE %I LOGIN PASSWORD %L', :'api_user', :'api_password') \gexec
|
|
SELECT format('CREATE ROLE %I LOGIN PASSWORD %L', :'worker_user', :'worker_password') \gexec
|
|
SELECT format('CREATE ROLE %I LOGIN PASSWORD %L', :'outbox_user', :'outbox_password') \gexec
|
|
SELECT format('GRANT CONNECT ON DATABASE %I TO %I', current_database(), :'api_user') \gexec
|
|
SELECT format('GRANT CONNECT ON DATABASE %I TO %I', current_database(), :'worker_user') \gexec
|
|
SELECT format('GRANT CONNECT ON DATABASE %I TO %I', current_database(), :'outbox_user') \gexec
|
|
GRANT USAGE ON SCHEMA public TO :"api_user", :"worker_user", :"outbox_user";
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA public
|
|
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO :"api_user", :"worker_user";
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA public
|
|
GRANT USAGE, SELECT ON SEQUENCES TO :"api_user", :"worker_user";
|
|
SQL
|