[kde-services-devel] r535 - trunk/scripts

[josef at new.kstuff.org]

Author: josef
Date: 2009-10-03 19:33:07 +0200 (Sat, 03 Oct 2009)
New Revision: 535

Added:
   trunk/scripts/hotstuff-db-update
Log:
- mass update script for database schema changes



Added: trunk/scripts/hotstuff-db-update
===================================================================
--- trunk/scripts/hotstuff-db-update	                        (rev 0)
+++ trunk/scripts/hotstuff-db-update	2009-10-03 17:33:07 UTC (rev 535)
@@ -0,0 +1,13 @@
+#!/bin/sh
+
+for i in /etc/hotstuff.d/*
+do
+	sysname=`basename $i | cut -d "." -f 1`
+	dbuser=`grep dbuser $i | sed -e 's/.*\"\\(.*\\)\";/\\1/'`
+	dbpass=`grep dbpass $i | sed -e 's/.*\"\\(.*\\)\";/\\1/'`
+	dbname=`grep dbname $i | sed -e 's/.*\"\\(.*\\)\";/\\1/'`
+	echo "== $sysname [$dbname] =="
+	echo $dbpass
+	psql --host=localhost --user=$dbuser --password $dbname < up.sql
+done
+


Property changes on: trunk/scripts/hotstuff-db-update
___________________________________________________________________
Name: svn:executable
   + *