Package com.easydesk.om
Class BaseReportPeer
java.lang.Object
com.easydesk.om.BaseReportPeer
- Direct Known Subclasses:
ReportPeer
Artifactizable(Report)
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 ReportPeer
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final ColumnMapThe column for the APPROVED fieldstatic final ColumnMapThe column for the CREATED_DATE fieldstatic final StringThe default database name for this class.static final ColumnMapThe column for the LIST_ID fieldstatic final ColumnMapThe column for the MODULE_ID fieldstatic final ColumnMapThe column for the NAME fieldstatic final intnumber of columns for this peerstatic final ColumnMapThe column for the REPORT_ID fieldstatic final ColumnMapThe column for the SCOPE_ID fieldstatic final TableMapThe table map for this class.static final StringThe table name for this class.static final ColumnMapThe column for the USER_ID field -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic voidaddSelectColumns(Criteria criteria) Add all the columns needed to create a new object.static ColumnValuesbuildColumnValues(Report report) Returns the contents of the object as ColumnValues objectstatic CriteriabuildCriteria(Report obj) Build a Criteria object from the data object for this peer.static CriteriabuildCriteria(Collection<ObjectKey<?>> pks) Build a Criteria object which selects all objects which primary keys are contained in the passed collection.static CriteriabuildCriteria(ObjectKey<?> pk) Build a Criteria object which selects all objects which have a given primary key.static CriteriabuildPkCriteria(Collection<Report> objects) Build a Criteria object which selects all passed objects using their primary key.static CriteriaBuild a Criteria object from the data object for this peer, skipping all binary columns.static voidcorrectBooleans(Criteria criteria) changes the boolean values in the criteria to the appropriate type, whenever a booleanchar or booleanint column is involved.static voidcorrectBooleans(ColumnValues columnValues) Checks all columns in the criteria to see whether booleanchar and booleanint columns are queried with a boolean.protected static ReportPeerImplCreates a new instance of the implementation of the peer.static intDeletes a data object, i.e. a row in a table, in the database.static intdoDelete(Report obj, Connection con) Deletes a data object, i.e. a row in a table, in the database.static intdoDelete(Collection<Report> objects) Deletes data objects, i.e. rows in a table, in the database.static intdoDelete(Collection<Report> objects, Connection con) Deletes data objects, i.e. rows in a table, in the database.static intDeletes rows from a database table.static intdoDelete(Criteria criteria, Connection con) Deletes rows from a table.static intDeletes a row in the database.static intdoDelete(ObjectKey<?> pk, Connection con) Deletes a row in the database.static voidMethod to do insertsstatic voiddoInsert(Report obj, Connection con) Method to do inserts.static intExecutes a insert into...select statement.static intExecutes a insert into...select statement.static intdoInsert(Column[] toInsertInto, Criteria criteria, String dbName, Connection connection) Executes a insert into...select statement.static intdoInsert(Column[] toInsertInto, Criteria criteria, Connection connection) Executes a insert into...select statement.static ObjectKey<?> doInsert(ColumnValues columnValues) Method to do inserts.static ObjectKey<?> doInsert(ColumnValues columnValues, Connection con) Method to do inserts.Selects Report objects from the database which have the same content as the passed object.static <T> List<T> doSelect(String query, RecordMapper<T> mapper, String dbName) Selects rows from a database an maps them to objects.static <T> List<T> doSelect(String query, RecordMapper<T> mapper, Connection connection) Selects rows from a database an maps them to objects.Selects Report objects from a database.doSelect(Criteria criteria, Connection connection) Selects Report objects from a database within a transaction.static <T> List<T> doSelect(Criteria criteria, RecordMapper<T> mapper) Selects rows from a database an maps them to objects.static <T> List<T> doSelect(Criteria criteria, RecordMapper<T> mapper, Connection connection) Selects rows from a database an maps them to objects.static <T> Stream<T> doSelectAsStream(String query, RecordMapper<T> mapper, Connection connection) Selects rows from a database an maps them to objects.doSelectAsStream(Criteria criteria, Connection connection) Selects Report objects from a database within a transaction.static <T> Stream<T> doSelectAsStream(Criteria criteria, RecordMapper<T> mapper, Connection connection) Selects rows from a database an maps them to objects.doSelectJoinAllExceptEasyDeskModule(Criteria criteria) selects a collection of Report objects pre-filled with all related objects.doSelectJoinAllExceptEasyDeskModule(Criteria criteria, Connection conn) selects a collection of Report objects pre-filled with related objects.selects a collection of Report objects pre-filled with all related objects.doSelectJoinAllExceptEasyDeskUserImpl(Criteria criteria, Connection conn) selects a collection of Report objects pre-filled with related objects.doSelectJoinAllExceptMITList(Criteria criteria) selects a collection of Report objects pre-filled with all related objects.doSelectJoinAllExceptMITList(Criteria criteria, Connection conn) selects a collection of Report objects pre-filled with related objects.doSelectJoinAllExceptScope(Criteria criteria) selects a collection of Report objects pre-filled with all related objects.doSelectJoinAllExceptScope(Criteria criteria, Connection conn) selects a collection of Report objects pre-filled with related objects.doSelectJoinEasyDeskModule(Criteria criteria) Selects a collection of dbObjectClassName objects pre-filled with their EasyDeskModule objects.doSelectJoinEasyDeskModule(Criteria criteria, Connection conn) Selects a collection of Report objects pre-filled with their EasyDeskModule objects.doSelectJoinEasyDeskUserImpl(Criteria criteria) Selects a collection of dbObjectClassName objects pre-filled with their EasyDeskUserImpl objects.doSelectJoinEasyDeskUserImpl(Criteria criteria, Connection conn) Selects a collection of Report objects pre-filled with their EasyDeskUserImpl objects.doSelectJoinMITList(Criteria criteria) Selects a collection of dbObjectClassName objects pre-filled with their MITList objects.doSelectJoinMITList(Criteria criteria, Connection conn) Selects a collection of Report objects pre-filled with their MITList objects.doSelectJoinScope(Criteria criteria) Selects a collection of dbObjectClassName objects pre-filled with their Scope objects.doSelectJoinScope(Criteria criteria, Connection conn) Selects a collection of Report objects pre-filled with their Scope objects.static ReportSelects at most one Report object from the database which has the same content as the passed object.static ReportdoSelectSingleRecord(Criteria criteria) Selects at most one Report object from a database.static ReportdoSelectSingleRecord(Criteria criteria, Connection connection) Selects at most one Report object from a database within a transaction.static <T> TdoSelectSingleRecord(Criteria criteria, RecordMapper<T> mapper) Selects at most a single row from a database an maps them to objects.static <T> TdoSelectSingleRecord(Criteria criteria, RecordMapper<T> mapper, Connection connection) Selects at most a single row from a database an maps them to objects.static intUpdates an Report in the database.static intdoUpdate(Report obj, Connection con) Updates a Report in the database.static intdoUpdate(Criteria selectCriteria, ColumnValues updateValues) Executes an update against the database.static intdoUpdate(Criteria criteria, ColumnValues updateValues, Connection connection) Executes an update against the database.static intdoUpdate(ColumnValues columnValues) Method to do updates.static intdoUpdate(ColumnValues columnValues, Connection con) Method to do updates.static intexecuteStatement(String statementString) Utility method which executes a given sql statement as prepared statement.static intexecuteStatement(String statementString, String dbName, List<JdbcTypedValue> replacementValues) Utility method which executes a given sql statement as prepared statement.static intexecuteStatement(String statementString, String dbName, Map<String, JdbcTypedValue> replacementValues) Utility method which executes a given sql statement as prepared statement.static intexecuteStatement(String statementString, Connection con, List<JdbcTypedValue> replacementValues) Utility method which executes a given sql statement as prepared statement.static intexecuteStatement(String statementString, Connection con, Map<String, JdbcTypedValue> replacementValues) Utility method which executes a given sql statement as prepared statement.static intexecuteStatement(String statementString, List<JdbcTypedValue> replacementValues) Utility method which executes a given sql statement as prepared statement.static intexecuteStatement(String statementString, Map<String, JdbcTypedValue> replacementValues) Utility method which executes a given sql statement as prepared statement.static ReportReturns a new instance of the Data object classstatic ReportPeerImplReturns an instance of the implementation of the peer.static TableMapReturns the TableMap related to this peer.static voidretrieveByObjectKeys(Collection<ObjectKey<?>> pks) Retrieve a multiple objects by pk.retrieveByObjectKeys(Collection<ObjectKey<?>> pks, Connection con) Retrieve multiple objects by pk.static ReportretrieveByPK(Long pk) Retrieve a single object by pkstatic ReportretrieveByPK(Long pk, Connection con) Retrieve a single object by pkstatic ReportretrieveByPK(ObjectKey<?> pk) Retrieve a single object by pkstatic ReportretrieveByPK(ObjectKey<?> pk, Connection con) Retrieve a single object by pkretrieveByTypedPKs(Collection<Long> pks) Retrieve multiple objects by pk.retrieveByTypedPKs(Collection<Long> pks, Connection dbcon) Retrieve multiple objects by pk.static voidsetAndSaveReportDatas(Report toLinkTo, Collection<ReportData> toSave) Saves the passed collection as linked objects.voidsetAndSaveReportDatas(Report toLinkTo, Collection<ReportData> toSave, Connection connection) Saves the passed collection as linked objects.static voidsetAndSaveReportHeadGroups(Report toLinkTo, Collection<ReportHeadGroup> toSave) Saves the passed collection as linked objects.voidsetAndSaveReportHeadGroups(Report toLinkTo, Collection<ReportHeadGroup> toSave, Connection connection) Saves the passed collection as linked objects.static voidsetAndSaveReportHeads(Report toLinkTo, Collection<ReportHead> toSave) Saves the passed collection as linked objects.voidsetAndSaveReportHeads(Report toLinkTo, Collection<ReportHead> toSave, Connection connection) Saves the passed collection as linked objects.static voidsetAndSaveReportStatuss(Report toLinkTo, Collection<ReportStatus> toSave) Saves the passed collection as linked objects.voidsetAndSaveReportStatuss(Report toLinkTo, Collection<ReportStatus> toSave, Connection connection) Saves the passed collection as linked objects.static voidsetReportPeerImpl(ReportPeerImpl peerImplInstance) Sets the instance of the implementation of the peer.
-
Field Details
-
DATABASE_NAME
The default database name for this class. -
TABLE_NAME
The table name for this class. -
TABLE
The table map for this class. -
REPORT_ID
The column for the REPORT_ID field -
USER_ID
The column for the USER_ID field -
MODULE_ID
The column for the MODULE_ID field -
LIST_ID
The column for the LIST_ID field -
NAME
The column for the NAME field -
SCOPE_ID
The column for the SCOPE_ID field -
APPROVED
The column for the APPROVED field -
CREATED_DATE
The column for the CREATED_DATE field -
numColumns
public static final int numColumnsnumber of columns for this peer- See Also:
-
-
Constructor Details
-
BaseReportPeer
public BaseReportPeer()
-
-
Method Details
-
createReportPeerImpl
Creates a new instance of the implementation of the peer.- Returns:
- the new instance.
-
getReportPeerImpl
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.
-
setReportPeerImpl
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
Add all the columns needed to create a new object.- Parameters:
criteria- object containing the columns to add.
-
correctBooleans
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
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
Selects Report 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<Report> doSelect(Criteria criteria, Connection connection) throws TorqueException Selects Report 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<Report> doSelectAsStream(Criteria criteria, Connection connection) throws TorqueException Selects Report 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
Selects Report 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
Selects at most one Report 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 Report doSelectSingleRecord(Criteria criteria, Connection connection) throws TorqueException Selects at most one Report 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
Selects at most one Report 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
Returns a new instance of the Data object class -
doInsert
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
Method to do inserts- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doInsert
Method to do inserts. This method is to be used during a transaction, otherwise use the doInsert(Report) 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
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
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
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 usingcriteriaand updated using the values inupdateValues.- Parameters:
selectCriteria- selects which rows of which table should be updated.updateValues- Which columns to update with which values, not null.- Returns:
- the number of affected rows.
- Throws:
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 usingcriteriaand updated using the values inupdateValues.- Parameters:
criteria- selects which rows of which table should be updated.updateValues- Which columns to update with which values, not null.connection- the database connection to use, not null.- Returns:
- the number of affected rows.
- Throws:
TorqueException- if updating fails.
-
doUpdate
Updates an Report 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
Updates a Report 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(Report) 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
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 TorqueExceptionUtility 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 TorqueExceptionUtility 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 TorqueExceptionUtility 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
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
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
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
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
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
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
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
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
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
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
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
Build a Criteria object from the data object for this peer.- Parameters:
obj- the object to build the criteria from, not null.
-
buildSelectCriteria
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
Returns the contents of the object as ColumnValues object- Throws:
TorqueException- if the table map cannot be retrieved (should not happen).
-
retrieveByPK
public static Report retrieveByPK(Long 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 Report retrieveByPK(Long pk, Connection con) throws TorqueException, NoRowsException, TooManyRowsException Retrieve a single object by pk- Parameters:
pk- the primary keycon- 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 Report 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 Report retrieveByPK(ObjectKey<?> pk, Connection con) throws TorqueException, NoRowsException, TooManyRowsException Retrieve a single object by pk- Parameters:
pk- the primary keycon- 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
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<Report> retrieveByTypedPKs(Collection<Long> pks, Connection dbcon) throws TorqueException Retrieve multiple objects by pk.- Parameters:
pks- List of primary keysdbcon- the connection to use- Returns:
- the list of matching objects, not null.
- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
retrieveByObjectKeys
public static List<Report> 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<Report> retrieveByObjectKeys(Collection<ObjectKey<?>> pks, Connection con) throws TorqueException Retrieve multiple objects by pk.- Parameters:
pks- List of primary keyscon- the connection to use- Returns:
- the list of matching objects, not null.
- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinEasyDeskUserImpl
Selects a collection of dbObjectClassName objects pre-filled with their EasyDeskUserImpl objects.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinEasyDeskUserImpl
public static List<Report> doSelectJoinEasyDeskUserImpl(Criteria criteria, Connection conn) throws TorqueException Selects a collection of Report objects pre-filled with their EasyDeskUserImpl objects.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinEasyDeskModule
Selects a collection of dbObjectClassName objects pre-filled with their EasyDeskModule objects.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinEasyDeskModule
public static List<Report> doSelectJoinEasyDeskModule(Criteria criteria, Connection conn) throws TorqueException Selects a collection of Report objects pre-filled with their EasyDeskModule objects.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinScope
Selects a collection of dbObjectClassName objects pre-filled with their Scope objects.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinScope
public static List<Report> doSelectJoinScope(Criteria criteria, Connection conn) throws TorqueException Selects a collection of Report objects pre-filled with their Scope objects.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinMITList
Selects a collection of dbObjectClassName objects pre-filled with their MITList objects.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinMITList
public static List<Report> doSelectJoinMITList(Criteria criteria, Connection conn) throws TorqueException Selects a collection of Report objects pre-filled with their MITList objects.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinAllExceptEasyDeskUserImpl
protected static List<Report> doSelectJoinAllExceptEasyDeskUserImpl(Criteria criteria) throws TorqueException selects a collection of Report objects pre-filled with all related objects. This method is protected by default in order to keep the public api reasonable. You can provide public methods for those you actually need in ReportPeer.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinAllExceptEasyDeskUserImpl
protected static List<Report> doSelectJoinAllExceptEasyDeskUserImpl(Criteria criteria, Connection conn) throws TorqueException selects a collection of Report objects pre-filled with related objects. This method is protected by default in order to keep the public api reasonable. You can provide public methods for those you actually need in ReportPeer.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinAllExceptEasyDeskModule
protected static List<Report> doSelectJoinAllExceptEasyDeskModule(Criteria criteria) throws TorqueException selects a collection of Report objects pre-filled with all related objects. This method is protected by default in order to keep the public api reasonable. You can provide public methods for those you actually need in ReportPeer.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinAllExceptEasyDeskModule
protected static List<Report> doSelectJoinAllExceptEasyDeskModule(Criteria criteria, Connection conn) throws TorqueException selects a collection of Report objects pre-filled with related objects. This method is protected by default in order to keep the public api reasonable. You can provide public methods for those you actually need in ReportPeer.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinAllExceptScope
selects a collection of Report objects pre-filled with all related objects. This method is protected by default in order to keep the public api reasonable. You can provide public methods for those you actually need in ReportPeer.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinAllExceptScope
protected static List<Report> doSelectJoinAllExceptScope(Criteria criteria, Connection conn) throws TorqueException selects a collection of Report objects pre-filled with related objects. This method is protected by default in order to keep the public api reasonable. You can provide public methods for those you actually need in ReportPeer.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinAllExceptMITList
protected static List<Report> doSelectJoinAllExceptMITList(Criteria criteria) throws TorqueException selects a collection of Report objects pre-filled with all related objects. This method is protected by default in order to keep the public api reasonable. You can provide public methods for those you actually need in ReportPeer.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
doSelectJoinAllExceptMITList
protected static List<Report> doSelectJoinAllExceptMITList(Criteria criteria, Connection conn) throws TorqueException selects a collection of Report objects pre-filled with related objects. This method is protected by default in order to keep the public api reasonable. You can provide public methods for those you actually need in ReportPeer.- Throws:
TorqueException- Any exceptions caught during processing will be rethrown wrapped into a TorqueException.
-
setAndSaveReportDatas
public static void setAndSaveReportDatas(Report toLinkTo, Collection<ReportData> 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
-
setAndSaveReportDatas
public void setAndSaveReportDatas(Report toLinkTo, Collection<ReportData> 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
-
setAndSaveReportStatuss
public static void setAndSaveReportStatuss(Report toLinkTo, Collection<ReportStatus> 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
-
setAndSaveReportStatuss
public void setAndSaveReportStatuss(Report toLinkTo, Collection<ReportStatus> 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
-
setAndSaveReportHeads
public static void setAndSaveReportHeads(Report toLinkTo, Collection<ReportHead> 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
-
setAndSaveReportHeads
public void setAndSaveReportHeads(Report toLinkTo, Collection<ReportHead> 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
-
setAndSaveReportHeadGroups
public static void setAndSaveReportHeadGroups(Report toLinkTo, Collection<ReportHeadGroup> 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
-
setAndSaveReportHeadGroups
public void setAndSaveReportHeadGroups(Report toLinkTo, Collection<ReportHeadGroup> 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
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()
-