Changeset 454 for cpc/trunk/project/bin

Timestamp:

Sep 8, 2009, 10:28:39 AM (12 years ago)

Author:

teymour

Message:

parse tout & insersion sql

Location:

cpc/trunk/project/bin

Files:

• load_questions (modified) (1 diff)
• loadbatch (modified) (1 diff)
• loadsql (modified) (1 diff)

cpc/trunk/project/bin/load_questions

@@ -9 +9 @@
 cd -
 php symfony cc
-for file in $(ls batch/questions/xml)
+for file in $(ls batch/questions/input)
 do
     echo $file
-    cp batch/questions/xml/$file batch/questions/input/
+#    cp batch/questions/xml/$file batch/questions/input/
     php symfony load:Questions >> /tmp/load_questions.log
     php symfony cc

cpc/trunk/project/bin/loadbatch

@@ -7 +7 @@
 bash bin/load_commission
 bash bin/tag_seance
-bash bin/load_question
+bash bin/load_questions
 php symfony set:Vacances
-
+php symfony top:Deputes

cpc/trunk/project/bin/loadsql

@@ -1 +1 @@
 #!/bin/bash
 MYSQLID="-u root"
+DBNAME="cpc"
+
 #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
+#echo "SHOW TABLES" | mysql $MYSQLID $DBNAME  | 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/drop.sql | mysql $MYSQLID $DBNAME
 #cat /tmp/tables.sql | sed 's/^/CREATE TABLE /' | sed 's/$/;/'  > /tmp/create.sql
-#cat /tmp/create.sql | mysql $MYSQLID cpc
+#cat /tmp/create.sql | mysql $MYSQLID $DBNAME
 #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
+#cat /tmp/delete.sql | mysql $MYSQLID $DBNAME
 #rm /tmp/tables.sql /tmp/drop.sql /tmp/create.sql /tmp/delete.sql
-zcat data/sql/data.sql.gz | grep -v '`sf_guard' | grep -v '`tag_template`' | mysql $MYSQLID cpc
+zcat data/sql/data.sql.gz | mysql $MYSQLID $DBNAME
 #php symfony set:Vacances