yuuji@546: #!/bin/sh
yuuji@546: 
yuuji@546: if [ -z "$1" ]; then
yuuji@546:   cat<<-EOF >&2
yuuji@546: 	Usage: $0 CSVfile
yuuji@546: 	       $0 -a CSVfile		# for al
yuuji@546: 	Csv file should be the form of:
yuuji@546: 	   GroupName,UserName(email)
yuuji@546: 	EOF
yuuji@546:   exit 1
yuuji@546: fi
yuuji@546: if [
yuuji@546: target=$(cd `dirname "$1"`; pwd)/`basename $1`
yuuji@546: 
yuuji@546: query<<-EOF
yuuji@546: 	.mode csv
yuuji@546: 	CREATE TEMPORARY TABLE _gusers(gname, user, admin);
yuuji@546: 	.import $target _gusers
yuuji@546: 	REPLACE INTO grp SELECT * FROM _gusers;
yuuji@546: 	REPLACE INTO grp_adm SELECT * FROM _gusers WHERE admin LIKE 'admin';
yuuji@546: EOF