Package mil.nga.geopackage.db.master

Class SQLiteMasterQuery

java.lang.Object

mil.nga.geopackage.db.master.SQLiteMasterQuery

public class SQLiteMasterQuery
extends Object

Query on the SQLiteMaster table

Since:

3.3.0

Author:

osbornb

Method Summary

Modifier and Type	Method	Description
void	add(SQLiteMasterColumn column, String value)	Add an equality query
void	add(SQLiteMasterColumn column, String operation, String value)	Add a query
void	addIsNotNull(SQLiteMasterColumn column)	Add an is not null query
void	addIsNull(SQLiteMasterColumn column)	Add an is null query
String	buildSQL()	Build the query SQL
static SQLiteMasterQuery	create()	Create an empty query that supports a single query
static SQLiteMasterQuery	create(SQLiteMasterColumn column, String value)	Create a single equality query
static SQLiteMasterQuery	create(SQLiteMasterColumn column, String operation, String value)	Create a single query
static SQLiteMasterQuery	createAnd()	Create a query with multiple queries combined by an AND
static SQLiteMasterQuery	createAnd(SQLiteMasterColumn column, String operation, Collection<String> values)	Create a query with multiple values for a single column combined with an AND
static SQLiteMasterQuery	createAnd(SQLiteMasterColumn column, Collection<String> values)	Create an equality query with multiple values for a single column combined with an AND
static SQLiteMasterQuery	createOr()	Create a query with multiple queries combined by an OR
static SQLiteMasterQuery	createOr(SQLiteMasterColumn column, String operation, Collection<String> values)	Create a query with multiple values for a single column combined with an OR
static SQLiteMasterQuery	createOr(SQLiteMasterColumn column, Collection<String> values)	Create an equality query with multiple values for a single column combined with an OR
static SQLiteMasterQuery	createTableViewQuery(String tableName)	Create a query to find views in the sql column referring to the table
List<String>	getArguments()	Get the query arguments
boolean	has()	Determine a query has been set

Methods inherited from class java.lang.Object

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

Method Detail

add

public void add(SQLiteMasterColumn column,
                String value)

Add an equality query

Parameters:

column - column

value - value

add

public void add(SQLiteMasterColumn column,
                String operation,
                String value)

Add a query

Parameters:

column - column

operation - operation

value - value

addIsNull

public void addIsNull(SQLiteMasterColumn column)

Add an is null query

Parameters:

column - column

addIsNotNull

public void addIsNotNull(SQLiteMasterColumn column)

Add an is not null query

Parameters:

column - column

has

public boolean has()

Determine a query has been set

Returns:

true if has a query

buildSQL

public String buildSQL()

Build the query SQL

Returns:

sql

getArguments

public List<String> getArguments()

Get the query arguments

Returns:

arguments

create

public static SQLiteMasterQuery create()

Create an empty query that supports a single query

Returns:

query

createOr

public static SQLiteMasterQuery createOr()

Create a query with multiple queries combined by an OR

Returns:

query

createAnd

public static SQLiteMasterQuery createAnd()

Create a query with multiple queries combined by an AND

Returns:

query

create

public static SQLiteMasterQuery create(SQLiteMasterColumn column,
                                       String value)

Create a single equality query

Parameters:

column - column

value - value

Returns:

query

create

public static SQLiteMasterQuery create(SQLiteMasterColumn column,
                                       String operation,
                                       String value)

Create a single query

Parameters:

column - column

operation - operation

value - value

Returns:

query

createOr

public static SQLiteMasterQuery createOr(SQLiteMasterColumn column,
                                         Collection<String> values)

Create an equality query with multiple values for a single column combined with an OR

Parameters:

column - column

values - value

Returns:

query

createOr

public static SQLiteMasterQuery createOr(SQLiteMasterColumn column,
                                         String operation,
                                         Collection<String> values)

Create a query with multiple values for a single column combined with an OR

Parameters:

column - column

operation - operation

values - value

Returns:

query

createAnd

public static SQLiteMasterQuery createAnd(SQLiteMasterColumn column,
                                          Collection<String> values)

Create an equality query with multiple values for a single column combined with an AND

Parameters:

column - column

values - value

Returns:

query

createAnd

public static SQLiteMasterQuery createAnd(SQLiteMasterColumn column,
                                          String operation,
                                          Collection<String> values)

Create a query with multiple values for a single column combined with an AND

Parameters:

column - column

operation - operation

values - value

Returns:

query

createTableViewQuery

public static SQLiteMasterQuery createTableViewQuery(String tableName)

Create a query to find views in the sql column referring to the table

Parameters:

tableName - table name

Returns:

query