Module Expr Str ImportFrom alias alias alias alias alias alias alias alias Import alias ImportFrom alias alias ImportFrom alias ImportFrom alias ImportFrom alias Import alias Assign NameStore Call AttributeLoad NameLoad attr NameLoad Expr Str Assign NameStore BinOpAdd BinOpMult BinOpMult BinOpMult BinOpMult Num Num Num Num Num BinOpMult BinOpMult BinOpMult Num Num Num Num ClassDef bases NameLoad body FunctionDef arguments args NameParam NameParam NameParam defaults body Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body If CompareEq AttributeLoad NameLoad attr NameLoad body Expr Call AttributeLoad NameLoad attr Str AttributeLoad AttributeLoad NameLoad attr attr Assign NameStore Call NameLoad AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Str AttributeLoad AttributeLoad NameLoad attr attr Assign AttributeStore NameLoad attr ListLoad For NameStore Call AttributeLoad NameLoad attr Str body Assign NameStore ListLoad For NameStore Call AttributeLoad NameLoad attr Str body If CompareNotEq AttributeLoad NameLoad attr NameLoad body Assign NameStore AttributeLoad AttributeLoad NameLoad attr attr If CompareNotEq NameLoad NameLoad body Assign NameStore Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad AttributeLoad NameLoad attr attr Call AttributeLoad Str attr NameLoad Expr Call AttributeLoad NameLoad attr Str AttributeLoad AttributeLoad NameLoad attr attr Return AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body If CompareEq AttributeLoad NameLoad attr NameLoad body Assign AttributeStore NameLoad attr Call AttributeLoad Str attr Call AttributeLoad NameLoad attr Return AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam defaults body TryExcept body Return Call NameLoad NameLoad handlers ExceptHandler body Assign NameStore ListLoad For NameStore NameLoad body TryExcept body Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad handlers ExceptHandler body Expr Call AttributeLoad NameLoad attr Str Return Call AttributeLoad Str attr NameLoad decorator_list decorator_list FunctionDef arguments args NameParam NameParam defaults body Assign NameStore SubscriptLoad NameLoad Index NameLoad If CompareEq NameLoad NameLoad body Return NameLoad Return Call AttributeLoad NameLoad attr BinOpAdd NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Assign NameStore SubscriptLoad NameLoad Index NameLoad If CompareEq NameLoad NameLoad body Return NameLoad Return NameLoad decorator_list ClassDef bases NameLoad body Assign NameStore Str Assign NameStore ListLoad Str Str Str Str Str Str Assign NameStore Call NameLoad Str NameLoad FunctionDef arguments args NameParam NameParam defaults body Expr Call AttributeLoad NameLoad attr NameLoad keyword SubscriptLoad NameLoad Index Str Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr SubscriptLoad NameLoad Index Str If CompareIn Str NameLoad body Assign AttributeStore NameLoad attr SubscriptLoad NameLoad Index Str Assign AttributeStore NameLoad attr BinOpAdd Str SubscriptLoad NameLoad Index Str Assign AttributeStore NameLoad attr IfExp BoolOpAnd CompareIn Str NameLoad CompareEq SubscriptLoad NameLoad Index Str Num Str Str Expr Call AttributeLoad NameLoad attr Str AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list decorator_list ClassDef bases NameLoad body Assign NameStore Str Assign NameStore ListLoad Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Assign NameStore Call NameLoad Str NameLoad FunctionDef arguments args NameParam NameParam defaults body Expr Call AttributeLoad NameLoad attr NameLoad keyword SubscriptLoad NameLoad Index Str keyword Call NameLoad NameLoad Str keyword Call NameLoad NameLoad Str keyword Call NameLoad NameLoad Str keyword Call NameLoad NameLoad Str keyword Call NameLoad NameLoad Str keyword Call NameLoad SubscriptLoad NameLoad Index Str keyword NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr SubscriptLoad NameLoad Index Str If CompareIn Str NameLoad body Assign AttributeStore NameLoad attr SubscriptLoad NameLoad Index Str Assign AttributeStore NameLoad attr BinOpAdd Str SubscriptLoad NameLoad Index Str Assign NameStore SubscriptLoad NameLoad Index Str If CompareNotEq NameLoad NameLoad body Assign AttributeStore NameLoad attr Call NameLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Str AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list decorator_list ClassDef bases NameLoad body Assign NameStore Str Assign NameStore ListLoad Str Str Str Str Str Str Assign NameStore Call NameLoad Str NameLoad FunctionDef arguments args NameParam NameParam defaults body Expr Call AttributeLoad NameLoad attr NameLoad keyword SubscriptLoad NameLoad Index Str Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr SubscriptLoad NameLoad Index Str If CompareIn Str NameLoad body Assign AttributeStore NameLoad attr SubscriptLoad NameLoad Index Str Assign AttributeStore NameLoad attr BinOpAdd Str SubscriptLoad NameLoad Index Str Expr Call AttributeLoad NameLoad attr Str AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list decorator_list ClassDef bases NameLoad body Assign NameStore Str Assign NameStore ListLoad Str Str Str Str Assign NameStore Call NameLoad Str NameLoad Assign NameStore Call NameLoad Str NameLoad FunctionDef arguments args NameParam NameParam defaults body Expr Call AttributeLoad NameLoad attr NameLoad Str Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr SubscriptLoad NameLoad Index Str Assign AttributeStore NameLoad attr IfExp CompareEq SubscriptLoad NameLoad Index Str NameLoad NameLoad Call NameLoad SubscriptLoad NameLoad Index Str decorator_list decorator_list ClassDef bases NameLoad body Assign NameStore Call NameLoad Str NameLoad Assign NameStore Call NameLoad Str NameLoad Assign NameStore Call NameLoad Str NameLoad FunctionDef arguments args NameParam defaults body Pass decorator_list decorator_list FunctionDef arguments args NameParam NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore AttributeLoad NameLoad attr Assign NameStore Dict For NameStore Call AttributeLoad NameLoad attr BinOpAdd BinOpAdd BinOpAdd Str Call AttributeLoad Str attr NameLoad Str AttributeLoad NameLoad attr body Assign NameStore Dict For NameStore Call NameLoad Num Call NameLoad NameLoad body Assign NameStore SubscriptLoad NameLoad Index NameLoad Assign NameStore SubscriptLoad NameLoad Index NameLoad Assign SubscriptStore NameLoad Index NameLoad NameLoad Assign NameStore Call NameLoad NameLoad Assign SubscriptStore NameLoad Index SubscriptLoad NameLoad Index SubscriptLoad NameLoad Index Num NameLoad Expr Call AttributeLoad NameLoad attr Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr Str Assign NameStore Dict For NameStore Call AttributeLoad NameLoad attr body If CompareNotEq SubscriptLoad AttributeLoad NameLoad attr Index Str NameLoad body Expr Call AttributeLoad NameLoad attr Str AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign SubscriptStore NameLoad Index SubscriptLoad AttributeLoad NameLoad attr Index Str NameLoad Assign NameStore SubscriptLoad NameLoad Index SubscriptLoad AttributeLoad NameLoad attr Index Str Assign AttributeStore NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr AttributeLoad NameLoad attr Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Call AttributeLoad NameLoad attr Str For NameStore Call AttributeLoad NameLoad attr body Assign NameStore AttributeLoad NameLoad attr If CompareNotEq AttributeLoad NameLoad attr NameLoad body Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index Str If CompareNotEq NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr Str AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign NameStore SubscriptLoad NameLoad Index NameLoad Assign AttributeStore NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad If CompareNotEq AttributeLoad NameLoad attr NameLoad body Assign NameStore SubscriptLoad NameLoad Index AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Str For NameStore Call AttributeLoad NameLoad attr body If CompareNotEq SubscriptLoad AttributeLoad NameLoad attr Index Str NameLoad body Expr Call AttributeLoad NameLoad attr Str AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign NameStore SubscriptLoad NameLoad Index SubscriptLoad AttributeLoad NameLoad attr Index Str Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Call AttributeLoad NameLoad attr Str For NameStore Call AttributeLoad NameLoad attr body If CompareNotEq SubscriptLoad AttributeLoad NameLoad attr Index Str NameLoad body Expr Call AttributeLoad NameLoad attr Str AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign NameStore SubscriptLoad NameLoad Index SubscriptLoad AttributeLoad NameLoad attr Index Str Assign NameStore AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr NameLoad orelse If SubscriptLoad AttributeLoad NameLoad attr Index Str body Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Call AttributeLoad NameLoad attr Str For NameStore Call AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr Str AttributeLoad NameLoad attr AttributeLoad NameLoad attr If CompareNotEq SubscriptLoad AttributeLoad NameLoad attr Index Str NameLoad body Assign NameStore SubscriptLoad NameLoad Index SubscriptLoad AttributeLoad NameLoad attr Index Str Assign AttributeStore NameLoad attr NameLoad Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad orelse Assign AttributeStore NameLoad attr NameLoad Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Str For NameStore Call AttributeLoad NameLoad attr body If CompareNotEq SubscriptLoad AttributeLoad NameLoad attr Index Str NameLoad body Expr Call AttributeLoad NameLoad attr Str AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign NameStore SubscriptLoad NameLoad Index SubscriptLoad AttributeLoad NameLoad attr Index Str Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad NameLoad attr Str For NameStore Call AttributeLoad NameLoad attr body If CompareNotEq SubscriptLoad AttributeLoad NameLoad attr Index Str NameLoad body Expr Call AttributeLoad NameLoad attr Str AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign NameStore SubscriptLoad NameLoad Index SubscriptLoad AttributeLoad NameLoad attr Index Str Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore ListLoad For NameStore NameLoad body If CompareEq AttributeLoad NameLoad attr NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call NameLoad NameLoad keyword NameLoad Assign NameStore Call NameLoad keyword Str Assign NameStore Call NameLoad keyword Str Assign NameStore Call NameLoad NameLoad keyword NameLoad Assign NameStore Call NameLoad NameLoad keyword NameLoad Assign NameStore Call NameLoad NameLoad keyword NameLoad Assign NameStore Call NameLoad NameLoad NameLoad Expr Call NameLoad NameLoad NameLoad NameLoad Expr Call NameLoad NameLoad Expr Call NameLoad NameLoad NameLoad NameLoad Expr Call NameLoad NameLoad NameLoad NameLoad Expr Call NameLoad NameLoad Expr Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr Assign NameStore Call NameLoad Call AttributeLoad NameLoad attr Assign NameStore Call NameLoad Call AttributeLoad NameLoad attr Assign NameStore BinOpAdd NameLoad NameLoad Assign NameStore Call NameLoad Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Num NameLoad Expr Call AttributeLoad NameLoad attr Num NameLoad Expr Call NameLoad NameLoad Expr Call NameLoad NameLoad Assign NameStore Call NameLoad keyword Str For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call NameLoad keyword Str keyword Str For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad Return TupleLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore SubscriptLoad NameLoad Index Str Assign NameStore ListComp BinOpAdd NameLoad NameLoad comprehension NameStore NameLoad For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr Str NameLoad If Call AttributeLoad NameLoad attr NameLoad body Expr Call AttributeLoad NameLoad attr Str NameLoad Return NameLoad Raise Call NameLoad BinOpAdd Str NameLoad decorator_list
N/A N/A 
Copyright 2013 Paul Sidnell

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
 treemodel PROJECT Project Node Task Context Folder Note sort N/A sqlite3 os environ path datetime datetime typeof TypeOf xml.dom.minidom parseString N/A logging N/A logger N/A N/A logging getLogger __name__ N/A 
