net.akaish.kitty.orm.query

Class KittyQueryBuilder

java.lang.Object

net.akaish.kitty.orm.query.KittyQueryBuilder

public class KittyQueryBuilder
extends java.lang.Object

Simple builder to build wrappers for common queries used in KittyORM. Created by akaish on 06.02.18.

Author:

akaish (Denis Bogomolov)

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	KittyQueryBuilder.QUERY_TYPE

Field Summary

Fields

Modifier and Type	Field and Description
static int	SB_SQL_SIZE

Constructor Summary

Constructors

Constructor and Description
KittyQueryBuilder(KittyQueryBuilder.QUERY_TYPE queryType, java.lang.String tableName)
KittyQueryBuilder(KittyQueryBuilder.QUERY_TYPE queryType, java.lang.String tableName, int sbSize)

Method Summary

Modifier and Type	Method and Description
KittySQLiteQuery	buildSQLQuery()
KittyQueryBuilder	setGroupBy(java.lang.String... columns)
KittyQueryBuilder	setLimit(java.lang.Long limit)
KittyQueryBuilder	setOffset(java.lang.Long offset)
KittyQueryBuilder	setOrderBy(AscDesc ascDesc, java.lang.String... columns)
KittyQueryBuilder	setOrderBy(java.lang.String column, AscDesc asc_desc)
KittyQueryBuilder	setQueryParameters(QueryParameters queryParameters)
KittyQueryBuilder	setRowIDSupport(boolean rowIdOn)
KittyQueryBuilder	setSchemaName(java.lang.String schemaName) Sets schema name for SelectTableNamesQuery : KittyQueryBuilder.QUERY_TYPE.SELECT_TABLE_NAMES (only).
KittyQueryBuilder	setSumColumn(java.lang.String sumColumn) Sets sum column name for SelectCountQuery : KittyQueryBuilder.QUERY_TYPE.SELECT_SUM (only).
KittyQueryBuilder	setWhereClause(SQLiteCondition condition)

Methods inherited from class java.lang.Object

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

Field Detail

SB_SQL_SIZE

public static final int SB_SQL_SIZE

See Also:

Constant Field Values

Constructor Detail

KittyQueryBuilder

public KittyQueryBuilder(KittyQueryBuilder.QUERY_TYPE queryType,
                         java.lang.String tableName)

KittyQueryBuilder

public KittyQueryBuilder(KittyQueryBuilder.QUERY_TYPE queryType,
                         java.lang.String tableName,
                         int sbSize)

Method Detail

setSumColumn

public KittyQueryBuilder setSumColumn(java.lang.String sumColumn)

Sets sum column name for SelectCountQuery : KittyQueryBuilder.QUERY_TYPE.SELECT_SUM (only). Values set via this method in other queries would be ignored.

Parameters:

sumColumn - column on which sum operation should be performed.

Returns:

setSchemaName

public KittyQueryBuilder setSchemaName(java.lang.String schemaName)

Sets schema name for SelectTableNamesQuery : KittyQueryBuilder.QUERY_TYPE.SELECT_TABLE_NAMES (only). Values set via this method in other queries would be ignored.

Parameters:

schemaName - schema name from what should table names to be retrieved.

Returns:

setOrderBy

public KittyQueryBuilder setOrderBy(java.lang.String column,
                                    AscDesc asc_desc)

setOrderBy

public KittyQueryBuilder setOrderBy(AscDesc ascDesc,
                                    java.lang.String... columns)

setQueryParameters

public KittyQueryBuilder setQueryParameters(QueryParameters queryParameters)

setRowIDSupport

public KittyQueryBuilder setRowIDSupport(boolean rowIdOn)

setGroupBy

public KittyQueryBuilder setGroupBy(java.lang.String... columns)

setLimit

public KittyQueryBuilder setLimit(java.lang.Long limit)

setOffset

public KittyQueryBuilder setOffset(java.lang.Long offset)

setWhereClause

public KittyQueryBuilder setWhereClause(SQLiteCondition condition)

buildSQLQuery

public KittySQLiteQuery buildSQLQuery()