Mercurial > hgrepos > hgweb.cgi > s4
annotate 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 |
| rev | line source |
|---|---|
| 546 | 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 |
