Package mil.nga.geopackage.db.master

Class SQLiteMaster

java.lang.Object

mil.nga.geopackage.db.master.SQLiteMaster

public class SQLiteMaster
extends Object

SQLite Master table queries (sqlite_master)

Since:

3.3.0

Author:

osbornb

Field Summary

Fields

Modifier and Type	Field	Description
static String	TABLE_NAME	Table Name

Method Summary

Modifier and Type	Method	Description
Set<SQLiteMasterColumn>	columns()	Get the columns in the result
static SQLiteMasterColumn[]	columns(SQLiteMasterColumn... columns)	Shortcut to build columns into an array
int	count()	Result count
static int	count(GeoPackageCoreConnection db)	Count the sqlite_master table
static int	count(GeoPackageCoreConnection db, String tableName)	Count the sqlite_master table
static int	count(GeoPackageCoreConnection db, Collection<SQLiteMasterType> types)	Count the sqlite_master table
static int	count(GeoPackageCoreConnection db, Collection<SQLiteMasterType> types, String tableName)	Count the sqlite_master table
static int	count(GeoPackageCoreConnection db, SQLiteMasterQuery query)	Count the sqlite_master table
static int	count(GeoPackageCoreConnection db, SQLiteMasterType type)	Count the sqlite_master table
static int	count(GeoPackageCoreConnection db, SQLiteMasterType[] types)	Count the sqlite_master table
static int	count(GeoPackageCoreConnection db, SQLiteMasterType[] types, String tableName)	Count the sqlite_master table
static int	count(GeoPackageCoreConnection db, SQLiteMasterType[] types, SQLiteMasterQuery query)	Count the sqlite_master table
static int	count(GeoPackageCoreConnection db, SQLiteMasterType type, String tableName)	Count the sqlite_master table
static int	count(GeoPackageCoreConnection db, SQLiteMasterType type, SQLiteMasterQuery query)	Count the sqlite_master table
static int	countByType(GeoPackageCoreConnection db, Collection<SQLiteMasterType> types)	Count the sqlite_master table
static int	countByType(GeoPackageCoreConnection db, Collection<SQLiteMasterType> types, String tableName)	Count the sqlite_master table
static int	countByType(GeoPackageCoreConnection db, SQLiteMasterType type)	Count the sqlite_master table
static int	countByType(GeoPackageCoreConnection db, SQLiteMasterType type, String tableName)	Count the sqlite_master table
static int	countViewsOnTable(GeoPackageCoreConnection db, String tableName)	Count the sqlite_master views on the table
int	getColumnIndex(SQLiteMasterColumn column)	Get the column index of the column type
TableConstraints	getConstraints(int row)	Get the constraints from table SQL
String	getName(int row)	Get the name
Long	getRootpage(int row)	Get the rootpage
List<Object>	getRow(int row)	Get the row at the row index
String	getSql(int row)	Get the sql
String	getTableName(int row)	Get the table name
SQLiteMasterType	getType(int row)	Get the type
String	getTypeString(int row)	Get the type string
Object	getValue(int row, SQLiteMasterColumn column)	Get the value of the column at the row index
Object	getValue(List<Object> row, SQLiteMasterColumn column)	Get the value in the row at the column index
static SQLiteMaster	query(GeoPackageCoreConnection db)	Query the sqlite_master table
static SQLiteMaster	query(GeoPackageCoreConnection db, String tableName)	Query the sqlite_master table
static SQLiteMaster	query(GeoPackageCoreConnection db, Collection<SQLiteMasterColumn> columns, Collection<SQLiteMasterType> types)	Query the sqlite_master table
static SQLiteMaster	query(GeoPackageCoreConnection db, Collection<SQLiteMasterColumn> columns, Collection<SQLiteMasterType> types, String tableName)	Query the sqlite_master table
static SQLiteMaster	query(GeoPackageCoreConnection db, Collection<SQLiteMasterColumn> columns, SQLiteMasterType type)	Query the sqlite_master table
static SQLiteMaster	query(GeoPackageCoreConnection db, Collection<SQLiteMasterColumn> columns, SQLiteMasterType type, String tableName)	Query the sqlite_master table
static SQLiteMaster	query(GeoPackageCoreConnection db, SQLiteMasterColumn[] columns, SQLiteMasterQuery query)	Query the sqlite_master table
static SQLiteMaster	query(GeoPackageCoreConnection db, SQLiteMasterColumn[] columns, SQLiteMasterType type)	Query the sqlite_master table
static SQLiteMaster	query(GeoPackageCoreConnection db, SQLiteMasterColumn[] columns, SQLiteMasterType[] types)	Query the sqlite_master table
static SQLiteMaster	query(GeoPackageCoreConnection db, SQLiteMasterColumn[] columns, SQLiteMasterType[] types, String tableName)	Query the sqlite_master table
static SQLiteMaster	query(GeoPackageCoreConnection db, SQLiteMasterColumn[] columns, SQLiteMasterType[] types, SQLiteMasterQuery query)	Query the sqlite_master table
static SQLiteMaster	query(GeoPackageCoreConnection db, SQLiteMasterColumn[] columns, SQLiteMasterType type, String tableName)	Query the sqlite_master table
static SQLiteMaster	query(GeoPackageCoreConnection db, SQLiteMasterColumn[] columns, SQLiteMasterType type, SQLiteMasterQuery query)	Query the sqlite_master table
static SQLiteMaster	query(GeoPackageCoreConnection db, SQLiteMasterQuery query)	Query the sqlite_master table
static SQLiteMaster	query(GeoPackageCoreConnection db, SQLiteMasterType type, SQLiteMasterQuery query)	Query the sqlite_master table
static SQLiteMaster	queryByType(GeoPackageCoreConnection db, Collection<SQLiteMasterType> types)	Query the sqlite_master table
static SQLiteMaster	queryByType(GeoPackageCoreConnection db, Collection<SQLiteMasterType> types, String tableName)	Query the sqlite_master table
static SQLiteMaster	queryByType(GeoPackageCoreConnection db, SQLiteMasterType type)	Query the sqlite_master table
static SQLiteMaster	queryByType(GeoPackageCoreConnection db, SQLiteMasterType type, String tableName)	Query the sqlite_master table
static SQLiteMaster	queryForColumns(GeoPackageCoreConnection db, Collection<SQLiteMasterColumn> columns)	Query the sqlite_master table
static SQLiteMaster	queryForColumns(GeoPackageCoreConnection db, Collection<SQLiteMasterColumn> columns, String tableName)	Query the sqlite_master table
static TableConstraints	queryForConstraints(GeoPackageCoreConnection db, String tableName)	Query for the table constraints
static SQLiteMaster	queryViewsOnTable(GeoPackageCoreConnection db, String tableName)	Query the sqlite_master views on the table
static SQLiteMaster	queryViewsOnTable(GeoPackageCoreConnection db, SQLiteMasterColumn[] columns, String tableName)	Query the sqlite_master views on the table
static SQLiteMasterType[]	types(SQLiteMasterType... types)	Shortcut to build types into an array

