#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