ZIMSqlExpression Class Reference

#import <ZIMSqlExpression.h>

List of all members.

Public Member Functions
(id)	- initWithSqlExpression:
(NSString *)	- expression
Static Public Member Functions
(ZIMSqlExpression *)	+ sql:
(NSString *)	+ prepareAlias:
(NSString *)	+ prepareConnector:
(NSString *)	+ prepareEnclosure:
(NSString *)	+ prepareIdentifier:
(NSString *)	+ prepareJoinType:
(NSString *)	+ prepareOperator:ofType:
(NSString *)	+ prepareSortOrder:
(NSString *)	+ prepareSortWeight:
(NSString *)	+ prepareValue:
Protected Attributes
NSString *	_expression

---

Detailed Description

Discussion:

This class handles the formatting of a SQL expression.

Updated:

2012-03-14

---

Member Function Documentation

- (NSString *) expression

Signature:

expression

Discussion:

This method returns the wrapped SQL expression.

Returns:

The wrapped SQL expression.

Updated:

2012-03-14

- (instancetype) initWithSqlExpression:

(NSString *)

sql

Signature:

initWithSqlExpression:

Discussion:

This method initialize the class with the specified SQL expression.

Parameters:

sql	The SQL expression to be wrapped.

Returns:

An instance of this class.

Updated:

2012-03-14

+ (NSString *) prepareAlias:

(NSString *)

token

Signature:

prepareConnector:

Discussion:

This method will prepare an alias for an SQL statement.

Parameters:

token

The token to be prepared.

Returns:

The prepared token.

Updated:

2012-03-24

+ (NSString *) prepareConnector:

(NSString *)

token

Signature:

prepareConnector:

Discussion:

This method will prepare a connector for an SQL statement.

Parameters:

token

The token to be prepared.

Returns:

The prepared token.

Updated:

2012-03-18

+ (NSString *) prepareEnclosure:

(NSString *)

token

Signature:

prepareEnclosure:

Discussion:

This method will prepare an enclosure character for an SQL statement.

Parameters:

token

The token to be prepared.

Returns:

The prepared token.

Updated:

2011-06-25

+ (NSString *) prepareIdentifier:

(id)

identifier

Signature:

prepareIdentifier:

Discussion:

This method will prepare an identifier for an SQL statement.

Parameters:

identifier

The identifier to be prepared.

Returns:

The prepared identifier.

Updated:

2012-03-19

+ (NSString *) prepareJoinType:

(NSString *)

token

Signature:

prepareJoinType:

Discussion:

This method will prepare a join type token for an SQL statement.

Parameters:

token

The token to be prepared.

Returns:

The prepared token.

Updated:

2012-03-18

+ (NSString *) prepareOperator:		(NSString *)	operator
ofType:		(NSString *)	type

Signature:

prepareOperator:type

Discussion:

This method will prepare an operator for an SQL statement.

Parameters:

operator	The operator to be prepared.
type	The type of operator.

Returns:

The prepared operator.

Updated:

2012-03-18

+ (NSString *) prepareSortOrder:

(BOOL)

descending

Signature:

prepareSortOrder:

Discussion:

This method will prepare a sort order token for an SQL statement.

Parameters:

descending

This will determine whether the token represents a descending tkoen or an ascending token.

Returns:

The prepared sort order token.

Updated:

2011-07-02

+ (NSString *) prepareSortWeight:

(NSString *)

weight

Signature:

prepareSortWeight:

Discussion:

This method will prepare the sort weight for an SQL statement.

Parameters:

weight

This indicates how nulls are to be weighed when comparing with non-nulls.

Returns:

The prepared sort weight.

Updated:

2011-11-06

+ (NSString *) prepareValue:

(id)

value

Signature:

prepareValue:

Discussion:

This method will prepare a value for an SQL statement.

Parameters:

value

The value to be prepared.

Returns:

The prepared value.

Updated:

2012-03-08

See also:

http://www.sqlite.org/c3ref/mprintf.html

http://codingrecipes.com/objective-c-a-function-for-escaping-values-before-inserting-into-sqlite

http://wiki.sa-mp.com/wiki/Escaping_Strings_SQLite

+ (ZIMSqlExpression *) sql:

(NSString *)

sql

Signature:

sql:

Discussion:

This method will wrap the SQL expression.

Parameters:

sql	The SQL expression to be wrapped

Returns:

The wrapped SQL expression.

Updated:

2012-03-17

---

Member Data Documentation

- (NSString*) _expression [protected]

---

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

• ZIMSqlExpression.h
• ZIMSqlExpression.m