Package mil.nga.geopackage.features.columns

Class GeometryColumnsSfSqlDao

java.lang.Object

com.j256.ormlite.dao.BaseDaoImpl<T,ID>

mil.nga.geopackage.db.GeoPackageDao<GeometryColumnsSfSql,TableColumnKey>

mil.nga.geopackage.features.columns.GeometryColumnsSfSqlDao

All Implemented Interfaces:

CloseableIterable<GeometryColumnsSfSql>, Dao<GeometryColumnsSfSql,TableColumnKey>, Iterable<GeometryColumnsSfSql>

public class GeometryColumnsSfSqlDao
extends GeoPackageDao<GeometryColumnsSfSql,TableColumnKey>

SF/SQL Geometry Columns Data Access Object

Author:

osbornb

Nested Class Summary

Nested classes/interfaces inherited from interface com.j256.ormlite.dao.Dao

Dao.CreateOrUpdateStatus, Dao.DaoObserver

Field Summary

Fields inherited from class mil.nga.geopackage.db.GeoPackageDao

db

Fields inherited from class com.j256.ormlite.dao.BaseDaoImpl

connectionSource, constructor, databaseType, dataClass, lastIterator, objectFactory, statementExecutor, tableConfig, tableInfo

Constructor Summary

Constructors

Constructor	Description
GeometryColumnsSfSqlDao(ConnectionSource connectionSource, Class<GeometryColumnsSfSql> dataClass)	Constructor, required by ORMLite

Method Summary

Modifier and Type	Method	Description
static GeometryColumnsSfSqlDao	create(GeoPackageCoreConnection db)	Create the DAO
static GeometryColumnsSfSqlDao	create(GeoPackageCore geoPackage)	Create the DAO
int	delete(GeometryColumnsSfSql data)
int	deleteById(TableColumnKey id)
int	deleteIds(Collection<TableColumnKey> idCollection)
TableColumnKey	extractId(GeometryColumnsSfSql data)
boolean	idExists(TableColumnKey id)
GeometryColumnsSfSql	queryForId(TableColumnKey key)
GeometryColumnsSfSql	queryForSameId(GeometryColumnsSfSql data)
int	update(GeometryColumnsSfSql geometryColumns)
int	updateId(GeometryColumnsSfSql data, TableColumnKey newId)

Methods inherited from class mil.nga.geopackage.db.GeoPackageDao

createDao, createDao, createDao, dropTable, getDatabase, isTable, isTableExists, isTableOrView, isView, setDatabase, tableExists, tableOrViewExists, verifyExists, viewExists

Methods inherited from class com.j256.ormlite.dao.BaseDaoImpl

assignEmptyForeignCollection, callBatchTasks, checkForInitialized, clearAllInternalObjectCaches, clearObjectCache, closeableIterator, closeLastIterator, commit, countOf, countOf, create, create, createIfNotExists, createObjectInstance, createOrUpdate, delete, delete, deleteBuilder, endThreadConnection, executeRaw, executeRawNoArgs, findForeignFieldType, getConnectionSource, getDataClass, getEmptyForeignCollection, getObjectCache, getRawRowMapper, getSelectStarRowMapper, getTableConfig, getTableInfo, getTableName, getWrappedIterable, getWrappedIterable, initialize, isAutoCommit, isUpdatable, iterator, iterator, iterator, iterator, mapSelectStarRow, notifyChanges, objectsEqual, objectToString, query, queryBuilder, queryForAll, queryForEq, queryForFieldValues, queryForFieldValuesArgs, queryForFirst, queryForFirst, queryForMatching, queryForMatchingArgs, queryRaw, queryRaw, queryRaw, queryRaw, queryRaw, queryRawValue, refresh, registerObserver, rollBack, setAutoCommit, setConnectionSource, setObjectCache, setObjectCache, setObjectFactory, setTableConfig, startThreadConnection, unregisterObserver, update, updateBuilder, updateRaw

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.lang.Iterable

forEach, spliterator

Constructor Detail

GeometryColumnsSfSqlDao

public GeometryColumnsSfSqlDao(ConnectionSource connectionSource,
                               Class<GeometryColumnsSfSql> dataClass)
                        throws SQLException

Constructor, required by ORMLite

Parameters:

connectionSource - connection source

dataClass - data class

Throws:

SQLException - upon failure

Method Detail

create

public static GeometryColumnsSfSqlDao create(GeoPackageCore geoPackage)

Create the DAO

Parameters:

geoPackage - GeoPackage

Returns:

dao

Since:

4.0.0

create

public static GeometryColumnsSfSqlDao create(GeoPackageCoreConnection db)

Create the DAO

Parameters:

db - database connection

Returns:

dao

Since:

4.0.0

queryForId

public GeometryColumnsSfSql queryForId(TableColumnKey key)
                                throws SQLException

Specified by:

queryForId in interface Dao<GeometryColumnsSfSql,TableColumnKey>

Overrides:

queryForId in class BaseDaoImpl<GeometryColumnsSfSql,TableColumnKey>

Throws:

SQLException

extractId

public TableColumnKey extractId(GeometryColumnsSfSql data)
                         throws SQLException

Specified by:

extractId in interface Dao<GeometryColumnsSfSql,TableColumnKey>

Overrides:

extractId in class BaseDaoImpl<GeometryColumnsSfSql,TableColumnKey>

Throws:

SQLException

idExists

public boolean idExists(TableColumnKey id)
                 throws SQLException

Specified by:

idExists in interface Dao<GeometryColumnsSfSql,TableColumnKey>

Overrides:

idExists in class BaseDaoImpl<GeometryColumnsSfSql,TableColumnKey>

Throws:

SQLException

queryForSameId

public GeometryColumnsSfSql queryForSameId(GeometryColumnsSfSql data)
                                    throws SQLException

Specified by:

queryForSameId in interface Dao<GeometryColumnsSfSql,TableColumnKey>

Overrides:

queryForSameId in class BaseDaoImpl<GeometryColumnsSfSql,TableColumnKey>

Throws:

SQLException

updateId

public int updateId(GeometryColumnsSfSql data,
                    TableColumnKey newId)
             throws SQLException

Specified by:

updateId in interface Dao<GeometryColumnsSfSql,TableColumnKey>

Overrides:

updateId in class BaseDaoImpl<GeometryColumnsSfSql,TableColumnKey>

Throws:

SQLException

delete

public int delete(GeometryColumnsSfSql data)
           throws SQLException

Specified by:

delete in interface Dao<GeometryColumnsSfSql,TableColumnKey>

Overrides:

delete in class BaseDaoImpl<GeometryColumnsSfSql,TableColumnKey>

Throws:

SQLException

deleteById

public int deleteById(TableColumnKey id)
               throws SQLException

Specified by:

deleteById in interface Dao<GeometryColumnsSfSql,TableColumnKey>

Overrides:

deleteById in class BaseDaoImpl<GeometryColumnsSfSql,TableColumnKey>

Throws:

SQLException

deleteIds

public int deleteIds(Collection<TableColumnKey> idCollection)
              throws SQLException

Specified by:

deleteIds in interface Dao<GeometryColumnsSfSql,TableColumnKey>

Overrides:

deleteIds in class BaseDaoImpl<GeometryColumnsSfSql,TableColumnKey>

Throws:

SQLException

update

public int update(GeometryColumnsSfSql geometryColumns)
           throws SQLException

Update using the complex key

Specified by:

update in interface Dao<GeometryColumnsSfSql,TableColumnKey>

Overrides:

update in class BaseDaoImpl<GeometryColumnsSfSql,TableColumnKey>

Throws:

SQLException