]> git.sesse.net Git - ccbs/blob - sql/em2-series/update-em2s.sh
Add scripts and example SQL for parsing the EM2 series from 2002.
[ccbs] / sql / em2-series / update-em2s.sh
1 #! /bin/sh
2
3 SEASON="Euromix 2-serie 2002"
4
5 (
6         while read ccno id; do
7                 wget -O- "http://www.ddreurope.com/results.php?since=0&act=2&t_id=$id" |
8                 iconv -f latin1 -t utf8 |
9                         perl ../../parse/parse-ddreurope-tournament.pl "$SEASON" > em2s$ccno.sql
10         done
11 ) <<"EOF"
12 01      6
13 02      7
14 03      8
15 04      9
16 05      10
17 06      11
18 07      12
19 08      13
20 09      14
21 10      15
22 11      16
23 EOF