package org.apache.turbine.services.security.torque.om;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.LinkedList;
import java.util.List;
import org.apache.torque.NoRowsException;
import org.apache.torque.TooManyRowsException;
import org.apache.torque.Torque;
import org.apache.torque.TorqueException;
import org.apache.torque.TorqueRuntimeException;
import org.apache.torque.map.MapBuilder;
import org.apache.torque.map.TableMap;
import org.apache.torque.om.DateKey;
import org.apache.torque.om.NumberKey;
import org.apache.torque.om.StringKey;
import org.apache.torque.om.ObjectKey;
import org.apache.torque.om.SimpleKey;
import org.apache.torque.util.BasePeer;
import org.apache.torque.util.Criteria;
import com.workingdogs.village.DataSetException;
import com.workingdogs.village.QueryDataSet;
import com.workingdogs.village.Record;
// Local classes
import org.apache.turbine.services.security.torque.om.map.*;
/**
* This class was autogenerated by Torque on:
*
* [Thu Jun 23 17:25:46 CEST 2011]
*
*/
public abstract class BaseTurbineUserGroupRolePeer
extends BasePeer
{
/** Serial version */
private static final long serialVersionUID = 1308842746584L;
/** the default database name for this class */
public static final String DATABASE_NAME;
/** the table name for this class */
public static final String TABLE_NAME;
/**
* @return the map builder for this peer
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
* @deprecated Torque.getMapBuilder(TurbineUserGroupRoleMapBuilder.CLASS_NAME) instead
*/
public static MapBuilder getMapBuilder()
throws TorqueException
{
return Torque.getMapBuilder(TurbineUserGroupRoleMapBuilder.CLASS_NAME);
}
/** the column name for the USER_ID field */
public static final String USER_ID;
/** the column name for the GROUP_ID field */
public static final String GROUP_ID;
/** the column name for the ROLE_ID field */
public static final String ROLE_ID;
static
{
DATABASE_NAME = "default";
TABLE_NAME = "TURBINE_USER_GROUP_ROLE";
USER_ID = "TURBINE_USER_GROUP_ROLE.USER_ID";
GROUP_ID = "TURBINE_USER_GROUP_ROLE.GROUP_ID";
ROLE_ID = "TURBINE_USER_GROUP_ROLE.ROLE_ID";
if (Torque.isInit())
{
try
{
Torque.getMapBuilder(TurbineUserGroupRoleMapBuilder.CLASS_NAME);
}
catch (TorqueException e)
{
log.error("Could not initialize Peer", e);
throw new TorqueRuntimeException(e);
}
}
else
{
Torque.registerMapBuilder(TurbineUserGroupRoleMapBuilder.CLASS_NAME);
}
}
/** number of columns for this peer */
public static final int numColumns = 3;
/** A class that can be returned by this peer. */
protected static final String CLASSNAME_DEFAULT =
"org.apache.turbine.services.security.torque.om.TurbineUserGroupRole";
/** A class that can be returned by this peer. */
protected static final Class CLASS_DEFAULT = initClass(CLASSNAME_DEFAULT);
/**
* Class object initialization method.
*
* @param className name of the class to initialize
* @return the initialized class
*/
private static Class initClass(String className)
{
Class c = null;
try
{
c = Class.forName(className);
}
catch (Throwable t)
{
log.error("A FATAL ERROR has occurred which should not "
+ "have happened under any circumstance. Please notify "
+ "the Torque developers <torque-dev@db.apache.org> "
+ "and give as many details as possible (including the error "
+ "stack trace).", t);
// Error objects should always be propagated.
if (t instanceof Error)
{
throw (Error) t.fillInStackTrace();
}
}
return c;
}
/**
* Get the list of objects for a ResultSet. Please not that your
* resultset MUST return columns in the right order. You can use
* getFieldNames() in BaseObject to get the correct sequence.
*
* @param results the ResultSet
* @return the list of objects
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static List<TurbineUserGroupRole> resultSet2Objects(java.sql.ResultSet results)
throws TorqueException
{
try
{
QueryDataSet qds = null;
List<Record> rows = null;
try
{
qds = new QueryDataSet(results);
rows = getSelectResults(qds);
}
finally
{
if (qds != null)
{
qds.close();
}
}
return populateObjects(rows);
}
catch (SQLException e)
{
throw new TorqueException(e);
}
catch (DataSetException e)
{
throw new TorqueException(e);
}
}
/**
* Method to do inserts.
*
* @param criteria object used to create the INSERT statement.
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static ObjectKey doInsert(Criteria criteria)
throws TorqueException
{
return BaseTurbineUserGroupRolePeer
.doInsert(criteria, (Connection) null);
}
/**
* Method to do inserts. This method is to be used during a transaction,
* otherwise use the doInsert(Criteria) method. It will take care of
* the connection details internally.
*
* @param criteria object used to create the INSERT statement.
* @param con the connection to use
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static ObjectKey doInsert(Criteria criteria, Connection con)
throws TorqueException
{
correctBooleans(criteria);
setDbName(criteria);
if (con == null)
{
return BasePeer.doInsert(criteria);
}
else
{
return BasePeer.doInsert(criteria, con);
}
}
/**
* Add all the columns needed to create a new object.
*
* @param criteria object containing the columns to add.
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static void addSelectColumns(Criteria criteria)
throws TorqueException
{
criteria.addSelectColumn(USER_ID);
criteria.addSelectColumn(GROUP_ID);
criteria.addSelectColumn(ROLE_ID);
}
/**
* changes the boolean values in the criteria to the appropriate type,
* whenever a booleanchar or booleanint column is involved.
* This enables the user to create criteria using Boolean values
* for booleanchar or booleanint columns
* @param criteria the criteria in which the boolean values should be corrected
* @throws TorqueException if the database map for the criteria cannot be
obtained.
*/
public static void correctBooleans(Criteria criteria) throws TorqueException
{
correctBooleans(criteria, getTableMap());
}
/**
* Create a new object of type cls from a resultset row starting
* from a specified offset. This is done so that you can select
* other rows than just those needed for this object. You may
* for example want to create two objects from the same row.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static TurbineUserGroupRole row2Object(Record row,
int offset,
Class cls)
throws TorqueException
{
try
{
TurbineUserGroupRole obj = (TurbineUserGroupRole) cls.newInstance();
TurbineUserGroupRolePeer.populateObject(row, offset, obj);
obj.setModified(false);
obj.setNew(false);
return obj;
}
catch (InstantiationException e)
{
throw new TorqueException(e);
}
catch (IllegalAccessException e)
{
throw new TorqueException(e);
}
}
/**
* Populates an object from a resultset row starting
* from a specified offset. This is done so that you can select
* other rows than just those needed for this object. You may
* for example want to create two objects from the same row.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static void populateObject(Record row,
int offset,
TurbineUserGroupRole obj)
throws TorqueException
{
try
{
obj.setUserId(row.getValue(offset + 0).asInt());
obj.setGroupId(row.getValue(offset + 1).asInt());
obj.setRoleId(row.getValue(offset + 2).asInt());
}
catch (DataSetException e)
{
throw new TorqueException(e);
}
}
/**
* Method to do selects.
*
* @param criteria object used to create the SELECT statement.
* @return List of selected Objects
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static List<TurbineUserGroupRole> doSelect(Criteria criteria) throws TorqueException
{
return populateObjects(doSelectVillageRecords(criteria));
}
/**
* Method to do selects within a transaction.
*
* @param criteria object used to create the SELECT statement.
* @param con the connection to use
* @return List of selected Objects
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static List<TurbineUserGroupRole> doSelect(Criteria criteria, Connection con)
throws TorqueException
{
return populateObjects(doSelectVillageRecords(criteria, con));
}
/**
* Grabs the raw Village records to be formed into objects.
* This method handles connections internally. The Record objects
* returned by this method should be considered readonly. Do not
* alter the data and call save(), your results may vary, but are
* certainly likely to result in hard to track MT bugs.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static List<Record> doSelectVillageRecords(Criteria criteria)
throws TorqueException
{
return BaseTurbineUserGroupRolePeer
.doSelectVillageRecords(criteria, (Connection) null);
}
/**
* Grabs the raw Village records to be formed into objects.
* This method should be used for transactions
*
* @param criteria object used to create the SELECT statement.
* @param con the connection to use
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static List<Record> doSelectVillageRecords(Criteria criteria, Connection con)
throws TorqueException
{
if (criteria.getSelectColumns().size() == 0)
{
addSelectColumns(criteria);
}
correctBooleans(criteria);
setDbName(criteria);
// BasePeer returns a List of Value (Village) arrays. The array
// order follows the order columns were placed in the Select clause.
if (con == null)
{
return BasePeer.doSelect(criteria);
}
else
{
return BasePeer.doSelect(criteria, con);
}
}
/**
* The returned List will contain objects of the default type or
* objects that inherit from the default.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static List<TurbineUserGroupRole> populateObjects(List<Record> records)
throws TorqueException
{
List<TurbineUserGroupRole> results = new ArrayList<TurbineUserGroupRole>(records.size());
// populate the object(s)
for (int i = 0; i < records.size(); i++)
{
Record row = records.get(i);
results.add(TurbineUserGroupRolePeer.row2Object(row, 1,
TurbineUserGroupRolePeer.getOMClass()));
}
return results;
}
/**
* The class that the Peer will make instances of.
* If the BO is abstract then you must implement this method
* in the BO.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static Class getOMClass()
throws TorqueException
{
return CLASS_DEFAULT;
}
/**
* Method to do updates.
*
* @param criteria object containing data that is used to create the UPDATE
* statement.
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static void doUpdate(Criteria criteria) throws TorqueException
{
BaseTurbineUserGroupRolePeer
.doUpdate(criteria, (Connection) null);
}
/**
* Method to do updates. This method is to be used during a transaction,
* otherwise use the doUpdate(Criteria) method. It will take care of
* the connection details internally.
*
* @param criteria object containing data that is used to create the UPDATE
* statement.
* @param con the connection to use
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static void doUpdate(Criteria criteria, Connection con)
throws TorqueException
{
Criteria selectCriteria = new Criteria(DATABASE_NAME, 2);
correctBooleans(criteria);
selectCriteria.put(USER_ID, criteria.remove(USER_ID));
selectCriteria.put(GROUP_ID, criteria.remove(GROUP_ID));
selectCriteria.put(ROLE_ID, criteria.remove(ROLE_ID));
setDbName(criteria);
if (con == null)
{
BasePeer.doUpdate(selectCriteria, criteria);
}
else
{
BasePeer.doUpdate(selectCriteria, criteria, con);
}
}
/**
* Method to do deletes.
*
* @param criteria object containing data that is used DELETE from database.
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static void doDelete(Criteria criteria) throws TorqueException
{
TurbineUserGroupRolePeer
.doDelete(criteria, (Connection) null);
}
/**
* Method to do deletes. This method is to be used during a transaction,
* otherwise use the doDelete(Criteria) method. It will take care of
* the connection details internally.
*
* @param criteria object containing data that is used DELETE from database.
* @param con the connection to use
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static void doDelete(Criteria criteria, Connection con)
throws TorqueException
{
correctBooleans(criteria);
setDbName(criteria);
if (con == null)
{
BasePeer.doDelete(criteria, TABLE_NAME);
}
else
{
BasePeer.doDelete(criteria, TABLE_NAME, con);
}
}
/**
* Method to do selects
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static List<TurbineUserGroupRole> doSelect(TurbineUserGroupRole obj) throws TorqueException
{
return doSelect(buildSelectCriteria(obj));
}
/**
* Method to do inserts
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static void doInsert(TurbineUserGroupRole obj) throws TorqueException
{
doInsert(buildCriteria(obj));
obj.setNew(false);
obj.setModified(false);
}
/**
* @param obj the data object to update in the database.
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static void doUpdate(TurbineUserGroupRole obj) throws TorqueException
{
doUpdate(buildCriteria(obj));
obj.setModified(false);
}
/**
* @param obj the data object to delete in the database.
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static void doDelete(TurbineUserGroupRole obj) throws TorqueException
{
doDelete(buildSelectCriteria(obj));
}
/**
* Method to do inserts. This method is to be used during a transaction,
* otherwise use the doInsert(TurbineUserGroupRole) method. It will take
* care of the connection details internally.
*
* @param obj the data object to insert into the database.
* @param con the connection to use
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static void doInsert(TurbineUserGroupRole obj, Connection con)
throws TorqueException
{
doInsert(buildCriteria(obj), con);
obj.setNew(false);
obj.setModified(false);
}
/**
* Method to do update. This method is to be used during a transaction,
* otherwise use the doUpdate(TurbineUserGroupRole) method. It will take
* care of the connection details internally.
*
* @param obj the data object to update in the database.
* @param con the connection to use
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static void doUpdate(TurbineUserGroupRole obj, Connection con)
throws TorqueException
{
doUpdate(buildCriteria(obj), con);
obj.setModified(false);
}
/**
* Method to delete. This method is to be used during a transaction,
* otherwise use the doDelete(TurbineUserGroupRole) method. It will take
* care of the connection details internally.
*
* @param obj the data object to delete in the database.
* @param con the connection to use
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static void doDelete(TurbineUserGroupRole obj, Connection con)
throws TorqueException
{
doDelete(buildSelectCriteria(obj), con);
}
/**
* Method to do deletes.
*
* @param pk ObjectKey that is used DELETE from database.
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static void doDelete(ObjectKey pk) throws TorqueException
{
BaseTurbineUserGroupRolePeer
.doDelete(pk, (Connection) null);
}
/**
* Method to delete. This method is to be used during a transaction,
* otherwise use the doDelete(ObjectKey) method. It will take
* care of the connection details internally.
*
* @param pk the primary key for the object to delete in the database.
* @param con the connection to use
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static void doDelete(ObjectKey pk, Connection con)
throws TorqueException
{
doDelete(buildCriteria(pk), con);
}
/** Build a Criteria object from an ObjectKey */
public static Criteria buildCriteria( ObjectKey pk )
{
Criteria criteria = new Criteria();
SimpleKey[] keys = (SimpleKey[])pk.getValue();
criteria.add(USER_ID, keys[0]);
criteria.add(GROUP_ID, keys[1]);
criteria.add(ROLE_ID, keys[2]);
return criteria;
}
/** Build a Criteria object from the data object for this peer */
public static Criteria buildCriteria( TurbineUserGroupRole obj )
{
Criteria criteria = new Criteria(DATABASE_NAME);
criteria.add(USER_ID, obj.getUserId());
criteria.add(GROUP_ID, obj.getGroupId());
criteria.add(ROLE_ID, obj.getRoleId());
return criteria;
}
/** Build a Criteria object from the data object for this peer, skipping all binary columns */
public static Criteria buildSelectCriteria( TurbineUserGroupRole obj )
{
Criteria criteria = new Criteria(DATABASE_NAME);
criteria.add(USER_ID, obj.getUserId());
criteria.add(GROUP_ID, obj.getGroupId());
criteria.add(ROLE_ID, obj.getRoleId());
return criteria;
}
/**
* Retrieve a single object by pk
*
* @param pk the primary key
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
* @throws NoRowsException Primary key was not found in database.
* @throws TooManyRowsException Primary key was not found in database.
*/
public static TurbineUserGroupRole retrieveByPK(ObjectKey pk)
throws TorqueException, NoRowsException, TooManyRowsException
{
Connection db = null;
TurbineUserGroupRole retVal = null;
try
{
db = Torque.getConnection(DATABASE_NAME);
retVal = retrieveByPK(pk, db);
}
finally
{
Torque.closeConnection(db);
}
return retVal;
}
/**
* Retrieve a single object by pk
*
* @param pk the primary key
* @param con the connection to use
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
* @throws NoRowsException Primary key was not found in database.
* @throws TooManyRowsException Primary key was not found in database.
*/
public static TurbineUserGroupRole retrieveByPK(ObjectKey pk, Connection con)
throws TorqueException, NoRowsException, TooManyRowsException
{
Criteria criteria = buildCriteria(pk);
List<TurbineUserGroupRole> v = doSelect(criteria, con);
if (v.size() == 0)
{
throw new NoRowsException("Failed to select a row.");
}
else if (v.size() > 1)
{
throw new TooManyRowsException("Failed to select only one row.");
}
else
{
return (TurbineUserGroupRole)v.get(0);
}
}
/**
* Retrieve a multiple objects by pk
*
* @param pks List of primary keys
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static List<TurbineUserGroupRole> retrieveByPKs(List<ObjectKey> pks)
throws TorqueException
{
Connection db = null;
List<TurbineUserGroupRole> retVal = null;
try
{
db = Torque.getConnection(DATABASE_NAME);
retVal = retrieveByPKs(pks, db);
}
finally
{
Torque.closeConnection(db);
}
return retVal;
}
/**
* Retrieve a multiple objects by pk
*
* @param pks List of primary keys
* @param dbcon the connection to use
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static List<TurbineUserGroupRole> retrieveByPKs( List<ObjectKey> pks, Connection dbcon )
throws TorqueException
{
List<TurbineUserGroupRole> objs = null;
if (pks == null || pks.size() == 0)
{
objs = new LinkedList<TurbineUserGroupRole>();
}
else
{
Criteria criteria = new Criteria();
Iterator<ObjectKey> iter = pks.iterator();
while (iter.hasNext())
{
ObjectKey pk = iter.next();
SimpleKey[] keys = (SimpleKey[])pk.getValue();
Criteria.Criterion c0 = criteria.getNewCriterion(
USER_ID, keys[0], Criteria.EQUAL);
Criteria.Criterion c1 = criteria.getNewCriterion(
GROUP_ID, keys[1], Criteria.EQUAL);
c0.and(c1);
Criteria.Criterion c2 = criteria.getNewCriterion(
ROLE_ID, keys[2], Criteria.EQUAL);
c1.and(c2);
criteria.or(c0);
}
objs = doSelect(criteria, dbcon);
}
return objs;
}
/**
* retrieve object using using pk values.
*
* @param userId int
* @param groupId int
* @param roleId int
*/
public static TurbineUserGroupRole retrieveByPK(
int userId
, int groupId
, int roleId
) throws TorqueException
{
Connection db = null;
TurbineUserGroupRole retVal = null;
try
{
db = Torque.getConnection(DATABASE_NAME);
retVal = retrieveByPK(
userId
, groupId
, roleId
, db);
}
finally
{
Torque.closeConnection(db);
}
return retVal;
}
/**
* retrieve object using using pk values.
*
* @param userId int
* @param groupId int
* @param roleId int
* @param con Connection
*/
public static TurbineUserGroupRole retrieveByPK(
int userId
, int groupId
, int roleId
,Connection con) throws TorqueException
{
Criteria criteria = new Criteria(5);
criteria.add(USER_ID, userId);
criteria.add(GROUP_ID, groupId);
criteria.add(ROLE_ID, roleId);
List<TurbineUserGroupRole> v = doSelect(criteria, con);
if (v.size() == 1)
{
return v.get(0);
}
else
{
throw new TorqueException("Failed to select one and only one row.");
}
}
/**
* selects a collection of TurbineUserGroupRole objects pre-filled with their
* TurbineUser objects.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in TurbineUserGroupRolePeer.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
protected static List<TurbineUserGroupRole> doSelectJoinTurbineUser(Criteria criteria)
throws TorqueException
{
return doSelectJoinTurbineUser(criteria, null);
}
/**
* selects a collection of TurbineUserGroupRole objects pre-filled with their
* TurbineUser objects.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in TurbineUserGroupRolePeer.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
protected static List<TurbineUserGroupRole> doSelectJoinTurbineUser(Criteria criteria, Connection conn)
throws TorqueException
{
setDbName(criteria);
TurbineUserGroupRolePeer.addSelectColumns(criteria);
int offset = numColumns + 1;
TurbineUserPeer.addSelectColumns(criteria);
criteria.addJoin(TurbineUserGroupRolePeer.USER_ID,
TurbineUserPeer.USER_ID);
correctBooleans(criteria);
List<Record> rows;
if (conn == null)
{
rows = BasePeer.doSelect(criteria);
}
else
{
rows = BasePeer.doSelect(criteria,conn);
}
List<TurbineUserGroupRole> results = new ArrayList<TurbineUserGroupRole>();
for (int i = 0; i < rows.size(); i++)
{
Record row = rows.get(i);
Class omClass = TurbineUserGroupRolePeer.getOMClass();
TurbineUserGroupRole obj1 = (TurbineUserGroupRole) TurbineUserGroupRolePeer
.row2Object(row, 1, omClass);
omClass = TurbineUserPeer.getOMClass();
TurbineUser obj2 = (TurbineUser) TurbineUserPeer
.row2Object(row, offset, omClass);
boolean newObject = true;
for (int j = 0; j < results.size(); j++)
{
TurbineUserGroupRole temp_obj1 = results.get(j);
TurbineUser temp_obj2 = (TurbineUser) temp_obj1.getTurbineUser();
if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey()))
{
newObject = false;
temp_obj2.addTurbineUserGroupRole(obj1);
break;
}
}
if (newObject)
{
obj2.initTurbineUserGroupRoles();
obj2.addTurbineUserGroupRole(obj1);
}
results.add(obj1);
}
return results;
}
/**
* selects a collection of TurbineUserGroupRole objects pre-filled with their
* TurbineGroup objects.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in TurbineUserGroupRolePeer.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
protected static List<TurbineUserGroupRole> doSelectJoinTurbineGroup(Criteria criteria)
throws TorqueException
{
return doSelectJoinTurbineGroup(criteria, null);
}
/**
* selects a collection of TurbineUserGroupRole objects pre-filled with their
* TurbineGroup objects.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in TurbineUserGroupRolePeer.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
protected static List<TurbineUserGroupRole> doSelectJoinTurbineGroup(Criteria criteria, Connection conn)
throws TorqueException
{
setDbName(criteria);
TurbineUserGroupRolePeer.addSelectColumns(criteria);
int offset = numColumns + 1;
TurbineGroupPeer.addSelectColumns(criteria);
criteria.addJoin(TurbineUserGroupRolePeer.GROUP_ID,
TurbineGroupPeer.GROUP_ID);
correctBooleans(criteria);
List<Record> rows;
if (conn == null)
{
rows = BasePeer.doSelect(criteria);
}
else
{
rows = BasePeer.doSelect(criteria,conn);
}
List<TurbineUserGroupRole> results = new ArrayList<TurbineUserGroupRole>();
for (int i = 0; i < rows.size(); i++)
{
Record row = rows.get(i);
Class omClass = TurbineUserGroupRolePeer.getOMClass();
TurbineUserGroupRole obj1 = (TurbineUserGroupRole) TurbineUserGroupRolePeer
.row2Object(row, 1, omClass);
omClass = TurbineGroupPeer.getOMClass();
TurbineGroup obj2 = (TurbineGroup) TurbineGroupPeer
.row2Object(row, offset, omClass);
boolean newObject = true;
for (int j = 0; j < results.size(); j++)
{
TurbineUserGroupRole temp_obj1 = results.get(j);
TurbineGroup temp_obj2 = (TurbineGroup) temp_obj1.getTurbineGroup();
if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey()))
{
newObject = false;
temp_obj2.addTurbineUserGroupRole(obj1);
break;
}
}
if (newObject)
{
obj2.initTurbineUserGroupRoles();
obj2.addTurbineUserGroupRole(obj1);
}
results.add(obj1);
}
return results;
}
/**
* selects a collection of TurbineUserGroupRole objects pre-filled with their
* TurbineRole objects.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in TurbineUserGroupRolePeer.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
protected static List<TurbineUserGroupRole> doSelectJoinTurbineRole(Criteria criteria)
throws TorqueException
{
return doSelectJoinTurbineRole(criteria, null);
}
/**
* selects a collection of TurbineUserGroupRole objects pre-filled with their
* TurbineRole objects.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in TurbineUserGroupRolePeer.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
protected static List<TurbineUserGroupRole> doSelectJoinTurbineRole(Criteria criteria, Connection conn)
throws TorqueException
{
setDbName(criteria);
TurbineUserGroupRolePeer.addSelectColumns(criteria);
int offset = numColumns + 1;
TurbineRolePeer.addSelectColumns(criteria);
criteria.addJoin(TurbineUserGroupRolePeer.ROLE_ID,
TurbineRolePeer.ROLE_ID);
correctBooleans(criteria);
List<Record> rows;
if (conn == null)
{
rows = BasePeer.doSelect(criteria);
}
else
{
rows = BasePeer.doSelect(criteria,conn);
}
List<TurbineUserGroupRole> results = new ArrayList<TurbineUserGroupRole>();
for (int i = 0; i < rows.size(); i++)
{
Record row = rows.get(i);
Class omClass = TurbineUserGroupRolePeer.getOMClass();
TurbineUserGroupRole obj1 = (TurbineUserGroupRole) TurbineUserGroupRolePeer
.row2Object(row, 1, omClass);
omClass = TurbineRolePeer.getOMClass();
TurbineRole obj2 = (TurbineRole) TurbineRolePeer
.row2Object(row, offset, omClass);
boolean newObject = true;
for (int j = 0; j < results.size(); j++)
{
TurbineUserGroupRole temp_obj1 = results.get(j);
TurbineRole temp_obj2 = (TurbineRole) temp_obj1.getTurbineRole();
if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey()))
{
newObject = false;
temp_obj2.addTurbineUserGroupRole(obj1);
break;
}
}
if (newObject)
{
obj2.initTurbineUserGroupRoles();
obj2.addTurbineUserGroupRole(obj1);
}
results.add(obj1);
}
return results;
}
/**
* selects a collection of TurbineUserGroupRole objects pre-filled with
* all related objects.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in TurbineUserGroupRolePeer.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
protected static List<TurbineUserGroupRole> doSelectJoinAllExceptTurbineUser(Criteria criteria)
throws TorqueException
{
return doSelectJoinAllExceptTurbineUser(criteria, null);
}
/**
* selects a collection of TurbineUserGroupRole objects pre-filled with
* all related objects.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in TurbineUserGroupRolePeer.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
protected static List<TurbineUserGroupRole> doSelectJoinAllExceptTurbineUser(Criteria criteria, Connection conn)
throws TorqueException
{
setDbName(criteria);
addSelectColumns(criteria);
int offset2 = numColumns + 1;
TurbineGroupPeer.addSelectColumns(criteria);
criteria.addJoin(TurbineUserGroupRolePeer.GROUP_ID, TurbineGroupPeer.GROUP_ID);
int offset3 = offset2 + TurbineGroupPeer.numColumns;
TurbineRolePeer.addSelectColumns(criteria);
criteria.addJoin(TurbineUserGroupRolePeer.ROLE_ID, TurbineRolePeer.ROLE_ID);
correctBooleans(criteria);
List<Record> rows;
if (conn == null)
{
rows = BasePeer.doSelect(criteria);
}
else
{
rows = BasePeer.doSelect(criteria,conn);
}
List<TurbineUserGroupRole> results = new ArrayList<TurbineUserGroupRole>();
for (int i = 0; i < rows.size(); i++)
{
Record row = rows.get(i);
Class omClass = TurbineUserGroupRolePeer.getOMClass();
TurbineUserGroupRole obj1 = (TurbineUserGroupRole) TurbineUserGroupRolePeer
.row2Object(row, 1, omClass);
omClass = TurbineGroupPeer.getOMClass();
TurbineGroup obj2 = (TurbineGroup) TurbineGroupPeer
.row2Object( row, offset2, omClass);
boolean newObject = true;
for (int j = 0; j < results.size(); j++)
{
TurbineUserGroupRole temp_obj1 = results.get(j);
TurbineGroup temp_obj2 = (TurbineGroup) temp_obj1.getTurbineGroup();
if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey()))
{
newObject = false;
temp_obj2.addTurbineUserGroupRole(obj1);
break;
}
}
if (newObject)
{
obj2.initTurbineUserGroupRoles();
obj2.addTurbineUserGroupRole(obj1);
}
omClass = TurbineRolePeer.getOMClass();
TurbineRole obj3 = (TurbineRole) TurbineRolePeer
.row2Object( row, offset3, omClass);
newObject = true;
for (int j = 0; j < results.size(); j++)
{
TurbineUserGroupRole temp_obj1 = results.get(j);
TurbineRole temp_obj3 = (TurbineRole) temp_obj1.getTurbineRole();
if (temp_obj3.getPrimaryKey().equals(obj3.getPrimaryKey()))
{
newObject = false;
temp_obj3.addTurbineUserGroupRole(obj1);
break;
}
}
if (newObject)
{
obj3.initTurbineUserGroupRoles();
obj3.addTurbineUserGroupRole(obj1);
}
results.add(obj1);
}
return results;
}
/**
* selects a collection of TurbineUserGroupRole objects pre-filled with
* all related objects.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in TurbineUserGroupRolePeer.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
protected static List<TurbineUserGroupRole> doSelectJoinAllExceptTurbineGroup(Criteria criteria)
throws TorqueException
{
return doSelectJoinAllExceptTurbineGroup(criteria, null);
}
/**
* selects a collection of TurbineUserGroupRole objects pre-filled with
* all related objects.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in TurbineUserGroupRolePeer.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
protected static List<TurbineUserGroupRole> doSelectJoinAllExceptTurbineGroup(Criteria criteria, Connection conn)
throws TorqueException
{
setDbName(criteria);
addSelectColumns(criteria);
int offset2 = numColumns + 1;
TurbineUserPeer.addSelectColumns(criteria);
criteria.addJoin(TurbineUserGroupRolePeer.USER_ID, TurbineUserPeer.USER_ID);
int offset3 = offset2 + TurbineUserPeer.numColumns;
TurbineRolePeer.addSelectColumns(criteria);
criteria.addJoin(TurbineUserGroupRolePeer.ROLE_ID, TurbineRolePeer.ROLE_ID);
correctBooleans(criteria);
List<Record> rows;
if (conn == null)
{
rows = BasePeer.doSelect(criteria);
}
else
{
rows = BasePeer.doSelect(criteria,conn);
}
List<TurbineUserGroupRole> results = new ArrayList<TurbineUserGroupRole>();
for (int i = 0; i < rows.size(); i++)
{
Record row = rows.get(i);
Class omClass = TurbineUserGroupRolePeer.getOMClass();
TurbineUserGroupRole obj1 = (TurbineUserGroupRole) TurbineUserGroupRolePeer
.row2Object(row, 1, omClass);
omClass = TurbineUserPeer.getOMClass();
TurbineUser obj2 = (TurbineUser) TurbineUserPeer
.row2Object( row, offset2, omClass);
boolean newObject = true;
for (int j = 0; j < results.size(); j++)
{
TurbineUserGroupRole temp_obj1 = results.get(j);
TurbineUser temp_obj2 = (TurbineUser) temp_obj1.getTurbineUser();
if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey()))
{
newObject = false;
temp_obj2.addTurbineUserGroupRole(obj1);
break;
}
}
if (newObject)
{
obj2.initTurbineUserGroupRoles();
obj2.addTurbineUserGroupRole(obj1);
}
omClass = TurbineRolePeer.getOMClass();
TurbineRole obj3 = (TurbineRole) TurbineRolePeer
.row2Object( row, offset3, omClass);
newObject = true;
for (int j = 0; j < results.size(); j++)
{
TurbineUserGroupRole temp_obj1 = results.get(j);
TurbineRole temp_obj3 = (TurbineRole) temp_obj1.getTurbineRole();
if (temp_obj3.getPrimaryKey().equals(obj3.getPrimaryKey()))
{
newObject = false;
temp_obj3.addTurbineUserGroupRole(obj1);
break;
}
}
if (newObject)
{
obj3.initTurbineUserGroupRoles();
obj3.addTurbineUserGroupRole(obj1);
}
results.add(obj1);
}
return results;
}
/**
* selects a collection of TurbineUserGroupRole objects pre-filled with
* all related objects.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in TurbineUserGroupRolePeer.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
protected static List<TurbineUserGroupRole> doSelectJoinAllExceptTurbineRole(Criteria criteria)
throws TorqueException
{
return doSelectJoinAllExceptTurbineRole(criteria, null);
}
/**
* selects a collection of TurbineUserGroupRole objects pre-filled with
* all related objects.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in TurbineUserGroupRolePeer.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
protected static List<TurbineUserGroupRole> doSelectJoinAllExceptTurbineRole(Criteria criteria, Connection conn)
throws TorqueException
{
setDbName(criteria);
addSelectColumns(criteria);
int offset2 = numColumns + 1;
TurbineUserPeer.addSelectColumns(criteria);
criteria.addJoin(TurbineUserGroupRolePeer.USER_ID, TurbineUserPeer.USER_ID);
int offset3 = offset2 + TurbineUserPeer.numColumns;
TurbineGroupPeer.addSelectColumns(criteria);
criteria.addJoin(TurbineUserGroupRolePeer.GROUP_ID, TurbineGroupPeer.GROUP_ID);
correctBooleans(criteria);
List<Record> rows;
if (conn == null)
{
rows = BasePeer.doSelect(criteria);
}
else
{
rows = BasePeer.doSelect(criteria,conn);
}
List<TurbineUserGroupRole> results = new ArrayList<TurbineUserGroupRole>();
for (int i = 0; i < rows.size(); i++)
{
Record row = rows.get(i);
Class omClass = TurbineUserGroupRolePeer.getOMClass();
TurbineUserGroupRole obj1 = (TurbineUserGroupRole) TurbineUserGroupRolePeer
.row2Object(row, 1, omClass);
omClass = TurbineUserPeer.getOMClass();
TurbineUser obj2 = (TurbineUser) TurbineUserPeer
.row2Object( row, offset2, omClass);
boolean newObject = true;
for (int j = 0; j < results.size(); j++)
{
TurbineUserGroupRole temp_obj1 = results.get(j);
TurbineUser temp_obj2 = (TurbineUser) temp_obj1.getTurbineUser();
if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey()))
{
newObject = false;
temp_obj2.addTurbineUserGroupRole(obj1);
break;
}
}
if (newObject)
{
obj2.initTurbineUserGroupRoles();
obj2.addTurbineUserGroupRole(obj1);
}
omClass = TurbineGroupPeer.getOMClass();
TurbineGroup obj3 = (TurbineGroup) TurbineGroupPeer
.row2Object( row, offset3, omClass);
newObject = true;
for (int j = 0; j < results.size(); j++)
{
TurbineUserGroupRole temp_obj1 = results.get(j);
TurbineGroup temp_obj3 = (TurbineGroup) temp_obj1.getTurbineGroup();
if (temp_obj3.getPrimaryKey().equals(obj3.getPrimaryKey()))
{
newObject = false;
temp_obj3.addTurbineUserGroupRole(obj1);
break;
}
}
if (newObject)
{
obj3.initTurbineUserGroupRoles();
obj3.addTurbineUserGroupRole(obj1);
}
results.add(obj1);
}
return results;
}
/**
* Returns the TableMap related to this peer.
*
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
*/
public static TableMap getTableMap()
throws TorqueException
{
return Torque.getDatabaseMap(DATABASE_NAME).getTable(TABLE_NAME);
}
private static void setDbName(Criteria crit)
{
// Set the correct dbName if it has not been overridden
// crit.getDbName will return the same object if not set to
// another value so == check is okay and faster
if (crit.getDbName() == Torque.getDefaultDB())
{
crit.setDbName(DATABASE_NAME);
}
}
// The following methods wrap some methods in BasePeer
// to have more support for Java5 generic types in the Peer
/**
* Utility method which executes a given sql statement. This
* method should be used for select statements only. Use
* executeStatement for update, insert, and delete operations.
*
* @param queryString A String with the sql statement to execute.
* @return List of Record objects.
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
* @see org.apache.torque.util.BasePeer#executeQuery(String)
*/
public static List<Record> executeQuery(String queryString) throws TorqueException
{
return BasePeer.executeQuery(queryString);
}
/**
* Utility method which executes a given sql statement. This
* method should be used for select statements only. Use
* executeStatement for update, insert, and delete operations.
*
* @param queryString A String with the sql statement to execute.
* @param dbName The database to connect to.
* @return List of Record objects.
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
* @see org.apache.torque.util.BasePeer#executeQuery(String,String)
*/
public static List<Record> executeQuery(String queryString, String dbName)
throws TorqueException
{
return BasePeer.executeQuery(queryString,dbName);
}
/**
* Method for performing a SELECT. Returns all results.
*
* @param queryString A String with the sql statement to execute.
* @param dbName The database to connect to.
* @param singleRecord Whether or not we want to select only a
* single record.
* @return List of Record objects.
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
* @see org.apache.torque.util.BasePeer#executeQuery(String,String,boolean)
*/
public static List<Record> executeQuery(
String queryString,
String dbName,
boolean singleRecord)
throws TorqueException
{
return BasePeer.executeQuery(queryString,dbName,singleRecord);
}
/**
* Method for performing a SELECT. Returns all results.
*
* @param queryString A String with the sql statement to execute.
* @param singleRecord Whether or not we want to select only a
* single record.
* @param con A Connection.
* @return List of Record objects.
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
* @see org.apache.torque.util.BasePeer#executeQuery(String,boolean,Connection)
*/
public static List<Record> executeQuery(
String queryString,
boolean singleRecord,
Connection con)
throws TorqueException
{
return BasePeer.executeQuery(queryString,singleRecord,con);
}
/**
* Method for performing a SELECT.
*
* @param queryString A String with the sql statement to execute.
* @param start The first row to return.
* @param numberOfResults The number of rows to return.
* @param dbName The database to connect to.
* @param singleRecord Whether or not we want to select only a
* single record.
* @return List of Record objects.
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
* @see org.apache.torque.util.BasePeer#executeQuery(String,int,int,String,boolean)
*/
public static List<Record> executeQuery(
String queryString,
int start,
int numberOfResults,
String dbName,
boolean singleRecord)
throws TorqueException
{
return BasePeer.executeQuery(queryString,start,numberOfResults,dbName,singleRecord);
}
/**
* Method for performing a SELECT. Returns all results.
*
* @param queryString A String with the sql statement to execute.
* @param start The first row to return.
* @param numberOfResults The number of rows to return.
* @param singleRecord Whether or not we want to select only a
* single record.
* @param con A Connection.
* @return List of Record objects.
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
* @see org.apache.torque.util.BasePeer#executeQuery(String,int,int,String,boolean,Connection)
*/
public static List<Record> executeQuery(
String queryString,
int start,
int numberOfResults,
boolean singleRecord,
Connection con)
throws TorqueException
{
return BasePeer.executeQuery(queryString,start,numberOfResults,singleRecord,con);
}
/**
* Returns all records in a QueryDataSet as a List of Record
* objects. Used for functionality like util.LargeSelect.
*
* @see #getSelectResults(QueryDataSet, int, int, boolean)
* @param qds the QueryDataSet
* @return a List of Record objects
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
* @see org.apache.torque.util.BasePeer#getSelectResults(QueryDataSet)
*/
public static List<Record> getSelectResults(QueryDataSet qds)
throws TorqueException
{
return BasePeer.getSelectResults(qds);
}
/**
* Returns all records in a QueryDataSet as a List of Record
* objects. Used for functionality like util.LargeSelect.
*
* @see #getSelectResults(QueryDataSet, int, int, boolean)
* @param qds the QueryDataSet
* @param singleRecord
* @return a List of Record objects
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
* @see org.apache.torque.util.BasePeer#getSelectResults(QueryDataSet,boolean)
*/
public static List<Record> getSelectResults(QueryDataSet qds, boolean singleRecord)
throws TorqueException
{
return BasePeer.getSelectResults(qds,singleRecord);
}
/**
* Returns numberOfResults records in a QueryDataSet as a List
* of Record objects. Starting at record 0. Used for
* functionality like util.LargeSelect.
*
* @see #getSelectResults(QueryDataSet, int, int, boolean)
* @param qds the QueryDataSet
* @param numberOfResults
* @param singleRecord
* @return a List of Record objects
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
* @see org.apache.torque.util.BasePeer#getSelectResults(QueryDataSet,int,boolean)
*/
public static List<Record> getSelectResults(
QueryDataSet qds,
int numberOfResults,
boolean singleRecord)
throws TorqueException
{
return BasePeer.getSelectResults(qds,numberOfResults,singleRecord);
}
/**
* Returns numberOfResults records in a QueryDataSet as a List
* of Record objects. Starting at record start. Used for
* functionality like util.LargeSelect.
*
* @param qds The <code>QueryDataSet</code> to extract results
* from.
* @param start The index from which to start retrieving
* <code>Record</code> objects from the data set.
* @param numberOfResults The number of results to return (or
* <code> -1</code> for all results).
* @param singleRecord Whether or not we want to select only a
* single record.
* @return A <code>List</code> of <code>Record</code> objects.
* @exception TorqueException If any <code>Exception</code> occurs.
* @see org.apache.torque.util.BasePeer#getSelectResults(QueryDataSet,int,int,boolean)
*/
public static List getSelectResults(
QueryDataSet qds,
int start,
int numberOfResults,
boolean singleRecord)
throws TorqueException
{
return BasePeer.getSelectResults(qds,start,numberOfResults,singleRecord);
}
/**
* Performs a SQL <code>select</code> using a PreparedStatement.
* Note: this method does not handle null criteria values.
*
* @param criteria
* @param con
* @return a List of Record objects.
* @throws TorqueException Error performing database query.
* @see org.apache.torque.util.BasePeer#doPSSelect(Criteria,Connection)
*/
public static List<Record> doPSSelect(Criteria criteria, Connection con)
throws TorqueException
{
return BasePeer.doPSSelect(criteria,con);
}
/**
* Do a Prepared Statement select according to the given criteria
*
* @param criteria
* @return a List of Record objects.
* @throws TorqueException Any exceptions caught during processing will be
* rethrown wrapped into a TorqueException.
* @see org.apache.torque.util.BasePeer#doPSSelect(Criteria)
*/
public static List<Record> doPSSelect(Criteria criteria) throws TorqueException
{
return BasePeer.doPSSelect(criteria);
}
}