diff options
Diffstat (limited to 'dumps/import-players.sh')
| -rwxr-xr-x | dumps/import-players.sh | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/dumps/import-players.sh b/dumps/import-players.sh index 9763ab5..3edb7c7 100755 --- a/dumps/import-players.sh +++ b/dumps/import-players.sh @@ -1,7 +1,7 @@ #!/bin/bash cd $(dirname $0) DBNAME=${LIGA_PLAYERS_DB_NAME} -curl ${LIGA_BAZA_CSV} | iconv -f cp1250 -t utf8 | grep '^[0-9]' | sed 's/;[0-9]\{4\}-[0-9]\{2\}-[0-9]\{2\}/;T/g' | cut -d';' -f1-7,10-11 > baza.csv +curl ${LIGA_BAZA_CSV} | iconv -f cp1250 -t utf8 | grep '^[0-9]' | sed 's/;[0-9]\{4\}-[0-9]\{2\}-[0-9]\{2\}/;T/g' | cut -d';' -f1-7,9,11 > baza.csv mysql ${LIGA_MYSQL_CONNECTION_OPTS} --local-infile=1 $DBNAME -e "TRUNCATE players; LOAD DATA LOCAL INFILE 'baza.csv' REPLACE |