blob: b59a42067fcf2e12fbbfdead9c7e44ee2b9d08ea (
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
|
#import "QSThingsProjectsParser.h"
@implementation QSThingsProjectsParser
- (BOOL)validParserForPath:(NSString *)path {
return [[path lastPathComponent] isEqualToString:@"main.sqlite"];
}
- (NSArray *)objectsFromPath:(NSString *)path withSettings:(NSDictionary *)settings {
NSString *query = @"SELECT "
"uuid, "
"creationDate, "
"status, "
"title, "
"notes, "
"area, "
"project "
"FROM TMTask "
"WHERE trashed = 0 "
"AND type = 1 "
"AND status < 3 "
"ORDER BY title;";
NSArray *results = [SQLHelper executeSql:query onFile:path];
NSMutableArray *objects = [NSMutableArray array];
[results enumerateObjectsUsingBlock:^(NSDictionary *dictionary, NSUInteger i, BOOL *stop) {
[objects addObject:[ObjectHelper projectFromSQLResult:dictionary usingPath:path ]];
}];
return objects;
}
@end
|
