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 ZIMSqlDeleteStatement : NSObject <ZIMSqlStatement, ZIMSqlDataManipulationCommand> { 00027 00028 @protected 00029 NSString *_table; 00030 NSMutableArray *_where; 00031 NSMutableArray *_orderBy; 00032 NSUInteger _limit; 00033 NSUInteger _offset; 00034 00035 } 00036 00043 - (void) table: (NSString *)table; 00050 - (void) whereBlock: (NSString *)brace; 00058 - (void) whereBlock: (NSString *)brace connector: (NSString *)connector; 00067 - (void) where: (id)column1 operator: (NSString *)operator column: (id)column2; 00077 - (void) where: (id)column1 operator: (NSString *)operator column: (id)column2 connector: (NSString *)connector; 00086 - (void) where: (id)column operator: (NSString *)operator value: (id)value; // wrap primitives with NSNumber 00096 - (void) where: (id)column operator: (NSString *)operator value: (id)value connector: (NSString *)connector; // wrap primitives with NSNumber 00103 - (void) orderBy: (NSString *)column; // ORDER BY [COLUMN] ASC 00111 - (void) orderBy: (NSString *)column descending: (BOOL)descending; // ORDER BY [COLUMN] [ASC | DESC] 00122 - (void) orderBy: (NSString *)column nulls: (NSString *)weight; // ORDER BY [COLUMN] ASC [NULLS FIRST | NULLS LAST] 00134 - (void) orderBy: (NSString *)column descending: (BOOL)descending nulls: (NSString *)weight; // ORDER BY [COLUMN] [ASC | DESC] [NULLS FIRST | NULLS LAST] 00141 - (void) limit: (NSUInteger)limit; 00149 - (void) limit: (NSUInteger)limit offset: (NSUInteger)offset; 00156 - (void) offset: (NSUInteger)offset; 00163 - (NSString *) statement; 00164 00165 @end