diff options
| -rw-r--r-- | Makefile | 3 | ||||
| -rwxr-xr-x | dumps/import-players.sh | 13 |
2 files changed, 16 insertions, 0 deletions
@@ -6,6 +6,9 @@ pull: autocommit: pull @cd http && git diff --quiet || (date && git add . && git commit -m 'Autocommit' && GIT_SSH_COMMAND="ssh ${LIGA_SSH_OPTS}" git push -q) +players: FORCE + ./dumps/import-players.sh + paid: players FORCE ./dumps/check-all-paid.sh diff --git a/dumps/import-players.sh b/dumps/import-players.sh new file mode 100755 index 0000000..5f499ef --- /dev/null +++ b/dumps/import-players.sh @@ -0,0 +1,13 @@ +#!/bin/bash +cd $(dirname $0) +DBNAME=${LIGA_PLAYERS_DB_NAME} +curl 'https://msc.com.pl/cezar/download/baza.csv' | grep '^[0-9]' > baza.csv +mysql ${LIGA_MYSQL_CONNECTION_OPTS} --local-infile=1 $DBNAME -e "LOAD DATA LOCAL INFILE 'baza.csv' +REPLACE +INTO TABLE players +FIELDS TERMINATED BY ';' ENCLOSED BY '\"' +(ID, gname, sname, rank, loc1, info, loc2, flag1, flag2); +UPDATE players SET age = REPLACE(info, 'K', ''), sex = IF(POSITION('K' IN info), 'K', ''); +UPDATE players SET info = NULL; +" +rm baza.csv |