Merge ~bjornt/maas:connect-to-snap-database into maas:master

[Björn Tillenius]

Add a script to make it easier to connect to the database the MAAS snap is using.

[Blake Rouse (blake-rouse)]

Looks good.

review: Approve

diff --git a/utilities/connect-to-snap-database b/utilities/connect-to-snap-database
 new file mode 100755
index 0000000..95c2beb
--- /dev/null
+++ b/utilities/connect-to-snap-database
@@ -0,0 +1,19 @@
+#!/bin/bash
+usage="$(basename "$0") [-h] [--help]
+
+Connect psql to the database used by the installed MAAS snap.
+
+If you have MAAS installed as a snap, this script will read the
+configuration file and connect the the snap's postgres database.
+
+It only works if the installed snap is configured to run the database server."
+
+if [ $1 == "-h" -o $1 == "--help" ];
+then
+    echo "$usage"
+    exit 1
+fi
+
+
+export PGPASS=$(sudo cat /var/snap/maas/current/regiond.conf | grep database_pass | sed 's/database_pass: \(.*\)/\1/')
+sudo psql -U maas -h /var/snap/maas/common/db -d maasdb