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 <Foundation/Foundation.h> 00018 #import <sqlite3.h> // Requires libsqlite3.dylib 00019 00025 @interface ZIMDbConnection : NSObject { 00026 00027 @protected 00028 NSString *_dataSource; 00029 BOOL _readonly; 00030 NSMutableSet *_privileges; 00031 NSLock *_mutex; 00032 sqlite3 *_database; 00033 BOOL _isConnected; 00034 00035 } 00048 - (instancetype) initWithDataSource: (NSString *)dataSource withMultithreadingSupport: (BOOL)multithreading; 00060 - (instancetype) initWithDataSource: (NSString *)dataSource; 00066 - (void) open; 00074 - (NSNumber *) beginTransaction; 00085 - (NSNumber *) execute: (NSString *)sql; 00094 - (NSArray *) query: (NSString *)sql; 00106 - (NSArray *) query: (NSString *)sql asObject: (Class)model; 00114 - (NSNumber *) rollbackTransaction; 00122 - (NSNumber *) commitTransaction; 00130 - (NSNumber *) vacuum; 00137 - (BOOL) isConnected; 00143 - (void) close; 00149 - (void) dealloc; 00159 + (NSNumber *) dataSource: (NSString *)dataSource execute: (NSString *)sql; 00168 + (NSArray *) dataSource: (NSString *)dataSource query: (NSString *)sql; 00180 + (NSArray *) dataSource: (NSString *)dataSource query: (NSString *)sql asObject: (Class)model; 00181 00182 @end