s4

view scripts/group-add.sh @ 546:768e80ef2b80

find changesets by author, revision, files, or words in the commit message
add group-add.sh
author HIROSE Yuuji <yuuji@gentei.org>
date Sat, 06 Apr 2019 21:32:10 +0900
parents
children bb34c7fbf1ad
line source
1 #!/bin/sh
2
3 if [ -z "$1" ]; then
4 cat<<-EOF >&2
5 Usage: $0 CSVfile
6 $0 -a CSVfile # for al
7 Csv file should be the form of:
8 GroupName,UserName(email)
9 EOF
10 exit 1
11 fi
12 if [
13 target=$(cd `dirname "$1"`; pwd)/`basename $1`
14
15 query<<-EOF
16 .mode csv
17 CREATE TEMPORARY TABLE _gusers(gname, user, admin);
18 .import $target _gusers
19 REPLACE INTO grp SELECT * FROM _gusers;
20 REPLACE INTO grp_adm SELECT * FROM _gusers WHERE admin LIKE 'admin';
21 EOF