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,UserCustomCursor>

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

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(UserCustomCursor cursor)	Get the user mapping row from the current cursor location
UserMappingRow	getRow(UserCustomRow row)	Get a user mapping row from the user custom row
UserMappingTable	getTable()
UserMappingRow	newRow()
UserCustomCursor	queryByBaseId(long baseId)	Query by base id
UserCustomCursor	queryByBaseId(UserMappingRow userMappingRow)	Query by base id
UserCustomCursor	queryByIds(long baseId, long relatedId)	Query by both base id and related id
UserCustomCursor	queryByIds(UserMappingRow userMappingRow)	Query by both base id and related id
UserCustomCursor	queryByRelatedId(long relatedId)	Query by related id
UserCustomCursor	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, registerCursorWrapper

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

beginTransaction, commit, endTransaction, getDatabaseConnection, getDb, insert, insert, insertOrThrow, inTransaction, isInvalidRequery, prepareResult, query, query, queryForIdRow, renameTableColumn, setInvalidRequery, setUseBindings, 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, 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, setPkModifiable, setValueValidation

Methods inherited from class java.lang.Object

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

Constructor Details

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 Details

getTable

public UserMappingTable getTable()

Overrides:

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

newRow

public UserMappingRow newRow()

Overrides:

newRow in class UserCustomDao

getRow

public UserMappingRow getRow(UserCustomCursor cursor)

Get the user mapping row from the current cursor location

Parameters:

cursor - cursor

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 UserCustomCursor queryByBaseId(UserMappingRow userMappingRow)

Query by base id

Parameters:

userMappingRow - user mapping row

Returns:

cursor

queryByBaseId

public UserCustomCursor queryByBaseId(long baseId)

Query by base id

Parameters:

baseId - base id

Returns:

cursor

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 UserCustomCursor queryByRelatedId(UserMappingRow userMappingRow)

Query by related id

Parameters:

userMappingRow - user mapping row

Returns:

cursor

queryByRelatedId

public UserCustomCursor queryByRelatedId(long relatedId)

Query by related id

Parameters:

relatedId - related id

Returns:

cursor

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 UserCustomCursor queryByIds(UserMappingRow userMappingRow)

Query by both base id and related id

Parameters:

userMappingRow - user mapping row

Returns:

cursor

queryByIds

public UserCustomCursor queryByIds(long baseId,
 long relatedId)

Query by both base id and related id

Parameters:

baseId - base id

relatedId - related id

Returns:

cursor

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