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 +