KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > blandware > atleap > persistence > hibernate > core > LookupDAOHibernate


1 /*
2  * Copyright 2004 Blandware (http://www.blandware.com)
3  *
4  * Licensed under the Apache License, Version 2.0 (the "License");
5  * you may not use this file except in compliance with the License.
6  * You may obtain a copy of the License at
7  *
8  * http://www.apache.org/licenses/LICENSE-2.0
9  *
10  * Unless required by applicable law or agreed to in writing, software
11  * distributed under the License is distributed on an "AS IS" BASIS,
12  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13  * See the License for the specific language governing permissions and
14  * limitations under the License.
15  */

16 package com.blandware.atleap.persistence.hibernate.core;
17
18 import com.blandware.atleap.persistence.core.LookupDAO;
19 import com.blandware.atleap.model.core.ActionPage;
20 import com.blandware.atleap.model.core.ContentPage;
21 import com.blandware.atleap.model.core.ContentDocument;
22 import com.blandware.atleap.model.core.ContentImage;
23 import com.blandware.atleap.common.Constants;
24
25 import java.util.List JavaDoc;
26
27
28 /**
29  * <p>Hibernate implementation of LookupDAO.
30  * </p>
31  * <p><a HREF="LookupDAOHibernate.java.htm"><i>View Source</i></a>
32  * </p>
33  *
34  * @author Sergey Zubtcovskii <a HREF="mailto:sergey.zubtcovskii@blandware.com">&lt;sergey.zubtcovskii@blandware.com&gt;</a>
35  * @version $Revision: 1.23 $ $Date: 2006/03/26 16:12:49 $
36  */

37 public class LookupDAOHibernate extends BaseDAOHibernate implements LookupDAO {
38
39     /**
40      * @see com.blandware.atleap.persistence.core.LookupDAO#listRoleTitles()
41      */

42     public List JavaDoc listRoleTitles() {
43         if ( log.isDebugEnabled() ) {
44             log.debug("retrieving all role titles...");
45         }
46         return executeFind("select r.title from Role r order by r.title");
47     }
48
49     /**
50      * @see com.blandware.atleap.persistence.core.LookupDAO#listRoles()
51      */

52     public List JavaDoc listRoles() {
53         if ( log.isDebugEnabled() ) {
54             log.debug("retrieving all roles...");
55         }
56         return executeFind("select r from Role r order by r.title");
57     }
58
59     /**
60      * @see com.blandware.atleap.persistence.core.LookupDAO#listRolesAssignedToLinkableItems()
61      */

62     public List JavaDoc listRolesAssignedToLinkableItems() {
63         if ( log.isDebugEnabled() ) {
64             log.debug("retrieving roles assigned to linkable items...");
65         }
66         return executeFind("select distinct r from Page as page inner join page.roles as r where page.className != '" + ActionPage.class.getName() + "' and page.className != '" + ContentPage.class.getName() + "' order by r.title");
67     }
68
69     /**
70      * @see com.blandware.atleap.persistence.core.LookupDAO#listRolesAssignedToContentPages()
71      */

72     public List JavaDoc listRolesAssignedToContentPages() {
73         if ( log.isDebugEnabled() ) {
74             log.debug("retrieving roles assigned to content pages...");
75         }
76         return executeFind("select distinct r from ContentPage as page inner join page.roles as r order by r.title");
77     }
78
79     /**
80      * @see com.blandware.atleap.persistence.core.LookupDAO#listRolesAssignedToDocuments()
81      */

82     public List JavaDoc listRolesAssignedToDocuments() {
83         if ( log.isDebugEnabled() ) {
84             log.debug("retrieving roles assigned to documents...");
85         }
86         return executeFind("select distinct r from ContentDocument as document inner join document.roles as r order by r.title");
87     }
88
89     /**
90      * @see com.blandware.atleap.persistence.core.LookupDAO#listRolesAssignedToFiles()
91      */

92     public List JavaDoc listRolesAssignedToFiles() {
93         if ( log.isDebugEnabled() ) {
94             log.debug("retrieving roles assigned to content resources...");
95         }
96         return executeFind("select distinct r from ContentResource as resource inner join resource.roles as r where resource.type = '" + Constants.RESOURCE_TYPE_FILE + "' order by r.title");
97     }
98
99     /**
100      * @see com.blandware.atleap.persistence.core.LookupDAO#listRolesAssignedToImages()
101      */

102     public List JavaDoc listRolesAssignedToImages() {
103         if ( log.isDebugEnabled() ) {
104             log.debug("retrieving roles assigned to images...");
105         }
106         return executeFind("select distinct r from ContentImage as image inner join image.roles as r order by r.title");
107     }
108
109     /**
110      * @see com.blandware.atleap.persistence.core.LookupDAO#listRolesAssignedToContentResources()
111      */

112     public List JavaDoc listRolesAssignedToContentResources() {
113         if ( log.isDebugEnabled() ) {
114             log.debug("retrieving roles assigned to content resources...");
115         }
116         return executeFind("select distinct r from ContentResource as resource inner join resource.roles as r order by r.title");
117     }
118
119     /**
120      * @see com.blandware.atleap.persistence.core.LookupDAO#listFreeRolesAssignedToUsers()
121      */

122     public List JavaDoc listFreeRolesAssignedToUsers() {
123         if ( log.isDebugEnabled() ) {
124             log.debug("retrieving roles assigned to users as free roles...");
125         }
126         return executeFind("select distinct r from User as u inner join u.rolesAssociations as fra left outer join fra.role as r where fra.group is null order by r.title");
127     }
128
129     /**
130      * @see com.blandware.atleap.persistence.core.LookupDAO#listRolesAssignedToNewsItems()
131      */

132     public List JavaDoc listRolesAssignedToNewsItems() {
133         if ( log.isDebugEnabled() ) {
134             log.debug("retrieving roles assigned to news items...");
135         }
136         return executeFind("select distinct r from NewsItem as item inner join item.roles as r order by r.title");
137     }
138
139     /**
140      * @see com.blandware.atleap.persistence.core.LookupDAO#listGroups() ()
141      */

142     public List JavaDoc listGroups() {
143         if ( log.isDebugEnabled() ) {
144             log.debug("retrieving all groups...");
145         }
146         return executeFind("select g from Group g order by g.title");
147     }
148
149     /**
150      * @see com.blandware.atleap.persistence.core.LookupDAO#listLayoutNames()
151      */

152     public List JavaDoc listLayoutNames() {
153         if ( log.isDebugEnabled() ) {
154             log.debug("retrieving all layout names...");
155         }
156         return executeFind("select l.name from Layout l order by l.name");
157     }
158
159     /**
160      * @see com.blandware.atleap.persistence.core.LookupDAO#listLayouts()
161      */

162     public List JavaDoc listLayouts() {
163         if ( log.isDebugEnabled() ) {
164             log.debug("retrieving all layouts...");
165         }
166         return executeFind("select l from Layout l order by l.name");
167     }
168
169     /**
170      * @see com.blandware.atleap.persistence.core.LookupDAO#listContentResourceTypes()
171      */

172     public List JavaDoc listContentResourceTypes() {
173         if ( log.isDebugEnabled() ) {
174             log.debug("retrieving all content resource types...");
175         }
176         return executeFind("select distinct r.type from ContentResource r order by r.type");
177     }
178 }
179
Popular Tags