/[virtual-ldap]/sql/group.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Annotation of /sql/group.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 48 - (hide annotations)
Fri Apr 17 23:16:00 2009 UTC (15 years ago) by dpavlin
File size: 352 byte(s)
implement multiple values by keeping dn and repeating rows with changed
attributes, implement organizationalunit and group with same attributes
as Active Directory

1 dpavlin 48 select
2     concat('cn=',c.categorycode,',ou=groups') as dn,
3     'group' as objectClass,
4     'groups' as ou,
5     c.categorycode as cn,
6     description as description,
7    
8     concat('uid=',replace(userid,'@ffzg.hr',''),',ou=',c.categorycode,',dc=ffzg,dc=hr') as members
9     from categories c
10     join borrowers b on b.categorycode = c.categorycode
11     where length(userid) > 0

  ViewVC Help
Powered by ViewVC 1.1.26