From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Wed, 29 Apr 2009 11:48:10 +0000 (+0000)
Subject: create organizationlUnit for each categorycode from Koha
X-Git-Url: http://git.rot13.org/?p=virtual-ldap;a=commitdiff_plain;h=81326d819a2f6c6fdd076087f54fb82c3a44739e

create organizationlUnit for each categorycode from Koha
---

diff --git a/sql/group.sql b/sql/group.sql
index b34ebf2..e98e8f4 100644
--- a/sql/group.sql
+++ b/sql/group.sql
@@ -1,5 +1,5 @@
 select
-	concat('cn=',c.categorycode,',ou=groups')	as dn,
+	concat('cn=',c.categorycode,',ou=',c.categorycode)	as dn,
 	'group'				as objectClass,
 	'groups'			as ou,
 	c.categorycode			as cn,
diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql
index d0eb058..b068bd7 100644
--- a/sql/hreduperson.sql
+++ b/sql/hreduperson.sql
@@ -16,8 +16,8 @@ select
 	surname						as displayName,
 	rfid_sid					as pager,
 	email						as mail,
---	categorycode					as memberOf,
-	categorycode					as department,
+	categorycode					as memberOf,
+	categorycode					as ou,
 	concat('/home/',borrowernumber)			as homeDirectory
 from borrowers
 
diff --git a/sql/organizationalunit.sql b/sql/organizationalunit.sql
index 7f010fc..21d4912 100644
--- a/sql/organizationalunit.sql
+++ b/sql/organizationalunit.sql
@@ -1,7 +1,8 @@
 
 select
-	'ou=groups'			as dn,
+	concat('ou=',c.categorycode,'dc=ffzg,dc=hr')	as dn,
 	'organizationalunit'		as objectClass,
-	'groups'			as ou,
-	'Groups from Koha'		as description
+	c.categorycode			as ou,
+	c.description			as description
+from categories c