Package mil.nga.geopackage.db

Class GeoPackageConnection

java.lang.Object

mil.nga.geopackage.db.GeoPackageCoreConnection

mil.nga.geopackage.db.GeoPackageConnection

All Implemented Interfaces:

Closeable, AutoCloseable

public class GeoPackageConnection
extends GeoPackageCoreConnection

GeoPackage Connection wrapper

Author:

osbornb

Field Summary

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

connectionSource

Constructor Summary

Constructors

Constructor	Description
GeoPackageConnection(File file, Connection connection, ConnectionSource connectionSource)	Constructor

Method Summary

Modifier and Type	Method	Description
void	beginTransaction()
void	close()
void	commit()
int	delete(String table, String whereClause, String[] whereArgs)
void	endTransaction(boolean successful)
void	execSQL(String sql)
Connection	getConnection()	Get the connection
ConnectionSource	getConnectionSource()
boolean	inTransaction()
ResultSet	query(String sql, String[] args)	Perform a database query
List<List<Object>>	queryResults(String sql, String[] args, GeoPackageDataType[] dataTypes, Integer limit)
List<Object>	querySingleColumnResults(String sql, String[] args, int column, GeoPackageDataType dataType, Integer limit)
Object	querySingleResult(String sql, String[] args, int column, GeoPackageDataType dataType)
String	readableSize()	Get a readable version of the database size
long	size()	Size of the database in bytes

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

addColumn, aggregateFunction, aggregateFunction, aggregateFunction, aggregateFunction, columnExists, count, count, count, count, count, count, enableForeignKeys, endAndBeginTransaction, endTransaction, failTransaction, foreignKeyCheck, foreignKeyCheck, foreignKeys, foreignKeys, getApplicationId, getApplicationId, getApplicationIdHex, getApplicationIdInteger, getUserVersion, getUserVersionMajor, getUserVersionMinor, getUserVersionPatch, max, max, min, min, queryResults, queryResults, queryResults, querySingleColumnResults, querySingleColumnResults, querySingleColumnResults, querySingleColumnResults, querySingleColumnResults, querySingleColumnTypedResults, querySingleColumnTypedResults, querySingleColumnTypedResults, querySingleColumnTypedResults, querySingleColumnTypedResults, querySingleColumnTypedResults, querySingleResult, querySingleResult, querySingleResult, querySingleRowResults, querySingleRowResults, querySingleRowTypedResults, querySingleRowTypedResults, querySingleTypedResult, querySingleTypedResult, querySingleTypedResult, querySingleTypedResult, queryTypedResults, queryTypedResults, queryTypedResults, queryTypedResults, setApplicationId, setApplicationId, setUserVersion, setUserVersion, tableExists, tableOrViewExists, viewExists

Methods inherited from class java.lang.Object

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

Constructor Detail

GeoPackageConnection

public GeoPackageConnection(File file,
                            Connection connection,
                            ConnectionSource connectionSource)

Constructor

Parameters:

file - file

connection - connection

connectionSource - connection source

Method Detail

getConnection

public Connection getConnection()

Get the connection

Returns:

connection

getConnectionSource

public ConnectionSource getConnectionSource()

Overrides:

getConnectionSource in class GeoPackageCoreConnection

size

public long size()

Size of the database in bytes

Returns:

bytes

Since:

4.0.0

readableSize

public String readableSize()

Get a readable version of the database size

Returns:

size

Since:

4.0.0

execSQL

public void execSQL(String sql)

Specified by:

execSQL in class GeoPackageCoreConnection

beginTransaction

public void beginTransaction()

Specified by:

beginTransaction in class GeoPackageCoreConnection

endTransaction

public void endTransaction(boolean successful)

Specified by:

endTransaction in class GeoPackageCoreConnection

commit

public void commit()

Specified by:

commit in class GeoPackageCoreConnection

inTransaction

public boolean inTransaction()

Specified by:

inTransaction in class GeoPackageCoreConnection

delete

public int delete(String table,
                  String whereClause,
                  String[] whereArgs)

Specified by:

delete in class GeoPackageCoreConnection

close

public void close()

Specified by:

close in interface AutoCloseable

Specified by:

close in interface Closeable

Overrides:

close in class GeoPackageCoreConnection

querySingleResult

public Object querySingleResult(String sql,
                                String[] args,
                                int column,
                                GeoPackageDataType dataType)

Specified by:

querySingleResult in class GeoPackageCoreConnection

querySingleColumnResults

public List<Object> querySingleColumnResults(String sql,
                                             String[] args,
                                             int column,
                                             GeoPackageDataType dataType,
                                             Integer limit)

Specified by:

querySingleColumnResults in class GeoPackageCoreConnection

queryResults

public List<List<Object>> queryResults(String sql,
                                       String[] args,
                                       GeoPackageDataType[] dataTypes,
                                       Integer limit)

Specified by:

queryResults in class GeoPackageCoreConnection

query

public ResultSet query(String sql,
                       String[] args)

Perform a database query

Parameters:

sql - sql statement

args - arguments

Returns:

result set

Since:

1.1.2