RMTileCacheDAO.m
3.13 KB
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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
//
// DAO.m
// CatchMe
//
// Created by Joseph Gentle on 21/07/08.
// Copyright 2008 __MyCompanyName__. All rights reserved.
//
#import "RMTileCacheDAO.h"
#import "FMDatabase.h"
#import "RMTileCache.h"
#import "RMTileImage.h"
static RMTileCacheDAO *sharedDAOManager = nil;
@implementation RMTileCacheDAO
-(void)configureDBForFirstUse
{
// [db executeUpdate:@"DROP TABLE ZCACHE"];
[db executeUpdate:@"CREATE TABLE IF NOT EXISTS ZCACHE (ztileHash INTEGER PRIMARY KEY, zlastUsed DATE, zdata BLOB)"];
}
- (NSString*)dbPath
{
NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
if ([paths count] > 0)
{
// only copying one file
return [[paths objectAtIndex:0] stringByAppendingPathComponent:@"Map.sqlite"];
}
return nil;
}
- (id)init
{
if (![super init])
return nil;
NSString *path = [self dbPath];
NSLog(@"Opening database at %@", path);
db = [[FMDatabase alloc] initWithPath:path];
if (![db open])
{
NSLog(@"Could not connect to database - %@", [db lastErrorMessage]);
// return nil;
}
[db setCrashOnErrors:TRUE];
[self configureDBForFirstUse];
return self;
}
- (void)dealloc
{
[db release];
[super dealloc];
}
-(NSUInteger) count
{
FMResultSet *results = [db executeQuery:@"SELECT COUNT(ztileHash) FROM ZCACHE"];
int count = 0;
if ([results next])
count = [results intForColumnIndex:0];
else
{
NSLog(@"Unable to count columns");
}
[results close];
return count;
}
-(NSData*) dataForTile: (uint64_t) tileHash
{
FMResultSet *results = [db executeQuery:@"SELECT zdata FROM ZCACHE WHERE ztilehash = ?", [NSNumber numberWithUnsignedLongLong:tileHash]];
if ([db hadError])
{
NSLog(@"DB error while fetching tile data: %@", [db lastErrorMessage]);
return nil;
}
NSData *data = nil;
if ([results next])
{
data = [results dataForColumnIndex:0];
}
[results close];
return data;
}
-(void) removeOldestFromDatabase
{
}
-(void) touchTile: (uint64_t) tileHash
{
}
-(void) addData: (NSData*) data LastUsed: (NSDate*)date ForTile: (uint64_t) tileHash
{
// Fixme
// NSLog(@"addData\t%d", tileHash);
BOOL result = [db executeUpdate:@"INSERT OR IGNORE INTO ZCACHE (ztileHash, zlastUsed, zdata) VALUES (?, ?, ?)", [NSNumber numberWithUnsignedLongLong:tileHash], date, data];
if (result == NO)
{
NSLog(@"Error occured adding data");
}
// NSLog(@"done\t%d", tileHash);
}
// Singleton gunk as per CocoaFundamentals page 99.
+ (RMTileCacheDAO*)sharedManager
{
@synchronized(self) {
if (sharedDAOManager == nil) {
[[self alloc] init]; // assignment not done here
}
}
return sharedDAOManager;
}
+ (id)allocWithZone:(NSZone *)zone
{
@synchronized(self) {
if (sharedDAOManager == nil) {
sharedDAOManager = [super allocWithZone:zone];
return sharedDAOManager; // assignment and return on first allocation
}
}
return nil; //on subsequent allocation attempts return nil
}
- (id)copyWithZone:(NSZone *)zone
{
return self;
}
- (id)retain
{
return self;
}
- (unsigned)retainCount
{
return UINT_MAX; //denotes an object that cannot be released
}
- (void)release
{
//do nothing
}
- (id)autorelease
{
return self;
}
@end