s4
view scripts/add-group-csv.sh @ 548:1f7d6999ed4c
Rename group-add script
| author | HIROSE Yuuji <yuuji@gentei.org> |
|---|---|
| date | Sat, 06 Apr 2019 21:34:53 +0900 |
| parents | scripts/group-add.sh@bb34c7fbf1ad |
| children | 2a48690b8cbc |
line source
1 #!/bin/sh
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 cd `dirname $0`/..
13 if ! . ./s4-funcs.sh; then
14 echo "Cannot find s4-funcs.sh, which should be located in $mydir/.."
15 exit 1
16 fi
18 target=$(cd `dirname "$1"`; pwd)/`basename $1`
20 query<<-EOF
21 .mode csv
22 CREATE TEMPORARY TABLE _gusers(gname, user, admin);
23 .import $target _gusers
24 REPLACE INTO grp SELECT * FROM _gusers;
25 REPLACE INTO grp_adm SELECT * FROM _gusers WHERE admin LIKE 'admin';
26 EOF