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