Convert csv files to sql

Used for filling member DB from spreadsheet

1 files changed, 8 insertions, 0 deletions

diff --git a/bin/csv2sql.sh b/bin/csv2sql.sh
new file mode 100755
index 0000000..c4f004a
--- /dev/null
+++ b/bin/csv2sql.sh
@@ -0,0 +1,8 @@
+#!/bin/bash
+
+awk 'BEGIN{ printf "BEGIN; SET NAMES 'utf8';\n\
+INSERT into `foundation`.`electorate`\n\
+	   (lastname, firstname, email)\n\
+       VALUES \n"} { print "(" $0 ")," }\
+END{ print ";\n\
+COMMIT;"}'