A library for loading a data model from the Omnifocus SQLite database.

---------
Notes on discovering what the Omni schema looks like

sqlite3 ~/Library/Caches/com.omnigroup.OmniFocus/OmniFocusDatabase2

.tables
Attachment   Folder       Perspective  Setting    
Context      ODOMetadata  ProjectInfo  Task       

sqlite> .schema Task
CREATE TABLE Task (persistentIdentifier text NOT NULL PRIMARY KEY, blocked integer NOT NULL, blockedByFutureStartDate integer NOT NULL, 
childrenCount integer NOT NULL, childrenCountAvailable integer NOT NULL, childrenCountCompleted integer NOT NULL, completeWhenChildrenComplete integer NOT NULL,
containingProjectContainsSingletons integer NOT NULL, containingProjectInfo text, containsNextTask integer NOT NULL, context text, creationOrdinal integer,
dateAdded timestamp NOT NULL, dateCompleted timestamp, dateDue timestamp, dateModified timestamp NOT NULL, dateToStart timestamp, effectiveContainingProjectInfoActive integer NOT NULL,
effectiveContainingProjectInfoRemaining integer NOT NULL, effectiveDateDue timestamp, effectiveDateToStart timestamp, effectiveFlagged integer NOT NULL,
effectiveInInbox integer NOT NULL, estimatedMinutes integer, flagged integer NOT NULL, hasCompletedDescendant integer NOT NULL, hasFlaggedTaskInTree integer NOT NULL,
hasUnestimatedLeafTaskInTree integer NOT NULL, inInbox integer NOT NULL, isDueSoon integer NOT NULL, isOverdue integer NOT NULL, maximumEstimateInTree integer,
minimumEstimateInTree integer, name text, nextTaskOfProjectInfo text, noteXMLData blob, parent text, projectInfo text, rank integer NOT NULL, repetitionMethodString text,
repetitionRuleString text, sequential integer NOT NULL);
CREATE INDEX Task_containingProjectInfo on Task (containingProjectInfo);
CREATE INDEX Task_context on Task (context);
CREATE INDEX Task_nextTaskOfProjectInfo on Task (nextTaskOfProjectInfo);
CREATE INDEX Task_parent on Task (parent);
CREATE INDEX Task_projectInfo on Task (projectInfo);

