Add children

8 files changed, 668 insertions, 0 deletions

diff --git a/QSThingsPlugin/Handlers/ThingsAppSectionHandler.h b/QSThingsPlugin/Handlers/ThingsAppSectionHandler.h
new file mode 100644
index 0000000..6fc3f35
--- /dev/null
+++ b/QSThingsPlugin/Handlers/ThingsAppSectionHandler.h
@@ -0,0 +1,14 @@
+#import "Constants.h"
+#import "SQLHelper.h"
+#import "ObjectHelper.h"
+#import "NSImage+Badge.h"
+#import <Foundation/Foundation.h>
+#import <QSCore/QSCore.h>
+
+NS_ASSUME_NONNULL_BEGIN
+
+@interface ThingsAppSectionHandler : NSObject <QSObjectHandler>
+
+@end
+
+NS_ASSUME_NONNULL_END
diff --git a/QSThingsPlugin/Handlers/ThingsAppSectionHandler.m b/QSThingsPlugin/Handlers/ThingsAppSectionHandler.m
new file mode 100644
index 0000000..0f294fc
--- /dev/null
+++ b/QSThingsPlugin/Handlers/ThingsAppSectionHandler.m
@@ -0,0 +1,190 @@
+#import "ThingsAppSectionHandler.h"
+
+NS_ASSUME_NONNULL_BEGIN
+
+@implementation ThingsAppSectionHandler
+
+- (BOOL)objectHasChildren:(QSObject *)object {
+  return YES;
+}
+
+- (void)setQuickIconForObject:(QSObject *)object {
+  NSImage *baseImage = [QSResourceManager imageNamed:@"com.culturedcode.ThingsMac"];
+  
+  ThingsAppSectionKey identifier  = [object identifier];
+  NSImage *imageWithBadge = nil;
+  if (identifier == ThingsAppSectionKeyInbox) {
+    NSColor *color = [NSColor colorWithRed:0.318 green:0.667 blue:0.949 alpha:1.0];
+    imageWithBadge = [baseImage imageOfSize:NSMakeSize(512, 512) withSystemBadge:@"tray.circle" ofColor:color];
+  }
+  if (identifier == ThingsAppSectionKeyToday) {
+    NSColor *color = [NSColor colorWithRed:0.973 green:0.839 blue:0.282 alpha:1.0];
+    imageWithBadge = [baseImage imageOfSize:NSMakeSize(512, 512) withSystemBadge:@"star.circle" ofColor:color];
+  }
+  if (identifier == ThingsAppSectionKeyAnytime) {
+    NSColor *color = [NSColor colorWithRed:0.353 green:0.651 blue:0.616 alpha:1.0];
+    imageWithBadge = [baseImage imageOfSize:NSMakeSize(512, 512) withSystemBadge:@"diamond.circle" ofColor:color];
+  }
+  if (identifier == ThingsAppSectionKeySomeday) {
+    NSColor *color = [NSColor colorWithRed:0.792 green:0.749 blue:0.525 alpha:1.0];
+    imageWithBadge = [baseImage imageOfSize:NSMakeSize(512, 512) withSystemBadge:@"archivebox.circle" ofColor:color];
+  }
+  if (identifier == ThingsAppSectionKeyUpcoming) {
+    NSColor *color = [NSColor colorWithRed:0.902 green:0.224 blue:0.349 alpha:1.0];
+    imageWithBadge = [baseImage imageOfSize:NSMakeSize(512, 512) withSystemBadge:@"calendar.circle" ofColor:color];
+  }
+
+  if (imageWithBadge) {
+    [object setIcon:imageWithBadge];
+  } else {
+    [object setIcon:baseImage];
+  }
+}
+
+- (BOOL)loadChildrenForObject:(QSObject *)object {
+  NSDictionary *contents = [object objectForType:kAppSectionType];
+  
+  if (!contents) {
+    NSLog(@"Malformed Things Task: No content.");
+    return NO;
+  }
+
+  NSString *path = [contents objectForKey:@"path"];
+  if (!path) {
+    NSLog(@"Malformed Things Task: No path.");
+    return NO;
+  }
+  
+  ThingsAppSectionKey appSection = [object identifier];
+  if (!appSection) {
+    NSLog(@"Malformed Things App Section: No identifier.");
+    return NO;
+  }
+
+  NSMutableArray *children = [NSMutableArray array];
+  [children addObjectsFromArray:[self tasksForAppSection:appSection usingDatabaseAt:path ]];
+  [children addObjectsFromArray:[self projectsForAppSection:appSection usingDatabaseAt:path ]];
+
+  [object setChildren:children];
+  return YES;
+}
+
+- (NSArray *)projectsForAppSection:(ThingsAppSectionKey)appSection usingDatabaseAt:(NSString *)path {
+  
+  NSString *conditions = [self conditionsFor:appSection];
+  
+  NSString *query = [NSString stringWithFormat: @"SELECT "
+            "task.uuid AS uuid, "
+            "task.creationDate AS creationDate, "
+            "task.status AS status, "
+            "task.title AS title, "
+            "task.notes AS notes, "
+            "task.area AS area "
+            "FROM TMTask as task "
+            "LEFT JOIN TMTask AS project "
+            "ON task.project = project.uuid "
+            "LEFT JOIN TMTask AS heading "
+            "ON task.heading = heading.uuid "
+            "LEFT JOIN TMTask AS headingProject "
+            "ON heading.project = headingProject.uuid "
+            "WHERE task.type = 1 "
+            "AND task.trashed = 0 "
+            "AND task.status = 0 "
+            "%@"
+            "GROUP BY task.uuid "
+            "ORDER BY title;", conditions];
+
+  NSArray *results = [SQLHelper executeSql:query onFile:path];
+  NSMutableArray *objects = [NSMutableArray array];
+  [results enumerateObjectsUsingBlock:^(NSDictionary *dictionary, NSUInteger i, BOOL *stop) {
+    NSLog(@"WE PROJECTIN!");
+    [objects addObject:[ObjectHelper projectFromSQLResult:dictionary usingPath:path ]];
+  }];
+  
+  return objects;
+}
+
+- (NSArray *)tasksForAppSection:(ThingsAppSectionKey)appSection usingDatabaseAt:(NSString *)path {
+  
+  NSString *conditions = [self conditionsFor:appSection];
+  
+  NSString *query = [NSString stringWithFormat: @"SELECT "
+            "task.uuid AS uuid, "
+            "task.creationDate AS creationDate, "
+            "task.status AS status, "
+            "task.title AS title, "
+            "task.notes AS notes, "
+            "task.area AS area "
+            "FROM TMTask as task "
+            "LEFT JOIN TMTask AS project "
+            "ON task.project = project.uuid "
+            "LEFT JOIN TMTask AS heading "
+            "ON task.heading = heading.uuid "
+            "LEFT JOIN TMTask AS headingProject "
+            "ON heading.project = headingProject.uuid "
+            "WHERE task.type = 0 "
+            "AND task.trashed = 0 "
+            "AND task.status = 0 "
+            "%@"
+            "GROUP BY task.uuid "
+            "ORDER BY title;", conditions];
+  
+  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;
+}
+
+- (NSString *)conditionsFor:(ThingsAppSectionKey)appSection {
+  if (appSection == ThingsAppSectionKeyInbox) {
+    return @"AND task.startDate IS NULL "
+            "AND task.area IS NULL "
+            "AND task.project IS NULL "
+            "AND task.heading IS NULL ";
+  }
+  if (appSection == ThingsAppSectionKeyToday) {
+    return @"AND task.todayIndexReferenceDate IS NOT NULL "
+            "AND task.todayIndex <= 0 ";
+  }
+  if (appSection == ThingsAppSectionKeyUpcoming) {
+    return @"AND task.todayIndexReferenceDate IS NOT NULL "
+            "AND task.todayIndex > 0 ";
+  }
+  if (appSection == ThingsAppSectionKeySomeday) {
+    return @"AND task.start=2 "
+            "AND task.startDate IS NULL "
+            "AND task.rt1_instanceCreationStartDate IS NULL ";
+  }
+  if (appSection == ThingsAppSectionKeyAnytime) {
+    return @"AND ( "
+      "( "
+        "task.todayIndexReferenceDate IS NOT NULL "
+        "AND task.todayIndex <= 0 "
+      ") "
+      "OR ( "
+        "task.startDate IS NULL AND "
+        "task.start=1 AND "
+        "task.rt1_instanceCreationStartDate IS NULL "
+        "AND ( "
+          "task.area IS NOT NULL "
+          "OR task.project IS NOT NULL "
+          "OR task.heading IS NOT NULL "
+        ") "
+        "AND project.todayIndexReferenceDate IS NULL "
+        "AND (project.start=1 OR headingProject.start IS NULL) "
+        "AND heading.todayIndexReferenceDate IS NULL "
+        "AND (heading.start=1 OR headingProject.start IS NULL) "
+        "AND headingProject.todayIndexReferenceDate IS NULL "
+        "AND (headingProject.start=1 OR headingProject.start IS NULL) "
+      ") "
+    ") ";
+  }
+}
+
+
+@end
+
+NS_ASSUME_NONNULL_END
diff --git a/QSThingsPlugin/Handlers/ThingsAreaHandler.h b/QSThingsPlugin/Handlers/ThingsAreaHandler.h
new file mode 100644
index 0000000..14dd5ad
--- /dev/null
+++ b/QSThingsPlugin/Handlers/ThingsAreaHandler.h
@@ -0,0 +1,13 @@
+#import "Constants.h"
+#import "SQLHelper.h"
+#import "ObjectHelper.h"
+#import "NSImage+Badge.h"
+#import <Foundation/Foundation.h>
+#import <QSCore/QSCore.h>
+
+NS_ASSUME_NONNULL_BEGIN
+
+@interface ThingsAreaHandler : NSObject <QSObjectHandler>
+@end
+
+NS_ASSUME_NONNULL_END
diff --git a/QSThingsPlugin/Handlers/ThingsAreaHandler.m b/QSThingsPlugin/Handlers/ThingsAreaHandler.m
new file mode 100644
index 0000000..6619a0e
--- /dev/null
+++ b/QSThingsPlugin/Handlers/ThingsAreaHandler.m
@@ -0,0 +1,124 @@
+#import "ThingsAreaHandler.h"
+
+NS_ASSUME_NONNULL_BEGIN
+
+@implementation ThingsAreaHandler
+
+- (BOOL)objectHasChildren:(QSObject *)object {
+  return YES;
+}
+
+- (void)setQuickIconForObject:(QSObject *)object {
+  NSImage *baseImage = [QSResourceManager imageNamed:@"com.culturedcode.ThingsMac"];
+  NSColor *color = [NSColor colorWithRed:0.478 green:0.702 blue:0.584 alpha:1.0];
+  NSImage *imageWithBadge = [baseImage imageOfSize:NSMakeSize(512, 512) withSystemBadge:@"cube.circle" ofColor:color];
+  
+  if (imageWithBadge) {
+    [object setIcon:imageWithBadge];
+  } else {
+    [object setIcon:baseImage];
+  }
+}
+
+- (BOOL)loadChildrenForObject:(QSObject *)object {
+  NSDictionary *contents = [object objectForType:kAreaType];
+  
+  if (!contents) {
+    NSLog(@"Malformed Things Task: No content.");
+    return NO;
+  }
+
+  NSString *path = [contents objectForKey:@"path"];
+  if (!path) {
+    NSLog(@"Malformed Things Task: No path.");
+    return NO;
+  }
+  
+  NSString *uuid = [contents objectForKey:@"uuid"];
+  if (!uuid) {
+    NSLog(@"Malformed Things Task: No uuid.");
+    return NO;
+  }
+  
+  NSMutableArray *children = [NSMutableArray array];
+  [children addObjectsFromArray:[self tagsForAreaIdentifiedBy:uuid usingDatabaseAt:path ]];
+  [children addObjectsFromArray:[self tasksForAreaIdentifiedBy:uuid usingDatabaseAt:path ]];
+  [children addObjectsFromArray:[self projectsForAreaIdentifiedBy:uuid usingDatabaseAt:path ]];
+
+  [object setChildren:children];
+  return YES;
+}
+
+- (NSArray *)tagsForAreaIdentifiedBy:(NSString *)uuid usingDatabaseAt:(NSString *)path {
+  NSString *query = [NSString stringWithFormat: @"SELECT "
+            "tag.uuid as uuid, "
+            "tag.title as title "
+            "FROM TMArea AS area "
+            "LEFT JOIN TMAreaTag as junction "
+            "ON junction.areas = area.uuid "
+            "LEFT JOIN TMTag as tag "
+            "ON junction.tags = tag.uuid "
+            "WHERE area.uuid = '%@' "
+            "AND tag.uuid IS NOT NULL "
+            "ORDER BY tag.title;", uuid];
+  
+  NSArray *results = [SQLHelper executeSql:query onFile:path];
+  NSMutableArray *objects = [NSMutableArray array];
+  [results enumerateObjectsUsingBlock:^(NSDictionary *dictionary, NSUInteger i, BOOL *stop) {
+    [objects addObject:[ObjectHelper tagFromSQLResult:dictionary usingPath:path ]];
+  }];
+  
+  return objects;
+}
+
+- (NSArray *)projectsForAreaIdentifiedBy:(NSString *)uuid usingDatabaseAt:(NSString *)path {
+  NSString *query = [NSString stringWithFormat: @"SELECT "
+            "uuid, "
+            "creationDate, "
+            "status, "
+            "title, "
+            "notes, "
+            "area "
+            "FROM TMTask "
+            "WHERE area = '%@' "
+            "AND type = 1 "
+            "AND trashed = 0 "
+            "AND status = 0 "
+            "ORDER BY title;", uuid];
+  
+  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;
+}
+
+- (NSArray *)tasksForAreaIdentifiedBy:(NSString *)uuid usingDatabaseAt:(NSString *)path {
+  NSString *query = [NSString stringWithFormat: @"SELECT "
+            "uuid, "
+            "creationDate, "
+            "status, "
+            "title, "
+            "notes, "
+            "area "
+            "FROM TMTask "
+            "WHERE area = '%@' "
+            "AND type = 0 "
+            "AND trashed = 0 "
+            "AND status = 0 "
+            "ORDER BY title;", uuid];
+  
+  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
+
+NS_ASSUME_NONNULL_END
diff --git a/QSThingsPlugin/Handlers/ThingsTagHandler.h b/QSThingsPlugin/Handlers/ThingsTagHandler.h
new file mode 100644
index 0000000..6ecf432
--- /dev/null
+++ b/QSThingsPlugin/Handlers/ThingsTagHandler.h
@@ -0,0 +1,14 @@
+#import "Constants.h"
+#import "SQLHelper.h"
+#import "ObjectHelper.h"
+#import "NSImage+Badge.h"
+#import <Foundation/Foundation.h>
+#import <QSCore/QSCore.h>
+
+NS_ASSUME_NONNULL_BEGIN
+
+@interface ThingsTagHandler : NSObject <QSObjectHandler>
+
+@end
+
+NS_ASSUME_NONNULL_END
diff --git a/QSThingsPlugin/Handlers/ThingsTagHandler.m b/QSThingsPlugin/Handlers/ThingsTagHandler.m
new file mode 100644
index 0000000..27b93a2
--- /dev/null
+++ b/QSThingsPlugin/Handlers/ThingsTagHandler.m
@@ -0,0 +1,134 @@
+#import "ThingsTagHandler.h"
+
+NS_ASSUME_NONNULL_BEGIN
+
+@implementation ThingsTagHandler
+
+- (BOOL)objectHasChildren:(QSObject *)object {
+  return YES;
+}
+
+- (void)setQuickIconForObject:(QSObject *)object {
+  NSImage *baseImage = [QSResourceManager imageNamed:@"com.culturedcode.ThingsMac"];
+  NSColor *color = [NSColor colorWithRed:0.263 green:0.502 blue:0.376 alpha:1.0];
+  NSImage *imageWithBadge = [baseImage imageOfSize:NSMakeSize(512, 512) withSystemBadge:@"tag.circle" ofColor:color];
+  
+  if (imageWithBadge) {
+    [object setIcon:imageWithBadge];
+  } else {
+    [object setIcon:baseImage];
+  }
+}
+
+- (BOOL)loadChildrenForObject:(QSObject *)object {
+  NSDictionary *contents = [object objectForType:kTagType];
+  
+  if (!contents) {
+    NSLog(@"Malformed Things Task: No content.");
+    return NO;
+  }
+
+  NSString *path = [contents objectForKey:@"path"];
+  if (!path) {
+    NSLog(@"Malformed Things Task: No path.");
+    return NO;
+  }
+  
+  NSString *uuid = [contents objectForKey:@"uuid"];
+  if (!uuid) {
+    NSLog(@"Malformed Things Task: No uuid.");
+    return NO;
+  }
+  
+  NSMutableArray *children = [NSMutableArray array];
+  [children addObjectsFromArray:[self areasForTagIdentifiedBy:uuid usingDatabaseAt:path ]];
+  [children addObjectsFromArray:[self projectsForTagIdentifiedBy:uuid usingDatabaseAt:path ]];
+  [children addObjectsFromArray:[self tasksForTagIdentifiedBy:uuid usingDatabaseAt:path ]];
+
+  [object setChildren:children];
+  return YES;
+}
+
+- (NSArray *)projectsForTagIdentifiedBy:(NSString *)uuid usingDatabaseAt:(NSString *)path {
+  NSString *query = [NSString stringWithFormat: @"SELECT "
+            "project.uuid as uuid, "
+            "project.creationDate as creationDate, "
+            "project.status as status, "
+            "project.title as title, "
+            "project.notes as notes, "
+            "project.area as area "
+            "FROM TMTag AS tag "
+            "LEFT JOIN TMTaskTag as junction "
+            "ON junction.tags = tag.uuid "
+            "LEFT JOIN TMTask as project "
+            "ON junction.tasks = project.uuid "
+            "WHERE tag.uuid = '%@' "
+            "AND project.uuid IS NOT NULL "
+            "AND project.type = 1 "
+            "AND project.status = 0 "
+            "AND project.trashed = 0 "
+            "ORDER BY project.title;", uuid];
+  
+  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;
+}
+
+- (NSArray *)tasksForTagIdentifiedBy:(NSString *)uuid usingDatabaseAt:(NSString *)path {
+  NSString *query = [NSString stringWithFormat: @"SELECT "
+            "task.uuid as uuid, "
+            "task.creationDate as creationDate, "
+            "task.status as status, "
+            "task.title as title, "
+            "task.notes as notes, "
+            "task.area as area "
+            "FROM TMTag AS tag "
+            "LEFT JOIN TMTaskTag as junction "
+            "ON junction.tags = tag.uuid "
+            "LEFT JOIN TMTask as task "
+            "ON junction.tasks = task.uuid "
+            "WHERE tag.uuid = '%@' "
+            "AND task.uuid IS NOT NULL "
+            "AND task.type = 0 "
+            "AND task.status = 0 "
+            "AND task.trashed = 0 "
+            "ORDER BY task.title;", uuid];
+  
+  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;
+}
+
+- (NSArray *)areasForTagIdentifiedBy:(NSString *)uuid usingDatabaseAt:(NSString *)path {
+  NSString *query = [NSString stringWithFormat: @"SELECT "
+            "area.uuid as uuid, "
+            "area.title as title "
+            "FROM TMTag AS tag "
+            "LEFT JOIN TMAreaTag as junction "
+            "ON junction.tags = tag.uuid "
+            "LEFT JOIN TMArea as area "
+            "ON junction.areas = area.uuid "
+            "WHERE tag.uuid = '%@' "
+            "AND area.uuid IS NOT NULL "
+            "ORDER BY area.title;", uuid];
+  
+  NSArray *results = [SQLHelper executeSql:query onFile:path];
+  NSMutableArray *objects = [NSMutableArray array];
+  [results enumerateObjectsUsingBlock:^(NSDictionary *dictionary, NSUInteger i, BOOL *stop) {
+    [objects addObject:[ObjectHelper areaFromSQLResult:dictionary usingPath:path ]];
+  }];
+  
+  return objects;
+}
+
+@end
+
+NS_ASSUME_NONNULL_END
diff --git a/QSThingsPlugin/Handlers/ThingsTaskHandler.h b/QSThingsPlugin/Handlers/ThingsTaskHandler.h
new file mode 100644
index 0000000..b32e527
--- /dev/null
+++ b/QSThingsPlugin/Handlers/ThingsTaskHandler.h
@@ -0,0 +1,14 @@
+#import "Constants.h"
+#import "SQLHelper.h"
+#import "ObjectHelper.h"
+#import "NSImage+Badge.h"
+#import <Foundation/Foundation.h>
+#import <QSCore/QSCore.h>
+
+NS_ASSUME_NONNULL_BEGIN
+
+@interface ThingsTaskHandler : NSObject <QSObjectHandler>
+
+@end
+
+NS_ASSUME_NONNULL_END
diff --git a/QSThingsPlugin/Handlers/ThingsTaskHandler.m b/QSThingsPlugin/Handlers/ThingsTaskHandler.m
new file mode 100644
index 0000000..5875feb
--- /dev/null
+++ b/QSThingsPlugin/Handlers/ThingsTaskHandler.m
@@ -0,0 +1,165 @@
+#import "ThingsTaskHandler.h"
+
+NS_ASSUME_NONNULL_BEGIN
+
+@implementation ThingsTaskHandler
+
+- (BOOL)objectHasChildren:(QSObject *)object {
+  return YES;
+}
+
+- (void)setQuickIconForObject:(QSObject *)object {
+  NSImage *baseImage = [QSResourceManager imageNamed:@"com.culturedcode.ThingsMac"];
+  NSString *badge = @"checkmark.circle";
+  NSColor *color = [NSColor colorWithRed:0.310 green:0.616 blue:0.976 alpha:1.0];
+  
+  if (object.primaryType == kProjectType) {
+    badge = @"circle";
+    color = [NSColor colorWithRed:0.157 green:0.376 blue:0.733 alpha:1.0];
+  }
+  NSImage *imageWithBadge = [baseImage imageOfSize:NSMakeSize(512, 512) withSystemBadge:badge ofColor:color];
+  
+  if (imageWithBadge) {
+    [object setIcon:imageWithBadge];
+  } else {
+    [object setIcon:baseImage];
+  }
+}
+
+- (BOOL)loadChildrenForObject:(QSObject *)object {
+  NSDictionary *contents = [object objectForType:object.primaryType];
+  
+  if (!contents) {
+    NSLog(@"Malformed Things Task: No content.");
+    return NO;
+  }
+
+  NSString *path = [contents objectForKey:@"path"];
+  if (!path) {
+    NSLog(@"Malformed Things Task: No path.");
+    return NO;
+  }
+  
+  NSString *uuid = [contents objectForKey:@"uuid"];
+  if (!uuid) {
+    NSLog(@"Malformed Things Task: No uuid.");
+    return NO;
+  }
+  
+  // Tasks and Projects are basically the same thing in the Things database. So we use the same handler.
+  // The big difference is that projects can't have projects, and tasks can't have tasks
+
+  NSMutableArray *children = [NSMutableArray array];
+  [children addObjectsFromArray:[self tagsForTaskIdentifiedBy:uuid usingDatabaseAt:path ]];
+  [children addObjectsFromArray:[self areasForTaskIdentifiedBy:uuid usingDatabaseAt:path ]];
+
+  if (object.primaryType == kProjectType) {
+    [children addObjectsFromArray:[self tasksForTaskIdentifiedBy:uuid usingDatabaseAt:path ]];
+  } else {
+    [children addObjectsFromArray:[self projectsForTaskIdentifiedBy:uuid usingDatabaseAt:path ]];
+  }
+
+  [object setChildren:children];
+  return YES;
+}
+
+- (NSArray *)tagsForTaskIdentifiedBy:(NSString *)uuid usingDatabaseAt:(NSString *)path {
+  NSString *query = [NSString stringWithFormat: @"SELECT "
+            "tag.uuid as uuid, "
+            "tag.title as title "
+            "FROM TMTask AS task "
+            "LEFT JOIN TMTaskTag as junction "
+            "ON junction.tasks = task.uuid "
+            "LEFT JOIN TMTag as tag "
+            "ON junction.tags = tag.uuid "
+            "WHERE task.uuid = '%@' "
+            "AND tag.uuid IS NOT NULL "
+            "ORDER BY tag.title;", uuid];
+  
+  NSArray *results = [SQLHelper executeSql:query onFile:path];
+  NSMutableArray *objects = [NSMutableArray array];
+  [results enumerateObjectsUsingBlock:^(NSDictionary *dictionary, NSUInteger i, BOOL *stop) {
+    [objects addObject:[ObjectHelper tagFromSQLResult:dictionary usingPath:path ]];
+  }];
+  
+  return objects;
+}
+
+- (NSArray *)projectsForTaskIdentifiedBy:(NSString *)uuid usingDatabaseAt:(NSString *)path {
+  NSString *query = [NSString stringWithFormat: @"SELECT "
+            "project.uuid as uuid, "
+            "project.creationDate as creationDate, "
+            "project.status as status, "
+            "project.title as title, "
+            "project.notes as notes, "
+            "project.area as area "
+            "FROM TMTask AS task "
+            "LEFT JOIN TMTask as project "
+            "ON task.project = project.uuid "
+            "AND project.type = 1 "
+            "WHERE task.uuid = '%@' "
+            "AND project.uuid IS NOT NULL "
+            "AND project.trashed = 0 "
+            "AND project.status = 0 "
+            "ORDER BY project.title;", uuid];
+  
+  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;
+}
+
+- (NSArray *)areasForTaskIdentifiedBy:(NSString *)uuid usingDatabaseAt:(NSString *)path {
+  NSString *query = [NSString stringWithFormat: @"SELECT "
+            "area.uuid as uuid, "
+            "area.title as title "
+            "FROM TMTask AS task "
+            "LEFT JOIN TMTask as project "
+            "ON task.project = project.uuid "
+            "LEFT JOIN TMArea as area "
+            "ON task.area = area.uuid OR project.area = area.uuid "
+            "WHERE task.uuid = '%@' "
+            "AND area.uuid IS NOT NULL "
+            "ORDER BY area.title;", uuid];
+
+  NSArray *results = [SQLHelper executeSql:query onFile:path];
+  NSMutableArray *objects = [NSMutableArray array];
+  if (results) {
+    [results enumerateObjectsUsingBlock:^(NSDictionary *dictionary, NSUInteger i, BOOL *stop) {
+      [objects addObject:[ObjectHelper areaFromSQLResult:dictionary usingPath:path ]];
+    }];
+  }
+  
+  return objects;
+}
+
+- (NSArray *)tasksForTaskIdentifiedBy:(NSString *)uuid usingDatabaseAt:(NSString *)path {
+  NSString *query = [NSString stringWithFormat: @"SELECT "
+            "uuid, "
+            "creationDate, "
+            "status, "
+            "title, "
+            "notes, "
+            "area "
+            "FROM TMTask "
+            "WHERE project = '%@' "
+            "AND type = 0 "
+            "AND trashed = 0 "
+            "AND status = 0 "
+            "ORDER BY title;", uuid];
+  
+  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
+
+NS_ASSUME_NONNULL_END