s4
changeset 548:1f7d6999ed4c
Rename group-add script
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Sat, 06 Apr 2019 21:34:53 +0900 |
parents | bb34c7fbf1ad |
children | 2a48690b8cbc |
files | scripts/add-group-csv.sh scripts/group-add.sh |
diffstat | 2 files changed, 26 insertions(+), 21 deletions(-) [+] |
line diff
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/scripts/add-group-csv.sh Sat Apr 06 21:34:53 2019 +0900 1.3 @@ -0,0 +1,26 @@ 1.4 +#!/bin/sh 1.5 + 1.6 +if [ -z "$1" ]; then 1.7 + cat<<-EOF >&2 1.8 + Usage: $0 CSVfile 1.9 + $0 -a CSVfile # for al 1.10 + Csv file should be the form of: 1.11 + GroupName,UserName(email) 1.12 + EOF 1.13 + exit 1 1.14 +fi 1.15 +cd `dirname $0`/.. 1.16 +if ! . ./s4-funcs.sh; then 1.17 + echo "Cannot find s4-funcs.sh, which should be located in $mydir/.." 1.18 + exit 1 1.19 +fi 1.20 + 1.21 +target=$(cd `dirname "$1"`; pwd)/`basename $1` 1.22 + 1.23 +query<<-EOF 1.24 + .mode csv 1.25 + CREATE TEMPORARY TABLE _gusers(gname, user, admin); 1.26 + .import $target _gusers 1.27 + REPLACE INTO grp SELECT * FROM _gusers; 1.28 + REPLACE INTO grp_adm SELECT * FROM _gusers WHERE admin LIKE 'admin'; 1.29 +EOF
2.1 --- a/scripts/group-add.sh Sat Apr 06 21:33:17 2019 +0900 2.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 2.3 @@ -1,21 +0,0 @@ 2.4 -#!/bin/sh 2.5 - 2.6 -if [ -z "$1" ]; then 2.7 - cat<<-EOF >&2 2.8 - Usage: $0 CSVfile 2.9 - $0 -a CSVfile # for al 2.10 - Csv file should be the form of: 2.11 - GroupName,UserName(email) 2.12 - EOF 2.13 - exit 1 2.14 -fi 2.15 - 2.16 -target=$(cd `dirname "$1"`; pwd)/`basename $1` 2.17 - 2.18 -query<<-EOF 2.19 - .mode csv 2.20 - CREATE TEMPORARY TABLE _gusers(gname, user, admin); 2.21 - .import $target _gusers 2.22 - REPLACE INTO grp SELECT * FROM _gusers; 2.23 - REPLACE INTO grp_adm SELECT * FROM _gusers WHERE admin LIKE 'admin'; 2.24 -EOF