Package mil.nga.geopackage.extension.related

Class UserMappingDao

java.lang.Object

mil.nga.geopackage.user.UserCoreDao<TColumn,TTable,TRow,TResult>

mil.nga.geopackage.user.UserDao<UserCustomColumn,UserCustomTable,UserCustomRow,UserCustomResultSet>

mil.nga.geopackage.user.custom.UserCustomDao

mil.nga.geopackage.extension.related.UserMappingDao

Direct Known Subclasses:

StyleMappingDao

public class UserMappingDao
extends UserCustomDao

User Mapping DAO for reading user mapping data tables

Since:

3.0.1

Author:

osbornb

Field Summary

Fields inherited from class mil.nga.geopackage.user.custom.UserCustomDao

userDb

Fields inherited from class mil.nga.geopackage.user.UserCoreDao

projection

Constructor Summary

Constructors

Modifier	Constructor	Description
	UserMappingDao(UserCustomDao dao)	Constructor
protected	UserMappingDao(UserCustomDao dao, UserMappingTable userMappingTable)	Constructor

Method Summary

Modifier and Type	Method	Description
int	countByBaseId(long baseId)	Count by base id
int	countByBaseId(UserMappingRow userMappingRow)	Count by base id
int	countByIds(long baseId, long relatedId)	Count by both base id and related id
int	countByIds(UserMappingRow userMappingRow)	Count by both base id and related id
int	countByRelatedId(long relatedId)	Count by related id
int	countByRelatedId(UserMappingRow userMappingRow)	Count by related id
int	deleteByBaseId(long baseId)	Delete user mappings by base id
int	deleteByBaseId(UserMappingRow userMappingRow)	Delete user mappings by base id
int	deleteByIds(long baseId, long relatedId)	Delete user mappings by both base id and related id
int	deleteByIds(UserMappingRow userMappingRow)	Delete user mappings by both base id and related id
int	deleteByRelatedId(long relatedId)	Delete user mappings by related id
int	deleteByRelatedId(UserMappingRow userMappingRow)	Delete user mappings by related id
UserMappingRow	getRow(UserCustomResultSet resultSet)	Get the user mapping row from the current result set location
UserMappingRow	getRow(UserCustomRow row)	Get a user mapping row from the user custom row
UserMappingTable	getTable()
UserMappingRow	newRow()
UserCustomResultSet	queryByBaseId(long baseId)	Query by base id
UserCustomResultSet	queryByBaseId(UserMappingRow userMappingRow)	Query by base id
UserCustomResultSet	queryByIds(long baseId, long relatedId)	Query by both base id and related id
UserCustomResultSet	queryByIds(UserMappingRow userMappingRow)	Query by both base id and related id
UserCustomResultSet	queryByRelatedId(long relatedId)	Query by related id
UserCustomResultSet	queryByRelatedId(UserMappingRow userMappingRow)	Query by related id
List<Long>	uniqueBaseIds()	Get the unique base ids
List<Long>	uniqueRelatedIds()	Get the unique related ids

Methods inherited from class mil.nga.geopackage.user.custom.UserCustomDao

count, getBoundingBox, getBoundingBox, getUserDb, readTable

Methods inherited from class mil.nga.geopackage.user.UserDao

beginTransaction, commit, endTransaction, getConnection, getDb, insert, insert, insertOrThrow, inTransaction, prepareResult, update, update

Methods inherited from class mil.nga.geopackage.user.UserCoreDao

