SHOW:
|
|
- or go back to the newest paste.
| 1 | <?xml version="1.0" encoding="UTF-8" standalone="no"?> | |
| 2 | <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd"> | |
| 3 | ||
| 4 | <sqlMap namespace="PosixGroup"> | |
| 5 | ||
| 6 | - | <select id="getPosixGroupList" resultClass="java.util.HashMap"> |
| 6 | + | <select id="getPosixGroupList" resultClass="java.util.HashMap"> |
| 7 | - | SELECT unix_group_name as cn, |
| 7 | + | SELECT unix_group_name as cn, |
| 8 | - | group_id+1000 as gidnumber |
| 8 | + | group_id+1000 as gidnumber |
| 9 | - | FROM groups |
| 9 | + | FROM groups |
| 10 | - | </select> |
| 10 | + | WHERE group_id > 100 |
| 11 | </select> | |
| 12 | - | <select id="getPosixGroup" resultClass="java.util.HashMap" parameterClass="java.util.Map"> |
| 12 | + | |
| 13 | - | <!-- 'GROUP_CONCAT' is to get comma separated group membership --> |
| 13 | + | <select id="getPosixGroup" resultClass="java.util.HashMap" parameterClass="java.util.Map"> |
| 14 | - | SELECT GROUP_CONCAT(user_name SEPARATOR ',') as memberUid, |
| 14 | + | <!-- 'GROUP_CONCAT' is to get comma separated group membership --> |
| 15 | - | ug.group_id+1000 as gidNumber, |
| 15 | + | SELECT GROUP_CONCAT(user_name SEPARATOR ',') as memberUid, |
| 16 | - | g.unix_group_name as cn, |
| 16 | + | CAST(g.group_id+1000 as CHAR) as gidNumber, |
| 17 | - | g.short_description as description |
| 17 | + | g.unix_group_name as cn, |
| 18 | - | FROM user_group ug, user u, groups g |
| 18 | + | g.short_description as description |
| 19 | - | WHERE ug.group_id = #gidnumber# |
| 19 | + | FROM user_group ug, user u, groups g |
| 20 | - | AND ug.user_id = u.user_id |
| 20 | + | WHERE ug.group_id = #gidnumber#-1000 |
| 21 | - | AND g.group_id = #gidnumber# |
| 21 | + | AND ug.user_id = u.user_id |
| 22 | AND g.group_id = #gidnumber#-1000 | |
| 23 | </select> | |
| 24 | - | </select> |
| 24 | + | |
| 25 | ||
| 26 | <select id="getPosixGroupClean" resultClass="java.util.HashMap" parameterClass="java.util.Map"> | |
| 27 | - | <select id="getPosixGroupClean" resultClass="java.util.HashMap" parameterClass="java.util.Map"> |
| 27 | + | SELECT group_id+1000 as gidNumber, |
| 28 | - | SELECT group_id+1000 as gidNumber, |
| 28 | + | unix_group_name as cn |
| 29 | - | unix_group_name as cn |
| 29 | + | FROM groups |
| 30 | - | FROM groups |
| 30 | + | WHERE group_id = #gidnumber#-1000 |
| 31 | - | WHERE group_id = #gidnumber# |
| 31 | + | </select> |
| 32 | - | </select> |
| 32 | + | |
| 33 | </sqlMap> |
