[Alba-desarrollo] SVN Alba r5446 - prosistem/alba/trunk/alba/data/sql

[commits en pressenter.com.ar]

Author: josx
Date: 2008-02-06 23:13:39 -0200 (Wed, 06 Feb 2008)
New Revision: 5446

Modified:
   prosistem/alba/trunk/alba/data/sql/updatedb.sh
Log:
Se agrego soporte para actualizar la base de datos para pgsql

Modified: prosistem/alba/trunk/alba/data/sql/updatedb.sh
===================================================================
--- prosistem/alba/trunk/alba/data/sql/updatedb.sh	2008-02-06 20:24:52 UTC (rev 5445)
+++ prosistem/alba/trunk/alba/data/sql/updatedb.sh	2008-02-07 01:13:39 UTC (rev 5446)
@@ -5,10 +5,15 @@
 EJEMPLO="datos_desde_cero.sql"
 DSNARCHIVO=`cat ../../config/databases.yml | grep dsn: | tr -d " "`
 DSN=${DSNARCHIVO#dsn:*}
+DSNs=${DSN#mysql://*}
 
-#DSN="mysql://root:master@localhost/alba"
+if [ $DSN == $DSNs ]; then
+    DBSERVER="pgsql"
+else
+    DBSERVER="mysql"    
+fi
 
-DSNs=${DSN#mysql://*}
+DSNs=${DSN#pgsql://*}
 USERANDPASS=${DSNs%@*}
 USER=${USERANDPASS%:*}
 PASS=${USERANDPASS#*:}
@@ -26,10 +31,20 @@
     OPTION="-p$PASS"
 fi
 
-ENCODING="--default-character-set=utf8"
 
-mysqladmin --force -u $USER $OPTION  -h $SERVER drop $DB
-mysqladmin $ENCODING  --force -u $USER $OPTION  -h $SERVER create $DB
-mysql $ENCODING -u $USER $OPTION  -h $SERVER $DB < $SCHEMA
-mysql $ENCODING -u $USER $OPTION  -h $SERVER $DB < $EJEMPLO
-echo "DB Actualizada!"
+if [ $DBSERVER == "mysql" ]; then
+    ENCODING="--default-character-set=utf8"
+    mysqladmin --force -u $USER -p$PASS -h $SERVER drop $DB
+    mysqladmin $ENCODING --force -u $USER -p$PASS -h $SERVER create $DB
+    mysql $ENCODING -u $USER -p$PASS -h $SERVER $DB < $SCHEMA
+    mysql $ENCODING -u $USER -p$PASS -h $SERVER $DB < $EJEMPLO
+fi
+
+if [ $DBSERVER == "pgsql" ]; then
+    dropdb $DB -U $USER
+    createdb $DB -U $USER
+    psql $DB -U $USER < $SCHEMA
+    #psql $DB -U $USER < $EJEMPLO
+    ../../symfony alba-load-data principal data/fixtures/datos_desde_cero.yml
+fi
+