]> gitweb.michael.orlitzky.com - mailshears.git/commitdiff
Add a quick script to load the test databases and fixtures for me.
authorMichael Orlitzky <michael@orlitzky.com>
Fri, 30 Oct 2015 03:24:25 +0000 (23:24 -0400)
committerMichael Orlitzky <michael@orlitzky.com>
Fri, 30 Oct 2015 03:24:25 +0000 (23:24 -0400)
bin/install-fixtures.sh [new file with mode: 0755]

diff --git a/bin/install-fixtures.sh b/bin/install-fixtures.sh
new file mode 100755 (executable)
index 0000000..815ba61
--- /dev/null
@@ -0,0 +1,21 @@
+#!/bin/sh
+
+dropdb --if-exists -U postgres agendav
+createdb -U postgres agendav
+psql -U postgres -d agendav < test/sql/agendav.sql
+psql -U postgres -d agendav < test/sql/agendav-fixtures.sql
+
+dropdb --if-exists -U postgres davical
+createdb -U postgres davical
+psql -U postgres -d davical < test/sql/davical.sql
+psql -U postgres -d davical < test/sql/davical-fixtures.sql
+
+dropdb --if-exists -U postgres postfixadmin
+createdb -U postgres postfixadmin
+psql -U postgres -d postfixadmin < test/sql/postfixadmin.sql
+psql -U postgres -d postfixadmin < test/sql/postfixadmin-fixtures.sql
+
+dropdb --if-exists -U postgres roundcube
+createdb -U postgres roundcube
+psql -U postgres -d roundcube < test/sql/roundcube.sql
+psql -U postgres -d roundcube < test/sql/roundcube-fixtures.sql