Class 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 field
      static org.apache.torque.map.ColumnMap EMAIL
      The column for the EMAIL field
      static org.apache.torque.map.ColumnMap HOUR
      The column for the HOUR field
      static org.apache.torque.map.ColumnMap JOB_ID
      The column for the JOB_ID field
      static org.apache.torque.map.ColumnMap MINUTE
      The column for the MINUTE field
      static int numColumns
      number of columns for this peer
      static org.apache.torque.map.ColumnMap PROPERTY
      The column for the PROPERTY field
      static org.apache.torque.map.ColumnMap SECOND
      The column for the SECOND field
      static 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 field
      static org.apache.torque.map.ColumnMap WEEK_DAY
      The column for the WEEK_DAY field
    • 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 object
      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.
      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 inserts
      static 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 class
      static 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 pk
      static JobEntryTorque retrieveByPK​(int pk, Connection con)
      Retrieve a single object by pk
      static JobEntryTorque retrieveByPK​(org.apache.torque.om.ObjectKey<?> pk)
      Retrieve a single object by pk
      static JobEntryTorque retrieveByPK​(org.apache.torque.om.ObjectKey<?> pk, Connection con)
      Retrieve a single object by pk
      static 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
    • Method Detail

      • 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<JobEntryTorquedoSelect​(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<JobEntryTorquedoSelect​(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<JobEntryTorquedoSelectAsStream​(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<JobEntryTorquedoSelect​(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.
      • 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 using criteria and updated using the values in updateValues.
        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 using criteria and updated using the values in updateValues.
        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 key
        con - 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 key
        con - 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<JobEntryTorqueretrieveByTypedPKs​(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<JobEntryTorqueretrieveByTypedPKs​(Collection<Integer> pks,
                                                              Connection dbcon)
                                                       throws org.apache.torque.TorqueException
        Retrieve multiple objects by pk.
        Parameters:
        pks - List of primary keys
        dbcon - 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<JobEntryTorqueretrieveByObjectKeys​(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<JobEntryTorqueretrieveByObjectKeys​(Collection<org.apache.torque.om.ObjectKey<?>> pks,
                                                                Connection con)
                                                         throws org.apache.torque.TorqueException
        Retrieve multiple objects by pk.
        Parameters:
        pks - List of primary keys
        con - 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.