summaryrefslogtreecommitdiff
path: root/dumps/import-players.sh
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2021-11-20 15:20:22 +0100
committeremkael <emkael@tlen.pl>2021-11-20 15:20:22 +0100
commit184310dea9f3b6d22786dd42776ff6e7093c58e9 (patch)
treec2aeb1ee2431487db6c2bbf5e9efc8dc7c47fc12 /dumps/import-players.sh
parent0a58fc613a6ee05d32043bde854b66451f2e630e (diff)
DB dump, players DB and team Cezar mapping settings updated for 2021/22
Diffstat (limited to 'dumps/import-players.sh')
-rwxr-xr-xdumps/import-players.sh2
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