objective-c-sql-query-builder
ZIMSqlDeleteStatement.h
Go to the documentation of this file.
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
 All Classes Files Functions Variables Properties Defines