1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/scripts/group-add.sh	Sat Apr 06 21:32:10 2019 +0900
     1.3 @@ -0,0 +1,21 @@
     1.4 +#!/bin/sh
     1.5 +
     1.6 +if [ -z "$1" ]; then
     1.7 +  cat<<-EOF >&2
     1.8 +	Usage: $0 CSVfile
     1.9 +	       $0 -a CSVfile		# for al
    1.10 +	Csv file should be the form of:
    1.11 +	   GroupName,UserName(email)
    1.12 +	EOF
    1.13 +  exit 1
    1.14 +fi
    1.15 +if [
    1.16 +target=$(cd `dirname "$1"`; pwd)/`basename $1`
    1.17 +
    1.18 +query<<-EOF
    1.19 +	.mode csv
    1.20 +	CREATE TEMPORARY TABLE _gusers(gname, user, admin);
    1.21 +	.import $target _gusers
    1.22 +	REPLACE INTO grp SELECT * FROM _gusers;
    1.23 +	REPLACE INTO grp_adm SELECT * FROM _gusers WHERE admin LIKE 'admin';
    1.24 +EOF