source: cpc/trunk/project/bin/updateDB3.sh @ 1395

Last change on this file since 1395 was 1395, checked in by roux, 11 years ago

premiers essais pour la carte

File size: 4.6 KB
Line 
1#!/bin/bash
2
3source bin/db.inc
4
5php symfony cc
6#php symfony doctrine:build --all-classes
7#cat bin/updateDB3.model.sql | mysql $MYSQLID $DBNAME
8php symfony doctrine:build --all --no-confirmation
9zcat data/sql/dumps/nosdeputes_prod.100912.sql.gz | mysql --default-character-set=utf8 $MYSQLID $DBNAME
10
11cat bin/updateDB3.1.sql | mysql $MYSQLID $DBNAME
12
13cd batch/hemicycle
14perl parse_hemicycle.pl html/http\:__www.assemblee-nationale.fr_13_cri_2007-2008_20080120.asp > out/out1
15perl parse_hemicycle.pl html/http\:__www.assemblee-nationale.fr_13_cri_2008-2009_20090021.asp > out/out2
16perl parse_hemicycle.pl html/http\:__www.assemblee-nationale.fr_13_cri_2007-2008_20080086.asp > out/out3
17perl parse_hemicycle.pl html/http\:__www.assemblee-nationale.fr_13_cri_2008-2009-extra2_20092014.asp > out/out4
18perl parse_hemicycle.pl html/http\:__www.assemblee-nationale.fr_13_cri_2009-2010_20100162.asp > out/out5
19perl parse_hemicycle.pl html/http\:__www.assemblee-nationale.fr_13_cri_2007-2008_20080193.asp > out/out6
20perl parse_hemicycle.pl html/http\:__www.assemblee-nationale.fr_13_cri_2008-2009_20090221.asp > out/out7
21perl parse_hemicycle.pl html/http\:__www.assemblee-nationale.fr_13_cri_2009-2010-extra_20101013.asp > out/out8
22perl parse_hemicycle.pl html/http\:__www.assemblee-nationale.fr_13_cri_2006-2007-extra2_20072008.asp > out/out9
23perl parse_hemicycle.pl html/http\:__www.assemblee-nationale.fr_13_cri_2008-2009_20090242.asp > out/out10
24cd -
25
26while ls batch/hemicycle/out | grep [a-z] > /dev/null ; do 
27        php symfony cc --env=test  --app=frontend > /dev/null
28        php symfony load:Hemicycle
29done;
30
31php symfony move:Seance 304 13 31
32php symfony move:Seance 278 1043 31
33php symfony move:Seance 84 1043 31
34php symfony move:Seance 2756 1043 7573
35php symfony move:Seance 2769 1043 7573
36php symfony move:Seance 59 785 254
37php symfony move:Seance 311 785 181
38php symfony move:Seance 59 784 254
39php symfony move:Seance 311 784 181
40php symfony move:Seance 311 7004 181
41php symfony move:Seance 521 5039 357
42php symfony move:Seance 3194 8634 2
43php symfony move:Seance 108 1356 1348
44php symfony move:Seance 281 3362 2765
45php symfony move:Seance 48 621 1380
46php symfony move:Seance 348 4185 2
47php symfony move:Seance 2903 7751 7573
48php symfony move:Seance 3639 10334 2
49php symfony move:Seance 3473 1213 2
50php symfony move:Seance 3264 8874 2
51
52cat bin/updateDB3.2.sql | mysql $MYSQLID $DBNAME
53
54php symfony fuse:Dossiers 5091 9804
55php symfony fuse:Dossiers 3511 952
56php symfony fuse:Dossiers 2867 952
57php symfony fuse:Dossiers 547 357
58php symfony fuse:Dossiers 6576 1993
59php symfony fuse:Dossiers 46 1993
60php symfony fuse:Dossiers 8897 8900
61php symfony fuse:Dossiers 7558 7573
62php symfony fuse:Dossiers 7591 7573
63php symfony fuse:Dossiers 927 1926
64php symfony fuse:Dossiers 733 4450
65php symfony fuse:Dossiers 4825 4450
66php symfony fuse:Dossiers 5911 4450
67php symfony fuse:Dossiers 1421 31
68php symfony fuse:Dossiers 1011 4321
69php symfony fuse:Dossiers 2783 195
70php symfony fuse:Dossiers 1443 2363
71php symfony fuse:Dossiers 6879 5549
72php symfony fuse:Dossiers 8837 1384
73php symfony fuse:Dossiers 7551 7521
74php symfony fuse:Dossiers 8740 8663
75php symfony fuse:Dossiers 9424 9427
76php symfony fuse:Dossiers 10869 10790
77php symfony fuse:Dossiers 9833 9718
78php symfony fuse:Dossiers 9747 9837
79php symfony fuse:Dossiers 7005 7038
80php symfony fuse:Dossiers 3201 4773
81php symfony fuse:Dossiers 5034 5470
82php symfony fuse:Dossiers 9842 9804
83php symfony fuse:Dossiers 3790 181
84php symfony fuse:Dossiers 5828 2675
85php symfony fuse:Dossiers 515 2811
86php symfony fuse:Dossiers 813 2814
87php symfony fuse:Dossiers 3759 5050
88php symfony fuse:Dossiers 3904 964
89php symfony fuse:Dossiers 10999 9328
90php symfony fuse:Dossiers 10772 9485
91php symfony fuse:Dossiers 10331 10354
92php symfony fuse:Dossiers 7983 8003
93php symfony fuse:Dossiers 8611 4974
94php symfony fuse:Dossiers 914 2370
95php symfony fuse:Dossiers 265 16
96php symfony fuse:Dossiers 2348 6376
97php symfony fuse:Dossiers 9485 10874
98php symfony fuse:Dossiers 3955 3953
99
100cat bin/updateDB3.3.sql | mysql $MYSQLID $DBNAME
101
102echo > /tmp/res_maxdate
103while grep -v "^0 sections trouvées" /tmp/res_maxdate > /dev/null ; do 
104        php symfony cc --env=test  --app=frontend > /dev/null
105        php symfony set:MaxDateDossiers > /tmp/res_maxdate
106done;
107rm -f /tmp/res_maxdate
108
109cd batch/documents
110  mkdir ppr
111  mkdir pjl
112  mkdir ppl
113  mkdir rap
114  mkdir ta
115  mkdir out
116  perl download_docs.pl
117  for dir in rap ppl pjl ppr ta; do
118    for file in `ls $dir`; do
119      perl parse_metas.pl $dir/$file > out/$file
120    done
121  done
122cd -
123
124
125while ls batch/documents/out | grep [a-z] > /dev/null ; do 
126        php symfony cc --env=test  --app=frontend > /dev/null
127        php symfony load:Documents
128done;
129
130php symfony top:Deputes
131bash bin/update_tops
132
133#bash bin/update_hardcache_all
134
135
136
Note: See TracBrowser for help on using the repository browser.