blob: a01d81889084671922f8c7fd9725ab77d82e7f64 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
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"
)
|
