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: import java.util.Map;
050: import java.util.HashMap;
051:
052: // Village
053: import com.workingdogs.village.Record;
054: import com.workingdogs.village.DataSetException;
055:
056: // Turbine classes
057: import org.apache.torque.TorqueException;
058: import org.apache.torque.util.Criteria;
059:
060: /**
061: * The Peer class for an AttributeValue
062: *
063: * @author <a href="mailto:jmcnally@collab.net">John McNally</a>
064: * @author <a href="mailto:jon@collab.net">Jon S. Stevens</a>
065: * @author <a href="mailto:elicia@collab.net">Elicia David</a>
066: * @version $Id: AttributeValuePeer.java 9977 2005-12-09 00:40:59Z hair $
067: */
068: public class AttributeValuePeer extends BaseAttributeValuePeer {
069: private static Map classMap = new HashMap();
070:
071: private static final String COUNT = "count(" + VALUE_ID + ')';
072: private static final String COUNT_DISTINCT = "count(DISTINCT "
073: + VALUE_ID + ')';
074:
075: /**
076: * Adds count(AttributeValuePeer.VALUE_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 VALUE_ID's they will be counted. However, if the
079: * criteria is known not to lead to this, or unique VALUE_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) AttributeValuePeer
091: .doSelectVillageRecords(crit).get(0)).getValue(1)
092: .asInt();
093: }
094:
095: /**
096: * Adds count(DISTINCT AttributeValuePeer.VALUE_ID) to the select clause and returns
097: * the number of rows resulting from the given Criteria. The returned
098: * value will be the number of unique VALUE_ID's.
099: *
100: * @param crit a <code>Criteria</code> value
101: * @return an <code>int</code> value
102: * @exception TorqueException if an error occurs
103: * @exception DataSetException if an error occurs
104: */
105: public static int countDistinct(Criteria crit)
106: throws TorqueException, DataSetException {
107: crit.addSelectColumn(COUNT_DISTINCT);
108: return ((Record) AttributeValuePeer
109: .doSelectVillageRecords(crit).get(0)).getValue(1)
110: .asInt();
111: }
112:
113: /**
114: * Get the className appropriate for a row in the
115: * SCARAB_ISSUE_ATTRIBUTE_VALUE table
116: */
117: public static Class getOMClass(Record record, int offset)
118: throws TorqueException {
119: Class c = null;
120: try {
121: Integer attId = new Integer(record.getValue(offset - 1 + 3)
122: .asString());
123: Attribute attribute = AttributeManager.getInstance(attId);
124: String className = attribute.getAttributeType()
125: .getJavaClassName();
126:
127: c = (Class) classMap.get(className);
128: if (c == null) {
129: c = Class.forName(className);
130: classMap.put(className, c);
131: }
132: } catch (Exception e) {
133: throw new TorqueException(e); //EXCEPTION
134: }
135:
136: return c;
137: }
138: }
|