# HG changeset patch
# User HIROSE Yuuji <yuuji@gentei.org>
# Date 1554553930 -32400
# Node ID 768e80ef2b803af848bb7ece53b7e555ef7aae4a
# Parent  7cd9e895fa09161219ec7f32a15bff4ea1360dfa
add group-add.sh

diff -r 7cd9e895fa09 -r 768e80ef2b80 scripts/group-add.sh
--- /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