Class UsageDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.inventoru.dao.UsageDAO

public class UsageDAO
extends CommonDAO

Whether a directory record is still referenced. The directories of the plugin are deleted for real, and a store type, a status, a manufacturer deleted from under the rows naming it left those rows pointing nowhere — the card showed a dash, the filter lost them, restoring a store brought back one without a type.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static enum	UsageDAO.Ref	A referencing column; table and column names are fixed here, never taken from a request.

Nested classes/interfaces inherited from class CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T>

Field Summary

Fields inherited from class CommonDAO

con, log, SQL_AND, SQL_DELETE, SQL_DELETE_FROM, SQL_DESC, SQL_DISTINCT, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT_IGNORE_INTO, SQL_INSERT_INTO, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UNION_ALL, SQL_UPDATE, SQL_VALUES, SQL_VALUES_1, SQL_VALUES_2, SQL_VALUES_3, SQL_VALUES_4, SQL_VALUES_5, SQL_WHERE

Constructor Summary

Constructors

Constructor	Description
UsageDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
int	count(UsageDAO.Ref ref, int id)

Methods inherited from class CommonDAO

deleteById, foundRows, getById, getGroupedIds, getGroupedIds, getIds, getIds, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, update, updateColumn, updateIds, updateIds, updateOrInsert

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

UsageDAO

public UsageDAO(Connection con)

Method Details

count

public int count(UsageDAO.Ref ref,
 int id)
          throws SQLException

Returns:

how many rows reference the record, deleted ones included: a deleted store can be restored, and it has to come back with its type and status.

Throws:

SQLException