Changeset 454 for cpc/trunk/project/bin


Ignore:
Timestamp:
Sep 8, 2009, 10:28:39 AM (12 years ago)
Author:
teymour
Message:

parse tout & insersion sql

Location:
cpc/trunk/project/bin
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • cpc/trunk/project/bin/load_questions

    r419 r454  
    99cd -
    1010php symfony cc
    11 for file in $(ls batch/questions/xml)
     11for file in $(ls batch/questions/input)
    1212do
    1313    echo $file
    14     cp batch/questions/xml/$file batch/questions/input/
     14#    cp batch/questions/xml/$file batch/questions/input/
    1515    php symfony load:Questions >> /tmp/load_questions.log
    1616    php symfony cc
  • cpc/trunk/project/bin/loadbatch

    r441 r454  
    77bash bin/load_commission
    88bash bin/tag_seance
    9 bash bin/load_question
     9bash bin/load_questions
    1010php symfony set:Vacances
    11 
     11php symfony top:Deputes
  • cpc/trunk/project/bin/loadsql

    r356 r454  
    11#!/bin/bash
    22MYSQLID="-u root"
     3DBNAME="cpc"
     4
    35#echo "SET FOREIGN_KEY_CHECKS = 0;" > /tmp/drop.sql
    46#echo "SET FOREIGN_KEY_CHECKS = 0;" > /tmp/delete.sql
    5 #echo "SHOW TABLES" | mysql $MYSQLID cpc  | grep -v Tables_  > /tmp/tables.sql
     7#echo "SHOW TABLES" | mysql $MYSQLID $DBNAME  | grep -v Tables_  > /tmp/tables.sql
    68#cat /tmp/tables.sql | sed 's/^/DROP TABLE /' | sed 's/$/;/'  >> /tmp/drop.sql
    7 #cat /tmp/drop.sql | mysql $MYSQLID cpc
     9#cat /tmp/drop.sql | mysql $MYSQLID $DBNAME
    810#cat /tmp/tables.sql | sed 's/^/CREATE TABLE /' | sed 's/$/;/'  > /tmp/create.sql
    9 #cat /tmp/create.sql | mysql $MYSQLID cpc
     11#cat /tmp/create.sql | mysql $MYSQLID $DBNAME
    1012#cat /tmp/tables.sql | sed 's/^/DELETE FROM /' | sed 's/$/;/'  >> /tmp/delete.sql
    1113php symfony doctrine:build-all-reload --no-confirmation
    12 #cat /tmp/delete.sql | mysql $MYSQLID cpc
     14#cat /tmp/delete.sql | mysql $MYSQLID $DBNAME
    1315#rm /tmp/tables.sql /tmp/drop.sql /tmp/create.sql /tmp/delete.sql
    14 zcat data/sql/data.sql.gz | grep -v '`sf_guard' | grep -v '`tag_template`' | mysql $MYSQLID cpc
     16zcat data/sql/data.sql.gz | mysql $MYSQLID $DBNAME
    1517#php symfony set:Vacances
Note: See TracChangeset for help on using the changeset viewer.