Changes between Version 8 and Version 9 of DailyReminderScriptForTracScript


Ignore:
Timestamp:
Apr 28, 2011, 8:50:42 AM (4 years ago)
Author:
ethanole
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DailyReminderScriptForTracScript

    v8 v9  
    1111This is a ptyhon script The underlying database connection relies on python's db capabilities, so probably you will have to install the appropriate db connector module(s) for your db. (MySQL: mysql-python, PostgreSQL: psycopg2, SQLite: sqlite2 or sqlite3) - and of course you'll need python 2.6 as well...
    1212
    13 It is tested on Trac 0.11 and 0.12 with PostgreSQL 3.10 on a Gentoo box.
     13It is tested on Trac 0.11 and 0.12 with PostgreSQL 3.10 and Python 2.6 on a Gentoo box.
    1414(I didn't test it on other platforms, but it isn't used to be very hard to adopt this tiny script to suit your needs... - like me: I have copied [http://trac-hacks.org/wiki/TicketRemindScript TicketReminder] script, and just customized it ;) )
    1515
     
    1717
    1818Feel free to adopt it to your needs, please test it, use it!
     19
     20'''UPDATE:'''
     21One should change line 103 if upgrading from Trac 11.x to Trac 12.x due to database changes:
     22{{{
     23        detail = detail + "  created at " + str(time.strftime('%Y. %B %d. (%A) %H:%M:%S',time.gmtime(int(tkt[0]/1000000))))
     24}}}
     25Please take care of indentation!
     26(the 12.x database converts every timestamp to a more accurate timestamp format, so a timestamp field must be divided by a million to work properly)
    1927
    2028See also: TracReminderScript, TicketRemindScript