objective-c-sql-query-builder
Public Member Functions | Protected Attributes
ZIMSqlDeleteStatement Class Reference

#import <ZIMSqlDeleteStatement.h>

Inheritance diagram for ZIMSqlDeleteStatement:
<ZIMSqlStatement> <ZIMSqlDataManipulationCommand>

List of all members.

Public Member Functions

(void) - table:
(void) - whereBlock:
(void) - whereBlock:connector:
(void) - where:operator:column:
(void) - where:operator:column:connector:
(void) - where:operator:value:
(void) - where:operator:value:connector:
(void) - orderBy:
(void) - orderBy:descending:
(void) - orderBy:nulls:
(void) - orderBy:descending:nulls:
(void) - limit:
(void) - limit:offset:
(void) - offset:
(NSString *) - statement
(id) - init [implementation]

Protected Attributes

NSString_table
NSMutableArray * _where
NSMutableArray * _orderBy
NSUInteger _limit
NSUInteger _offset

Detailed Description

Discussion:
This class represents an SQL delete statement.
Updated:
2012-03-18
See also:
http://www.sqlite.org/lang_delete.html

Member Function Documentation

- (instancetype) init [implementation]
- (void) limit: (NSUInteger)  limit
Signature:
limit:
Discussion:
This method will add a limit clause to the SQL statement.
Parameters:
limitThe number of records to be returned.
Updated:
2012-03-18
- (void) limit: (NSUInteger)  limit
offset: (NSUInteger)  offset 
Signature:
limit:offset:
Discussion:
This method will add a limit clause and an offset clause to the SQL statement.
Parameters:
limitThe number of records to be returned.
offsetThe starting point to start evaluating.
Updated:
2012-03-18
- (void) offset: (NSUInteger)  offset
Signature:
offset:
Discussion:
This method will add an offset clause to the SQL statement.
Parameters:
offsetThe starting point to start evaluating.
Updated:
2012-03-18
- (void) orderBy: (NSString *)  column
Signature:
orderBy:
Discussion:
This method will add an order by clause to the SQL statement.
Parameters:
columnThe column to be ordered.
Updated:
2012-03-19
- (void) orderBy: (NSString *)  column
descending: (BOOL)  descending 
Signature:
orderBy:descending:
Discussion:
This method will add an order by clause to the SQL statement.
Parameters:
columnThe column to be ordered.
descendingThis will determine whether the column should be ordered in descending order.
Updated:
2012-03-19
- (void) orderBy: (NSString *)  column
descending: (BOOL)  descending
nulls: (NSString *)  weight 
Signature:
orderBy:descending:nulls:
Discussion:
This method will add an order by clause to the SQL statement.
Parameters:
columnThe column to be ordered.
descendingThis will determine whether the column should be ordered in descending order.
weightThis indicates how nulls are to be weighed when comparing with non-nulls.
Updated:
2012-03-19
See also:
http://sqlite.org/cvstrac/wiki?p=UnsupportedSql
https://hibernate.onjira.com/browse/HHH-465
http://sqlblog.com/blogs/denis_gobo/archive/2007/10/19/3048.aspx
- (void) orderBy: (NSString *)  column
nulls: (NSString *)  weight 
Signature:
orderBy:nulls:
Discussion:
This method will add an order by clause to the SQL statement.
Parameters:
columnThe column to be ordered.
weightThis indicates how nulls are to be weighed when comparing with non-nulls.
Updated:
2012-03-19
See also:
http://sqlite.org/cvstrac/wiki?p=UnsupportedSql
https://hibernate.onjira.com/browse/HHH-465
http://sqlblog.com/blogs/denis_gobo/archive/2007/10/19/3048.aspx
- (NSString *) statement
Signature:
statement
Discussion:
This method will return the SQL statement.
Returns:
The SQL statement that was constructed.
Updated:
2012-03-18

Reimplemented from <ZIMSqlStatement>.

- (void) table: (NSString *)  table
Signature:
table:
Discussion:
This method will set the table used in the SQL statement.
Parameters:
tableThe table that will be used in the SQL statement.
Updated:
2011-10-30
- (void) where: (id)  column1
operator: (NSString *)  operator
column: (id)  column2 
Signature:
where:operator:column:
Discussion:
This method will add a where clause to the SQL statement.
Parameters:
column1The column to be tested.
operatorThe operator to be used.
column2The column to be compared.
Updated:
2012-03-23
- (void) where: (id)  column1
operator: (NSString *)  operator
column: (id)  column2
connector: (NSString *)  connector 
Signature:
where:operator:column:connector:
Discussion:
This method will add a where clause to the SQL statement.
Parameters:
column1The column to be tested.
operatorThe operator to be used.
column2The column to be compared.
connectorThe connector to be used.
Updated:
2012-03-23
- (void) where: (id)  column
operator: (NSString *)  operator
value: (id)  value 
Signature:
where:operator:value:
Discussion:
This method will add a where clause to the SQL statement.
Parameters:
columnThe column to be tested.
operatorThe operator to be used.
valueThe value to be compared.
Updated:
2012-03-23
- (void) where: (id)  column
operator: (NSString *)  operator
value: (id)  value
connector: (NSString *)  connector 
Signature:
where:operator:value:connector:
Discussion:
This method will add a where clause to the SQL statement.
Parameters:
columnThe column to be tested.
operatorThe operator to be used.
valueThe value to be compared.
connectorThe connector to be used.
Updated:
2012-03-23
- (void) whereBlock: (NSString *)  brace
Signature:
whereBlock:
Discussion:
This method will start or end a block.
Parameters:
braceThe brace to be used; it is either an opening or closing brace.
Updated:
2011-03-13
- (void) whereBlock: (NSString *)  brace
connector: (NSString *)  connector 
Signature:
whereBlock:connector:
Discussion:
This method will start or end a block.
Parameters:
braceThe brace to be used; it is either an opening or closing brace.
connectorThe connector to be used.
Updated:
2011-04-01

Member Data Documentation

- (NSUInteger) _limit [protected]
- (NSUInteger) _offset [protected]
- (NSMutableArray*) _orderBy [protected]
- (NSString*) _table [protected]
- (NSMutableArray*) _where [protected]

The documentation for this class was generated from the following files:
 All Classes Files Functions Variables Properties Defines