Mercurial > hgrepos > hgweb.cgi > s4
comparison scripts/group-add.sh @ 546:768e80ef2b80
add group-add.sh
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Sat, 06 Apr 2019 21:32:10 +0900 |
parents | |
children | bb34c7fbf1ad |
comparison
equal
deleted
inserted
replaced
545:7cd9e895fa09 | 546:768e80ef2b80 |
---|---|
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 |