| #!/bin/bash | |
| _db_conninfo=$1 | |
| _sqlite_db_path=$2 | |
| _db_cmdstr="psql --dbname=${_db_conninfo}" | |
| ( | |
| echo "BEGIN;"; | |
| cat create_tables.sql; | |
| echo "SET CONSTRAINTS ALL DEFERRED;"; | |
| sqlite $2 .dump | bash sqlite_dump_process.sh; | |
| echo "COMMIT"; | |
| ) | $_db_cmdstr | |
| ( | |
| cat turn_to_boolean.sql; | |
| cat reset_sequences.sql; | |
| ) | $_db_cmdstr |