--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/group-add.sh	Sat Apr 06 21:32:10 2019 +0900
@@ -0,0 +1,21 @@
+#!/bin/sh
+
+if [ -z "$1" ]; then
+  cat<<-EOF >&2
+	Usage: $0 CSVfile
+	       $0 -a CSVfile		# for al
+	Csv file should be the form of:
+	   GroupName,UserName(email)
+	EOF
+  exit 1
+fi
+if [
+target=$(cd `dirname "$1"`; pwd)/`basename $1`
+
+query<<-EOF
+	.mode csv
+	CREATE TEMPORARY TABLE _gusers(gname, user, admin);
+	.import $target _gusers
+	REPLACE INTO grp SELECT * FROM _gusers;
+	REPLACE INTO grp_adm SELECT * FROM _gusers WHERE admin LIKE 'admin';
+EOF