-
Notifications
You must be signed in to change notification settings - Fork 0
/
Documents.m
57 lines (47 loc) · 1.63 KB
/
Documents.m
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
//
// Documents.m
// Japanese Zen Garden 2
//
// Created by Tri Vuong on 8/11/12.
// Copyright (c) 2012 __MyCompanyName__. All rights reserved.
//
#import "Documents.h"
#import "Document.h"
@implementation Documents
- (NSMutableArray *) getDocuments
{
NSMutableArray *documentsArray = [[NSMutableArray alloc] init];
@try {
NSFileManager *fileManager = [NSFileManager defaultManager];
NSString *dbPath = [[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent:@"Japanese Zen Garden.sqlite"];
BOOL success = [fileManager fileExistsAtPath:dbPath];
if (!success)
{
NSLog(@"Cannot locate database file");
}
if (!(sqlite3_open([dbPath UTF8String], &db) == SQLITE_OK))
{
NSLog(@"An error has occured");
}
const char *sql = "SELECT * FROM documents";
sqlite3_stmt *sqlStatement;
if (sqlite3_prepare(db, sql, -1, &sqlStatement, NULL) != SQLITE_OK)
{
NSLog(@"Problem with prepare statement");
}
while (sqlite3_step(sqlStatement) == SQLITE_ROW)
{
Document *doc = [[Document alloc] init];
doc.title = [NSString stringWithUTF8String:(char *) sqlite3_column_text(sqlStatement, 1)];
doc.content = [NSString stringWithUTF8String:(char *) sqlite3_column_text(sqlStatement, 2)];
[documentsArray addObject:doc];
}
}
@catch (NSException *exception) {
NSLog(@"An exception occured: %@", [exception reason]);
}
@finally {
return documentsArray;
}
}
@end