com.bingzer.android.dbv.content.queries

Class SelectImpl

java.lang.Object

com.bingzer.android.dbv.content.queries.SelectImpl

All Implemented Interfaces:

Selectable.Select, Selectable.Select.OrderBy

public abstract class SelectImpl
extends java.lang.Object
implements Selectable.Select, Selectable.Select.OrderBy

Created by Ricky on 8/20/13.

Nested Class Summary

Nested classes/interfaces inherited from interface com.bingzer.android.dbv.content.contracts.Selectable.Select

Selectable.Select.OrderBy

Constructor Summary

Constructors

Constructor and Description
SelectImpl(IBaseResolver resolver, int top)

Method Summary

Methods

Modifier and Type	Method and Description
SelectImpl	columns(java.lang.String... columns) Specified the column to return.
java.lang.String[]	getProjections() This is columns
java.lang.String	getSelection() This is the where string
java.lang.String[]	getSelectionArgs() Where args
java.lang.String	getSortingOrder() Order by
Selectable.Select.OrderBy	orderBy(java.lang.String... columns) Order by.
Paging	paging(int row)
SelectImpl	where(java.lang.String whereClause, java.lang.Object... args)

Methods inherited from class java.lang.Object

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

Constructor Detail

SelectImpl

public SelectImpl(IBaseResolver resolver,
          int top)

Method Detail

columns

public SelectImpl columns(java.lang.String... columns)

Description copied from interface: Selectable.Select

Specified the column to return. default or null will produce SELECT * FROM

Specified by:

columns in interface Selectable.Select

Parameters:

columns - column names

Returns:

Selectable.Select

orderBy

public Selectable.Select.OrderBy orderBy(java.lang.String... columns)

Description copied from interface: Selectable.Select

Order by. To create multiple orderBy ASC or DESC or both, this is possible

   db.get("Table").select().orderBy("Id", "Name", "Price DESC");
 

Specified by:

orderBy in interface Selectable.Select

Parameters:

columns - column names

Returns:

Selectable.Select

paging

public Paging paging(int row)

where

public SelectImpl where(java.lang.String whereClause,
               java.lang.Object... args)

getProjections

public java.lang.String[] getProjections()

This is columns

Returns:

array of columns names

getSelection

public java.lang.String getSelection()

This is the where string

Returns:

where clause

getSelectionArgs

public java.lang.String[] getSelectionArgs()

Where args

Returns:

selection args

getSortingOrder

public java.lang.String getSortingOrder()

Order by

Returns:

sorting order as string