ZIMSqlDeleteStatement Class Reference

#import <ZIMSqlDeleteStatement.h>

Inheritance diagram for ZIMSqlDeleteStatement:

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:

limit

The 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:

limit	The number of records to be returned.
offset	The 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:

offset

The 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:

column

The 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:

column	The column to be ordered.
descending	This 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:

column	The column to be ordered.
descending	This will determine whether the column should be ordered in descending order.
weight	This 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:

column	The column to be ordered.
weight	This 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:

table

The 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:

column1	The column to be tested.
operator	The operator to be used.
column2	The 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:

column1	The column to be tested.
operator	The operator to be used.
column2	The column to be compared.
connector	The 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:

column	The column to be tested.
operator	The operator to be used.
value	The 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:

column	The column to be tested.
operator	The operator to be used.
value	The value to be compared.
connector	The connector to be used.

Updated:

2012-03-23

- (void) whereBlock:

(NSString *)

brace

Signature:

whereBlock:

Discussion:

This method will start or end a block.

Parameters:

brace

The 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:

brace	The brace to be used; it is either an opening or closing brace.
connector	The 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:

• ZIMSqlDeleteStatement.h
• ZIMSqlDeleteStatement.m