Players data import from Cezar to Players db

2 files changed, 16 insertions, 0 deletions

diff --git a/Makefile b/Makefile
index 10748b9..e579a88 100644
--- a/Makefile
+++ b/Makefile
@@ -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