net.akaish.kitty.orm.query

Class QueryParameters

java.lang.Object

net.akaish.kitty.orm.query.QueryParameters

public class QueryParameters
extends java.lang.Object

Simple class for setting and storing query parameters such as LIMIT, OFFSET, ORDER_BY and GROUP_BY. Also, don't forget that using LIMIT keyword (and setLimit()) without GROUP_BY would cause limiting not by id\rowid but by, probably order how rows are physically stored in file. SQLite, I love you. Created by akaish on 07.04.18.

Author:

akaish (Denis Bogomolov)

Constructor Summary

Constructors

Constructor and Description
QueryParameters()

Method Summary

Modifier and Type	Method and Description
java.lang.String[]	getGroupByColumns()
java.lang.Long	getLimit()
java.lang.Long	getOffset()
AscDesc	getOrderAscDesc() Returns order ASCENDING or DESCENDING, see (AscDesc.ASCENDING).
java.lang.String[]	getOrderByColumns()
QueryParameters	setGroupByColumns(java.lang.String... groupByColumns)
QueryParameters	setLimit(java.lang.Long limit) Sets LIMIT keyword for query.
QueryParameters	setOffset(java.lang.Long offset)
QueryParameters	setOrderAscDesc(AscDesc orderAscDesc)
QueryParameters	setOrderByColumns(java.lang.String... orderByColumns)

Methods inherited from class java.lang.Object

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

Constructor Detail

QueryParameters

public QueryParameters()

Method Detail

getLimit

public java.lang.Long getLimit()

setLimit

public QueryParameters setLimit(java.lang.Long limit)

Sets LIMIT keyword for query. Don't forget that using LIMIT keyword (and setLimit()) without GROUP_BY would cause limiting not by id\rowid but by, probably order how rows are physically stored in file.
Also used PostgreSQL styled syntax, like LIMIT 10, OFFSET 20, liming on syntax style LIMIT 20, 10 not supported by this library.

Parameters:

limit - limit of rows for query to process

Returns:

this

getOffset

public java.lang.Long getOffset()

setOffset

public QueryParameters setOffset(java.lang.Long offset)

getGroupByColumns

public java.lang.String[] getGroupByColumns()

setGroupByColumns

public QueryParameters setGroupByColumns(java.lang.String... groupByColumns)

getOrderByColumns

public java.lang.String[] getOrderByColumns()

setOrderByColumns

public QueryParameters setOrderByColumns(java.lang.String... orderByColumns)

getOrderAscDesc

public AscDesc getOrderAscDesc()

Returns order ASCENDING or DESCENDING, see (AscDesc.ASCENDING). By default order is ASCENDING.

Returns:

setOrderAscDesc

public QueryParameters setOrderAscDesc(AscDesc orderAscDesc)