Methods inherited from class java.lang.Object

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

Field Detail

TABLE_NAME

public static final String TABLE_NAME

Table Name

See Also:

Constant Field Values

Method Detail

count

public int count()

Result count

Returns:

count

columns

public Set<SQLiteMasterColumn> columns()

Get the columns in the result

Returns:

columns

getType

public SQLiteMasterType getType(int row)

Get the type

Parameters:

row - row index

Returns:

type

getTypeString

public String getTypeString(int row)

Get the type string

Parameters:

row - row index

Returns:

type string

getName

public String getName(int row)

Get the name

Parameters:

row - row index

Returns:

name

getTableName

public String getTableName(int row)

Get the table name

Parameters:

row - row index

Returns:

name

getRootpage

public Long getRootpage(int row)

Get the rootpage

Parameters:

row - row index

Returns:

name

getSql

public String getSql(int row)

Get the sql

Parameters:

row - row index

Returns:

name

getValue

public Object getValue(int row,
                       SQLiteMasterColumn column)

Get the value of the column at the row index

Parameters:

row - row index

column - column type

Returns:

value

getRow

public List<Object> getRow(int row)

Get the row at the row index

Parameters:

row - row index

Returns:

row column values

getValue

public Object getValue(List<Object> row,
                       SQLiteMasterColumn column)

Get the value in the row at the column index

Parameters:

row - row

column - column type

Returns:

value

getColumnIndex

public int getColumnIndex(SQLiteMasterColumn column)

Get the column index of the column type

Parameters:

column - column type

Returns:

column index

getConstraints

public TableConstraints getConstraints(int row)

Get the constraints from table SQL

Parameters:

row - row index

Returns:

constraints

columns

public static SQLiteMasterColumn[] columns(SQLiteMasterColumn... columns)

Shortcut to build columns into an array

Parameters:

columns - columns

Returns:

columns

types

public static SQLiteMasterType[] types(SQLiteMasterType... types)

Shortcut to build types into an array

Parameters:

types - types

Returns:

types

count

public static int count(GeoPackageCoreConnection db)

Count the sqlite_master table

Parameters:

db - connection

Returns:

count

query

public static SQLiteMaster query(GeoPackageCoreConnection db)

Query the sqlite_master table

Parameters:

db - connection

Returns:

SQLiteMaster result

count

public static int count(GeoPackageCoreConnection db,
                        String tableName)

Count the sqlite_master table

