Mercurial > hgrepos > hgweb.cgi > 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 wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/scripts/add-group-csv.sh Sat Apr 06 21:34:53 2019 +0900 @@ -0,0 +1,26 @@ +#!/bin/sh + +if [ -z "$1" ]; then + cat<<-EOF >&2 + Usage: $0 CSVfile + $0 -a CSVfile # for al + Csv file should be the form of: + GroupName,UserName(email) + EOF + exit 1 +fi +cd `dirname $0`/.. +if ! . ./s4-funcs.sh; then + echo "Cannot find s4-funcs.sh, which should be located in $mydir/.." + exit 1 +fi + +target=$(cd `dirname "$1"`; pwd)/`basename $1` + +query<<-EOF + .mode csv + CREATE TEMPORARY TABLE _gusers(gname, user, admin); + .import $target _gusers + REPLACE INTO grp SELECT * FROM _gusers; + REPLACE INTO grp_adm SELECT * FROM _gusers WHERE admin LIKE 'admin'; +EOF
--- a/scripts/group-add.sh Sat Apr 06 21:33:17 2019 +0900 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,21 +0,0 @@ -#!/bin/sh - -if [ -z "$1" ]; then - cat<<-EOF >&2 - Usage: $0 CSVfile - $0 -a CSVfile # for al - Csv file should be the form of: - GroupName,UserName(email) - EOF - exit 1 -fi - -target=$(cd `dirname "$1"`; pwd)/`basename $1` - -query<<-EOF - .mode csv - CREATE TEMPORARY TABLE _gusers(gname, user, admin); - .import $target _gusers - REPLACE INTO grp SELECT * FROM _gusers; - REPLACE INTO grp_adm SELECT * FROM _gusers WHERE admin LIKE 'admin'; -EOF