001: package org.tigris.scarab.om;
002:
003: /* ================================================================
004: * Copyright (c) 2000-2005 CollabNet. All rights reserved.
005: *
006: * Redistribution and use in source and binary forms, with or without
007: * modification, are permitted provided that the following conditions are
008: * met:
009: *
010: * 1. Redistributions of source code must retain the above copyright
011: * notice, this list of conditions and the following disclaimer.
012: *
013: * 2. Redistributions in binary form must reproduce the above copyright
014: * notice, this list of conditions and the following disclaimer in the
015: * documentation and/or other materials provided with the distribution.
016: *
017: * 3. The end-user documentation included with the redistribution, if
018: * any, must include the following acknowlegement: "This product includes
019: * software developed by Collab.Net <http://www.Collab.Net/>."
020: * Alternately, this acknowlegement may appear in the software itself, if
021: * and wherever such third-party acknowlegements normally appear.
022: *
023: * 4. The hosted project names must not be used to endorse or promote
024: * products derived from this software without prior written
025: * permission. For written permission, please contact info@collab.net.
026: *
027: * 5. Products derived from this software may not use the "Tigris" or
028: * "Scarab" names nor may "Tigris" or "Scarab" appear in their names without
029: * prior written permission of Collab.Net.
030: *
031: * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
032: * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
033: * MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
034: * IN NO EVENT SHALL COLLAB.NET OR ITS CONTRIBUTORS BE LIABLE FOR ANY
035: * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
036: * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE
037: * GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
038: * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER
039: * IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
040: * OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
041: * ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
042: *
043: * ====================================================================
044: *
045: * This software consists of voluntary contributions made by many
046: * individuals on behalf of Collab.Net.
047: */
048:
049: // Turbine classes
050: import org.apache.torque.TorqueException;
051: import org.apache.torque.om.ObjectKey;
052: import org.apache.torque.util.Criteria;
053: import com.workingdogs.village.Record;
054: import com.workingdogs.village.DataSetException;
055:
056: // Scarab classes
057: import org.tigris.scarab.services.cache.ScarabCache;
058:
059: /**
060: * The Peer class for an issue.
061: *
062: * @author <a href="mailto:jmcnally@collab.net">John McNally</a>
063: * @author <a href="mailto:jon@collab.net">Jon S. Stevens</a>
064: * @author <a href="mailto:elicia@collab.net">Elicia David</a>
065: * @version $Id: IssuePeer.java 9977 2005-12-09 00:40:59Z hair $
066: */
067: public class IssuePeer extends BaseIssuePeer {
068: private static final String ISSUE_PEER = "IssuePeer";
069: private static final String RETRIEVE_BY_PK = "retrieveByPK";
070:
071: private static final String COUNT = "count(" + ISSUE_ID + ')';
072: private static final String COUNT_DISTINCT = "count(DISTINCT "
073: + ISSUE_ID + ')';
074:
075: /**
076: * Adds count(IssuePeer.ISSUE_ID) to the select clause and returns the
077: * number of rows resulting from the given Criteria. If the criteria will
078: * lead to duplicate ISSUE_ID's they will be counted. However, if the
079: * criteria is known not to lead to this, or unique ISSUE_ID's are not
080: * required, this method is cheaper than {@link #countDistinct(Criteria)}
081: *
082: * @param crit a <code>Criteria</code> value
083: * @return an <code>int</code> value
084: * @exception TorqueException if an error occurs
085: * @exception DataSetException if an error occurs
086: */
087: public static int count(Criteria crit) throws TorqueException,
088: DataSetException {
089: crit.addSelectColumn(COUNT);
090: return ((Record) IssuePeer.doSelectVillageRecords(crit).get(0))
091: .getValue(1).asInt();
092: }
093:
094: /**
095: * Adds count(DISTINCT IssuePeer.ISSUE_ID) to the select clause and returns
096: * the number of rows resulting from the given Criteria. The returned
097: * value will be the number of unique ISSUE_ID's.
098: *
099: * @param crit a <code>Criteria</code> value
100: * @return an <code>int</code> value
101: * @exception TorqueException if an error occurs
102: * @exception DataSetException if an error occurs
103: */
104: public static int countDistinct(Criteria crit)
105: throws TorqueException, DataSetException {
106: crit.addSelectColumn(COUNT_DISTINCT);
107: return ((Record) IssuePeer.doSelectVillageRecords(crit).get(0))
108: .getValue(1).asInt();
109: }
110:
111: /**
112: * Retrieve a single object by pk
113: *
114: * @param pk
115: */
116: public static Issue retrieveByPK(ObjectKey pk)
117: throws TorqueException {
118: Issue result = null;
119: Object obj = ScarabCache.get(ISSUE_PEER, RETRIEVE_BY_PK, pk);
120: if (obj == null) {
121: result = BaseIssuePeer.retrieveByPK(pk);
122: ScarabCache.put(result, ISSUE_PEER, RETRIEVE_BY_PK, pk);
123: } else {
124: result = (Issue) obj;
125: }
126:
127: result = BaseIssuePeer.retrieveByPK(pk);
128: return result;
129: }
130: }
|