summaryrefslogtreecommitdiff
path: root/bin/import-rankings.sh
diff options
context:
space:
mode:
Diffstat (limited to 'bin/import-rankings.sh')
-rwxr-xr-xbin/import-rankings.sh16
1 files changed, 0 insertions, 16 deletions
diff --git a/bin/import-rankings.sh b/bin/import-rankings.sh
deleted file mode 100755
index 90ce6bc..0000000
--- a/bin/import-rankings.sh
+++ /dev/null
@@ -1,16 +0,0 @@
-#!/bin/bash
-DBCONFIG=($(jq -r '.[]' config/import-db.json))
-mysql -h ${DBCONFIG[2]} -P ${DBCONFIG[3]} -u ${DBCONFIG[0]} --password=${DBCONFIG[1]} -e "SET foreign_key_checks = 0;
-DELETE FROM temp_rankings;
-LOAD DATA LOCAL INFILE '$1'
-REPLACE
-INTO TABLE temp_rankings
-FIELDS TERMINATED BY ',';
-INSERT INTO rankings (
- SELECT pid, \`date\`, place, score, region, flags, rank, club
- FROM temp_rankings
- JOIN players
- ON players.id = temp_rankings.pid
-);
-SET foreign_key_checks = 1
-" ${DBCONFIG[4]}