s4

changeset 366:884cd7c66917

find changesets by author, revision, files, or words in the commit message
Use gecoses table instead of coalesce().
author HIROSE Yuuji <yuuji@gentei.org>
date Wed, 23 Nov 2016 15:54:05 +0859
parents be652501ca71
children 037b514bb6ae
files s4-blog.sh
diffstat 1 files changed, 1 insertions(+), 3 deletions(-) [+]
line diff
     1.1 --- a/s4-blog.sh	Tue Nov 22 09:20:54 2016 +0859
     1.2 +++ b/s4-blog.sh	Wed Nov 23 15:54:05 2016 +0859
     1.3 @@ -320,9 +320,7 @@
     1.4    sql="with arts as (select id,author from article \
     1.5  	    where blogid=(select id from blog where rowid=$2))\
     1.6        select (select rowid from user where name=c0.user)||'	'|| \
     1.7 -	      coalesce((select val from user_s where name=c0.user \
     1.8 -			and key='gecos'),\
     1.9 -		      c0.user) as 'メンバー',\
    1.10 +	      (select gecos from gecoses where name=c0.user) as 'メンバー',\
    1.11  	     sum(case when c1.key is not null then 1 else 0 end)\
    1.12  		 as 'コメント記入',\
    1.13  	     sum(case when c2.key is not null then 1 else 0 end)\