From 8f795b1d445441daab5ffb75060a6dbf8ed0934a Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Fri, 8 Sep 2017 01:28:21 +0200
Subject: Renaming scripts so that their names make sense

---
 bin/cezar-db-import.sh | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100755 bin/cezar-db-import.sh

(limited to 'bin/cezar-db-import.sh')

diff --git a/bin/cezar-db-import.sh b/bin/cezar-db-import.sh
new file mode 100755
index 0000000..4db5261
--- /dev/null
+++ b/bin/cezar-db-import.sh
@@ -0,0 +1,9 @@
+#!/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;
+LOAD DATA LOCAL INFILE '$1'
+REPLACE
+INTO TABLE players
+FIELDS TERMINATED BY ';' ENCLOSED BY '\"';
+SET foreign_key_checks = 1
+" ${DBCONFIG[4]}
-- 
cgit v1.2.3