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 |
|---|---|
| yuuji@546 | 1 #!/bin/sh |
| yuuji@546 | 2 |
| yuuji@546 | 3 if [ -z "$1" ]; then |
| yuuji@546 | 4 cat<<-EOF >&2 |
| yuuji@546 | 5 Usage: $0 CSVfile |
| yuuji@546 | 6 $0 -a CSVfile # for al |
| yuuji@546 | 7 Csv file should be the form of: |
| yuuji@546 | 8 GroupName,UserName(email) |
| yuuji@546 | 9 EOF |
| yuuji@546 | 10 exit 1 |
| yuuji@546 | 11 fi |
| yuuji@546 | 12 if [ |
| yuuji@546 | 13 target=$(cd `dirname "$1"`; pwd)/`basename $1` |
| yuuji@546 | 14 |
| yuuji@546 | 15 query<<-EOF |
| yuuji@546 | 16 .mode csv |
| yuuji@546 | 17 CREATE TEMPORARY TABLE _gusers(gname, user, admin); |
| yuuji@546 | 18 .import $target _gusers |
| yuuji@546 | 19 REPLACE INTO grp SELECT * FROM _gusers; |
| yuuji@546 | 20 REPLACE INTO grp_adm SELECT * FROM _gusers WHERE admin LIKE 'admin'; |
| yuuji@546 | 21 EOF |