Class BaseActivitySetTypePeer

java.lang.Object
com.easydesk.om.BaseActivitySetTypePeer
Direct Known Subclasses:
ActivitySetTypePeer

public abstract class BaseActivitySetTypePeer extends Object
Transaction Type AutoIncrement from 1000, Artifactizable(ActivitySetType) Optionable(ActivitySetType) The skeleton for this class was autogenerated by Torque on: [Sun Oct 18 20:57:13 KST 2026] You should not use this class directly. It should not even be extended; all references should be to ActivitySetTypePeer
  • Field Details

    • 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 TableMap TABLE
      The table map for this class.
    • TYPE_ID

      public static final ColumnMap TYPE_ID
      The column for the TYPE_ID field
    • NAME

      public static final ColumnMap NAME
      The column for the NAME field
    • SCOPE

      public static final ColumnMap SCOPE
      The column for the SCOPE field
    • numColumns

      public static final int numColumns
      number of columns for this peer
      See Also:
  • Constructor Details

    • BaseActivitySetTypePeer

      public BaseActivitySetTypePeer()
  • Method Details

    • createActivitySetTypePeerImpl

      protected static ActivitySetTypePeerImpl createActivitySetTypePeerImpl()
      Creates a new instance of the implementation of the peer.
      Returns:
      the new instance.
    • getActivitySetTypePeerImpl

      public static ActivitySetTypePeerImpl getActivitySetTypePeerImpl()
      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.
    • setActivitySetTypePeerImpl

      public static void setActivitySetTypePeerImpl(ActivitySetTypePeerImpl 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(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(Criteria criteria) throws 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:
      TorqueException - if the database map for the criteria cannot be obtained.
    • correctBooleans

      public static void correctBooleans(ColumnValues columnValues) throws 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:
      TorqueException - if the database map for the criteria cannot be retrieved.
    • doSelect

      public static List<ActivitySetType> doSelect(Criteria criteria) throws TorqueException
      Selects ActivitySetType objects from a database.
      Parameters:
      criteria - object used to create the SELECT statement.
      Returns:
      the list of selected objects, not null.
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doSelect

      public static List<ActivitySetType> doSelect(Criteria criteria, Connection connection) throws TorqueException
      Selects ActivitySetType 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:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doSelectAsStream

      public static Stream<ActivitySetType> doSelectAsStream(Criteria criteria, Connection connection) throws TorqueException
      Selects ActivitySetType 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:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doSelect

      public static <T> List<T> doSelect(Criteria criteria, RecordMapper<T> mapper) throws 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:
      TorqueException - if querying the database fails.
    • doSelect

      public static <T> List<T> doSelect(Criteria criteria, RecordMapper<T> mapper, Connection connection) throws 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:
      TorqueException - Error performing database query.
    • doSelectAsStream

      public static <T> Stream<T> doSelectAsStream(Criteria criteria, RecordMapper<T> mapper, Connection connection) throws 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:
      TorqueException - Error performing database query.
    • doSelect

      public static <T> List<T> doSelect(String query, RecordMapper<T> mapper, String dbName) throws 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:
      TorqueException - if querying the database fails.
    • doSelect

      public static <T> List<T> doSelect(String query, RecordMapper<T> mapper, Connection connection) throws 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:
      TorqueException - if querying the database fails.
    • doSelectAsStream

      public static <T> Stream<T> doSelectAsStream(String query, RecordMapper<T> mapper, Connection connection) throws 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:
      TorqueException - if querying the database fails.
    • doSelect

      public static List<ActivitySetType> doSelect(ActivitySetType obj) throws TorqueException
      Selects ActivitySetType objects from the database which have the same content as the passed object.
      Returns:
      The list of selected objects, not null.
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doSelectSingleRecord

      public static ActivitySetType doSelectSingleRecord(Criteria criteria) throws TorqueException
      Selects at most one ActivitySetType 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:
      TorqueException - If more than one record is selected or if an error occurs when processing the query.
    • doSelectSingleRecord

      public static ActivitySetType doSelectSingleRecord(Criteria criteria, Connection connection) throws TorqueException
      Selects at most one ActivitySetType 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:
      TorqueException - If more than one record is selected or if an error occurs when processing the query.
    • doSelectSingleRecord

      public static <T> T doSelectSingleRecord(Criteria criteria, RecordMapper<T> mapper) throws 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:
      TorqueException - if querying the database fails.
    • doSelectSingleRecord

      public static <T> T doSelectSingleRecord(Criteria criteria, RecordMapper<T> mapper, Connection connection) throws 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:
      TorqueException - if querying the database fails.
    • doSelectSingleRecord

      public static ActivitySetType doSelectSingleRecord(ActivitySetType obj) throws TorqueException
      Selects at most one ActivitySetType 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:
      TorqueException - If more than one record is selected or if an error occurs when processing the query.
    • getDbObjectInstance

      public static ActivitySetType getDbObjectInstance()
      Returns a new instance of the Data object class
    • doInsert

      public static ObjectKey<?> doInsert(ColumnValues columnValues) throws TorqueException
      Method to do inserts.
      Parameters:
      columnValues - the values to insert.
      Returns:
      the primary key of the inserted row.
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doInsert

      public static ObjectKey<?> doInsert(ColumnValues columnValues, Connection con) throws 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:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doInsert

      public static void doInsert(ActivitySetType obj) throws TorqueException
      Method to do inserts
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doInsert

      public static void doInsert(ActivitySetType obj, Connection con) throws TorqueException
      Method to do inserts. This method is to be used during a transaction, otherwise use the doInsert(ActivitySetType) 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:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doInsert

      public static int doInsert(Column[] toInsertInto, Criteria criteria) throws 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:
      TorqueException - if a database error occurs.
    • doInsert

      public static int doInsert(Column[] toInsertInto, Criteria criteria, String dbName) throws 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:
      TorqueException - if a database error occurs.
    • doInsert

      public static int doInsert(Column[] toInsertInto, Criteria criteria, Connection connection) throws 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:
      TorqueException - if a database error occurs.
    • doInsert

      public static int doInsert(Column[] toInsertInto, Criteria criteria, String dbName, Connection connection) throws 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:
      TorqueException - if a database error occurs.
    • doUpdate

      public static int doUpdate(ColumnValues columnValues) throws TorqueException
      Method to do updates.
      Parameters:
      columnValues - the values to update plus the primary key identifying the row to update.
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doUpdate

      public static int doUpdate(ColumnValues columnValues, Connection con) throws 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:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doUpdate

      public static int doUpdate(Criteria selectCriteria, ColumnValues updateValues) throws 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:
      TorqueException - if updating fails.
    • doUpdate

      public static int doUpdate(Criteria criteria, ColumnValues updateValues, Connection connection) throws 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:
      TorqueException - if updating fails.
    • doUpdate

      public static int doUpdate(ActivitySetType obj) throws TorqueException
      Updates an ActivitySetType 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:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doUpdate

      public static int doUpdate(ActivitySetType obj, Connection con) throws TorqueException
      Updates a ActivitySetType 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(ActivitySetType) method can be used.
      Parameters:
      obj - the data object to update in the database.
      con - the connection to use, not null.
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • executeStatement

      public static int executeStatement(String statementString) throws 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:
      TorqueException - if executing the statement fails or no database connection can be established.
    • executeStatement

      public static int executeStatement(String statementString, List<JdbcTypedValue> replacementValues) throws 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:
      TorqueException - if executing the statement fails or no database connection can be established.
    • executeStatement

      public static int executeStatement(String statementString, String dbName, List<JdbcTypedValue> replacementValues) throws 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:
      TorqueException - if executing the statement fails or no database connection can be established.
    • executeStatement

      public static int executeStatement(String statementString, Connection con, List<JdbcTypedValue> replacementValues) throws 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:
      TorqueException - if executing the statement fails.
    • executeStatement

      public static int executeStatement(String statementString, Map<String,JdbcTypedValue> replacementValues) throws 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:
      TorqueException - if executing the statement fails.
    • executeStatement

      public static int executeStatement(String statementString, String dbName, Map<String,JdbcTypedValue> replacementValues) throws 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:
      TorqueException - if executing the statement fails.
    • executeStatement

      public static int executeStatement(String statementString, Connection con, Map<String,JdbcTypedValue> replacementValues) throws 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:
      TorqueException - if executing the statement fails.
    • doDelete

      public static int doDelete(Criteria criteria) throws TorqueException
      Deletes rows from a database table.
      Parameters:
      criteria - defines the rows to be deleted, not null.
      Returns:
      the number of deleted rows.
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doDelete

      public static int doDelete(Criteria criteria, Connection con) throws 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:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doDelete

      public static int doDelete(ActivitySetType obj) throws 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:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doDelete

      public static int doDelete(ActivitySetType obj, Connection con) throws 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:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doDelete

      public static int doDelete(Collection<ActivitySetType> objects) throws 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:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doDelete

      public static int doDelete(Collection<ActivitySetType> objects, Connection con) throws 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:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doDelete

      public static int doDelete(ObjectKey<?> pk) throws TorqueException
      Deletes a row in the database.
      Parameters:
      pk - the ObjectKey that identifies the row to delete.
      Returns:
      the number of deleted rows.
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doDelete

      public static int doDelete(ObjectKey<?> pk, Connection con) throws 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:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • buildCriteria

      public static Criteria buildCriteria(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 Criteria buildCriteria(Collection<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 Criteria buildPkCriteria(Collection<ActivitySetType> 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 Criteria buildCriteria(ActivitySetType 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 Criteria buildSelectCriteria(ActivitySetType 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 ColumnValues buildColumnValues(ActivitySetType activitySetType) throws TorqueException
      Returns the contents of the object as ColumnValues object
      Throws:
      TorqueException - if the table map cannot be retrieved (should not happen).
    • retrieveByPK

      Retrieve a single object by pk
      Parameters:
      pk - the primary key
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
      NoRowsException - Primary key was not found in database.
      TooManyRowsException - Primary key was not found in database.
    • retrieveByPK

      Retrieve a single object by pk
      Parameters:
      pk - the primary key
      con - the connection to use
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
      NoRowsException - Primary key was not found in database.
      TooManyRowsException - Primary key was not found in database.
    • retrieveByPK

      public static ActivitySetType retrieveByPK(ObjectKey<?> pk) throws TorqueException, NoRowsException, TooManyRowsException
      Retrieve a single object by pk
      Parameters:
      pk - the primary key
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
      NoRowsException - Primary key was not found in database.
      TooManyRowsException - Primary key was not found in database.
    • retrieveByPK

      public static ActivitySetType retrieveByPK(ObjectKey<?> pk, Connection con) throws TorqueException, NoRowsException, TooManyRowsException
      Retrieve a single object by pk
      Parameters:
      pk - the primary key
      con - the connection to use
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
      NoRowsException - Primary key was not found in database.
      TooManyRowsException - Primary key was not found in database.
    • retrieveByTypedPKs

      public static List<ActivitySetType> retrieveByTypedPKs(Collection<Integer> pks) throws TorqueException
      Retrieve multiple objects by pk.
      Parameters:
      pks - List of primary keys
      Returns:
      the list of matching objects, not null.
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • retrieveByTypedPKs

      public static List<ActivitySetType> retrieveByTypedPKs(Collection<Integer> pks, Connection dbcon) throws 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:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • retrieveByObjectKeys

      public static List<ActivitySetType> retrieveByObjectKeys(Collection<ObjectKey<?>> pks) throws TorqueException
      Retrieve a multiple objects by pk.
      Parameters:
      pks - List of primary keys
      Returns:
      the list of matching objects, not null.
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • retrieveByObjectKeys

      public static List<ActivitySetType> retrieveByObjectKeys(Collection<ObjectKey<?>> pks, Connection con) throws 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:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doSelectJoinTimeScope

      public static List<ActivitySetType> doSelectJoinTimeScope(Criteria criteria) throws TorqueException
      Selects a collection of dbObjectClassName objects pre-filled with their TimeScope objects.
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • doSelectJoinTimeScope

      public static List<ActivitySetType> doSelectJoinTimeScope(Criteria criteria, Connection conn) throws TorqueException
      Selects a collection of ActivitySetType objects pre-filled with their TimeScope objects.
      Throws:
      TorqueException - Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
    • setAndSaveActivitySets

      public static void setAndSaveActivitySets(ActivitySetType toLinkTo, Collection<ActivitySet> toSave) throws Exception
      Saves the passed collection as linked objects. This means the following is done:
      • The current collection of objects which are linked to toLinkTo and which are also in the list toSave is read from the database into the list intersection.
      • All objects in toSave which are not in intersection are inserted.
      • All objects in intersection are updated with the corresponding values in toSave and saved.
      • All objects in the database which are linked to toLinkTo but are not in toSave are deleted from the database.
      Parameters:
      toLinkTo - the object which collections should be set with the values in toSave.
      toSave - Contains the objects to save, not null, may not contain null.
      Throws:
      TorqueException - if an error accessing the database occurs.
      NullPointerException - if toSave is null or contains null elements.
      Exception
    • setAndSaveActivitySets

      public void setAndSaveActivitySets(ActivitySetType toLinkTo, Collection<ActivitySet> toSave, Connection connection) throws Exception
      Saves the passed collection as linked objects. This means the following is done:
      • The current collection of objects which are linked to toLinkTo and which are also in the list toSave is read from the database into the list intersection.
      • All objects in toSave which are not in intersection are inserted.
      • All objects in intersection are updated with the corresponding values in toSave and saved.
      • All objects in the database which are linked to toLinkTo but are not in toSave are deleted from the database.
      Parameters:
      toLinkTo - the object which collections should be set with the values in toSave.
      toSave - Contains the objects to save, not null, may not contain null.
      connection - the database connection to use.
      Throws:
      TorqueException - if an error accessing the database occurs.
      NullPointerException - if toSave is null or contains null elements.
      Exception
    • setAndSaveNotificationFilters

      public static void setAndSaveNotificationFilters(ActivitySetType toLinkTo, Collection<NotificationFilter> toSave) throws Exception
      Saves the passed collection as linked objects. This means the following is done:
      • The current collection of objects which are linked to toLinkTo and which are also in the list toSave is read from the database into the list intersection.
      • All objects in toSave which are not in intersection are inserted.
      • All objects in intersection are updated with the corresponding values in toSave and saved.
      • All objects in the database which are linked to toLinkTo but are not in toSave are deleted from the database.
      Parameters:
      toLinkTo - the object which collections should be set with the values in toSave.
      toSave - Contains the objects to save, not null, may not contain null.
      Throws:
      TorqueException - if an error accessing the database occurs.
      NullPointerException - if toSave is null or contains null elements.
      Exception
    • setAndSaveNotificationFilters

      public void setAndSaveNotificationFilters(ActivitySetType toLinkTo, Collection<NotificationFilter> toSave, Connection connection) throws Exception
      Saves the passed collection as linked objects. This means the following is done:
      • The current collection of objects which are linked to toLinkTo and which are also in the list toSave is read from the database into the list intersection.
      • All objects in toSave which are not in intersection are inserted.
      • All objects in intersection are updated with the corresponding values in toSave and saved.
      • All objects in the database which are linked to toLinkTo but are not in toSave are deleted from the database.
      Parameters:
      toLinkTo - the object which collections should be set with the values in toSave.
      toSave - Contains the objects to save, not null, may not contain null.
      connection - the database connection to use.
      Throws:
      TorqueException - if an error accessing the database occurs.
      NullPointerException - if toSave is null or contains null elements.
      Exception
    • setAndSaveAnonymousNotificationFilters

      public static void setAndSaveAnonymousNotificationFilters(ActivitySetType toLinkTo, Collection<AnonymousNotificationFilter> toSave) throws Exception
      Saves the passed collection as linked objects. This means the following is done:
      • The current collection of objects which are linked to toLinkTo and which are also in the list toSave is read from the database into the list intersection.
      • All objects in toSave which are not in intersection are inserted.
      • All objects in intersection are updated with the corresponding values in toSave and saved.
      • All objects in the database which are linked to toLinkTo but are not in toSave are deleted from the database.
      Parameters:
      toLinkTo - the object which collections should be set with the values in toSave.
      toSave - Contains the objects to save, not null, may not contain null.
      Throws:
      TorqueException - if an error accessing the database occurs.
      NullPointerException - if toSave is null or contains null elements.
      Exception
    • setAndSaveAnonymousNotificationFilters

      public void setAndSaveAnonymousNotificationFilters(ActivitySetType toLinkTo, Collection<AnonymousNotificationFilter> toSave, Connection connection) throws Exception
      Saves the passed collection as linked objects. This means the following is done:
      • The current collection of objects which are linked to toLinkTo and which are also in the list toSave is read from the database into the list intersection.
      • All objects in toSave which are not in intersection are inserted.
      • All objects in intersection are updated with the corresponding values in toSave and saved.
      • All objects in the database which are linked to toLinkTo but are not in toSave are deleted from the database.
      Parameters:
      toLinkTo - the object which collections should be set with the values in toSave.
      toSave - Contains the objects to save, not null, may not contain null.
      connection - the database connection to use.
      Throws:
      TorqueException - if an error accessing the database occurs.
      NullPointerException - if toSave is null or contains null elements.
      Exception
    • setAndSaveNotificationTypes

      public static void setAndSaveNotificationTypes(ActivitySetType toLinkTo, Collection<NotificationType> toSave) throws Exception
      Saves the passed collection as linked objects. This means the following is done:
      • The current collection of objects which are linked to toLinkTo and which are also in the list toSave is read from the database into the list intersection.
      • All objects in toSave which are not in intersection are inserted.
      • All objects in intersection are updated with the corresponding values in toSave and saved.
      • All objects in the database which are linked to toLinkTo but are not in toSave are deleted from the database.
      Parameters:
      toLinkTo - the object which collections should be set with the values in toSave.
      toSave - Contains the objects to save, not null, may not contain null.
      Throws:
      TorqueException - if an error accessing the database occurs.
      NullPointerException - if toSave is null or contains null elements.
      Exception
    • setAndSaveNotificationTypes

      public void setAndSaveNotificationTypes(ActivitySetType toLinkTo, Collection<NotificationType> toSave, Connection connection) throws Exception
      Saves the passed collection as linked objects. This means the following is done:
      • The current collection of objects which are linked to toLinkTo and which are also in the list toSave is read from the database into the list intersection.
      • All objects in toSave which are not in intersection are inserted.
      • All objects in intersection are updated with the corresponding values in toSave and saved.
      • All objects in the database which are linked to toLinkTo but are not in toSave are deleted from the database.
      Parameters:
      toLinkTo - the object which collections should be set with the values in toSave.
      toSave - Contains the objects to save, not null, may not contain null.
      connection - the database connection to use.
      Throws:
      TorqueException - if an error accessing the database occurs.
      NullPointerException - if toSave is null or contains null elements.
      Exception
    • setAndSaveWorkflows

      public static void setAndSaveWorkflows(ActivitySetType toLinkTo, Collection<Workflow> toSave) throws Exception
      Saves the passed collection as linked objects. This means the following is done:
      • The current collection of objects which are linked to toLinkTo and which are also in the list toSave is read from the database into the list intersection.
      • All objects in toSave which are not in intersection are inserted.
      • All objects in intersection are updated with the corresponding values in toSave and saved.
      • All objects in the database which are linked to toLinkTo but are not in toSave are deleted from the database.
      Parameters:
      toLinkTo - the object which collections should be set with the values in toSave.
      toSave - Contains the objects to save, not null, may not contain null.
      Throws:
      TorqueException - if an error accessing the database occurs.
      NullPointerException - if toSave is null or contains null elements.
      Exception
    • setAndSaveWorkflows

      public void setAndSaveWorkflows(ActivitySetType toLinkTo, Collection<Workflow> toSave, Connection connection) throws Exception
      Saves the passed collection as linked objects. This means the following is done:
      • The current collection of objects which are linked to toLinkTo and which are also in the list toSave is read from the database into the list intersection.
      • All objects in toSave which are not in intersection are inserted.
      • All objects in intersection are updated with the corresponding values in toSave and saved.
      • All objects in the database which are linked to toLinkTo but are not in toSave are deleted from the database.
      Parameters:
      toLinkTo - the object which collections should be set with the values in toSave.
      toSave - Contains the objects to save, not null, may not contain null.
      connection - the database connection to use.
      Throws:
      TorqueException - if an error accessing the database occurs.
      NullPointerException - if toSave is null or contains null elements.
      Exception
    • setAndSaveWorkflowGroups

      public static void setAndSaveWorkflowGroups(ActivitySetType toLinkTo, Collection<WorkflowGroup> toSave) throws Exception
      Saves the passed collection as linked objects. This means the following is done:
      • The current collection of objects which are linked to toLinkTo and which are also in the list toSave is read from the database into the list intersection.
      • All objects in toSave which are not in intersection are inserted.
      • All objects in intersection are updated with the corresponding values in toSave and saved.
      • All objects in the database which are linked to toLinkTo but are not in toSave are deleted from the database.
      Parameters:
      toLinkTo - the object which collections should be set with the values in toSave.
      toSave - Contains the objects to save, not null, may not contain null.
      Throws:
      TorqueException - if an error accessing the database occurs.
      NullPointerException - if toSave is null or contains null elements.
      Exception
    • setAndSaveWorkflowGroups

      public void setAndSaveWorkflowGroups(ActivitySetType toLinkTo, Collection<WorkflowGroup> toSave, Connection connection) throws Exception
      Saves the passed collection as linked objects. This means the following is done:
      • The current collection of objects which are linked to toLinkTo and which are also in the list toSave is read from the database into the list intersection.
      • All objects in toSave which are not in intersection are inserted.
      • All objects in intersection are updated with the corresponding values in toSave and saved.
      • All objects in the database which are linked to toLinkTo but are not in toSave are deleted from the database.
      Parameters:
      toLinkTo - the object which collections should be set with the values in toSave.
      toSave - Contains the objects to save, not null, may not contain null.
      connection - the database connection to use.
      Throws:
      TorqueException - if an error accessing the database occurs.
      NullPointerException - if toSave is null or contains null elements.
      Exception
    • getTableMap

      public static TableMap getTableMap() throws TorqueException
      Returns the TableMap related to this peer.
      Returns:
      the table map, not null.
      Throws:
      TorqueException - if the Peer instance does not hold a Table map.
    • initDatabaseMap

      public static void initDatabaseMap()