addColumn, alterColumn, alterColumns, buildColumnsAs, buildColumnsAs, buildColumnsAs, buildColumnsAs, buildColumnsAs, buildColumnsAsNull, buildColumnsAsNull, buildLimit, buildValueWhere, buildValueWhereArgs, buildWhere, buildWhere, buildWhere, buildWhere, buildWhere, buildWhere, buildWhere, buildWhere, buildWhere, buildWhere, buildWhere, buildWhere, buildWhereArgs, buildWhereArgs, buildWhereArgs, buildWhereArgs, buildWhereArgs, buildWhereArgs, buildWhereArgs, buildWhereArgs, buildWhereArgs, buildWhereArgs, buildWhereArgs, buildWhereArgs, buildWhereIn, buildWhereInArgs, buildWhereLike, buildWhereLike, buildWhereNull, columnCount, count, count, count, count, count, count, count, count, countColumn, countColumnIn, countColumnIn, countForEq, countForEq, countForEq, countForEq, countForEq, countForEq, countForEq, countForEq, countForEq, countForFieldValues, countForFieldValues, countForFieldValues, countForLike, countForLike, countForLike, countForLike, countForLike, countForLike, countForLike, countForLike, countForLike, countForValueFieldValues, countForValueFieldValues, countForValueFieldValues, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, countIn, create, createDao, delete, delete, delete, deleteAll, deleteById, dropColumn, dropColumn, dropColumn, dropColumnIndexes, dropColumnNames, dropColumns, dropTable, endAndBeginTransaction, endTransaction, failTransaction, getColumnNames, getColumns, getContents, getDatabase, getPkColumn, getPkColumnIndex, getPkColumnName, getPkWhere, getPkWhereArgs, getProjection, getTableName, getXRange, getXRange, getYRange, getYRange, getZoomLevel, hasPkColumn, isPkModifiable, isValueValidation, max, max, min, min, projectBoundingBox, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, query, queryAs, queryAs, queryForAll, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForChunk, queryForEq, queryForEq, queryForEq, queryForEq, queryForEq, queryForEq, queryForEq, queryForEq, queryForEq, queryForEq, queryForEq, queryForEq, queryForFieldValues, queryForFieldValues, queryForFieldValues, queryForFieldValues, queryForId, queryForId, queryForId, queryForId, queryForIdRow, queryForIdRow, queryForIdRow, queryForIdRow, queryForLike, queryForLike, queryForLike, queryForLike, queryForLike, queryForLike, queryForLike, queryForLike, queryForLike, queryForLike, queryForLike, queryForLike, queryForValueFieldValues, queryForValueFieldValues, queryForValueFieldValues, queryForValueFieldValues, queryIdsSQL, queryIdsSQL, queryIdsSQL, queryIdsSQL, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryIn, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunk, queryInForChunkWhere, queryInForChunkWhere, queryInForChunkWhere, queryInForChunkWhere, queryInForChunkWhere, queryInForChunkWhere, queryInForChunkWhere, queryInForChunkWhere, queryInForChunkWhere, queryInForChunkWhere, queryInForChunkWhere, queryInForChunkWhere, queryInForChunkWhere, queryInForChunkWhere, queryInForChunkWhere, queryInForChunkWhere, queryResults, queryResults, queryResults, queryResults, querySingleColumnResults, querySingleColumnResults, querySingleColumnResults, querySingleColumnResults, querySingleColumnResults, querySingleColumnResults, querySingleColumnTypedResults, querySingleColumnTypedResults, querySingleColumnTypedResults, querySingleColumnTypedResults, querySingleColumnTypedResults, querySingleColumnTypedResults, querySingleResult, querySingleResult, querySingleResult, querySingleResult, querySingleRowResults, querySingleRowResults, querySingleRowTypedResults, querySingleRowTypedResults, querySingleTypedResult, querySingleTypedResult, querySingleTypedResult, querySingleTypedResult, querySQL, querySQL, querySQL, querySQL, querySQL, querySQL, querySQL, querySQL, queryTypedResults, queryTypedResults, queryTypedResults, queryTypedResults, rawQuery, rawQuery, rawQuery, renameColumn, renameColumn, renameColumn, renameTableColumn, setPkModifiable, setValueValidation

Methods inherited from class java.lang.Object

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

Constructor Detail

UserMappingDao

public UserMappingDao(UserCustomDao dao)

Constructor

Parameters:

dao - user custom data access object

UserMappingDao

protected UserMappingDao(UserCustomDao dao,
                         UserMappingTable userMappingTable)

Constructor

Parameters:

dao - user custom data access object

