From 2422a081a5be0d5ac5afb122361bc283da67341f Mon Sep 17 00:00:00 2001 From: Pavel Raiskup Date: Wed, 22 Oct 2014 08:54:05 +0200 Subject: big reorg: prepare for generalization Try to split into three separate components -> controller, tester, and 'tasks' (postgresql-tasks in our case). The controller component is the main part which is able to run the task remotely. Tester is more-like library for 'tasks' component (should be reusable on the raw git level). * controller: Almost separated component. * postgresql-tasks: Likewise. * tester: Likewise. --- gen-data/databases/pagila.sh | 39 --------------------------------------- 1 file changed, 39 deletions(-) delete mode 100644 gen-data/databases/pagila.sh (limited to 'gen-data/databases') 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" -) -- cgit