From 8f795b1d445441daab5ffb75060a6dbf8ed0934a Mon Sep 17 00:00:00 2001 From: emkael Date: Fri, 8 Sep 2017 01:28:21 +0200 Subject: Renaming scripts so that their names make sense --- bin/import-rankings.sh | 16 ---------------- 1 file changed, 16 deletions(-) delete mode 100755 bin/import-rankings.sh (limited to 'bin/import-rankings.sh') 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]} -- cgit v1.2.3