01: /**
02: * Copyright (c) 2000-2008 Liferay, Inc. All rights reserved.
03: *
04: * Permission is hereby granted, free of charge, to any person obtaining a copy
05: * of this software and associated documentation files (the "Software"), to deal
06: * in the Software without restriction, including without limitation the rights
07: * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
08: * copies of the Software, and to permit persons to whom the Software is
09: * furnished to do so, subject to the following conditions:
10: *
11: * The above copyright notice and this permission notice shall be included in
12: * all copies or substantial portions of the Software.
13: *
14: * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
15: * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
16: * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
17: * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
18: * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
19: * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
20: * SOFTWARE.
21: */package com.liferay.portal.service.persistence;
22:
23: import com.liferay.portal.NoSuchOrgGroupPermissionException;
24: import com.liferay.portal.SystemException;
25: import com.liferay.portal.model.OrgGroupPermission;
26: import com.liferay.portal.model.impl.OrgGroupPermissionImpl;
27: import com.liferay.portal.spring.hibernate.CustomSQLUtil;
28: import com.liferay.portal.spring.hibernate.HibernateUtil;
29: import com.liferay.util.dao.hibernate.QueryPos;
30:
31: import java.util.Iterator;
32:
33: import org.hibernate.SQLQuery;
34: import org.hibernate.Session;
35:
36: /**
37: * <a href="OrgGroupPermissionFinderImpl.java.html"><b><i>View Source</i></b>
38: * </a>
39: *
40: * @author Brian Wing Shun Chan
41: *
42: */
43: public class OrgGroupPermissionFinderImpl implements
44: OrgGroupPermissionFinder {
45:
46: public static String FIND_BY_O_G_R = OrgGroupPermissionFinder.class
47: .getName()
48: + ".findByO_G_R";
49:
50: public void removeByO_G_R(long organizationId, long groupId,
51: long resourceId) throws NoSuchOrgGroupPermissionException,
52: SystemException {
53:
54: Session session = null;
55:
56: try {
57: session = HibernateUtil.openSession();
58:
59: String sql = CustomSQLUtil.get(FIND_BY_O_G_R);
60:
61: SQLQuery q = session.createSQLQuery(sql);
62:
63: q.addEntity("OrgGroupPermission",
64: OrgGroupPermissionImpl.class);
65:
66: QueryPos qPos = QueryPos.getInstance(q);
67:
68: qPos.add(resourceId);
69: qPos.add(organizationId);
70: qPos.add(groupId);
71:
72: Iterator itr = q.list().iterator();
73:
74: while (itr.hasNext()) {
75: OrgGroupPermission orgGroupPermission = (OrgGroupPermission) itr
76: .next();
77:
78: OrgGroupPermissionUtil.remove(orgGroupPermission
79: .getPrimaryKey());
80: }
81: } catch (Exception e) {
82: throw new SystemException(e);
83: } finally {
84: HibernateUtil.closeSession(session);
85: }
86: }
87:
88: }
|