aboutsummaryrefslogtreecommitdiff
path: root/QSThingsPlugin/Parsers/QSThingsTasksParser.m
blob: 8f4415b1612042e6aeb18583dd69750976a523d5 (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 "QSThingsTasksParser.h"

@implementation QSThingsTasksParser
- (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 = 0 "
            "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 taskFromSQLResult:dictionary usingPath:path ]];
  }];
  
  return objects;
}
@end