X-Git-Url: http://git.ithinksw.org/ITFoundation.git/blobdiff_plain/ecf80bca64f1e1a0c83ec0b90f370f41db477024..HEAD:/ITSQLite3Database.h diff --git a/ITSQLite3Database.h b/ITSQLite3Database.h index a8b93b0..b08327d 100644 --- a/ITSQLite3Database.h +++ b/ITSQLite3Database.h @@ -2,10 +2,7 @@ * ITFoundation * ITSQLite3Database.h * - * Copyright (c) 2008 by iThink Software. - * All Rights Reserved. - * - * $Id$ + * Copyright (c) 2008 iThink Software * */ @@ -18,6 +15,7 @@ extern id sqlite3_column_objc_object(sqlite3_stmt *statement, int columnIndex); @interface ITSQLite3Database : NSObject { NSString *dbPath; sqlite3 *db; + NSRecursiveLock *dbLock; } - (id)initWithPath:(NSString *)path; @@ -29,13 +27,18 @@ extern id sqlite3_column_objc_object(sqlite3_stmt *statement, int columnIndex); - (BOOL)rollback; - (BOOL)rollbackTransaction; -- (BOOL)executeQuery:(NSString *)query va_args:(va_list)args; - (BOOL)executeQuery:(NSString *)query, ...; -- (NSDictionary *)fetchRow:(NSString *)query va_args:(va_list)args; +// returns a dictionary with column names as keys, or nil - (NSDictionary *)fetchRow:(NSString *)query, ...; -- (NSArray *)fetchTable:(NSString *)query va_args:(va_list)args; +// returns an array of dictionaries with column names as keys, or an empty array - (NSArray *)fetchTable:(NSString *)query, ...; +// returns a single column value, or nil +- (id)fetchRowColumn:(NSString *)query, ...; + +// returns an array of single column values, or an empty array +- (NSArray *)fetchTableColumn:(NSString *)query, ...; + @end