Changeset 352 for cpc/trunk/project/bin

Timestamp:

Aug 30, 2009, 2:44:06 AM (12 years ago)

Author:

teymour

Message:

Début des articles possibilité d'en créer pour la FAQ et les Organismes

File:

• cpc/trunk/project/bin/loadsql (modified) (1 diff)

cpc/trunk/project/bin/loadsql

@@ -1 +1 @@
 #!/bin/bash
 MYSQLID="-u root"
-echo "SET FOREIGN_KEY_CHECKS = 0;" > /tmp/drop.sql
-echo "SET FOREIGN_KEY_CHECKS = 0;" > /tmp/delete.sql
-echo "SHOW TABLES" | mysql $MYSQLID cpc  | grep -v Tables_  > /tmp/tables.sql
-cat /tmp/tables.sql | sed 's/^/DROP TABLE /' | sed 's/$/;/'  >> /tmp/drop.sql
-cat /tmp/drop.sql | mysql $MYSQLID cpc
-cat /tmp/tables.sql | sed 's/^/CREATE TABLE /' | sed 's/$/;/'  > /tmp/create.sql
-cat /tmp/create.sql | mysql $MYSQLID cpc
-cat /tmp/tables.sql | sed 's/^/DELETE FROM /' | sed 's/$/;/'  >> /tmp/delete.sql
+#echo "SET FOREIGN_KEY_CHECKS = 0;" > /tmp/drop.sql
+#echo "SET FOREIGN_KEY_CHECKS = 0;" > /tmp/delete.sql
+#echo "SHOW TABLES" | mysql $MYSQLID cpc  | grep -v Tables_  > /tmp/tables.sql
+#cat /tmp/tables.sql | sed 's/^/DROP TABLE /' | sed 's/$/;/'  >> /tmp/drop.sql
+#cat /tmp/drop.sql | mysql $MYSQLID cpc
+#cat /tmp/tables.sql | sed 's/^/CREATE TABLE /' | sed 's/$/;/'  > /tmp/create.sql
+#cat /tmp/create.sql | mysql $MYSQLID cpc
+#cat /tmp/tables.sql | sed 's/^/DELETE FROM /' | sed 's/$/;/'  >> /tmp/delete.sql
 php symfony doctrine:build-all-reload --no-confirmation
-cat /tmp/delete.sql | mysql $MYSQLID cpc
-rm /tmp/tables.sql /tmp/drop.sql /tmp/create.sql /tmp/delete.sql
+#cat /tmp/delete.sql | mysql $MYSQLID cpc
+#rm /tmp/tables.sql /tmp/drop.sql /tmp/create.sql /tmp/delete.sql
 zcat data/sql/data.sql.gz | grep -v '`blog`' | grep -v '`tag_template`' | mysql $MYSQLID cpc
-php symfony set:Vacances
+#php symfony set:Vacances