virtual-ldap/sql/hreduperson.sql


select
        concat('uid=',trim(userid))                     as dn,
        'person
        organizationalPerson
        inetOrgPerson
        hrEduPerson'                                    as objectClass,

        trim(userid)                                    as uid,
        firstname                                       as givenName,
        surname                                         as sn,
        concat(firstname,' ',surname)                   as cn,

        -- SAFEQ specific mappings from UMgr-LDAP.conf
        borrowernumber                                  as objectGUID,
        surname                                         as displayName,
        rfid_sid                                        as pager,
        email                                           as mail,
        categorycode                                    as memberOf,
        categorycode                                    as ou,
        concat('/home/',borrowernumber)                 as homeDirectory
from borrowers

1	dpavlin	47
2			select
3			concat('uid=',trim(userid)) as dn,
4			'person
5			organizationalPerson
6			inetOrgPerson
7			hrEduPerson' as objectClass,
8
9			trim(userid) as uid,
10			firstname as givenName,
11			surname as sn,
12			concat(firstname,' ',surname) as cn,
13
14			-- SAFEQ specific mappings from UMgr-LDAP.conf
15			borrowernumber as objectGUID,
16			surname as displayName,
17			rfid_sid as pager,
18			email as mail,
19	dpavlin	54	categorycode as memberOf,
20			categorycode as ou,
21	dpavlin	47	concat('/home/',borrowernumber) as homeDirectory
22			from borrowers
23