Merge branch 'database'

[debbugs.git] / sql / dbicdump_command.sh

diff --git a/sql/dbicdump_command.sh b/sql/dbicdump_command.sh
new file mode 100755 (executable)
index 0000000..c957f8f
--- /dev/null
+++ b/sql/dbicdump_command.sh
@@ -0,0 +1,18 @@
+#!/bin/sh
+
+if [ -z "$DEBBUGS_SERVICE" ]; then
+    DEBBUGS_SERVICE="debbugs";
+fi;
+
+if ! [ -d "sql" ] || ! [ -d "Debbugs" ]; then 
+    echo "In the wrong directory"
+    exit 1;
+fi;
+
+dbicdump -I. -o dump_directory=. \
+    -o components='["InflateColumn::DateTime","TimeStamp"]' \
+    -o preserve_case=1 \
+    -o skip_load_external=1 \
+    -o exclude='qr/^dbix_class_deploymenthandler_versions$/' \
+    Debbugs::DB dbi:Pg:service=$DEBBUGS_SERVICE '' '';
+