Changeset 3513

Timestamp:

04/14/08 01:28:38 (8 months ago)

Author:

tcoulter

Message:

First implementation finished! If there are incoming links for a ticket, they will be displayed in the "Incoming Links" section right after the ticket info.

Most of the changes made since the last commit were simply to get the data to display properly/nicely.

Because of the use of Transformer, this plugin requires Genshi trunk.

Files:

• trashtalkplugin/0.11/setup.py (modified) (1 diff)
• trashtalkplugin/0.11/trashtalk/htdocs (added)
• trashtalkplugin/0.11/trashtalk/htdocs/trashtalk.css (added)
• trashtalkplugin/0.11/trashtalk/trashtalk.py (modified) (8 diffs)

trashtalkplugin/0.11/setup.py

@@ -1 +1 @@
-from setuptools import find_packages, setup
-
-# name can be any name.  This name will be used to create .egg file.
-# name that is used in packages is the one that is used in the trac.ini file.
-# use package name as entry_points
-setup(
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-)
-

trashtalkplugin/0.11/trashtalk/trashtalk.py

@@ -29 +29 @@
-
-Some methods below were legally pilferred from the tracpasteplugin:
-d
+
-"""
-
-import re
-
+from genshi.core import Markup
-from genshi.builder import tag
+from genshi.filters.transform import Transformer
-
-from trac.core import *
@@ -40 +42 @@
-from trac.db import Table, Column, Index
-from trac.resource import ResourceNotFound
-from trac.web.api import *
-from trac.ticket import Ticket
-from trac.util.datefmt import utc, to_timestamp
-from datetime import datetime
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
-
-class TrashTalkPlugin(Component):
-RequestFilter, IEnvironmentSetupParticipant
+EnvironmentSetupParticipant, ITemplateStreamFilter, ITemplateProvider, IRequestFilter
-
-    SCHEMA = [
@@ -73 +57 @@
-            Column('ticket'),                  # The id of the ticket that has been linked to.
-            Column('external_url'),            # The url linking to the ticket.
-),            
+, type='int'),
-            Column('first', type='int'),       # The first time the external_url linked to the ticket.
-            Column('most_recent', type='int')  # The most recent time the external_url linked to the ticket.
@@ -89 +73 @@
-
-    TICKET_URI_PATTERN = re.compile("^/ticket/(\d+)(?:$|.*$)", re.VERBOSE)
-
+
-    # IEnvironmentSetupParticipant methods
-    def environment_created(self):
@@ -107 +91 @@
-        self._upgrade_db(db)
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-    # IRequestFilter methods
-    def pre_process_request(self, req, handler):
-        if self._is_external(req) and self._is_ticket(req):
-            self._talk_about(req)
-        return handler
-
+
-    # for ClearSilver templates
-    def post_process_request(self, req, template, content_type):
-        return (template, content_type)
-
+
-    # for Genshi templates
-    def post_process_request(self, req, template, data, content_type):
+        #if self._is_ticket(req):
+        add_stylesheet(req, 'trashtalk/trashtalk.css')
+
-        return (template, data, content_type)
+    
+    # ITemplateProvider methods
+    def get_htdocs_dirs(self):
+        """Return the absolute path of a directory containing additional
+        static resources (such as images, style sheets, etc).
+        """
+        from pkg_resources import resource_filename
+        return [('trashtalk', resource_filename(__name__, 'htdocs'))]
+
+    def get_templates_dirs(self):
+        """Return the absolute path of the directory containing the provided
+        ClearSilver templates.
+        """
+        #from pkg_resources import resource_filename
+        #return [resource_filename(__name__, 'templates')]
+        return []
-    
-    # Private methods
@@ -128 +156 @@
-        # Right now though, for a first implementation, this will suffice.
-        
-int(self.TICKET_URI_PATTERN.findall(req.path_info)[0]
+self._get_ticket_from_request(req
-        external_url = req.get_header("referer")
-        click_count = 1
@@ -165 +193 @@
-    def _is_ticket(self, req):
-        return len(self.TICKET_URI_PATTERN.findall(req.path_info)) > 0
+    
+    def _get_ticket_from_request(self, req):
+        return int(self.TICKET_URI_PATTERN.findall(req.path_info)[0])
+    
+    def _get_incoming_links_for_ticket(self, ticket):
+        # Let's get a database connection.
+        db = self.env.get_db_cnx()
+        cursor = db.cursor()
+        cursor.execute('select * from incoming_links where ticket=%s order by first desc', str(ticket))
+        
+        rows = cursor.fetchall()
+        
+        result = []
+        for row in rows:
+            result.append({
+                'id':                   row[self.SCHEMA_LOOKUP['id']],
+                'ticket':               row[self.SCHEMA_LOOKUP['ticket']],
+                'external_url':         row[self.SCHEMA_LOOKUP['external_url']],
+                'click_count':          row[self.SCHEMA_LOOKUP['click_count']],
+                'first':                row[self.SCHEMA_LOOKUP['first']],
+                'most_recent':          row[self.SCHEMA_LOOKUP['most_recent']]
+            })
+        return result
-    
-    def _upgrade_db(self, db):
@@ -184 +235 @@
-            self.env.log.error(e, exc_info=1)
-            raise TracError(str(e))
-
+
+
+