Class BaseJobEntryTorquePeer
- java.lang.Object
-
- org.apache.turbine.services.schedule.BaseJobEntryTorquePeer
-
- Direct Known Subclasses:
JobEntryTorquePeer
public abstract class BaseJobEntryTorquePeer extends Object
The skeleton for this class was autogenerated by Torque on: [Tue Dec 14 09:51:09 CET 2021] You should not use this class directly. It should not even be extended; all references should be to JobEntryTorquePeer
-
-
Field Summary
Fields Modifier and Type Field Description static String
DATABASE_NAME
The default database name for this class.static org.apache.torque.map.ColumnMap
DAY_OF_MONTH
The column for the DAY_OF_MONTH fieldstatic org.apache.torque.map.ColumnMap
EMAIL
The column for the EMAIL fieldstatic org.apache.torque.map.ColumnMap
HOUR
The column for the HOUR fieldstatic org.apache.torque.map.ColumnMap
JOB_ID
The column for the JOB_ID fieldstatic org.apache.torque.map.ColumnMap
MINUTE
The column for the MINUTE fieldstatic int
numColumns
number of columns for this peerstatic org.apache.torque.map.ColumnMap
PROPERTY
The column for the PROPERTY fieldstatic org.apache.torque.map.ColumnMap
SECOND
The column for the SECOND fieldstatic org.apache.torque.map.TableMap
TABLE
The table map for this class.static String
TABLE_NAME
The table name for this class.static org.apache.torque.map.ColumnMap
TASK
The column for the TASK fieldstatic org.apache.torque.map.ColumnMap
WEEK_DAY
The column for the WEEK_DAY field
-
Constructor Summary
Constructors Constructor Description BaseJobEntryTorquePeer()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static void
addSelectColumns(org.apache.torque.criteria.Criteria criteria)
Add all the columns needed to create a new object.static org.apache.torque.util.ColumnValues
buildColumnValues(JobEntryTorque jobEntryTorque)
Returns the contents of the object as ColumnValues objectstatic org.apache.torque.criteria.Criteria
buildCriteria(Collection<org.apache.torque.om.ObjectKey<?>> pks)
Build a Criteria object which selects all objects which primary keys are contained in the passed collection.static org.apache.torque.criteria.Criteria
buildCriteria(org.apache.torque.om.ObjectKey<?> pk)
Build a Criteria object which selects all objects which have a given primary key.static org.apache.torque.criteria.Criteria
buildCriteria(JobEntryTorque obj)
Build a Criteria object from the data object for this peer.static org.apache.torque.criteria.Criteria
buildPkCriteria(Collection<JobEntryTorque> objects)
Build a Criteria object which selects all passed objects using their primary key.static org.apache.torque.criteria.Criteria
buildSelectCriteria(JobEntryTorque obj)
Build a Criteria object from the data object for this peer, skipping all binary columns.static void
correctBooleans(org.apache.torque.criteria.Criteria criteria)
changes the boolean values in the criteria to the appropriate type, whenever a booleanchar or booleanint column is involved.static void
correctBooleans(org.apache.torque.util.ColumnValues columnValues)
Checks all columns in the criteria to see whether booleanchar and booleanint columns are queried with a boolean.protected static JobEntryTorquePeerImpl
createJobEntryTorquePeerImpl()
Creates a new instance of the implementation of the peer.static int
doDelete(Collection<JobEntryTorque> objects)
Deletes data objects, i.e. rows in a table, in the database.static int
doDelete(Collection<JobEntryTorque> objects, Connection con)
Deletes data objects, i.e. rows in a table, in the database.static int
doDelete(org.apache.torque.criteria.Criteria criteria)
Deletes rows from a database table.static int
doDelete(org.apache.torque.criteria.Criteria criteria, Connection con)
Deletes rows from a table.static int
doDelete(org.apache.torque.om.ObjectKey<?> pk)
Deletes a row in the database.static int
doDelete(org.apache.torque.om.ObjectKey<?> pk, Connection con)
Deletes a row in the database.static int
doDelete(JobEntryTorque obj)
Deletes a data object, i.e. a row in a table, in the database.static int
doDelete(JobEntryTorque obj, Connection con)
Deletes a data object, i.e. a row in a table, in the database.static int
doInsert(org.apache.torque.Column[] toInsertInto, org.apache.torque.criteria.Criteria criteria)
Executes a insert into...select statement.static int
doInsert(org.apache.torque.Column[] toInsertInto, org.apache.torque.criteria.Criteria criteria, String dbName)
Executes a insert into...select statement.static int
doInsert(org.apache.torque.Column[] toInsertInto, org.apache.torque.criteria.Criteria criteria, String dbName, Connection connection)
Executes a insert into...select statement.static int
doInsert(org.apache.torque.Column[] toInsertInto, org.apache.torque.criteria.Criteria criteria, Connection connection)
Executes a insert into...select statement.static org.apache.torque.om.ObjectKey<?>
doInsert(org.apache.torque.util.ColumnValues columnValues)
Method to do inserts.static org.apache.torque.om.ObjectKey<?>
doInsert(org.apache.torque.util.ColumnValues columnValues, Connection con)
Method to do inserts.static void
doInsert(JobEntryTorque obj)
Method to do insertsstatic void
doInsert(JobEntryTorque obj, Connection con)
Method to do inserts.static <T> List<T>
doSelect(String query, org.apache.torque.om.mapper.RecordMapper<T> mapper, String dbName)
Selects rows from a database an maps them to objects.static <T> List<T>
doSelect(String query, org.apache.torque.om.mapper.RecordMapper<T> mapper, Connection connection)
Selects rows from a database an maps them to objects.static List<JobEntryTorque>
doSelect(org.apache.torque.criteria.Criteria criteria)
Selects JobEntryTorque objects from a database.static List<JobEntryTorque>
doSelect(org.apache.torque.criteria.Criteria criteria, Connection connection)
Selects JobEntryTorque objects from a database within a transaction.static <T> List<T>
doSelect(org.apache.torque.criteria.Criteria criteria, org.apache.torque.om.mapper.RecordMapper<T> mapper)
Selects rows from a database an maps them to objects.static <T> List<T>
doSelect(org.apache.torque.criteria.Criteria criteria, org.apache.torque.om.mapper.RecordMapper<T> mapper, Connection connection)
Selects rows from a database an maps them to objects.static List<JobEntryTorque>
doSelect(JobEntryTorque obj)
Selects JobEntryTorque objects from the database which have the same content as the passed object.static <T> Stream<T>
doSelectAsStream(String query, org.apache.torque.om.mapper.RecordMapper<T> mapper, Connection connection)
Selects rows from a database an maps them to objects.static Stream<JobEntryTorque>
doSelectAsStream(org.apache.torque.criteria.Criteria criteria, Connection connection)
Selects JobEntryTorque objects from a database within a transaction.static <T> Stream<T>
doSelectAsStream(org.apache.torque.criteria.Criteria criteria, org.apache.torque.om.mapper.RecordMapper<T> mapper, Connection connection)
Selects rows from a database an maps them to objects.static JobEntryTorque
doSelectSingleRecord(org.apache.torque.criteria.Criteria criteria)
Selects at most one JobEntryTorque object from a database.static JobEntryTorque
doSelectSingleRecord(org.apache.torque.criteria.Criteria criteria, Connection connection)
Selects at most one JobEntryTorque object from a database within a transaction.static <T> T
doSelectSingleRecord(org.apache.torque.criteria.Criteria criteria, org.apache.torque.om.mapper.RecordMapper<T> mapper)
Selects at most a single row from a database an maps them to objects.static <T> T
doSelectSingleRecord(org.apache.torque.criteria.Criteria criteria, org.apache.torque.om.mapper.RecordMapper<T> mapper, Connection connection)
Selects at most a single row from a database an maps them to objects.static JobEntryTorque
doSelectSingleRecord(JobEntryTorque obj)
Selects at most one JobEntryTorque object from the database which has the same content as the passed object.static int
doUpdate(org.apache.torque.criteria.Criteria selectCriteria, org.apache.torque.util.ColumnValues updateValues)
Executes an update against the database.static int
doUpdate(org.apache.torque.criteria.Criteria criteria, org.apache.torque.util.ColumnValues updateValues, Connection connection)
Executes an update against the database.static int
doUpdate(org.apache.torque.util.ColumnValues columnValues)
Method to do updates.static int
doUpdate(org.apache.torque.util.ColumnValues columnValues, Connection con)
Method to do updates.static int
doUpdate(JobEntryTorque obj)
Updates an JobEntryTorque in the database.static int
doUpdate(JobEntryTorque obj, Connection con)
Updates a JobEntryTorque in the database.static int
executeStatement(String statementString)
Utility method which executes a given sql statement as prepared statement.static int
executeStatement(String statementString, String dbName, List<org.apache.torque.util.JdbcTypedValue> replacementValues)
Utility method which executes a given sql statement as prepared statement.static int
executeStatement(String statementString, String dbName, Map<String,org.apache.torque.util.JdbcTypedValue> replacementValues)
Utility method which executes a given sql statement as prepared statement.static int
executeStatement(String statementString, Connection con, List<org.apache.torque.util.JdbcTypedValue> replacementValues)
Utility method which executes a given sql statement as prepared statement.static int
executeStatement(String statementString, Connection con, Map<String,org.apache.torque.util.JdbcTypedValue> replacementValues)
Utility method which executes a given sql statement as prepared statement.static int
executeStatement(String statementString, List<org.apache.torque.util.JdbcTypedValue> replacementValues)
Utility method which executes a given sql statement as prepared statement.static int
executeStatement(String statementString, Map<String,org.apache.torque.util.JdbcTypedValue> replacementValues)
Utility method which executes a given sql statement as prepared statement.static JobEntryTorque
getDbObjectInstance()
Returns a new instance of the Data object classstatic JobEntryTorquePeerImpl
getJobEntryTorquePeerImpl()
Returns an instance of the implementation of the peer.static org.apache.torque.map.TableMap
getTableMap()
Returns the TableMap related to this peer.static void
initDatabaseMap()
static List<JobEntryTorque>
retrieveByObjectKeys(Collection<org.apache.torque.om.ObjectKey<?>> pks)
Retrieve a multiple objects by pk.static List<JobEntryTorque>
retrieveByObjectKeys(Collection<org.apache.torque.om.ObjectKey<?>> pks, Connection con)
Retrieve multiple objects by pk.static JobEntryTorque
retrieveByPK(int pk)
Retrieve a single object by pkstatic JobEntryTorque
retrieveByPK(int pk, Connection con)
Retrieve a single object by pkstatic JobEntryTorque
retrieveByPK(org.apache.torque.om.ObjectKey<?> pk)
Retrieve a single object by pkstatic JobEntryTorque
retrieveByPK(org.apache.torque.om.ObjectKey<?> pk, Connection con)
Retrieve a single object by pkstatic List<JobEntryTorque>
retrieveByTypedPKs(Collection<Integer> pks)
Retrieve multiple objects by pk.static List<JobEntryTorque>
retrieveByTypedPKs(Collection<Integer> pks, Connection dbcon)
Retrieve multiple objects by pk.static void
setJobEntryTorquePeerImpl(JobEntryTorquePeerImpl peerImplInstance)
Sets the instance of the implementation of the peer.
-
-
-
Field Detail
-
DATABASE_NAME
public static final String DATABASE_NAME
The default database name for this class.
-
TABLE_NAME
public static final String TABLE_NAME
The table name for this class.
-
TABLE
public static final org.apache.torque.map.TableMap TABLE
The table map for this class.
-
JOB_ID
public static final org.apache.torque.map.ColumnMap JOB_ID
The column for the JOB_ID field
-
SECOND
public static final org.apache.torque.map.ColumnMap SECOND
The column for the SECOND field
-
MINUTE
public static final org.apache.torque.map.ColumnMap MINUTE
The column for the MINUTE field
-
HOUR
public static final org.apache.torque.map.ColumnMap HOUR
The column for the HOUR field
-
WEEK_DAY
public static final org.apache.torque.map.ColumnMap WEEK_DAY
The column for the WEEK_DAY field
-
DAY_OF_MONTH
public static final org.apache.torque.map.ColumnMap DAY_OF_MONTH
The column for the DAY_OF_MONTH field
-
TASK
public static final org.apache.torque.map.ColumnMap TASK
The column for the TASK field
-
EMAIL
public static final org.apache.torque.map.ColumnMap EMAIL
The column for the EMAIL field
-
PROPERTY
public static final org.apache.torque.map.ColumnMap PROPERTY
The column for the PROPERTY field
-
numColumns
public static final int numColumns
number of columns for this peer- See Also:
- Constant Field Values
-
-
Constructor Detail
-
BaseJobEntryTorquePeer
public BaseJobEntryTorquePeer()
-
-
Method Detail
-
createJobEntryTorquePeerImpl
protected static JobEntryTorquePeerImpl createJobEntryTorquePeerImpl()
Creates a new instance of the implementation of the peer.- Returns:
- the new instance.
-
getJobEntryTorquePeerImpl
public static JobEntryTorquePeerImpl getJobEntryTorquePeerImpl()
Returns an instance of the implementation of the peer. If no instance is currently cached, a new instance is created and cached.- Returns:
- an instance of the implementation of the peer, not null.
-
setJobEntryTorquePeerImpl
public static void setJobEntryTorquePeerImpl(JobEntryTorquePeerImpl peerImplInstance)
Sets the instance of the implementation of the peer.- Parameters:
peerImplInstance
- an instance of the implementation of the peer, or null if a new instance should be created automatically.
-
addSelectColumns
public static void addSelectColumns(org.apache.torque.criteria.Criteria criteria)
Add all the columns needed to create a new object.- Parameters:
criteria
- object containing the columns to add.
-
correctBooleans
public static void correctBooleans(org.apache.torque.criteria.Criteria criteria) throws org.apache.torque.TorqueException
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.- Parameters:
criteria
- the criteria in which the boolean values should be corrected.- Throws:
org.apache.torque.TorqueException
- if the database map for the criteria cannot be obtained.
-
correctBooleans
public static void correctBooleans(org.apache.torque.util.ColumnValues columnValues) throws org.apache.torque.TorqueException
Checks all columns in the criteria to see whether booleanchar and booleanint columns are queried with a boolean. If yes, the query values are mapped onto values the database does understand, i.e. 0 and 1 for booleanints and N and Y for booleanchar columns.- Parameters:
columnValues
- The value to be checked for booleanint and booleanchar columns.- Throws:
org.apache.torque.TorqueException
- if the database map for the criteria cannot be retrieved.
-
doSelect
public static List<JobEntryTorque> doSelect(org.apache.torque.criteria.Criteria criteria) throws org.apache.torque.TorqueException
Selects JobEntryTorque objects from a database.- Parameters:
criteria
- object used to create the SELECT statement.- Returns:
- the list of selected objects, not null.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelect
public static List<JobEntryTorque> doSelect(org.apache.torque.criteria.Criteria criteria, Connection connection) throws org.apache.torque.TorqueException
Selects JobEntryTorque objects from a database within a transaction.- Parameters:
criteria
- object used to create the SELECT statement.connection
- the connection holding the transaction, not null.- Returns:
- The list of selected objects, not null.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectAsStream
public static Stream<JobEntryTorque> doSelectAsStream(org.apache.torque.criteria.Criteria criteria, Connection connection) throws org.apache.torque.TorqueException
Selects JobEntryTorque objects from a database within a transaction. This method returns a stream that must be closed after use. All resources used by this method will be closed when the stream is closed.- Parameters:
criteria
- object used to create the SELECT statement.connection
- the connection holding the transaction, not null.- Returns:
- The results of the query as a Stream, not null.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelect
public static <T> List<T> doSelect(org.apache.torque.criteria.Criteria criteria, org.apache.torque.om.mapper.RecordMapper<T> mapper) throws org.apache.torque.TorqueException
Selects rows from a database an maps them to objects.- Parameters:
criteria
- A Criteria specifying the records to select, not null.mapper
- The mapper creating the objects from the resultSet, not null.- Returns:
- The results of the query, not null.
- Throws:
org.apache.torque.TorqueException
- if querying the database fails.
-
doSelect
public static <T> List<T> doSelect(org.apache.torque.criteria.Criteria criteria, org.apache.torque.om.mapper.RecordMapper<T> mapper, Connection connection) throws org.apache.torque.TorqueException
Selects rows from a database an maps them to objects.- Parameters:
criteria
- A Criteria specifying the records to select, not null.mapper
- The mapper creating the objects from the resultSet, not null.connection
- the database connection for selecting records, not null.- Returns:
- The results of the query, not null.
- Throws:
org.apache.torque.TorqueException
- Error performing database query.
-
doSelectAsStream
public static <T> Stream<T> doSelectAsStream(org.apache.torque.criteria.Criteria criteria, org.apache.torque.om.mapper.RecordMapper<T> mapper, Connection connection) throws org.apache.torque.TorqueException
Selects rows from a database an maps them to objects. This method returns a stream that must be closed after use. All resources used by this method will be closed when the stream is closed.- Parameters:
criteria
- A Criteria specifying the records to select, not null.mapper
- The mapper creating the objects from the resultSet, not null.connection
- the database connection for selecting records, not null.- Returns:
- The results of the query as a Stream, not null.
- Throws:
org.apache.torque.TorqueException
- Error performing database query.
-
doSelect
public static <T> List<T> doSelect(String query, org.apache.torque.om.mapper.RecordMapper<T> mapper, String dbName) throws org.apache.torque.TorqueException
Selects rows from a database an maps them to objects.- Parameters:
query
- the sql query to execute, not null.mapper
- The mapper creating the objects from the resultSet, not null.dbName
- The name of the database to create the connection for, or null for the default SDB.- Returns:
- The results of the query, not null.
- Throws:
org.apache.torque.TorqueException
- if querying the database fails.
-
doSelect
public static <T> List<T> doSelect(String query, org.apache.torque.om.mapper.RecordMapper<T> mapper, Connection connection) throws org.apache.torque.TorqueException
Selects rows from a database an maps them to objects.- Parameters:
query
- the SQL Query to execute, not null.mapper
- The mapper creating the objects from the resultSet, not null.connection
- the database connection, not null.- Returns:
- The results of the query, not null.
- Throws:
org.apache.torque.TorqueException
- if querying the database fails.
-
doSelectAsStream
public static <T> Stream<T> doSelectAsStream(String query, org.apache.torque.om.mapper.RecordMapper<T> mapper, Connection connection) throws org.apache.torque.TorqueException
Selects rows from a database an maps them to objects. This method returns a stream that must be closed after use. All resources used by this method will be closed when the stream is closed.- Parameters:
query
- the SQL Query to execute, not null.mapper
- The mapper creating the objects from the resultSet, not null.connection
- the database connection, not null.- Returns:
- The results of the query as a Stream, not null.
- Throws:
org.apache.torque.TorqueException
- if querying the database fails.
-
doSelect
public static List<JobEntryTorque> doSelect(JobEntryTorque obj) throws org.apache.torque.TorqueException
Selects JobEntryTorque objects from the database which have the same content as the passed object.- Returns:
- The list of selected objects, not null.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectSingleRecord
public static JobEntryTorque doSelectSingleRecord(org.apache.torque.criteria.Criteria criteria) throws org.apache.torque.TorqueException
Selects at most one JobEntryTorque object from a database.- Parameters:
criteria
- object used to create the SELECT statement.- Returns:
- the selected Object, or null if no object was selected.
- Throws:
org.apache.torque.TorqueException
- If more than one record is selected or if an error occurs when processing the query.
-
doSelectSingleRecord
public static JobEntryTorque doSelectSingleRecord(org.apache.torque.criteria.Criteria criteria, Connection connection) throws org.apache.torque.TorqueException
Selects at most one JobEntryTorque object from a database within a transaction.- Parameters:
criteria
- object used to create the SELECT statement.connection
- the connection holding the transaction, not null.- Returns:
- the selected Object, or null if no object was selected.
- Throws:
org.apache.torque.TorqueException
- If more than one record is selected or if an error occurs when processing the query.
-
doSelectSingleRecord
public static <T> T doSelectSingleRecord(org.apache.torque.criteria.Criteria criteria, org.apache.torque.om.mapper.RecordMapper<T> mapper) throws org.apache.torque.TorqueException
Selects at most a single row from a database an maps them to objects.- Parameters:
criteria
- A Criteria specifying the records to select, not null.mapper
- The mapper creating the objects from the resultSet, not null.- Returns:
- The selected row, or null if no records was selected.
- Throws:
org.apache.torque.TorqueException
- if querying the database fails.
-
doSelectSingleRecord
public static <T> T doSelectSingleRecord(org.apache.torque.criteria.Criteria criteria, org.apache.torque.om.mapper.RecordMapper<T> mapper, Connection connection) throws org.apache.torque.TorqueException
Selects at most a single row from a database an maps them to objects.- Parameters:
criteria
- A Criteria specifying the records to select, not null.mapper
- The mapper creating the objects from the resultSet, not null.connection
- the database connection, not null.- Returns:
- The selected row, or null if no records was selected.
- Throws:
org.apache.torque.TorqueException
- if querying the database fails.
-
doSelectSingleRecord
public static JobEntryTorque doSelectSingleRecord(JobEntryTorque obj) throws org.apache.torque.TorqueException
Selects at most one JobEntryTorque object from the database which has the same content as the passed object.- Returns:
- the selected Object, or null if no object was selected.
- Throws:
org.apache.torque.TorqueException
- If more than one record is selected or if an error occurs when processing the query.
-
getDbObjectInstance
public static JobEntryTorque getDbObjectInstance()
Returns a new instance of the Data object class
-
doInsert
public static org.apache.torque.om.ObjectKey<?> doInsert(org.apache.torque.util.ColumnValues columnValues) throws org.apache.torque.TorqueException
Method to do inserts.- Parameters:
columnValues
- the values to insert.- Returns:
- the primary key of the inserted row.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doInsert
public static org.apache.torque.om.ObjectKey<?> doInsert(org.apache.torque.util.ColumnValues columnValues, Connection con) throws org.apache.torque.TorqueException
Method to do inserts. This method is to be used during a transaction, otherwise use the doInsert(Criteria) method.- Parameters:
columnValues
- the values to insert.con
- the connection to use, not null.- Returns:
- the primary key of the inserted row.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doInsert
public static void doInsert(JobEntryTorque obj) throws org.apache.torque.TorqueException
Method to do inserts- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doInsert
public static void doInsert(JobEntryTorque obj, Connection con) throws org.apache.torque.TorqueException
Method to do inserts. This method is to be used during a transaction, otherwise use the doInsert(JobEntryTorque) method. It will take care of the connection details internally.- Parameters:
obj
- the data object to insert into the database.con
- the connection to use- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doInsert
public static int doInsert(org.apache.torque.Column[] toInsertInto, org.apache.torque.criteria.Criteria criteria) throws org.apache.torque.TorqueException
Executes a insert into...select statement.- Parameters:
toInsertInto
- the columns in which to insert, not null.criteria
- the criteria which selects the values to insert, not null.- Returns:
- the number of inserted rows.
- Throws:
org.apache.torque.TorqueException
- if a database error occurs.
-
doInsert
public static int doInsert(org.apache.torque.Column[] toInsertInto, org.apache.torque.criteria.Criteria criteria, String dbName) throws org.apache.torque.TorqueException
Executes a insert into...select statement.- Parameters:
toInsertInto
- the columns in which to insert, not null.criteria
- the criteria which selects the values to insert, not null.dbName
- the database name, or null to take the database name from getDatabaseName().- Returns:
- the number of inserted rows.
- Throws:
org.apache.torque.TorqueException
- if a database error occurs.
-
doInsert
public static int doInsert(org.apache.torque.Column[] toInsertInto, org.apache.torque.criteria.Criteria criteria, Connection connection) throws org.apache.torque.TorqueException
Executes a insert into...select statement.- Parameters:
toInsertInto
- the columns in which to insert, not null.criteria
- the criteria which selects the values to insert, not null.connection
- the database connection to use, not null.- Returns:
- the number of inserted rows.
- Throws:
org.apache.torque.TorqueException
- if a database error occurs.
-
doInsert
public static int doInsert(org.apache.torque.Column[] toInsertInto, org.apache.torque.criteria.Criteria criteria, String dbName, Connection connection) throws org.apache.torque.TorqueException
Executes a insert into...select statement.- Parameters:
toInsertInto
- the columns in which to insert, not null.criteria
- the criteria which selects the values to insert, not null.dbName
- the database name, or null to take the database name from getDatabaseName().connection
- the database connection to use, not null.- Returns:
- the number of inserted rows.
- Throws:
org.apache.torque.TorqueException
- if a database error occurs.
-
doUpdate
public static int doUpdate(org.apache.torque.util.ColumnValues columnValues) throws org.apache.torque.TorqueException
Method to do updates.- Parameters:
columnValues
- the values to update plus the primary key identifying the row to update.- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doUpdate
public static int doUpdate(org.apache.torque.util.ColumnValues columnValues, Connection con) throws org.apache.torque.TorqueException
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.- Parameters:
columnValues
- the values to update plus the primary key identifying the row to update.con
- the connection to use, not null.- Returns:
- the number of affected rows.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doUpdate
public static int doUpdate(org.apache.torque.criteria.Criteria selectCriteria, org.apache.torque.util.ColumnValues updateValues) throws org.apache.torque.TorqueException
Executes an update against the database. The rows to be updated are selected usingcriteria
and updated using the values inupdateValues
.- Parameters:
selectCriteria
- selects which rows of which table should be updated.updateValues
- Which columns to update with which values, not null.- Returns:
- the number of affected rows.
- Throws:
org.apache.torque.TorqueException
- if updating fails.
-
doUpdate
public static int doUpdate(org.apache.torque.criteria.Criteria criteria, org.apache.torque.util.ColumnValues updateValues, Connection connection) throws org.apache.torque.TorqueException
Executes an update against the database. The rows to be updated are selected usingcriteria
and updated using the values inupdateValues
.- Parameters:
criteria
- selects which rows of which table should be updated.updateValues
- Which columns to update with which values, not null.connection
- the database connection to use, not null.- Returns:
- the number of affected rows.
- Throws:
org.apache.torque.TorqueException
- if updating fails.
-
doUpdate
public static int doUpdate(JobEntryTorque obj) throws org.apache.torque.TorqueException
Updates an JobEntryTorque in the database. The primary key is used to identify the object to update.- Parameters:
obj
- the data object to update in the database.- Returns:
- the number of affected rows.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doUpdate
public static int doUpdate(JobEntryTorque obj, Connection con) throws org.apache.torque.TorqueException
Updates a JobEntryTorque in the database. The primary key is used to identify the object to update. This method is to be used during a transaction, otherwise the doUpdate(JobEntryTorque) method can be used.- Parameters:
obj
- the data object to update in the database.con
- the connection to use, not null.- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
executeStatement
public static int executeStatement(String statementString) throws org.apache.torque.TorqueException
Utility method which executes a given sql statement as prepared statement. This method should be used for update, insert, and delete statements. Use executeQuery() for selects.- Parameters:
statementString
- A String with the sql statement to execute.- Returns:
- The number of rows affected.
- Throws:
org.apache.torque.TorqueException
- if executing the statement fails or no database connection can be established.
-
executeStatement
public static int executeStatement(String statementString, List<org.apache.torque.util.JdbcTypedValue> replacementValues) throws org.apache.torque.TorqueException
Utility method which executes a given sql statement as prepared statement. This method should be used for update, insert, and delete statements. Use executeQuery() for selects.- Parameters:
statementString
- A String with the sql statement to execute.replacementValues
- values to use as placeholders in the query. or null or empty if no placeholders need to be filled.- Returns:
- The number of rows affected.
- Throws:
org.apache.torque.TorqueException
- if executing the statement fails or no database connection can be established.
-
executeStatement
public static int executeStatement(String statementString, String dbName, List<org.apache.torque.util.JdbcTypedValue> replacementValues) throws org.apache.torque.TorqueException
Utility method which executes a given sql statement as prepared statement. This method should be used for update, insert, and delete statements. Use executeQuery() for selects.- Parameters:
statementString
- A String with the sql statement to execute.dbName
- The name of the database to execute the statement against, or null for the default DB.replacementValues
- values to use as placeholders in the query. or null or empty if no placeholders need to be filled.- Returns:
- The number of rows affected.
- Throws:
org.apache.torque.TorqueException
- if executing the statement fails or no database connection can be established.
-
executeStatement
public static int executeStatement(String statementString, Connection con, List<org.apache.torque.util.JdbcTypedValue> replacementValues) throws org.apache.torque.TorqueException
Utility method which executes a given sql statement as prepared statement. This method should be used for update, insert, and delete statements. Use executeQuery() for selects.- Parameters:
statementString
- A String with the sql statement to execute.con
- The database connection to use.replacementValues
- values to use as placeholders in the query. or null or empty if no placeholders need to be filled.- Returns:
- The number of rows affected.
- Throws:
org.apache.torque.TorqueException
- if executing the statement fails.
-
executeStatement
public static int executeStatement(String statementString, Map<String,org.apache.torque.util.JdbcTypedValue> replacementValues) throws org.apache.torque.TorqueException
Utility method which executes a given sql statement as prepared statement. This method should be used for update, insert, and delete statements. Use executeQuery() for selects.- Parameters:
statementString
- A String with the sql statement to execute, containing placeholders of the form ":${placeholderName}". ${placeholderName} must contain only letters, digits and the underscore Each placeholder must be followed by a space, except when it is at the end of the statement.replacementValues
- a map mapping the placeholder names to values to use as placeholders in the query. Can be null or empty if no placeholders need to be filled.- Returns:
- The number of rows affected.
- Throws:
org.apache.torque.TorqueException
- if executing the statement fails.
-
executeStatement
public static int executeStatement(String statementString, String dbName, Map<String,org.apache.torque.util.JdbcTypedValue> replacementValues) throws org.apache.torque.TorqueException
Utility method which executes a given sql statement as prepared statement. This method should be used for update, insert, and delete statements. Use executeQuery() for selects.- Parameters:
statementString
- A String with the sql statement to execute, containing placeholders of the form ":${placeholderName}". ${placeholderName} must contain only letters, digits and the underscore Each placeholder must be followed by a space, except when it is at the end of the statement.dbName
- The name of the database to execute the statement against, or null for the default DB.replacementValues
- a map mapping the placeholder names to values to use as placeholders in the query. Can be null or empty if no placeholders need to be filled.- Returns:
- The number of rows affected.
- Throws:
org.apache.torque.TorqueException
- if executing the statement fails.
-
executeStatement
public static int executeStatement(String statementString, Connection con, Map<String,org.apache.torque.util.JdbcTypedValue> replacementValues) throws org.apache.torque.TorqueException
Utility method which executes a given sql statement as prepared statement. This method should be used for update, insert, and delete statements. Use executeQuery() for selects.- Parameters:
statementString
- A String with the sql statement to execute, containing placeholders of the form ":${placeholderName}". ${placeholderName} must contain only letters, digits and the underscore Each placeholder must be followed by a space, except when it is at the end of the statement.con
- The database connection to use.replacementValues
- a map mapping the placeholder names (without leading colons) to values to use as placeholders in the query. Can be null or empty if no placeholders need to be filled.- Returns:
- The number of rows affected.
- Throws:
org.apache.torque.TorqueException
- if executing the statement fails.
-
doDelete
public static int doDelete(org.apache.torque.criteria.Criteria criteria) throws org.apache.torque.TorqueException
Deletes rows from a database table.- Parameters:
criteria
- defines the rows to be deleted, not null.- Returns:
- the number of deleted rows.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doDelete
public static int doDelete(org.apache.torque.criteria.Criteria criteria, Connection con) throws org.apache.torque.TorqueException
Deletes rows from a table. This method uses the passed connection to delete the rows; if a transaction is open in the connection, the deletion happens inside this transaction.- Parameters:
criteria
- defines the rows to be deleted, not null.con
- the connection to use, not null.- Returns:
- the number of deleted rows.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doDelete
public static int doDelete(JobEntryTorque obj) throws org.apache.torque.TorqueException
Deletes a data object, i.e. a row in a table, in the database.- Parameters:
obj
- the data object to delete in the database, not null.- Returns:
- the number of deleted rows.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doDelete
public static int doDelete(JobEntryTorque obj, Connection con) throws org.apache.torque.TorqueException
Deletes a data object, i.e. a row in a table, in the database. This method uses the passed connection to delete the rows; if a transaction is open in the connection, the deletion happens inside this transaction.- Parameters:
obj
- the data object to delete in the database, not null.con
- the connection to use, not null.- Returns:
- the number of deleted rows.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doDelete
public static int doDelete(Collection<JobEntryTorque> objects) throws org.apache.torque.TorqueException
Deletes data objects, i.e. rows in a table, in the database.- Parameters:
objects
- the datas object to delete in the database, not null, may not contain null.- Returns:
- the number of deleted rows.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doDelete
public static int doDelete(Collection<JobEntryTorque> objects, Connection con) throws org.apache.torque.TorqueException
Deletes data objects, i.e. rows in a table, in the database. This method uses the passed connection to delete the rows; if a transaction is open in the connection, the deletion happens inside this transaction.- Parameters:
objects
- the datas object to delete in the database, not null, may not contain null.con
- the connection to use for deleting, not null.- Returns:
- the number of deleted rows.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doDelete
public static int doDelete(org.apache.torque.om.ObjectKey<?> pk) throws org.apache.torque.TorqueException
Deletes a row in the database.- Parameters:
pk
- the ObjectKey that identifies the row to delete.- Returns:
- the number of deleted rows.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doDelete
public static int doDelete(org.apache.torque.om.ObjectKey<?> pk, Connection con) throws org.apache.torque.TorqueException
Deletes a row in the database. This method uses the passed connection to delete the rows; if a transaction is open in the connection, the deletion happens inside this transaction.- Parameters:
pk
- the ObjectKey that identifies the row to delete.con
- the connection to use for deleting, not null.- Returns:
- the number of deleted rows.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
buildCriteria
public static org.apache.torque.criteria.Criteria buildCriteria(org.apache.torque.om.ObjectKey<?> pk)
Build a Criteria object which selects all objects which have a given primary key.- Parameters:
pk
- the primary key value to build the criteria from, not null.
-
buildCriteria
public static org.apache.torque.criteria.Criteria buildCriteria(Collection<org.apache.torque.om.ObjectKey<?>> pks)
Build a Criteria object which selects all objects which primary keys are contained in the passed collection.- Parameters:
pks
- the primary key values to build the criteria from, not null, may not contain null.
-
buildPkCriteria
public static org.apache.torque.criteria.Criteria buildPkCriteria(Collection<JobEntryTorque> objects)
Build a Criteria object which selects all passed objects using their primary key. Objects which do not yet have a primary key are ignored.- Parameters:
objects
- the objects to build the criteria from, not null, may not contain null.
-
buildCriteria
public static org.apache.torque.criteria.Criteria buildCriteria(JobEntryTorque obj)
Build a Criteria object from the data object for this peer.- Parameters:
obj
- the object to build the criteria from, not null.
-
buildSelectCriteria
public static org.apache.torque.criteria.Criteria buildSelectCriteria(JobEntryTorque obj)
Build a Criteria object from the data object for this peer, skipping all binary columns.- Parameters:
obj
- the object to build the criteria from, not null.
-
buildColumnValues
public static org.apache.torque.util.ColumnValues buildColumnValues(JobEntryTorque jobEntryTorque) throws org.apache.torque.TorqueException
Returns the contents of the object as ColumnValues object- Throws:
org.apache.torque.TorqueException
- if the table map cannot be retrieved (should not happen).
-
retrieveByPK
public static JobEntryTorque retrieveByPK(int pk) throws org.apache.torque.TorqueException, org.apache.torque.NoRowsException, org.apache.torque.TooManyRowsException
Retrieve a single object by pk- Parameters:
pk
- the primary key- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.org.apache.torque.NoRowsException
- Primary key was not found in database.org.apache.torque.TooManyRowsException
- Primary key was not found in database.
-
retrieveByPK
public static JobEntryTorque retrieveByPK(int pk, Connection con) throws org.apache.torque.TorqueException, org.apache.torque.NoRowsException, org.apache.torque.TooManyRowsException
Retrieve a single object by pk- Parameters:
pk
- the primary keycon
- the connection to use- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.org.apache.torque.NoRowsException
- Primary key was not found in database.org.apache.torque.TooManyRowsException
- Primary key was not found in database.
-
retrieveByPK
public static JobEntryTorque retrieveByPK(org.apache.torque.om.ObjectKey<?> pk) throws org.apache.torque.TorqueException, org.apache.torque.NoRowsException, org.apache.torque.TooManyRowsException
Retrieve a single object by pk- Parameters:
pk
- the primary key- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.org.apache.torque.NoRowsException
- Primary key was not found in database.org.apache.torque.TooManyRowsException
- Primary key was not found in database.
-
retrieveByPK
public static JobEntryTorque retrieveByPK(org.apache.torque.om.ObjectKey<?> pk, Connection con) throws org.apache.torque.TorqueException, org.apache.torque.NoRowsException, org.apache.torque.TooManyRowsException
Retrieve a single object by pk- Parameters:
pk
- the primary keycon
- the connection to use- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.org.apache.torque.NoRowsException
- Primary key was not found in database.org.apache.torque.TooManyRowsException
- Primary key was not found in database.
-
retrieveByTypedPKs
public static List<JobEntryTorque> retrieveByTypedPKs(Collection<Integer> pks) throws org.apache.torque.TorqueException
Retrieve multiple objects by pk.- Parameters:
pks
- List of primary keys- Returns:
- the list of matching objects, not null.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
retrieveByTypedPKs
public static List<JobEntryTorque> retrieveByTypedPKs(Collection<Integer> pks, Connection dbcon) throws org.apache.torque.TorqueException
Retrieve multiple objects by pk.- Parameters:
pks
- List of primary keysdbcon
- the connection to use- Returns:
- the list of matching objects, not null.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
retrieveByObjectKeys
public static List<JobEntryTorque> retrieveByObjectKeys(Collection<org.apache.torque.om.ObjectKey<?>> pks) throws org.apache.torque.TorqueException
Retrieve a multiple objects by pk.- Parameters:
pks
- List of primary keys- Returns:
- the list of matching objects, not null.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
retrieveByObjectKeys
public static List<JobEntryTorque> retrieveByObjectKeys(Collection<org.apache.torque.om.ObjectKey<?>> pks, Connection con) throws org.apache.torque.TorqueException
Retrieve multiple objects by pk.- Parameters:
pks
- List of primary keyscon
- the connection to use- Returns:
- the list of matching objects, not null.
- Throws:
org.apache.torque.TorqueException
- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
getTableMap
public static org.apache.torque.map.TableMap getTableMap() throws org.apache.torque.TorqueException
Returns the TableMap related to this peer.- Returns:
- the table map, not null.
- Throws:
org.apache.torque.TorqueException
- if the Peer instance does not hold a Table map.
-
initDatabaseMap
public static void initDatabaseMap()
-
-