Dirk Vogt | 8e4fe81 | 2017-10-09 15:19:06 +0200 | [diff] [blame] | 1 | #!/bin/bash |
2 | |||||
3 | _db_conninfo=$1 | ||||
4 | |||||
5 | _sqlite_db_path=$2 | ||||
6 | |||||
7 | _db_cmdstr="psql --dbname=${_db_conninfo}" | ||||
8 | |||||
9 | |||||
10 | ( | ||||
11 | echo "BEGIN;"; | ||||
12 | cat create_tables.sql; | ||||
13 | echo "SET CONSTRAINTS ALL DEFERRED;"; | ||||
14 | sqlite $2 .dump | bash sqlite_dump_process.sh; | ||||
15 | echo "COMMIT"; | ||||
16 | ) | $_db_cmdstr | ||||
17 | |||||
18 | ( | ||||
19 | cat turn_to_boolean.sql; | ||||
20 | cat reset_sequences.sql; | ||||
21 | ) | $_db_cmdstr |