]>
Commit | Line | Data |
---|---|---|
1 | #!/bin/bash | |
2 | ||
3 | export PGPASSWORD="${PGPASSWORD:-$POSTGRES_PASSWORD}" | |
4 | psql=( psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --no-password ) | |
5 | ||
6 | for db in local_db ccontrol chanfix dronescan; do | |
7 | "${psql[@]}" --dbname postgres --set db="$db" <<-'EOSQL' | |
8 | CREATE DATABASE :"db"; | |
9 | EOSQL | |
10 | echo | |
11 | done | |
12 | ||
13 | echo "$0: Setting up cservice db" | |
14 | for sql_file in cservice.sql languages.sql language_table.sql cservice.help.sql cservice.web.sql cservice.config.sql cservice.addme.sql greeting.sql; do | |
15 | ${psql[@]} --dbname cservice < /gnuworld/doc/${sql_file} | |
16 | done | |
17 | ||
18 | echo "$0: Setting up ccontrol db" | |
19 | for sql_file in ccontrol.sql ccontrol.help.sql ccontrol.addme.sql ccontrol.commands.sql; do | |
20 | ${psql[@]} --dbname ccontrol < /gnuworld/doc/${sql_file} | |
21 | done | |
22 | ||
23 | echo "$0: Setting up chanfix db" | |
24 | for sql_file in chanfix.sql chanfix.languages.sql chanfix.language.english.sql chanfix.help.sql chanfix.addme.sql; do | |
25 | ${psql[@]} --dbname chanfix < /gnuworld/mod.openchanfix/doc/${sql_file} | |
26 | done | |
27 | ||
28 | echo "$0: Setting up dronescan db" | |
29 | ${psql[@]} --dbname dronescan < /gnuworld/doc/dronescan.sql | |
30 | ||
31 | echo "$0: Setting up local db" | |
32 | ${psql[@]} --dbname local_db < /gnuworld/doc/local_db.sql | |
33 | ||
34 | echo "$0: Loading themes into local_db..." | |
35 | for theme in $(find /cservice-web/docs/gnuworld/themes/data -name "*.sql"); do | |
36 | cat $theme | ${psql[@]} --dbname local_db | |
37 | done |