s4

changeset 935:c17e67348950

find changesets by author, revision, files, or words in the commit message
Separate grp_* judgement in isfilereadable()
author HIROSE Yuuji <yuuji@gentei.org>
date Thu, 29 Apr 2021 15:40:37 +0900
parents 9184aa358773
children 789258aa857a
files s4-funcs.sh
diffstat 1 files changed, 12 insertions(+), 1 deletions(-) [+]
line diff
     1.1 --- a/s4-funcs.sh	Tue Apr 06 14:51:44 2021 +0900
     1.2 +++ b/s4-funcs.sh	Thu Apr 29 15:40:37 2021 +0900
     1.3 @@ -536,7 +536,16 @@
     1.4    #      fi
     1.5    # esac
     1.6    # ↑ 要はこういう処理を↓で一気にやっている
     1.7 -  sql="with getblog as (
     1.8 +  case "$2" in
     1.9 +    grp_*)
    1.10 +      sql="SELECT 'owner'
    1.11 +	FROM grp_adm
    1.12 +	WHERE gname=(SELECT gname FROM $2 WHERE rowid=$3)
    1.13 +	      AND
    1.14 +	      user = '$user';"
    1.15 +      ;;
    1.16 +    *)
    1.17 +      sql="with getblog as (
    1.18  	select key,val from blog_s where id=(
    1.19  	select blogid from article where id in
    1.20          	(select id from $2 where rowid=$3))),
    1.21 @@ -574,6 +583,8 @@
    1.22  		id=(select id from $2 where rowid=$3))='$1'
    1.23  	then 'user+author'
    1.24  	else '' end;"
    1.25 +      ;;
    1.26 +  esac
    1.27    ## err isfilereadable: sql="`echo $sql`"
    1.28    # caseのネストで内側のcaseがスカラーtrueを返しても外側はtrue扱いにならない
    1.29    # result=`query "$sql"`