s4

changeset 172:e9f9c72bfa48

find changesets by author, revision, files, or words in the commit message
create view "gecoses", through which gecos name can be retrieved
author HIROSE Yuuji <yuuji@gentei.org>
date Fri, 19 Feb 2016 15:36:51 +0859
parents cdade692e17d
children 31e63d173d38
files s4-init.sh
diffstat 1 files changed, 12 insertions(+), 0 deletions(-) [+]
line diff
     1.1 --- a/s4-init.sh	Thu Feb 11 17:06:19 2016 +0859
     1.2 +++ b/s4-init.sh	Fri Feb 19 15:36:51 2016 +0859
     1.3 @@ -75,6 +75,18 @@
     1.4  	primary key(user, tbl, rowid), \
     1.5  	foreign key(user) references user(name))"
     1.6  
     1.7 +create view gecoses "AS
     1.8 +SELECT name,
     1.9 +       coalesce(
    1.10 +         case when (SELECT name FROM user u WHERE u.name=name) IS NOT NULL
    1.11 +	      then (SELECT val FROM user_s u
    1.12 +	            WHERE u.name=a.name AND key='gecos')
    1.13 +	      else (SELECT val FROM grp_s g
    1.14 +	      	    WHERE g.gname=name AND key='gecos')
    1.15 +	 end,
    1.16 +	 name) gecos
    1.17 +FROM (SELECT name FROM user UNION ALL SELECT gname FROM grp) a;"
    1.18 +
    1.19  
    1.20  for f in $formdir/*def; do
    1.21    echo -n Creating form of $f...