Renaming scripts so that their names make sense

1 files changed, 16 insertions, 0 deletions

diff --git a/bin/rankings-csv-import.sh b/bin/rankings-csv-import.sh
new file mode 100755
index 0000000..90ce6bc
--- /dev/null
+++ b/bin/rankings-csv-import.sh
@@ -0,0 +1,16 @@
+#!/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]}