objective-c-sql-query-builder
Public Member Functions | Static Public Member Functions | Protected Attributes
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:
sqlThe 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:
tokenThe 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:
tokenThe 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:
tokenThe 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:
identifierThe 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:
tokenThe 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:
operatorThe operator to be prepared.
typeThe 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:
descendingThis 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:
weightThis 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:
valueThe 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:
sqlThe 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:
 All Classes Files Functions Variables Properties Defines