DBSelectQuery Class Reference

#import <DBSelectQuery.h>

Inheritance diagram for DBSelectQuery:

Collaboration diagram for DBSelectQuery:

Instance Methods
(instancetype)	- order:by:
(instancetype)	- orderBy:
(instancetype)	- groupBy:
(instancetype)	- limit:
(instancetype)	- offset:
(instancetype)	- distinct:
(instancetype)	- join:
(instancetype)	- innerJoin:on:
(instancetype)	- leftJoin:on:
(instancetype)	- union:
(instancetype)	- union:type:
(id)	- objectAtIndexedSubscript:
(NSUInteger)	- count
(id)	- firstObject
Instance Methods inherited from DBReadQuery
(NSArray *)	- execute
(NSArray *)	- execute:
(NSArray *)	- executeOnConnection:error:
Instance Methods inherited from DBQuery
(BOOL)	- canCombineWithQuery:
(instancetype)	- combineWith:
(NSString *)	- stringRepresentation
(DBDeleteQuery *)	- delete
(DBInsertQuery *)	- insert:
(DBInsertQuery *)	- insertUsingSelect:
(DBInsertQuery *)	- insertUsingSelect:intoColumns:
(DBSelectQuery *)	- select:
(DBSelectQuery *)	- select
(DBUpdateQuery *)	- update:
Instance Methods inherited from <DBFilterableQuery>
(instancetype)	- where:
(instancetype)	- where:arguments:
(instancetype)	- narrow:
(instancetype)	- withPredicate:

Class Methods
(instancetype)	+ fromSubquery:
Class Methods inherited from <DBTableQuery>
(instancetype)	+ withTable:

Properties
DBSelectQuery *	subQuery
NSArray *	orderedBy
NSArray *	groupedBy
DBOrder	order
NSUInteger	limit
NSUInteger	offset
DBJoin *	join
DBSelectQuery *	unionQuery
NSString *	unionType
BOOL	distinct
Properties inherited from <DBTableQuery>
DBTable *	table
Properties inherited from <DBFilterableQuery>
NSPredicate *	where

Detailed Description

Definition at line 11 of file DBSelectQuery.h.

Method Documentation

- (NSUInteger) count

Definition at line 176 of file DBSelectQuery.m.

References DBReadQuery::execute:, DBAs::field:alias:, and DBQuery::select:.

- (instancetype) distinct:

(BOOL)

distinct

Definition at line 217 of file DBSelectQuery.m.

References distinct.

- (id) firstObject

Definition at line 144 of file DBSelectQuery.m.

+ (instancetype) fromSubquery:

(DBSelectQuery *)

aSubQuery

Definition at line 38 of file DBSelectQuery.m.

References <DBTableQuery>::table.

- (instancetype) groupBy:

(NSArray *)

columns

Definition at line 196 of file DBSelectQuery.m.

References DBQuery::columns, and groupedBy.

- (instancetype) innerJoin:		(id)	table
on:		(NSString *)	format
,			...

Definition at line 230 of file DBSelectQuery.m.

References join:, and DBJoin::withType:table:predicate:.

- (instancetype) join:

(DBJoin *)

join

Definition at line 224 of file DBSelectQuery.m.

References join.

Referenced by innerJoin:on:, and leftJoin:on:.

- (instancetype) leftJoin:		(id)	table
on:		(NSString *)	format
,			...

Definition at line 238 of file DBSelectQuery.m.

References join:, and DBJoin::withType:table:predicate:.

- (instancetype) limit:

(NSUInteger)

limit

Definition at line 203 of file DBSelectQuery.m.

References limit.

- (id) objectAtIndexedSubscript:

(NSUInteger)

idx

Definition at line 139 of file DBSelectQuery.m.

References offset:.

- (instancetype) offset:

(NSUInteger)

offset

Definition at line 210 of file DBSelectQuery.m.

References offset.

Referenced by objectAtIndexedSubscript:.

- (instancetype) order:		(DBOrder)	order
by:		(NSArray *)	columns

Definition at line 184 of file DBSelectQuery.m.

References DBQuery::columns, order, and orderedBy.

- (instancetype) orderBy:

(NSArray *)

columns

Referenced by union:type:.

- (instancetype) union:

(DBSelectQuery *)

otherQuery

Definition at line 247 of file DBSelectQuery.m.

References union:type:.

- (instancetype) union:		(DBSelectQuery *)	otherQuery
type:		(NSString *)	type

Definition at line 252 of file DBSelectQuery.m.

References order, orderBy:, orderedBy, unionQuery, and unionType.

Referenced by union:.

Property Documentation

- (BOOL) distinct

readatomicassign

Definition at line 20 of file DBSelectQuery.h.

Referenced by distinct:.

- (NSArray*) groupedBy

readatomicstrong

Definition at line 14 of file DBSelectQuery.h.

Referenced by groupBy:.

- (DBJoin*) join

readatomicstrong

Definition at line 17 of file DBSelectQuery.h.

Referenced by join:.

- (NSUInteger) limit

readatomicassign

Definition at line 16 of file DBSelectQuery.h.

Referenced by limit:.

- (NSUInteger) offset

readatomicassignprotected

Definition at line 16 of file DBSelectQuery.h.

Referenced by offset:.

- (DBOrder) order

readatomicassign

Definition at line 15 of file DBSelectQuery.h.

Referenced by order:by:, and union:type:.

- (NSArray*) orderedBy

readatomicstrong

Definition at line 13 of file DBSelectQuery.h.

Referenced by order:by:, and union:type:.

- (DBSelectQuery*) subQuery

readatomicstrong

Definition at line 12 of file DBSelectQuery.h.

- (DBSelectQuery*) unionQuery

readatomicstrong

Definition at line 18 of file DBSelectQuery.h.

Referenced by union:type:.

- (NSString*) unionType

readatomicstrong

Definition at line 19 of file DBSelectQuery.h.

Referenced by union:type:.

---

The documentation for this class was generated from the following files:

• Source/Queries/DBSelectQuery.h
• Source/Queries/DBSelectQuery.m