Parameters:

db - connection

tableName - table name

Returns:

count

query

public static SQLiteMaster query(GeoPackageCoreConnection db,
                                 String tableName)

Query the sqlite_master table

Parameters:

db - connection

tableName - table name

Returns:

SQLiteMaster result

queryForColumns

public static SQLiteMaster queryForColumns(GeoPackageCoreConnection db,
                                           Collection<SQLiteMasterColumn> columns)

Query the sqlite_master table

Parameters:

db - connection

columns - result columns

Returns:

SQLiteMaster result

queryForColumns

public static SQLiteMaster queryForColumns(GeoPackageCoreConnection db,
                                           Collection<SQLiteMasterColumn> columns,
                                           String tableName)

Query the sqlite_master table

Parameters:

db - connection

columns - result columns

tableName - table name

Returns:

SQLiteMaster result

countByType

public static int countByType(GeoPackageCoreConnection db,
                              SQLiteMasterType type)

Count the sqlite_master table

Parameters:

db - connection

type - result type

Returns:

count

queryByType

public static SQLiteMaster queryByType(GeoPackageCoreConnection db,
                                       SQLiteMasterType type)

Query the sqlite_master table

Parameters:

db - connection

type - result type

Returns:

SQLiteMaster result

countByType

public static int countByType(GeoPackageCoreConnection db,
                              Collection<SQLiteMasterType> types)

Count the sqlite_master table

Parameters:

db - connection

types - result types

Returns:

count

queryByType

public static SQLiteMaster queryByType(GeoPackageCoreConnection db,
                                       Collection<SQLiteMasterType> types)

Query the sqlite_master table

Parameters:

db - connection

types - result types

Returns:

SQLiteMaster result

countByType

public static int countByType(GeoPackageCoreConnection db,
                              SQLiteMasterType type,
                              String tableName)

Count the sqlite_master table

Parameters:

db - connection

type - result type

tableName - table name

Returns:

count

queryByType

public static SQLiteMaster queryByType(GeoPackageCoreConnection db,
                                       SQLiteMasterType type,
                                       String tableName)

Query the sqlite_master table

Parameters:

db - connection

type - result type

tableName - table name

Returns:

SQLiteMaster result

countByType

public static int countByType(GeoPackageCoreConnection db,
                              Collection<SQLiteMasterType> types,
                              String tableName)

Count the sqlite_master table

Parameters:

db - connection

types - result types

tableName - table name

Returns:

count

queryByType

public static SQLiteMaster queryByType(GeoPackageCoreConnection db,
                                       Collection<SQLiteMasterType> types,
                                       String tableName)

Query the sqlite_master table

Parameters:

db - connection

types - result types

tableName - table name

Returns:

SQLiteMaster result

count

public static int count(GeoPackageCoreConnection db,
                        Collection<SQLiteMasterType> types)

Count the sqlite_master table

Parameters:

db - connection

types - result types

Returns:

count

query

public static SQLiteMaster query(GeoPackageCoreConnection db,
                                 Collection<SQLiteMasterColumn> columns,
                                 SQLiteMasterType type)

Query the sqlite_master table

Parameters:

db - connection

columns - result columns

type - result type

Returns:

SQLiteMaster result

query

public static SQLiteMaster query(GeoPackageCoreConnection db,
                                 Collection<SQLiteMasterColumn> columns,
                                 Collection<SQLiteMasterType> types)

Query the sqlite_master table

Parameters:

db - connection

columns - result columns

types - result types

Returns:

SQLiteMaster result

query

public static SQLiteMaster query(GeoPackageCoreConnection db,
                                 Collection<SQLiteMasterColumn> columns,
                                 SQLiteMasterType type,
                                 String tableName)

Query the sqlite_master table

Parameters:

db - connection

columns - result columns

type - result type

tableName - table name

Returns:

SQLiteMaster result

count

public static int count(GeoPackageCoreConnection db,
                        Collection<SQLiteMasterType> types,
                        String tableName)

Count the sqlite_master table

Parameters:

db - connection

types - result types

tableName - table name

Returns:

count

query

public static SQLiteMaster query(GeoPackageCoreConnection db,
                                 Collection<SQLiteMasterColumn> columns,
                                 Collection<SQLiteMasterType> types,
                                 String tableName)

Query the sqlite_master table

Parameters:

db - connection

columns - result columns

types - result types

tableName - table name

Returns:

SQLiteMaster result

count

public static int count(GeoPackageCoreConnection db,
                        SQLiteMasterType type)

Count the sqlite_master table

Parameters:

db - connection

type - result type

Returns:

count

query

public static SQLiteMaster query(GeoPackageCoreConnection db,
                                 SQLiteMasterColumn[] columns,
                                 SQLiteMasterType type)

Query the sqlite_master table

