objective-c-sql-query-builder
Classes | Defines | Functions
ZIMSqlExpression.h File Reference
#import <Foundation/Foundation.h>

Go to the source code of this file.

Classes

class  ZIMSqlExpression

Defines

#define ZIMSqlEnclosureOpeningBrace   @"("
#define ZIMSqlEnclosureClosingBrace   @")"
#define ZIMSqlConnectorAnd   @"AND"
#define ZIMSqlConnectorOr   @"OR"
#define ZIMSqlJoinTypeCross   @"CROSS"
#define ZIMSqlJoinTypeInner   @"INNER"
#define ZIMSqlJoinTypeLeft   @"LEFT"
#define ZIMSqlJoinTypeLeftOuter   @"LEFT OUTER"
#define ZIMSqlJoinTypeNatural   @"NATURAL"
#define ZIMSqlJoinTypeNaturalCross   @"NATURAL CROSS"
#define ZIMSqlJoinTypeNaturalInner   @"NATURAL INNER"
#define ZIMSqlJoinTypeNaturalLeft   @"NATURAL LEFT"
#define ZIMSqlJoinTypeNaturalLeftOuter   @"NATURAL LEFT OUTER"
#define ZIMSqlJoinTypeNone   @""
#define ZIMSqlOperatorAdd   @"+"
#define ZIMSqlOperatorSubtract   @"-"
#define ZIMSqlOperatorMultiply   @"*"
#define ZIMSqlOperatorDivide   @"/"
#define ZIMSqlOperatorMod   @"%"
#define ZIMSqlOperatorAnd   @"AND"
#define ZIMSqlOperatorOr   @"OR"
#define ZIMSqlOperatorNot   @"NOT"
#define ZIMSqlOperatorLessThan   @"<"
#define ZIMSqlOperatorLessThanOrEqualTo   @"<="
#define ZIMSqlOperatorGreaterThan   @">"
#define ZIMSqlOperatorGreaterThanOrEqualTo   @">="
#define ZIMSqlOperatorEqualTo   @"="
#define ZIMSqlOperatorNotEqualTo   @"<>"
#define ZIMSqlOperatorBitwiseAnd   @"&"
#define ZIMSqlOperatorBitwiseOr   @"|"
#define ZIMSqlOperatorBitwiseShiftLeft   @"<<"
#define ZIMSqlOperatorBitwiseShiftRight   @">>"
#define ZIMSqlOperatorBitwiseNegation   @"~"
#define ZIMSqlOperatorConcatenate   @"||"
#define ZIMSqlOperatorIn   @"IN"
#define ZIMSqlOperatorNotIn   @"NOT IN"
#define ZIMSqlOperatorIs   @"IS"
#define ZIMSqlOperatorIsNot   @"IS NOT"
#define ZIMSqlOperatorLike   @"LIKE"
#define ZIMSqlOperatorNotLike   @"NOT LIKE"
#define ZIMSqlOperatorGlob   @"GLOB"
#define ZIMSqlOperatorNotGlob   @"NOT GLOB"
#define ZIMSqlOperatorBetween   @"BETWEEN"
#define ZIMSqlOperatorNotBetween   @"NOT BETWEEN"
#define ZIMSqlOperatorExcept   @"EXCEPT"
#define ZIMSqlOperatorIntersect   @"INTERSECT"
#define ZIMSqlOperatorUnion   @"UNION"
#define ZIMSqlOperatorUnionAll   @"UNION ALL"
#define ZIMSqlShowTypeAll   @"ALL"
#define ZIMSqlShowTypePermanent   @"PERMANENT"
#define ZIMSqlShowTypeTemporary   @"TEMPORARY"
#define ZIMSqlNullsFirst   @"FIRST"
#define ZIMSqlNullsLast   @"LAST"
#define ZIMSqlDefaultValueIsAutoIncremented   @"PRIMARY KEY AUTOINCREMENT NOT NULL"
#define ZIMSqlDefaultValueIsNull   @"DEFAULT NULL"
#define ZIMSqlDefaultValueIsNotNull   @"NOT NULL"
#define ZIMSqlDefaultValueIsCurrentDate   @"DEFAULT CURRENT_DATE"
#define ZIMSqlDefaultValueIsCurrentDateTime   @"DEFAULT (datetime('now','localtime'))"
#define ZIMSqlDefaultValueIsCurrentTime   @"DEFAULT CURRENT_TIME"
#define ZIMSqlDefaultValueIsCurrentTimestamp   @"DEFAULT CURRENT_TIMESTAMP"
#define ZIMSqlDataTypeBigInt   @"BIGINT"
#define ZIMSqlDataTypeBlob   @"BLOB"
#define ZIMSqlDataTypeBoolean   @"BOOLEAN"
#define ZIMSqlDataTypeClob   @"CLOB"
#define ZIMSqlDataTypeDate   @"DATE"
#define ZIMSqlDataTypeDateTime   @"DATETIME"
#define ZIMSqlDataTypeDouble   @"DOUBLE"
#define ZIMSqlDataTypeDoublePrecision   @"DOUBLE PRECISION"
#define ZIMSqlDataTypeFloat   @"FLOAT"
#define ZIMSqlDataTypeInt   @"INT"
#define ZIMSqlDataTypeInt2   @"INT2"
#define ZIMSqlDataTypeInt8   @"INT8"
#define ZIMSqlDataTypeInteger   @"INTEGER"
#define ZIMSqlDataTypeMediumInt   @"MEDIUMINT"
#define ZIMSqlDataTypeNumeric   @"NUMERIC"
#define ZIMSqlDataTypeReal   @"REAL"
#define ZIMSqlDataTypeSmallInt   @"SMALLINT"
#define ZIMSqlDataTypeText   @"TEXT"
#define ZIMSqlDataTypeTimestamp   @"TIMESTAMP"
#define ZIMSqlDataTypeTinyInt   @"TINYINT"
#define ZIMSqlDataTypeUnsignedBigInt   @"UNSIGNED BIG INT"
#define ZIMSqlDataTypeVariant   @"VARIANT"

