Package mil.nga.geopackage.user

Class UserQuery

java.lang.Object

mil.nga.geopackage.user.UserQuery

public class UserQuery
extends Object

User Query parameter types

Since:

2.0.0

Constructor Summary

Constructors

Constructor	Description
UserQuery()	Constructor
UserQuery(Boolean distinct, String table, String[] columns, String[] columnsAs, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)	Constructor
UserQuery(Boolean distinct, String table, String[] columns, String[] columnsAs, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)	Constructor
UserQuery(Boolean distinct, String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)	Constructor
UserQuery(Boolean distinct, String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)	Constructor
UserQuery(String sql, String[] selectionArgs)	Constructor for raw query
UserQuery(String sql, String[] columns, String[] selectionArgs)	Constructor for raw query
UserQuery(String table, String[] columns, String[] columnsAs, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)	Constructor
UserQuery(String table, String[] columns, String[] columnsAs, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)	Constructor
UserQuery(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)	Constructor
UserQuery(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)	Constructor

Method Summary

Modifier and Type	Method	Description
Object	get(UserQueryParamType type)	Get the param value
String[]	getColumns()	Get the column names
String[]	getColumnsAs()	Get the columns as values
boolean	getDistinct()	Get the distinct flag
String	getGroupBy()	Get the group by value
String	getHaving()	Get the having value
String	getLimit()	Get the limit value
String	getOrBuildSql()	Get or build the SQL statement
String	getOrderBy()	Get the order by value
String	getSelection()	Get the selection value
String[]	getSelectionArgs()	Get the selection args
String	getSql()	Get the raw SQL value
String	getTable()	Get the table name
boolean	has(UserQueryParamType type)	Check if there is a param value
void	set(UserQueryParamType type, Object value)	Set the value for the param type

Methods inherited from class java.lang.Object

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

Constructor Details

UserQuery

public UserQuery()

Constructor

UserQuery

public UserQuery(String sql,
 String[] selectionArgs)

Constructor for raw query

Parameters:

sql - sql statement

selectionArgs - selection arguments

UserQuery

public UserQuery(String sql,
 String[] columns,
 String[] selectionArgs)

Constructor for raw query

Parameters:

sql - sql statement

columns - columns

selectionArgs - selection arguments

Since:

6.2.0

UserQuery

public UserQuery(String table,
 String[] columns,
 String selection,
 String[] selectionArgs,
 String groupBy,
 String having,
 String orderBy)

Constructor

Parameters:

table - table name

columns - column names

selection - selection

selectionArgs - selection args

groupBy - group by

having - having

orderBy - order by

UserQuery

public UserQuery(Boolean distinct,
 String table,
 String[] columns,
 String selection,
 String[] selectionArgs,
 String groupBy,
 String having,
 String orderBy)

Constructor

Parameters:

distinct - distinct flag

table - table name

columns - column names

selection - selection

selectionArgs - selection args

groupBy - group by

having - having

orderBy - order by

Since:

4.0.0

UserQuery

public UserQuery(String table,
 String[] columns,
 String[] columnsAs,
 String selection,
 String[] selectionArgs,
 String groupBy,
 String having,
 String orderBy)

Constructor

Parameters:

table - table name

columns - column names

columnsAs - columns as values

selection - selection

selectionArgs - selection args

groupBy - group by

having - having

orderBy - order by

UserQuery

public UserQuery(Boolean distinct,
 String table,
 String[] columns,
 String[] columnsAs,
 String selection,
 String[] selectionArgs,
 String groupBy,
 String having,
 String orderBy)

Constructor

Parameters:

distinct - distinct flag

table - table name

columns - column names

columnsAs - columns as values

selection - selection

selectionArgs - selection args

groupBy - group by

having - having

orderBy - order by

Since:

4.0.0

UserQuery

public UserQuery(String table,
 String[] columns,
 String selection,
 String[] selectionArgs,
 String groupBy,
 String having,
 String orderBy,
 String limit)

Constructor

Parameters:

table - table name

columns - column names

selection - selection

selectionArgs - selection args

groupBy - group by

having - having

orderBy - order by

limit - limit

UserQuery

public UserQuery(Boolean distinct,
 String table,
 String[] columns,
 String selection,
 String[] selectionArgs,
 String groupBy,
 String having,
 String orderBy,
 String limit)

Constructor

Parameters:

distinct - distinct flag

table - table name

columns - column names

selection - selection

selectionArgs - selection args

groupBy - group by

having - having

orderBy - order by

limit - limit

Since:

4.0.0

UserQuery

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

Constructor

Parameters:

table - table name

columns - column names

columnsAs - columns as values

selection - selection

selectionArgs - selection args

groupBy - group by

having - having

orderBy - order by

limit - limit

UserQuery

public UserQuery(Boolean distinct,
 String table,
 String[] columns,
 String[] columnsAs,
 String selection,
 String[] selectionArgs,
 String groupBy,
 String having,
 String orderBy,
 String limit)

Constructor

Parameters:

distinct - distinct flag

table - table name

columns - column names

columnsAs - columns as values

selection - selection

selectionArgs - selection args

groupBy - group by

having - having

orderBy - order by

limit - limit

Since:

4.0.0

Method Details

set

public void set(UserQueryParamType type,
 Object value)

Set the value for the param type

Parameters:

type - param type

value - param value

get

public Object get(UserQueryParamType type)

Get the param value

Parameters:

type - param type

Returns:

param value

has

public boolean has(UserQueryParamType type)

Check if there is a param value

Parameters:

type - param type

Returns:

true if param value exists

getSql

public String getSql()

Get the raw SQL value

Returns:

SQL value

getSelectionArgs

public String[] getSelectionArgs()

Get the selection args

Returns:

selection args

getDistinct

public boolean getDistinct()

Get the distinct flag

Returns:

distinct flag

Since:

4.0.0

getTable

public String getTable()

Get the table name

Returns:

table name

getColumns

public String[] getColumns()

Get the column names

Returns:

column names

getColumnsAs

public String[] getColumnsAs()

Get the columns as values

Returns:

columns as values

getSelection

public String getSelection()

Get the selection value

Returns:

selection value

getGroupBy

public String getGroupBy()

Get the group by value

Returns:

group by value

getHaving

public String getHaving()

Get the having value

Returns:

having value

getOrderBy

public String getOrderBy()

Get the order by value

Returns:

order by value

getLimit

public String getLimit()

Get the limit value

Returns:

limit value

getOrBuildSql

public String getOrBuildSql()

Get or build the SQL statement

Returns:

SQL statement

Since:

6.2.0