.schema ProjectInfo
CREATE TABLE ProjectInfo (pk text NOT NULL PRIMARY KEY, containsSingletonActions integer NOT NULL, folder text, folderEffectiveActive integer NOT NULL,
lastReviewDate timestamp, minimumDueDate timestamp, nextReviewDate timestamp, nextTask text, numberOfAvailableTasks integer NOT NULL, numberOfDueSoonTasks integer NOT NULL,
numberOfOverdueTasks integer NOT NULL, numberOfRemainingTasks integer NOT NULL, reviewRepetitionString text, status text NOT NULL, task text, taskBlocked integer NOT NULL,
taskBlockedByFutureStartDate integer NOT NULL, taskDateToStart timestamp);
CREATE INDEX ProjectInfo_folder on ProjectInfo (folder);
CREATE INDEX ProjectInfo_nextTask on ProjectInfo (nextTask);
CREATE INDEX ProjectInfo_task on ProjectInfo (task);


sqlite> .schema Folder
CREATE TABLE Folder (persistentIdentifier text NOT NULL PRIMARY KEY, active integer NOT NULL, childrenCount integer NOT NULL, creationOrdinal integer,
dateAdded timestamp NOT NULL, dateModified timestamp NOT NULL, effectiveActive integer NOT NULL, name text, noteXMLData blob, numberOfAvailableTasks integer NOT NULL,
numberOfDueSoonTasks integer NOT NULL, numberOfOverdueTasks integer NOT NULL, parent text, rank integer NOT NULL);
CREATE INDEX Folder_parent on Folder (parent);