Functions

NSStringZIMSqlDefaultValue (id value)
NSStringZIMSqlDataTypeChar (NSUInteger x)
NSStringZIMSqlDataTypeCharacter (NSUInteger x)
NSStringZIMSqlDataTypeDecimal (NSUInteger x, NSUInteger y)
NSStringZIMSqlDataTypeNativeCharacter (NSUInteger x)
NSStringZIMSqlDataTypeNChar (NSUInteger x)
NSStringZIMSqlDataTypeNVarChar (NSUInteger x)
NSStringZIMSqlDataTypeVarChar (NSUInteger x)
NSStringZIMSqlDataTypeVaryingCharacter (NSUInteger x)

Define Documentation

#define ZIMSqlConnectorAnd   @"AND"
#define ZIMSqlConnectorOr   @"OR"
#define ZIMSqlDataTypeBigInt   @"BIGINT"
#define ZIMSqlDataTypeBlob   @"BLOB"
#define ZIMSqlDataTypeBoolean   @"BOOLEAN"
#define ZIMSqlDataTypeClob   @"CLOB"
#define ZIMSqlDataTypeDate   @"DATE"
#define ZIMSqlDataTypeDateTime   @"DATETIME"
#define ZIMSqlDataTypeDouble   @"DOUBLE"
#define ZIMSqlDataTypeDoublePrecision   @"DOUBLE PRECISION"
#define ZIMSqlDataTypeFloat   @"FLOAT"
#define ZIMSqlDataTypeInt   @"INT"
#define ZIMSqlDataTypeInt2   @"INT2"
#define ZIMSqlDataTypeInt8   @"INT8"
#define ZIMSqlDataTypeInteger   @"INTEGER"
#define ZIMSqlDataTypeMediumInt   @"MEDIUMINT"
#define ZIMSqlDataTypeNumeric   @"NUMERIC"
#define ZIMSqlDataTypeReal   @"REAL"
#define ZIMSqlDataTypeSmallInt   @"SMALLINT"
#define ZIMSqlDataTypeText   @"TEXT"
#define ZIMSqlDataTypeTimestamp   @"TIMESTAMP"
#define ZIMSqlDataTypeTinyInt   @"TINYINT"
#define ZIMSqlDataTypeUnsignedBigInt   @"UNSIGNED BIG INT"
#define ZIMSqlDataTypeVariant   @"VARIANT"
#define ZIMSqlDefaultValueIsAutoIncremented   @"PRIMARY KEY AUTOINCREMENT NOT NULL"
#define ZIMSqlDefaultValueIsCurrentDate   @"DEFAULT CURRENT_DATE"
#define ZIMSqlDefaultValueIsCurrentDateTime   @"DEFAULT (datetime('now','localtime'))"
#define ZIMSqlDefaultValueIsCurrentTime   @"DEFAULT CURRENT_TIME"
#define ZIMSqlDefaultValueIsCurrentTimestamp   @"DEFAULT CURRENT_TIMESTAMP"
#define ZIMSqlDefaultValueIsNotNull   @"NOT NULL"
#define ZIMSqlDefaultValueIsNull   @"DEFAULT NULL"
#define ZIMSqlEnclosureClosingBrace   @")"
#define ZIMSqlEnclosureOpeningBrace   @"("
#define ZIMSqlJoinTypeCross   @"CROSS"
#define ZIMSqlJoinTypeInner   @"INNER"
#define ZIMSqlJoinTypeLeft   @"LEFT"
#define ZIMSqlJoinTypeLeftOuter   @"LEFT OUTER"
#define ZIMSqlJoinTypeNatural   @"NATURAL"
#define ZIMSqlJoinTypeNaturalCross   @"NATURAL CROSS"
#define ZIMSqlJoinTypeNaturalInner   @"NATURAL INNER"
#define ZIMSqlJoinTypeNaturalLeft   @"NATURAL LEFT"
#define ZIMSqlJoinTypeNaturalLeftOuter   @"NATURAL LEFT OUTER"
#define ZIMSqlJoinTypeNone   @""
#define ZIMSqlNullsFirst   @"FIRST"
#define ZIMSqlNullsLast   @"LAST"
#define ZIMSqlOperatorAdd   @"+"
#define ZIMSqlOperatorAnd   @"AND"
#define ZIMSqlOperatorBetween   @"BETWEEN"
#define ZIMSqlOperatorBitwiseAnd   @"&"
#define ZIMSqlOperatorBitwiseNegation   @"~"
#define ZIMSqlOperatorBitwiseOr   @"|"
#define ZIMSqlOperatorBitwiseShiftLeft   @"<<"
#define ZIMSqlOperatorBitwiseShiftRight   @">>"
#define ZIMSqlOperatorConcatenate   @"||"
#define ZIMSqlOperatorDivide   @"/"
#define ZIMSqlOperatorEqualTo   @"="
#define ZIMSqlOperatorExcept   @"EXCEPT"
#define ZIMSqlOperatorGlob   @"GLOB"
#define ZIMSqlOperatorGreaterThan   @">"
#define ZIMSqlOperatorGreaterThanOrEqualTo   @">="
#define ZIMSqlOperatorIn   @"IN"
#define ZIMSqlOperatorIntersect   @"INTERSECT"
#define ZIMSqlOperatorIs   @"IS"
#define ZIMSqlOperatorIsNot   @"IS NOT"
#define ZIMSqlOperatorLessThan   @"<"
#define ZIMSqlOperatorLessThanOrEqualTo   @"<="
#define ZIMSqlOperatorLike   @"LIKE"
#define ZIMSqlOperatorMod   @"%"
#define ZIMSqlOperatorMultiply   @"*"
#define ZIMSqlOperatorNot   @"NOT"
#define ZIMSqlOperatorNotBetween   @"NOT BETWEEN"
#define ZIMSqlOperatorNotEqualTo   @"<>"
#define ZIMSqlOperatorNotGlob   @"NOT GLOB"
#define ZIMSqlOperatorNotIn   @"NOT IN"
#define ZIMSqlOperatorNotLike   @"NOT LIKE"
#define ZIMSqlOperatorOr   @"OR"
#define ZIMSqlOperatorSubtract   @"-"
#define ZIMSqlOperatorUnion   @"UNION"
#define ZIMSqlOperatorUnionAll   @"UNION ALL"
#define ZIMSqlShowTypeAll   @"ALL"
#define ZIMSqlShowTypePermanent   @"PERMANENT"
#define ZIMSqlShowTypeTemporary   @"TEMPORARY"

Function Documentation

NSString* ZIMSqlDataTypeChar ( NSUInteger  x)
NSString* ZIMSqlDataTypeCharacter ( NSUInteger  x)
NSString* ZIMSqlDataTypeDecimal ( NSUInteger  x,
NSUInteger  y 
)
NSString* ZIMSqlDataTypeNativeCharacter ( NSUInteger  x)
NSString* ZIMSqlDataTypeNChar ( NSUInteger  x)
NSString* ZIMSqlDataTypeNVarChar ( NSUInteger  x)
NSString* ZIMSqlDataTypeVarChar ( NSUInteger  x)
NSString* ZIMSqlDataTypeVaryingCharacter ( NSUInteger  x)
NSString* ZIMSqlDefaultValue ( id  value)
 All Classes Files Functions Variables Properties Defines