Package mil.nga.geopackage.user

Class UserCoreConnection<TColumn extends UserColumn,TTable extends UserTable<TColumn>,TRow extends UserCoreRow<TColumn,TTable>,TResult extends UserCoreResult<TColumn,TTable,TRow>>

java.lang.Object

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

Type Parameters:

TColumn - column type

TTable - table type

TRow - row type

TResult - result type

public abstract class UserCoreConnection<TColumn extends UserColumn,TTable extends UserTable<TColumn>,TRow extends UserCoreRow<TColumn,TTable>,TResult extends UserCoreResult<TColumn,TTable,TRow>>
extends Object

GeoPackage Connection used to define common functionality within different connection types

Author:

osbornb

Constructor Summary

Constructors

Constructor	Description
UserCoreConnection()

Method Summary

Modifier and Type	Method	Description
abstract TResult	query(boolean distinct, String table, String[] columns, String[] columnsAs, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)	Query the given table, returning a UserCoreResult over the result set.
abstract TResult	query(boolean distinct, String table, String[] columns, String[] columnsAs, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)	Query the given URL, returning a UserCoreResult over the result set.
abstract TResult	query(boolean distinct, String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)	Query the given table, returning a UserCoreResult over the result set.
abstract TResult	query(boolean distinct, String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)	Query the given URL, returning a UserCoreResult over the result set.
abstract TResult	query(String table, String[] columns, String[] columnsAs, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)	Query the given table, returning a UserCoreResult over the result set.
abstract TResult	query(String table, String[] columns, String[] columnsAs, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)	Query the given URL, returning a UserCoreResult over the result set.
abstract TResult	query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)	Query the given table, returning a UserCoreResult over the result set.
abstract TResult	query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)	Query the given URL, returning a UserCoreResult over the result set.
abstract String	querySQL(boolean distinct, String table, String[] columns, String[] columnsAs, String selection, String groupBy, String having, String orderBy)	Build the query SQL
abstract String	querySQL(boolean distinct, String table, String[] columns, String[] columnsAs, String selection, String groupBy, String having, String orderBy, String limit)	Build the query SQL
abstract String	querySQL(boolean distinct, String table, String[] columns, String selection, String groupBy, String having, String orderBy)	Build the query SQL
abstract String	querySQL(boolean distinct, String table, String[] columns, String selection, String groupBy, String having, String orderBy, String limit)	Build the query SQL
abstract String	querySQL(String table, String[] columns, String[] columnsAs, String selection, String groupBy, String having, String orderBy)	Build the query SQL
abstract String	querySQL(String table, String[] columns, String[] columnsAs, String selection, String groupBy, String having, String orderBy, String limit)	Build the query SQL
abstract String	querySQL(String table, String[] columns, String selection, String groupBy, String having, String orderBy)	Build the query SQL
abstract String	querySQL(String table, String[] columns, String selection, String groupBy, String having, String orderBy, String limit)	Build the query SQL
abstract TResult	rawQuery(String sql, String[] selectionArgs)	Runs the provided SQL and returns a UserCoreResult over the result set.
abstract TResult	rawQuery(String sql, String[] columns, String[] selectionArgs)	Runs the provided SQL and returns a UserCoreResult over the result set.

Methods inherited from class java.lang.Object

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

Constructor Detail

UserCoreConnection

public UserCoreConnection()

Method Detail

rawQuery

public abstract TResult rawQuery(String sql,
                                 String[] selectionArgs)

Runs the provided SQL and returns a UserCoreResult over the result set.

Parameters:

sql - SQL statement

selectionArgs - selection arguments

Returns:

result

rawQuery

public abstract TResult rawQuery(String sql,
                                 String[] columns,
                                 String[] selectionArgs)

Runs the provided SQL and returns a UserCoreResult over the result set.

Parameters:

sql - SQL statement

columns - subset of table columns defined in the SQL

selectionArgs - selection arguments

Returns:

result

Since:

6.2.0

query

public abstract TResult query(String table,
                              String[] columns,
                              String selection,
                              String[] selectionArgs,
                              String groupBy,
                              String having,
                              String orderBy)

Query the given table, returning a UserCoreResult over the result set.

Parameters:

table - table name

columns - columns

selection - selection

selectionArgs - selection arguments

groupBy - group by

having - having

orderBy - order by

Returns:

result

query

public abstract TResult query(boolean distinct,
                              String table,
                              String[] columns,
                              String selection,
                              String[] selectionArgs,
                              String groupBy,
                              String having,
                              String orderBy)

Query the given table, returning a UserCoreResult over the result set.

Parameters:

distinct - distinct rows

table - table name

columns - columns

selection - selection

selectionArgs - selection arguments

groupBy - group by

having - having

orderBy - order by

Returns:

result

Since:

4.0.0

query

public abstract TResult query(String table,
                              String[] columns,
                              String[] columnsAs,
                              String selection,
                              String[] selectionArgs,
                              String groupBy,
                              String having,
                              String orderBy)

Query the given table, returning a UserCoreResult over the result set.

Parameters:

table - table name

columns - columns

columnsAs - columns as values

selection - selection

selectionArgs - selection arguments

groupBy - group by

having - having

orderBy - order by

Returns:

result

Since:

2.0.0

query

public abstract TResult query(boolean distinct,
                              String table,
                              String[] columns,
                              String[] columnsAs,
                              String selection,
                              String[] selectionArgs,
                              String groupBy,
                              String having,
                              String orderBy)

