objective-c-sql-query-builder
|
00001 /* 00002 * Copyright 2011-2015 Ziminji 00003 * 00004 * Licensed under the Apache License, Version 2.0 (the "License"); 00005 * you may not use this file except in compliance with the License. 00006 * You may obtain a copy of the License at: 00007 * 00008 * http://www.apache.org/licenses/LICENSE-2.0 00009 * 00010 * Unless required by applicable law or agreed to in writing, software 00011 * distributed under the License is distributed on an "AS IS" BASIS, 00012 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 00013 * See the License for the specific language governing permissions and 00014 * limitations under the License. 00015 */ 00016 00017 #import "ZIMSqlStatement.h" 00018 #import "ZIMSqlDataManipulationCommand.h" 00019 00026 @interface ZIMSqlUpdateStatement : NSObject <ZIMSqlStatement, ZIMSqlDataManipulationCommand> { 00027 00028 @protected 00029 NSString *_table; 00030 NSMutableArray *_column; 00031 NSMutableArray *_where; 00032 NSMutableArray *_orderBy; 00033 NSUInteger _limit; 00034 NSUInteger _offset; 00035 00036 } 00043 - (void) table: (NSString *)table; 00051 - (void) column: (NSString *)column value: (id)value; // wrap primitives with NSNumber 00058 - (void) whereBlock: (NSString *)brace; 00066 - (void) whereBlock: (NSString *)brace connector: (NSString *)connector; 00075 - (void) where: (id)column1 operator: (NSString *)operator column: (id)column2; 00085 - (void) where: (id)column1 operator: (NSString *)operator column: (id)column2 connector: (NSString *)connector; 00094 - (void) where: (id)column operator: (NSString *)operator value: (id)value; // wrap primitives with NSNumber 00104 - (void) where: (id)column operator: (NSString *)operator value: (id)value connector: (NSString *)connector; // wrap primitives with NSNumber 00111 - (void) orderBy: (NSString *)column; // ORDER BY [COLUMN] ASC 00119 - (void) orderBy: (NSString *)column descending: (BOOL)descending; // ORDER BY [COLUMN] [ASC | DESC] 00130 - (void) orderBy: (NSString *)column nulls: (NSString *)weight; // ORDER BY [COLUMN] ASC [NULLS FIRST | NULLS LAST] 00142 - (void) orderBy: (NSString *)column descending: (BOOL)descending nulls: (NSString *)weight; // ORDER BY [COLUMN] [ASC | DESC] [NULLS FIRST | NULLS LAST] 00149 - (void) limit: (NSUInteger)limit; 00157 - (void) limit: (NSUInteger)limit offset: (NSUInteger)offset; 00164 - (void) offset: (NSUInteger)offset; 00171 - (NSString *) statement; 00172 00173 @end