Parameters:

db - connection

columns - result columns

type - result type

Returns:

SQLiteMaster result

count

public static int count(GeoPackageCoreConnection db,
                        SQLiteMasterType type,
                        String tableName)

Count the sqlite_master table

Parameters:

db - connection

type - result type

tableName - table name

Returns:

count

query

public static SQLiteMaster query(GeoPackageCoreConnection db,
                                 SQLiteMasterColumn[] columns,
                                 SQLiteMasterType type,
                                 String tableName)

Query the sqlite_master table

Parameters:

db - connection

columns - result columns

type - result type

tableName - table name

Returns:

SQLiteMaster result

count

public static int count(GeoPackageCoreConnection db,
                        SQLiteMasterType[] types)

Count the sqlite_master table

Parameters:

db - connection

types - result types

Returns:

count

query

public static SQLiteMaster query(GeoPackageCoreConnection db,
                                 SQLiteMasterColumn[] columns,
                                 SQLiteMasterType[] types)

Query the sqlite_master table

Parameters:

db - connection

columns - result columns

types - result types

Returns:

SQLiteMaster result

count

public static int count(GeoPackageCoreConnection db,
                        SQLiteMasterType[] types,
                        String tableName)

Count the sqlite_master table

Parameters:

db - connection

types - result types

tableName - table name

Returns:

count

query

public static SQLiteMaster query(GeoPackageCoreConnection db,
                                 SQLiteMasterColumn[] columns,
                                 SQLiteMasterType[] types,
                                 String tableName)

Query the sqlite_master table

Parameters:

db - connection

columns - result columns

types - result types

tableName - table name

Returns:

SQLiteMaster result

query

public static SQLiteMaster query(GeoPackageCoreConnection db,
                                 SQLiteMasterQuery query)

Query the sqlite_master table

Parameters:

db - connection

query - query

Returns:

SQLiteMaster result

count

public static int count(GeoPackageCoreConnection db,
                        SQLiteMasterQuery query)

Count the sqlite_master table

Parameters:

db - connection

query - query

Returns:

count

query

public static SQLiteMaster query(GeoPackageCoreConnection db,
                                 SQLiteMasterColumn[] columns,
                                 SQLiteMasterQuery query)

Query the sqlite_master table

Parameters:

db - connection

columns - result columns

query - query

Returns:

SQLiteMaster result

query

public static SQLiteMaster query(GeoPackageCoreConnection db,
                                 SQLiteMasterType type,
                                 SQLiteMasterQuery query)

Query the sqlite_master table

Parameters:

db - connection

type - result type

query - query

Returns:

SQLiteMaster result

count

public static int count(GeoPackageCoreConnection db,
                        SQLiteMasterType type,
                        SQLiteMasterQuery query)

Count the sqlite_master table

Parameters:

db - connection

type - result type

query - query

Returns:

count

query

public static SQLiteMaster query(GeoPackageCoreConnection db,
                                 SQLiteMasterColumn[] columns,
                                 SQLiteMasterType type,
                                 SQLiteMasterQuery query)

Query the sqlite_master table

Parameters:

db - connection

columns - result columns

type - result type

query - query

Returns:

SQLiteMaster result

count

public static int count(GeoPackageCoreConnection db,
                        SQLiteMasterType[] types,
                        SQLiteMasterQuery query)

Count the sqlite_master table

Parameters:

db - connection

types - result types

query - query

Returns:

count

query

public static SQLiteMaster query(GeoPackageCoreConnection db,
                                 SQLiteMasterColumn[] columns,
                                 SQLiteMasterType[] types,
                                 SQLiteMasterQuery query)

Query the sqlite_master table

Parameters:

db - connection

columns - result columns

types - result types

query - query

Returns:

SQLiteMaster result

queryViewsOnTable

public static SQLiteMaster queryViewsOnTable(GeoPackageCoreConnection db,
                                             String tableName)

Query the sqlite_master views on the table

Parameters:

db - connection

tableName - table name

Returns:

SQLiteMaster result

queryViewsOnTable

public static SQLiteMaster queryViewsOnTable(GeoPackageCoreConnection db,
                                             SQLiteMasterColumn[] columns,
                                             String tableName)

Query the sqlite_master views on the table

Parameters:

db - connection

columns - result columns

tableName - table name

Returns:

SQLiteMaster result

countViewsOnTable

public static int countViewsOnTable(GeoPackageCoreConnection db,
                                    String tableName)

Count the sqlite_master views on the table

Parameters:

db - connection

tableName - table name

Returns:

count

queryForConstraints

public static TableConstraints queryForConstraints(GeoPackageCoreConnection db,
                                                   String tableName)

Query for the table constraints

Parameters:

db - connection

tableName - table name

Returns:

SQL constraints