summaryrefslogtreecommitdiffstats
path: root/gen-data/databases
diff options
context:
space:
mode:
Diffstat (limited to 'gen-data/databases')
-rw-r--r--gen-data/databases/pagila.sh39
1 files changed, 0 insertions, 39 deletions
diff --git a/gen-data/databases/pagila.sh b/gen-data/databases/pagila.sh
deleted file mode 100644
index a01d818..0000000
--- a/gen-data/databases/pagila.sh
+++ /dev/null
@@ -1,39 +0,0 @@
-create_pagila()
-(
- testit()
- {
- debug "testing database"
-
- local cmd="psql -tA -d pagila -c \"select city from city where city = 'Banjul';\""
-
- out="$(admin_cmd "$cmd")"
- test "$out" = Banjul || return 1
- test "$(wc -l < pagila_init.log)" -gt 335 || return 1
-
- test "$({ grep ERROR | wc -l ; } < pagila_init.log)" -lt 2
- }
-
- debug "creating DB pagilla"
- INDENT="$INDENT "
-
- pagila="pagila-0.10.1"
- pagila_tarball="$pagila.zip"
- pagila_link="http://pgfoundry.org/frs/download.php/1719/$pagila_tarball"
-
- cached_download $pagila_link
-
- debug "unzipping tarball"
- unzip $pagila_tarball &>/dev/null || die "can not unzip pagila"
-
- pushd $pagila >/dev/null || die "can not switch directory"
- admin_cmd "createdb pagila --owner postgres" || die "can't create db"
- { su - postgres -c 'psql -d pagila' < pagila-schema.sql \
- && su - postgres -c 'psql -d pagila' < pagila-data.sql
- } &>pagila_init.log || die "can not initialize pagila"
-
- cp pagila_init.log /tmp
-
- testit || die "can not test"
-
- popd >/dev/null || die "can't go back"
-)