Query the given table, returning a UserCoreResult over the result set.

Parameters:

distinct - distinct rows

table - table name

columns - columns

columnsAs - columns as values

selection - selection

selectionArgs - selection arguments

groupBy - group by

having - having

orderBy - order by

Returns:

result

Since:

4.0.0

query

public abstract TResult query(String table,
                              String[] columns,
                              String selection,
                              String[] selectionArgs,
                              String groupBy,
                              String having,
                              String orderBy,
                              String limit)

Query the given URL, returning a UserCoreResult over the result set.

Parameters:

table - table name

columns - columns

selection - selection

selectionArgs - selection arguments

groupBy - group by

having - having

orderBy - order by

limit - query limit

Returns:

result

query

public abstract TResult query(boolean distinct,
                              String table,
                              String[] columns,
                              String selection,
                              String[] selectionArgs,
                              String groupBy,
                              String having,
                              String orderBy,
                              String limit)

Query the given URL, returning a UserCoreResult over the result set.

Parameters:

distinct - distinct rows

table - table name

columns - columns

selection - selection

selectionArgs - selection arguments

groupBy - group by

having - having

orderBy - order by

limit - query limit

Returns:

result

Since:

4.0.0

query

public abstract TResult query(String table,
                              String[] columns,
                              String[] columnsAs,
                              String selection,
                              String[] selectionArgs,
                              String groupBy,
                              String having,
                              String orderBy,
                              String limit)

Query the given URL, returning a UserCoreResult over the result set.

Parameters:

table - table name

columns - columns

columnsAs - columns as values

selection - selection

selectionArgs - selection arguments

groupBy - group by

having - having

orderBy - order by

limit - query limit

Returns:

result

Since:

2.0.0

query

public abstract TResult query(boolean distinct,
                              String table,
                              String[] columns,
                              String[] columnsAs,
                              String selection,
                              String[] selectionArgs,
                              String groupBy,
                              String having,
                              String orderBy,
                              String limit)

Query the given URL, returning a UserCoreResult over the result set.

Parameters:

distinct - distinct rows

table - table name

columns - columns

columnsAs - columns as values

selection - selection

selectionArgs - selection arguments

groupBy - group by

having - having

orderBy - order by

limit - query limit

Returns:

result

Since:

4.0.0

querySQL

public abstract String querySQL(String table,
                                String[] columns,
                                String selection,
                                String groupBy,
                                String having,
                                String orderBy)

Build the query SQL

Parameters:

table - table name

columns - columns

selection - selection

groupBy - group by

having - having

orderBy - order by

Returns:

SQL

Since:

3.4.0

querySQL

public abstract String querySQL(boolean distinct,
                                String table,
                                String[] columns,
                                String selection,
                                String groupBy,
                                String having,
                                String orderBy)

Build the query SQL

Parameters:

distinct - distinct rows

table - table name

columns - columns

selection - selection

groupBy - group by

having - having

orderBy - order by

Returns:

SQL

Since:

4.0.0

querySQL

public abstract String querySQL(String table,
                                String[] columns,
                                String[] columnsAs,
                                String selection,
                                String groupBy,
                                String having,
                                String orderBy)

Build the query SQL

Parameters:

table - table name

columns - columns

columnsAs - columns as values

selection - selection

groupBy - group by

having - having

orderBy - order by

Returns:

SQL

Since:

3.4.0

querySQL

public abstract String querySQL(boolean distinct,
                                String table,
                                String[] columns,
                                String[] columnsAs,
                                String selection,
                                String groupBy,
                                String having,
                                String orderBy)

Build the query SQL

Parameters:

distinct - distinct rows

table - table name

columns - columns

columnsAs - columns as values

selection - selection

groupBy - group by

having - having

orderBy - order by

Returns:

SQL

Since:

4.0.0

querySQL

public abstract String querySQL(String table,
                                String[] columns,
                                String selection,
                                String groupBy,
                                String having,
                                String orderBy,
                                String limit)

Build the query SQL

Parameters:

table - table name

columns - columns

selection - selection

groupBy - group by

having - having

orderBy - order by

limit - query limit

Returns:

SQL

Since:

3.4.0

querySQL

public abstract String querySQL(boolean distinct,
                                String table,
                                String[] columns,
                                String selection,
                                String groupBy,
                                String having,
                                String orderBy,
                                String limit)

Build the query SQL

Parameters:

distinct - distinct rows

table - table name

columns - columns

selection - selection

groupBy - group by

having - having

orderBy - order by

limit - query limit

Returns:

SQL

Since:

4.0.0

querySQL

public abstract String querySQL(String table,
                                String[] columns,
                                String[] columnsAs,
                                String selection,
                                String groupBy,
                                String having,
                                String orderBy,
                                String limit)

Build the query SQL

Parameters:

table - table name

columns - columns

columnsAs - columns as values

selection - selection

groupBy - group by

having - having

orderBy - order by

limit - query limit

Returns:

SQL

Since:

3.4.0

querySQL

public abstract String querySQL(boolean distinct,
                                String table,
                                String[] columns,
                                String[] columnsAs,
                                String selection,
                                String groupBy,
                                String having,
                                String orderBy,
                                String limit)

Build the query SQL

Parameters:

distinct - distinct rows

table - table name

columns - columns

columnsAs - columns as values

selection - selection

groupBy - group by

having - having

orderBy - order by

limit - query limit

Returns:

SQL

Since:

4.0.0