blob: 6f3104a66d36c5b4094b3cb56f72d7780157fc03 (
plain)
1
2
3
4
5
6
7
8
9
10
|
#!/bin/bash
DBCONFIG=($(jq -r '.[]' config/import-db.json))
mysql --local-infile=1 -h ${DBCONFIG[2]} -P ${DBCONFIG[3]} -u ${DBCONFIG[0]} --password=${DBCONFIG[1]} -e "SET foreign_key_checks = 0;
DELETE FROM hidden_players;
LOAD DATA LOCAL INFILE '$1'
INTO TABLE hidden_players
FIELDS TERMINATED BY ';' ENCLOSED BY '\"';
UPDATE rankings SET hidden = 1 WHERE pid IN (SELECT pid FROM hidden_players);
SET foreign_key_checks = 1
" ${DBCONFIG[4]}
|
