Module: OmnifocusMcp::Tools::DatabaseStats

Defined in:
lib/omnifocus_mcp/tools/database_stats.rb

Overview

Lightweight database overview helpers that don’t require pulling the full OmniFocus dataset.

Provides:

* {.get_database_stats} — counts + last-modified timestamp
* {.get_changes_since}  — incremental change feed since a timestamp

rubocop:disable Metrics/ModuleLength

Constant Summary collapse

STATS_SCRIPT = 
<<~JS
  (() => {
    try {
      const allTasks = flattenedTasks;
      const activeTasks = allTasks.filter(task =>
        task.taskStatus !== Task.Status.Completed &&
        task.taskStatus !== Task.Status.Dropped
      );

      const allProjects = flattenedProjects;
      const activeProjects = allProjects.filter(project =>
        project.status === Project.Status.Active
      );

      const overdueCount = activeTasks.filter(task =>
        task.taskStatus === Task.Status.Overdue
      ).length;

      const nextActionCount = activeTasks.filter(task =>
        task.taskStatus === Task.Status.Next
      ).length;

      const flaggedCount = activeTasks.filter(task => task.flagged).length;
      const inboxCount = activeTasks.filter(task => task.inInbox).length;

      let lastModified = new Date(0);
      allTasks.forEach(task => {
        if (task.modificationDate && task.modificationDate > lastModified) {
          lastModified = task.modificationDate;
        }
      });

      return JSON.stringify({
        taskCount: allTasks.length,
        activeTaskCount: activeTasks.length,
        projectCount: allProjects.length,
        activeProjectCount: activeProjects.length,
        folderCount: flattenedFolders.length,
        tagCount: flattenedTags.filter(tag => tag.active).length,
        overdueCount: overdueCount,
        nextActionCount: nextActionCount,
        flaggedCount: flaggedCount,
        inboxCount: inboxCount,
        lastModified: lastModified.toISOString()
      });

    } catch (error) {
      return JSON.stringify({
        error: "Failed to get database stats: " + error.toString()
      });
    }
  })();
JS

Class Method Summary collapse

Class Method Details

.changes_script(since_iso) ⇒ Object

rubocop:disable Metrics/MethodLength



91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
 
# File 'lib/omnifocus_mcp/tools/database_stats.rb', line 91

def changes_script(since_iso)
  escaped_since = Infrastructure::JsEmbed.double_quoted_string(since_iso)

  <<~JS
    (() => {
      try {
        const sinceDate = new Date("#{escaped_since}");

        const allTasks = flattenedTasks;

        const newTasks = allTasks.filter(task =>
          task.creationDate && task.creationDate > sinceDate
        ).map(task => ({
          id: task.id.primaryKey,
          name: task.name,
          creationDate: task.creationDate.toISOString()
        }));

        const updatedTasks = allTasks.filter(task =>
          task.modificationDate &&
          task.modificationDate > sinceDate &&
          task.creationDate &&
          task.creationDate <= sinceDate
        ).map(task => ({
          id: task.id.primaryKey,
          name: task.name,
          modificationDate: task.modificationDate.toISOString()
        }));

        const completedTasks = allTasks.filter(task =>
          task.completionDate &&
          task.completionDate > sinceDate
        ).map(task => ({
          id: task.id.primaryKey,
          name: task.name,
          completionDate: task.completionDate.toISOString()
        }));

        const allProjects = flattenedProjects;

        const newProjects = allProjects.filter(project =>
          project.creationDate && project.creationDate > sinceDate
        ).map(project => ({
          id: project.id.primaryKey,
          name: project.name,
          creationDate: project.creationDate.toISOString()
        }));

        const updatedProjects = allProjects.filter(project =>
          project.modificationDate &&
          project.modificationDate > sinceDate &&
          project.creationDate &&
          project.creationDate <= sinceDate
        ).map(project => ({
          id: project.id.primaryKey,
          name: project.name,
          modificationDate: project.modificationDate.toISOString()
        }));

        return JSON.stringify({
          newTasks: newTasks,
          updatedTasks: updatedTasks,
          completedTasks: completedTasks,
          newProjects: newProjects,
          updatedProjects: updatedProjects
        });

      } catch (error) {
        return JSON.stringify({
          error: "Failed to get changes: " + error.toString()
        });
      }
    })();
  JS
end

.get_changes_since(since) ⇒ OmnifocusMcp::Result

Incremental change feed since ‘since` (a Time, DateTime, or ISO string).

Returns:



30
31
32
33
34
 
# File 'lib/omnifocus_mcp/tools/database_stats.rb', line 30

def get_changes_since(since)
  require_relative "operations/database_stats"

  Operations::DatabaseStats.get_changes_since(since)
end

.get_database_stats ⇒ Object 



21
22
23
24
25
 
# File 'lib/omnifocus_mcp/tools/database_stats.rb', line 21

def get_database_stats
  require_relative "operations/database_stats"

  Operations::DatabaseStats.get_database_stats
end