userMappingTable - user mapping table

Method Detail

getTable

public UserMappingTable getTable()

Overrides:

getTable in class UserCoreDao<UserCustomColumn,UserCustomTable,UserCustomRow,UserCustomResultSet>

newRow

public UserMappingRow newRow()

Overrides:

newRow in class UserCustomDao

getRow

public UserMappingRow getRow(UserCustomResultSet resultSet)

Get the user mapping row from the current result set location

Parameters:

resultSet - result set

Returns:

user mapping row

getRow

public UserMappingRow getRow(UserCustomRow row)

Get a user mapping row from the user custom row

Parameters:

row - custom row

Returns:

user mapping row

queryByBaseId

public UserCustomResultSet queryByBaseId(UserMappingRow userMappingRow)

Query by base id

Parameters:

userMappingRow - user mapping row

Returns:

result set

queryByBaseId

public UserCustomResultSet queryByBaseId(long baseId)

Query by base id

Parameters:

baseId - base id

Returns:

result set

countByBaseId

public int countByBaseId(UserMappingRow userMappingRow)

Count by base id

Parameters:

userMappingRow - user mapping row

Returns:

count

countByBaseId

public int countByBaseId(long baseId)

Count by base id

Parameters:

baseId - base id

Returns:

count

queryByRelatedId

public UserCustomResultSet queryByRelatedId(UserMappingRow userMappingRow)

Query by related id

Parameters:

userMappingRow - user mapping row

Returns:

result set

queryByRelatedId

public UserCustomResultSet queryByRelatedId(long relatedId)

Query by related id

Parameters:

relatedId - related id

Returns:

result set

countByRelatedId

public int countByRelatedId(UserMappingRow userMappingRow)

Count by related id

Parameters:

userMappingRow - user mapping row

Returns:

count

countByRelatedId

public int countByRelatedId(long relatedId)

Count by related id

Parameters:

relatedId - related id

Returns:

count

queryByIds

public UserCustomResultSet queryByIds(UserMappingRow userMappingRow)

Query by both base id and related id

Parameters:

userMappingRow - user mapping row

Returns:

result set

queryByIds

public UserCustomResultSet queryByIds(long baseId,
                                      long relatedId)

Query by both base id and related id

Parameters:

baseId - base id

relatedId - related id

Returns:

result set

uniqueBaseIds

public List<Long> uniqueBaseIds()

Get the unique base ids

Returns:

list of unique base ids

Since:

3.2.0

uniqueRelatedIds

public List<Long> uniqueRelatedIds()

Get the unique related ids

Returns:

list of unique related ids

Since:

3.2.0

countByIds

public int countByIds(UserMappingRow userMappingRow)

Count by both base id and related id

Parameters:

userMappingRow - user mapping row

Returns:

count

countByIds

public int countByIds(long baseId,
                      long relatedId)

Count by both base id and related id

Parameters:

baseId - base id

relatedId - related id

Returns:

count

deleteByBaseId

public int deleteByBaseId(UserMappingRow userMappingRow)

Delete user mappings by base id

Parameters:

userMappingRow - user mapping row

Returns:

rows deleted

deleteByBaseId

public int deleteByBaseId(long baseId)

Delete user mappings by base id

Parameters:

baseId - base id

Returns:

rows deleted

deleteByRelatedId

public int deleteByRelatedId(UserMappingRow userMappingRow)

Delete user mappings by related id

Parameters:

userMappingRow - user mapping row

Returns:

rows deleted

deleteByRelatedId

public int deleteByRelatedId(long relatedId)

Delete user mappings by related id

Parameters:

relatedId - related id

Returns:

rows deleted

deleteByIds

public int deleteByIds(UserMappingRow userMappingRow)

Delete user mappings by both base id and related id

Parameters:

userMappingRow - user mapping row

Returns:

rows deleted

deleteByIds

public int deleteByIds(long baseId,
                       long relatedId)

Delete user mappings by both base id and related id

Parameters:

baseId - base id

relatedId - related id

Returns:

rows deleted