aboutsummaryrefslogtreecommitdiffstats
path: root/tests/travis/prepare_pgsql.sh
diff options
context:
space:
mode:
authorgit-marijus <mario@mariovavti.com>2018-02-06 12:48:34 +0100
committerGitHub <noreply@github.com>2018-02-06 12:48:34 +0100
commit24a650d7ecc07e46a7d7cfb1ef3cd60cc7da791b (patch)
tree2a782957d6340dd0135eba8ca2db661827821d54 /tests/travis/prepare_pgsql.sh
parentcb042e32bc6d521050c48a5e4fe6c74f7a33ed4f (diff)
parent210c91398da573d3c44bd1ff5bee4c65128c8686 (diff)
downloadvolse-hubzilla-24a650d7ecc07e46a7d7cfb1ef3cd60cc7da791b.tar.gz
volse-hubzilla-24a650d7ecc07e46a7d7cfb1ef3cd60cc7da791b.tar.bz2
volse-hubzilla-24a650d7ecc07e46a7d7cfb1ef3cd60cc7da791b.zip
Merge pull request #971 from dawnbreak/QA_testing
UnitTests for database classes and bit cleanup and docu
Diffstat (limited to 'tests/travis/prepare_pgsql.sh')
-rwxr-xr-xtests/travis/prepare_pgsql.sh13
1 files changed, 9 insertions, 4 deletions
diff --git a/tests/travis/prepare_pgsql.sh b/tests/travis/prepare_pgsql.sh
index 63c7388cb..0175b9858 100755
--- a/tests/travis/prepare_pgsql.sh
+++ b/tests/travis/prepare_pgsql.sh
@@ -33,12 +33,17 @@ psql --version
psql -U postgres -c "SELECT VERSION();"
# Create Hubzilla database
-psql -U postgres -c "DROP DATABASE IF EXISTS hubzilla;"
-psql -U postgres -c "CREATE DATABASE hubzilla;"
+psql -U postgres -c "DROP DATABASE IF EXISTS travis_hubzilla;"
+psql -U postgres -v ON_ERROR_STOP=1 <<-EOSQL
+ CREATE USER travis_hz WITH PASSWORD 'hubzilla';
+ CREATE DATABASE travis_hubzilla;
+ ALTER DATABASE travis_hubzilla OWNER TO travis_hz;
+ GRANT ALL PRIVILEGES ON DATABASE travis_hubzilla TO travis_hz;
+EOSQL
# Import table structure
-psql -U postgres -v ON_ERROR_STOP=1 hubzilla < ./install/schema_postgres.sql
+psql -U travis_hz -v ON_ERROR_STOP=1 travis_hubzilla < ./install/schema_postgres.sql
# Show databases and tables
psql -U postgres -l
-psql -U postgres -d hubzilla -c "\dt;"
+psql -U postgres -d travis_hubzilla -c "\dt;"