implement multiple values by keeping dn and repeating rows with changed

[virtual-ldap] / sql / group.sql

diff --git a/sql/group.sql b/sql/group.sql
new file mode 100644 (file)
index 0000000..b34ebf2
--- /dev/null
+++ b/sql/group.sql
@@ -0,0 +1,11 @@
+select
+       concat('cn=',c.categorycode,',ou=groups')       as dn,
+       'group'                         as objectClass,
+       'groups'                        as ou,
+       c.categorycode                  as cn,
+       description                     as description,
+
+       concat('uid=',replace(userid,'@ffzg.hr',''),',ou=',c.categorycode,',dc=ffzg,dc=hr') as members
+from categories c
+join borrowers b on b.categorycode = c.categorycode
+where length(userid) > 0