COmanage Developers List

Author: benno
Date: 2012-08-31 14:33:40 -0400 (Fri, 31 Aug 2012)
New Revision: 354

Modified:
   demo/trunk/demo.sql
Log:
Add address to demo ldap sql data (CO-435)

Modified: demo/trunk/demo.sql
===================================================================
--- demo/trunk/demo.sql 2012-08-31 00:11:40 UTC (rev 353)
+++ demo/trunk/demo.sql 2012-08-31 18:33:40 UTC (rev 354)
@@ -42,7 +42,12 @@
             copr.affiliation AS affiliation,
             e.mail AS mail,
             t.number AS telephoneNumber,
-            i.identifier AS uid
+            i.identifier AS uid,
+            a.line1 AS street,
+            a.locality AS l,
+            a.state AS st,
+            a.postal_code AS postalcode,
+            a.country AS c
 FROM        cm_co_people AS cop
 INNER JOIN  cm_cos AS c
 ON          cop.co_id=c.id
@@ -58,6 +63,8 @@
 ON          copr.id=t.co_person_role_id
 LEFT JOIN   cm_identifiers AS i
 ON          coil.org_identity_id=i.org_identity_id
+LEFT JOIN   cm_addresses AS a
+ON          copr.id=a.co_person_role_id
 WHERE       i.login=1
 AND         i.type='eppn'
 AND         cop.status IN ('A', 'Y')
@@ -239,6 +246,21 @@
 insert into ldap_attr_mappings 
(id,oc_map_id,name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return)
 values (13,4,'dc','demo_ldap_top.dc','demo_ldap_top',NULL,NULL,NULL,3,0);
 
+insert into ldap_attr_mappings 
(id,oc_map_id,name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return)
+values (14,1,'street','demo_ldap_v.street','demo_ldap_v',NULL,NULL,NULL,3,0);
+
+insert into ldap_attr_mappings 
(id,oc_map_id,name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return)
+values (15,1,'l','demo_ldap_v.l','demo_ldap_v',NULL,NULL,NULL,3,0);
+
+insert into ldap_attr_mappings 
(id,oc_map_id,name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return)
+values (16,1,'st','demo_ldap_v.st','demo_ldap_v',NULL,NULL,NULL,3,0);
+
+insert into ldap_attr_mappings 
(id,oc_map_id,name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return)
+values 
(17,1,'postalcode','demo_ldap_v.postalcode','demo_ldap_v',NULL,NULL,NULL,3,0);
+
+insert into ldap_attr_mappings 
(id,oc_map_id,name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return)
+values (18,1,'c','demo_ldap_v.c','demo_ldap_v',NULL,NULL,NULL,3,0);
+
 --insert into ldap_attr_mappings 
(id,oc_map_id,name,sel_expr,from_tbls,join_where,add_proc,delete_proc,param_order,expect_return)
 --values (5,1,'userPassword','persons.password','persons','persons.password 
IS NOT NULL',NULL,NULL,3,0);