Changeset 32 for trunk/AnalyzeCustomField

Timestamp:

02/16/2012 11:46:39 PM (15 months ago)

Author:

matobaa

Message:

append trac-admin command

Location:

trunk/AnalyzeCustomField

Files:

• analyzecustomfield/admin.py (modified) (5 diffs)
• setup.py (modified) (1 diff)

trunk/AnalyzeCustomField/analyzecustomfield/admin.py

@@ -3 +3 @@
 
 from pkg_resources import ResourceManager
-from trac.admin.api import IAdminPanelProvider
+from trac.admin.api import IAdminPanelProvider, IAdminCommandProvider
 from trac.core import Component, implements
 from trac.ticket.api import TicketSystem
 from trac.util.translation import _
 from trac.web.chrome import ITemplateProvider
+import json
 
 # なにを見たいか?
@@ -19 +20 @@
 # レポートを書き換える必要があるかもしれない
 
-class Analyzer(Component):
+def analyze(self):
     count_values = """
         SELECT name, COUNT(value) FROM (
@@ -27 +28 @@
     count_all = "SELECT count(id) from ticket"
     
-    implements(ITemplateProvider, IAdminPanelProvider )
+    ticket = TicketSystem(self.env)
+    cfields = ticket.get_custom_fields()
+    db = self.env.get_read_db()
+    cursor = db.cursor()
+    # QTY of Valid data, without Default value
+    valid = {}
+    cursor.execute(count_valid)
+    for name, count in cursor:
+        valid[name] = count
+    # QTY of data valiation for valiation
+    cursor.execute(count_values)
+    valiation = {}
+    for name, count in cursor:
+        valiation[name] = count
+    # rebuild cfields
+    for field in cfields:
+        field['valiation'] = valiation.get(field['name'], 0)
+        field['valid'] = valid.get(field['name'], 0)
+    data = {'cfields':cfields}
+    # Ticket QTY
+    cursor.execute(count_all)
+    data['qty'] = cursor.fetchone()
+    # build notdefined list
+    notdefined = []
+    for name in [name for name in valid.keys() if name not in [field.get('name') for field in cfields]]:
+        notdefined.append({
+                        'name':name,
+                        'label':'N/A',
+                        'type':'N/A',
+                        'valiation':valiation.get(name, 0),
+                        'valid':valid.get(name, 0)})
+    data['notdefined'] = notdefined
+    return data
+
+class AdminPanel(Component):
+    implements(ITemplateProvider, IAdminPanelProvider)
 
     # ITemplateProvider methods
@@ -36 +72 @@
         return []
 
-    #IAdminPanelProvider methods
+    # IAdminPanelProvider methods
     def get_admin_panels(self,req):
         if 'TICKET_ADMIN' in req.perm:
@@ -44 +80 @@
     def render_admin_panel(self, req, category, page, path_info):
         req.perm.require('TICKET_ADMIN')
-        data = self._analyze()
+        data = analyze(self)
         return ('analayzecustomfield.html', data)
 
-    def _analyze(self):
-        ticket = TicketSystem(self.env)
-        cfields = ticket.get_custom_fields()
-        db = self.env.get_read_db()
-        cursor = db.cursor()
-        # QTY of Valid data, without Default value
-        valid = {}
-        cursor.execute(self.count_valid)
-        for name, count in cursor:
-            valid[name] = count
-        # QTY of data valiation for valiation
-        cursor.execute(self.count_values)
-        valiation = {}
-        for name, count in cursor:
-            valiation[name] = count
-        # rebuild cfields
-        for field in cfields:
-            field['valiation'] = valiation.get(field['name'], 0)
-            field['valid'] = valid.get(field['name'], 0)
-        data = {'cfields':cfields}
-        # Ticket QTY
-        cursor.execute(self.count_all)
-        data['qty'] = cursor.fetchone()
-        # build notdefined list
-        notdefined = []
-        for name in [name for name in valid.keys() if name not in [field.get('name') for field in cfields]]:
-            notdefined.append({
-                            'name':name,
-                            'label':'N/A',
-                            'type':'N/A',
-                            'valiation':valiation.get(name, 0),
-                            'valid':valid.get(name, 0)})
-        data['notdefined'] = notdefined
-        return data
+class Command(Component):
+    implements(IAdminCommandProvider)
+    
+    # IAdminCommandProvider methods
+    def get_admin_commands(self):
+        yield ('customfield analyze', '', 'Analyze custom field', None, self.command)
+    
+    def command(self):
+        data = analyze(self)
+        print json.dumps(data, indent=2)

trunk/AnalyzeCustomField/setup.py

@@ -6 +6 @@
 setup(
     name='AnalyzeCustomField',
-    version='0.1',
+    version='0.2',
     license='Modified BSD',
     author='MATOBA Akihiro',