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
NSString *	ZIMSqlDefaultValue (id value)
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)

---

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

)