diff options
author | emkael <emkael@tlen.pl> | 2021-11-20 15:20:22 +0100 |
---|---|---|
committer | emkael <emkael@tlen.pl> | 2021-11-20 15:20:22 +0100 |
commit | 184310dea9f3b6d22786dd42776ff6e7093c58e9 (patch) | |
tree | c2aeb1ee2431487db6c2bbf5e9efc8dc7c47fc12 /dumps/import-players.sh | |
parent | 0a58fc613a6ee05d32043bde854b66451f2e630e (diff) |
DB dump, players DB and team Cezar mapping settings updated for 2021/22
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 |