s4
changeset 172:e9f9c72bfa48
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...