#import "Constants.h"
#import "QSThingsProjectsParser.h"
#import "SQLHelper.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) {
    
    QSObject *newObject = [QSObject
        makeObjectWithIdentifier:[dictionary objectForKey:@"uuid"]];
    [newObject setObject:dictionary forType:kProjectType];
    [newObject setName:[dictionary objectForKey:@"title"]];
    [newObject setDetails:[dictionary objectForKey:@"notes"]];
    [newObject setPrimaryType:kProjectType];
    
    [objects addObject:newObject];
  }];
  
  return objects;
}
@end