Changeset 873


Ignore:
Timestamp:
Oct 7, 2009, 3:37:21 PM (12 years ago)
Author:
goya
Message:

Centralisation de la conf db

Location:
cpc/trunk/project
Files:
1 added
4 edited

Legend:

Unmodified
Added
Removed
  • cpc/trunk/project/batch/amendements/compute_latest.sh

    r853 r873  
    11#!/bin/bash
    22
    3 MYSQLID="-u cpc -pM_O_T__D_E__P_A_S_S_E"
    4 DBNAME="cpc"
     3. ../../bin/db.inc
     4
    55cat liste_sort_indefini.sql | mysql $MYSQLID $DBNAME | grep -v source > liste_sort_indefini.txt
     6
    67rm -f html/*
     8
    79perl download_amendements.pl > /tmp/download_amendements.log
     10
    811for file in html/*; do
    912        fileout=$(echo $file | sed 's/html/json/' | sed 's/\.asp/\.xml/')
  • cpc/trunk/project/batch/questions/compute_latest.sh

    r852 r873  
    11#!/bin/bash
    22
    3 MYSQLID="-u cpc -pM_O_T__D_E__P_A_S_S_E"
    4 DBNAME="cpc"
     3. ../../bin/db.inc
     4
    55cat dernier_numero.sql | mysql $MYSQLID $DBNAME | grep -v numero > dernier_numero.txt
    66cat liste_sans_reponse.sql | mysql $MYSQLID $DBNAME | grep -v source > liste_sans_reponse.txt
     7
    78rm -f html/*
     9
    810#log cette partie très verbeuse
    911perl download_questions.pl > /tmp/download_questions.log
  • cpc/trunk/project/bin/dump

    r182 r873  
    11#!/bin/bash
    2 MYSQLID="-u root"
    3 path="/home/roux/dev/cpc/project"
     2. bin/db.inc
     3path="/home/nosdeputes/prod"
    44
    5 mysqldump $MYSQLID cpc -q --single-transaction --add-drop-table -R -t --disable-keys --complete-insert | gzip > ${path}/data/sql/data.sql.gz
     5mysqldump $MYSQLID $DBNAME -q --single-transaction --add-drop-table -R -t --disable-keys --complete-insert | gzip > ${path}/data/sql/data.dump.sql.gz
  • cpc/trunk/project/bin/loadsql

    r512 r873  
    11#!/bin/bash
    2 MYSQLID="-u cpc -pM_O_T__D_E__P_A_S_S_E"
    3 DBNAME="cpc"
     2. bin/db.inc
    43
    54#echo "SET FOREIGN_KEY_CHECKS = 0;" > /tmp/drop.sql
Note: See TracChangeset for help on using the changeset viewer.