blob: f125d61a498c6acaaa32e4132453d6a7d141282e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
|
#import <Foundation/Foundation.h>
#import "sqlite3.h"
#import "FMResultSet.h"
@interface FMDatabase : NSObject
{
sqlite3* db;
NSString* databasePath;
BOOL logsErrors;
BOOL crashOnErrors;
BOOL inUse;
BOOL inTransaction;
BOOL traceExecution;
BOOL checkedOut;
int busyRetryTimeout;
BOOL shouldCacheStatements;
NSMutableDictionary *cachedStatements;
NSMutableSet *openResultSets;
}
+ (id)databaseWithPath:(NSString*)inPath;
- (id)initWithPath:(NSString*)inPath;
- (BOOL)open;
#if SQLITE_VERSION_NUMBER >= 3005000
- (BOOL)openWithFlags:(int)flags;
#endif
- (BOOL)close;
- (BOOL)goodConnection;
- (void)clearCachedStatements;
- (void)closeOpenResultSets;
// encryption methods. You need to have purchased the sqlite encryption extensions for these to work.
- (BOOL)setKey:(NSString*)key;
- (BOOL)rekey:(NSString*)key;
- (NSString *)databasePath;
- (NSString*)lastErrorMessage;
- (int)lastErrorCode;
- (BOOL)hadError;
- (sqlite_int64)lastInsertRowId;
- (sqlite3*)sqliteHandle;
- (BOOL)update:(NSString*)sql error:(NSError**)outErr bind:(id)bindArgs, ...;
- (BOOL)executeUpdate:(NSString*)sql, ...;
- (BOOL)executeUpdate:(NSString*)sql withArgumentsInArray:(NSArray *)arguments;
- (BOOL)executeUpdate:(NSString*)sql error:(NSError**)outErr withArgumentsInArray:(NSArray*)arrayArgs orVAList:(va_list)args; // you shouldn't ever need to call this. use the previous two instead.
- (FMResultSet *)executeQuery:(NSString*)sql, ...;
- (FMResultSet *)executeQuery:(NSString *)sql withArgumentsInArray:(NSArray *)arguments;
- (FMResultSet *)executeQuery:(NSString *)sql withArgumentsInArray:(NSArray*)arrayArgs orVAList:(va_list)args; // you shouldn't ever need to call this. use the previous two instead.
- (BOOL)rollback;
- (BOOL)commit;
- (BOOL)beginTransaction;
- (BOOL)beginDeferredTransaction;
- (BOOL)logsErrors;
- (void)setLogsErrors:(BOOL)flag;
- (BOOL)crashOnErrors;
- (void)setCrashOnErrors:(BOOL)flag;
- (BOOL)inUse;
- (void)setInUse:(BOOL)value;
- (BOOL)inTransaction;
- (void)setInTransaction:(BOOL)flag;
- (BOOL)traceExecution;
- (void)setTraceExecution:(BOOL)flag;
- (BOOL)checkedOut;
- (void)setCheckedOut:(BOOL)flag;
- (int)busyRetryTimeout;
- (void)setBusyRetryTimeout:(int)newBusyRetryTimeout;
- (BOOL)shouldCacheStatements;
- (void)setShouldCacheStatements:(BOOL)value;
- (NSMutableDictionary *)cachedStatements;
- (void)setCachedStatements:(NSMutableDictionary *)value;
+ (NSString*)sqliteLibVersion;
- (int)changes;
@end
@interface FMStatement : NSObject {
sqlite3_stmt *statement;
NSString *query;
long useCount;
}
- (void)close;
- (void)reset;
- (sqlite3_stmt *)statement;
- (void)setStatement:(sqlite3_stmt *)value;
- (NSString *)query;
- (void)setQuery:(NSString *)value;
- (long)useCount;
- (void)setUseCount:(long)value;
@end
|
