Package io.clonecloudstore.common.database.utils

Class DbQuery

java.lang.Object

io.clonecloudstore.common.database.utils.RestQuery

io.clonecloudstore.common.database.utils.DbQuery

public class DbQuery
extends RestQuery

DbQuery (Where Condition) for both SQL and NoSQL. A DbQuery is not ready to use as is. It must be used through PostgreSqlHelper or MongoSqlHelper or natively using Repository.

Nested Class Summary

Nested classes/interfaces inherited from class io.clonecloudstore.common.database.utils.RestQuery

RestQuery.CONJUNCTION, RestQuery.QUERY

Constructor Summary

Constructors

Constructor	Description
DbQuery()	Empty query
DbQuery(RestQuery.CONJUNCTION conjunction, DbQuery... queries)	Query conjunction using parameters
DbQuery(RestQuery.CONJUNCTION conjunction, Collection<DbQuery> queries)	Query conjunction using parameters
DbQuery(RestQuery.QUERY query, String field, Object value)	Query using parameters
DbQuery(RestQuery.QUERY query, String field, Object... values)	Query using parameters
DbQuery(RestQuery.QUERY query, String field, String value)	Query using parameters
DbQuery(RestQuery.QUERY query, String field, Collection<?> values)	Query using parameters

Method Summary

Modifier and Type	Method	Description
static DbQuery	fromRestQuery(RestQuery restQuery)	Build a DbQuery from RestQuery
org.bson.conversions.Bson	getBson()
protected String	getMgPostMetadataField()
protected String	getMgPreMetadataField()
StringBuilder	getMgQueryString()
protected String	getPostMetadataField()
protected String	getPreMetadataField()
List<Object>	getSqlParams()
Object[]	getSqlParamsAsArray()
StringBuilder	getSqlQueryString()
static DbQuery	idEquals(String id)	Helper to request on ID
void	replaceSqlParam(Object args)	Replace all parameters with one parameter.
void	replaceSqlParams(List<Object> args)	Replace all parameters with this list.

Methods inherited from class io.clonecloudstore.common.database.utils.RestQuery

getAvalues, getConjunction, getFieldName, getOvalue, getQUERY, getRestQueries, getSvalue, getValueCollection, isEmpty

Methods inherited from class java.lang.Object

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

Constructor Details

DbQuery

public DbQuery()

Empty query

DbQuery

public DbQuery(RestQuery.QUERY query,
 String field,
 Object... values)

Query using parameters

DbQuery

public DbQuery(RestQuery.QUERY query,
 String field,
 Collection<?> values)

Query using parameters

DbQuery

public DbQuery(RestQuery.QUERY query,
 String field,
 String value)

Query using parameters

DbQuery

public DbQuery(RestQuery.QUERY query,
 String field,
 Object value)

Query using parameters

DbQuery

public DbQuery(RestQuery.CONJUNCTION conjunction,
 DbQuery... queries)

Query conjunction using parameters

DbQuery

public DbQuery(RestQuery.CONJUNCTION conjunction,
 Collection<DbQuery> queries)

Query conjunction using parameters

Method Details

getPreMetadataField

protected String getPreMetadataField()

getPostMetadataField

protected String getPostMetadataField()

getMgPreMetadataField

protected String getMgPreMetadataField()

getMgPostMetadataField

protected String getMgPostMetadataField()

idEquals

public static DbQuery idEquals(String id)

Helper to request on ID

Parameters:

id - the ID unique value

Returns:

the DbQuery

fromRestQuery

public static DbQuery fromRestQuery(RestQuery restQuery)

Build a DbQuery from RestQuery

Parameters:

restQuery - the RestQuery to transform

Returns:

the new DbQuery

replaceSqlParams

public void replaceSqlParams(List<Object> args)

Replace all parameters with this list. Note that it works only for SQL query, not NoSQL one.

replaceSqlParam

public void replaceSqlParam(Object args)

Replace all parameters with one parameter. Note that it works only for SQL query, not NoSQL one.

getSqlParams

public List<Object> getSqlParams()

Returns:

the parameters as a List (for SQL)

getSqlParamsAsArray

public Object[] getSqlParamsAsArray()

Returns:

the parameters as Array (for SQL)

getSqlQueryString

public StringBuilder getSqlQueryString()

Returns:

the query as StringBuilder (for SQL)

getMgQueryString

public StringBuilder getMgQueryString()

Returns:

the query as StringBuilder (for NoSQL)

getBson

public org.bson.conversions.Bson getBson()

Returns:

the query as Bson (for NoSQL)