aboutsummaryrefslogtreecommitdiffstats
path: root/tests/travis/prepare_pgsql.sh
diff options
context:
space:
mode:
authorgit-marijus <mario@mariovavti.com>2017-05-07 15:06:45 +0200
committerGitHub <noreply@github.com>2017-05-07 15:06:45 +0200
commitbd3708870d04bd59d3a632945d1f4ff63640afe8 (patch)
tree783a4dc2f9e9e3bd915b5e38133e53e9a387f057 /tests/travis/prepare_pgsql.sh
parent2aa699d03e17091b92c55da0b16833b299b0d081 (diff)
parentf162508ad18b1fca9a5201f4956d52022bd941a8 (diff)
downloadvolse-hubzilla-bd3708870d04bd59d3a632945d1f4ff63640afe8.tar.gz
volse-hubzilla-bd3708870d04bd59d3a632945d1f4ff63640afe8.tar.bz2
volse-hubzilla-bd3708870d04bd59d3a632945d1f4ff63640afe8.zip
Merge pull request #756 from dawnbreak/QA_testing
:construction_worker::white_check_mark::bug: Import table structure in TravisCI.
Diffstat (limited to 'tests/travis/prepare_pgsql.sh')
-rwxr-xr-xtests/travis/prepare_pgsql.sh13
1 files changed, 10 insertions, 3 deletions
diff --git a/tests/travis/prepare_pgsql.sh b/tests/travis/prepare_pgsql.sh
index dcd83f3be..63c7388cb 100755
--- a/tests/travis/prepare_pgsql.sh
+++ b/tests/travis/prepare_pgsql.sh
@@ -30,8 +30,15 @@ echo "Preparing for PostgreSQL ..."
# Print out some PostgreSQL information
psql --version
# Why does this hang further execution of the job?
-psql -c "SELECT VERSION();" -U postgres
+psql -U postgres -c "SELECT VERSION();"
# Create Hubzilla database
-psql -c "DROP DATABASE IF EXISTS hubzilla;" -U postgres
-psql -c "CREATE DATABASE hubzilla;" -U postgres
+psql -U postgres -c "DROP DATABASE IF EXISTS hubzilla;"
+psql -U postgres -c "CREATE DATABASE hubzilla;"
+
+# Import table structure
+psql -U postgres -v ON_ERROR_STOP=1 hubzilla < ./install/schema_postgres.sql
+
+# Show databases and tables
+psql -U postgres -l
+psql -U postgres -d hubzilla -c "\dt;"