.schema Context
CREATE TABLE Context (persistentIdentifier text NOT NULL PRIMARY KEY, active integer NOT NULL, allowsNextAction integer NOT NULL, altitude real,
availableTaskCount integer NOT NULL, childrenCount integer NOT NULL, creationOrdinal integer, dateAdded timestamp NOT NULL, dateModified timestamp NOT NULL,
effectiveActive integer NOT NULL, latitude real, localNumberOfDueSoonTasks integer NOT NULL, localNumberOfOverdueTasks integer NOT NULL, locationName text,
longitude real, name text, noteXMLData blob, notificationFlags integer, parent text, radius real, rank integer NOT NULL, remainingTaskCount integer NOT NULL,
totalNumberOfDueSoonTasks integer NOT NULL, totalNumberOfOverdueTasks integer NOT NULL);
CREATE INDEX Context_parent on Context (parent);

.schema Perspective (no name!!!)

CREATE TABLE Perspective (persistentIdentifier text NOT NULL PRIMARY KEY, creationOrdinal integer, dateAdded timestamp NOT NULL, dateModified timestamp NOT NULL, valueData blob);
 N/A THIRTY_ONE_YEARS N/A N/A N/A N/A N/A 60 60 24 365 31 N/A N/A N/A 60 60 24 8 OFNote N/A Note N/A __init__ N/A N/A self item noteXMLData N/A N/A N/A N/A self noteXMLData noteXMLData N/A N/A self item item N/A N/A self text None N/A N/A self lines None N/A get_note_lines N/A N/A self N/A N/A N/A N/A N/A self lines None N/A N/A N/A N/A logger debug %s note: parsing xml N/A N/A self item id N/A dom N/A parseString N/A self noteXMLData N/A N/A N/A logger debug %s note: collating lines N/A N/A self item id N/A N/A self lines N/A N/A para N/A N/A dom getElementsByTagName p N/A N/A line N/A N/A lit N/A N/A para getElementsByTagName lit N/A N/A N/A N/A lit firstChild None N/A N/A nodeValue N/A N/A lit firstChild nodeValue N/A N/A nodeValue None N/A N/A text N/A N/A self fix_dodgy_chars nodeValue N/A N/A N/A line append text N/A N/A N/A N/A self lines append N/A N/A join line N/A N/A N/A logger debug %s note: processed N/A N/A self item id N/A N/A self lines N/A get_note N/A N/A self N/A N/A N/A N/A N/A self text None N/A N/A N/A self text N/A N/A join N/A N/A self get_note_lines N/A N/A self text N/A fix_dodgy_chars N/A N/A self text N/A N/A N/A N/A N/A N/A unicode text N/A N/A N/A N/A buf N/A N/A c text N/A N/A N/A N/A N/A N/A buf append N/A unicode c N/A N/A N/A N/A N/A N/A buf append ? N/A N/A N/A join buf N/A N/A datetimeFromAttrib N/A N/A ofattribs name N/A N/A N/A val N/A ofattribs N/A name N/A N/A val None N/A N/A None N/A N/A N/A datetime fromtimestamp N/A THIRTY_ONE_YEARS val N/A intFromAttrib N/A N/A ofattribs name N/A N/A N/A val N/A ofattribs N/A name N/A N/A val None N/A N/A None N/A val N/A OFContext N/A Context N/A N/A TABLE context N/A COLUMNS N/A persistentIdentifier name parent childrenCount rank allowsNextAction N/A ofattribs N/A TypeOf ofattribs dict __init__ N/A N/A self ofattribs N/A N/A N/A N/A N/A Context __init__ self name N/A ofattribs N/A name N/A N/A self ofattribs ofattribs N/A N/A self order N/A ofattribs N/A rank N/A N/A persistentIdentifier ofattribs N/A N/A N/A self id N/A ofattribs N/A persistentIdentifier N/A N/A self link N/A omnifocus:///context/ N/A ofattribs N/A persistentIdentifier N/A N/A self status N/A N/A N/A allowsNextAction ofattribs N/A N/A ofattribs N/A allowsNextAction 0 inactive active N/A N/A N/A logger debug loaded context: %s %s N/A self id N/A self name N/A N/A OFTask N/A Task N/A N/A TABLE task N/A COLUMNS N/A persistentIdentifier name inInbox dateDue dateCompleted dateToStart dateDue dateAdded estimatedMinutes projectInfo context containingProjectInfo childrenCount parent rank flagged noteXMLData N/A ofattribs N/A TypeOf ofattribs dict __init__ N/A N/A self ofattribs N/A N/A N/A N/A N/A Task __init__ self name N/A ofattribs N/A name date_completed N/A datetimeFromAttrib ofattribs dateCompleted date_to_start N/A datetimeFromAttrib ofattribs dateToStart date_due N/A datetimeFromAttrib ofattribs dateDue date_added N/A datetimeFromAttrib ofattribs dateAdded estimated_minutes N/A intFromAttrib ofattribs estimatedMinutes flagged N/A bool N/A ofattribs N/A flagged context None N/A N/A self ofattribs ofattribs N/A N/A self order N/A ofattribs N/A rank N/A N/A persistentIdentifier ofattribs N/A N/A N/A self id N/A ofattribs N/A persistentIdentifier N/A N/A self link N/A omnifocus:///task/ N/A ofattribs N/A persistentIdentifier N/A noteXMLData N/A ofattribs N/A noteXMLData N/A N/A noteXMLData None N/A N/A N/A self note N/A OFNote self noteXMLData N/A N/A N/A logger debug loaded task: %s %s N/A self id N/A self name N/A N/A OFFolder N/A Folder N/A N/A TABLE folder N/A COLUMNS N/A persistentIdentifier name childrenCount parent rank noteXMLData N/A ofattribs N/A TypeOf ofattribs dict __init__ N/A N/A self ofattribs N/A N/A N/A N/A N/A Folder __init__ self name N/A ofattribs N/A name N/A N/A self ofattribs ofattribs N/A N/A self order N/A ofattribs N/A rank N/A N/A persistentIdentifier ofattribs N/A N/A N/A self id N/A ofattribs N/A persistentIdentifier N/A N/A self link N/A omnifocus:///folder/ N/A ofattribs N/A persistentIdentifier N/A N/A N/A logger debug loaded folder: %s %s N/A self id N/A self name N/A N/A ProjectInfo N/A Node N/A N/A TABLE projectinfo N/A COLUMNS N/A pk folder status nextTask N/A status N/A TypeOf status unicode N/A nextTask N/A TypeOf nextTask str __init__ N/A N/A self ofattribs N/A N/A N/A N/A N/A Node __init__ self ProjectInfo N/A N/A self ofattribs ofattribs N/A N/A self status N/A ofattribs N/A status N/A N/A self next_task N/A N/A N/A ofattribs N/A nextTask None None N/A str N/A ofattribs N/A nextTask N/A N/A OFProject N/A Project N/A N/A ofattribs N/A TypeOf ofattribs dict N/A folder N/A TypeOf folder Folder N/A project_info N/A TypeOf project_info ProjectInfo __init__ N/A N/A self N/A N/A N/A N/A N/A query N/A N/A conn clazz N/A N/A N/A c N/A N/A conn cursor N/A columns N/A clazz COLUMNS N/A results N/A N/A row N/A N/A c execute N/A N/A N/A SELECT  N/A N/A , join columns  from  N/A clazz TABLE N/A N/A rowData N/A N/A i N/A range 0 N/A len columns N/A N/A key N/A columns N/A i N/A val N/A row N/A i N/A N/A rowData N/A key val N/A node N/A clazz rowData N/A N/A results N/A N/A rowData N/A N/A columns N/A 0 node N/A N/A N/A c close N/A results N/A transmute_projects N/A N/A project_infos tasks N/A N/A N/A 
    Some tasks are actually projects, convert them
     N/A N/A N/A logger debug transmuting projects N/A projects N/A N/A project N/A N/A tasks values N/A N/A N/A N/A N/A project ofattribs N/A projectInfo None N/A N/A N/A N/A logger debug transmuting: %s %s N/A project id N/A project name N/A N/A projects N/A N/A N/A project ofattribs N/A persistentIdentifier project N/A project_info N/A project_infos N/A N/A N/A project ofattribs N/A projectInfo N/A N/A project __class__ OFProject N/A N/A N/A project __init__ N/A N/A project_info project project N/A N/A project type PROJECT N/A N/A project project_info project_info N/A N/A project status N/A project_info status N/A projects N/A wire_projects_and_folders N/A N/A projects folders tasks N/A N/A N/A N/A N/A logger debug wiring projects and folders N/A project N/A N/A projects values N/A N/A project_info N/A project project_info N/A N/A N/A project project_info None N/A N/A folder_ref N/A N/A project_info ofattribs N/A folder N/A N/A folder_ref None N/A N/A N/A N/A logger debug wiring: %s %s N/A project id N/A project name N/A folder N/A folders N/A folder_ref N/A N/A project folder folder N/A N/A N/A folder add_child project N/A N/A N/A project_info next_task None N/A N/A task N/A tasks N/A N/A project_info next_task N/A N/A task next True N/A wire_task_hierarchy N/A N/A tasks N/A N/A N/A N/A N/A logger debug wiring type hierarchy N/A task N/A N/A tasks values N/A N/A N/A N/A N/A task ofattribs N/A parent None N/A N/A N/A N/A logger debug wiring: %s %s N/A task id N/A task name N/A parent N/A tasks N/A N/A N/A task ofattribs N/A parent N/A N/A N/A parent add_child task N/A wire_tasks_to_enclosing_projects N/A N/A project_infos tasks inbox N/A N/A N/A N/A N/A logger debug wiring tasks to enclosing projects N/A task N/A N/A tasks values N/A N/A N/A N/A N/A task ofattribs N/A containingProjectInfo None N/A N/A N/A N/A logger debug wiring: %s %s N/A task id N/A task name N/A project_info N/A project_infos N/A N/A N/A task ofattribs N/A containingProjectInfo N/A project N/A project_info project N/A N/A task project project N/A N/A N/A N/A task ofattribs N/A inInbox N/A N/A N/A N/A inbox add_child task N/A wire_tasks_and_contexts N/A N/A contexts tasks no_context N/A N/A N/A N/A N/A logger debug wiring tasks and contexts N/A task N/A N/A tasks values N/A N/A N/A N/A logger debug wiring: %s %s N/A task id N/A task name N/A N/A N/A N/A task ofattribs N/A context None N/A N/A context N/A contexts N/A N/A N/A task ofattribs N/A context N/A N/A task context context N/A N/A N/A N/A context children append task N/A N/A N/A task context no_context N/A N/A N/A N/A no_context children append task N/A wire_folder_hierarchy N/A N/A folders N/A N/A N/A N/A N/A logger debug wiring folder hierarchy N/A folder N/A N/A folders values N/A N/A N/A N/A N/A folder ofattribs N/A parent None N/A N/A N/A N/A logger debug wiring: %s %s N/A folder id N/A folder name N/A parent N/A folders N/A N/A N/A folder ofattribs N/A parent N/A N/A N/A parent add_child folder N/A wire_context_hierarchy N/A N/A contexts N/A N/A N/A N/A N/A logger debug wiring context hierarchy N/A context N/A N/A contexts values N/A N/A N/A N/A N/A context ofattribs N/A parent None N/A N/A N/A N/A logger debug wiring: %s %s N/A context id N/A context name N/A parent N/A contexts N/A N/A N/A context ofattribs N/A parent N/A N/A N/A parent add_child context N/A only_roots N/A N/A items N/A N/A N/A roots N/A N/A item items N/A N/A N/A N/A item parent None N/A N/A N/A N/A roots append item N/A roots N/A build_model N/A N/A db N/A N/A N/A conn N/A N/A sqlite3 connect db N/A contexts N/A query conn clazz OFContext N/A no_context N/A Context name No Context N/A inbox N/A Project name Inbox N/A project_infos N/A query conn clazz ProjectInfo N/A folders N/A query conn clazz OFFolder N/A tasks N/A query conn clazz OFTask N/A projects N/A transmute_projects project_infos tasks N/A N/A wire_projects_and_folders projects folders tasks N/A N/A wire_task_hierarchy tasks N/A N/A wire_tasks_to_enclosing_projects project_infos tasks inbox N/A N/A wire_tasks_and_contexts contexts tasks no_context N/A N/A wire_folder_hierarchy folders N/A N/A wire_context_hierarchy contexts N/A N/A N/A conn close N/A project_roots N/A only_roots N/A N/A projects values N/A folder_roots N/A only_roots N/A N/A folders values N/A root_projects_and_folders N/A project_roots folder_roots N/A root_contexts N/A only_roots N/A N/A contexts values N/A N/A N/A root_contexts insert 0 no_context N/A N/A N/A root_projects_and_folders insert 0 inbox N/A N/A sort root_projects_and_folders N/A N/A sort root_contexts N/A root_folder N/A Folder name N/A child root_projects_and_folders N/A N/A N/A N/A root_folder add_child child N/A root_context N/A Context name status active N/A child root_contexts N/A N/A N/A N/A root_context add_child child N/A N/A root_folder root_context N/A find_database N/A N/A databases N/A N/A N/A home N/A environ N/A HOME N/A databases N/A N/A home x N/A x databases N/A db databases N/A N/A N/A N/A logger debug testing for db %s db N/A N/A N/A path exists db N/A N/A N/A N/A logger info found db %s db N/A db N/A N/A IOError N/A cannot find OmnifocusDatabase in  databases N/A