Changes between Version 10 and Version 11 of DailyReminderScriptForTracScript


Ignore:
Timestamp:
Jun 9, 2015, 9:30:27 AM (9 years ago)
Author:
figaro
Comment:

Cosmetic changes, tagged with nolicense

Legend:

Unmodified
Added
Removed
Modified

  • DailyReminderScriptForTracScript

    v10 v11  
    11[[PageOutline(2-5,Contents,pullout)]]
    22
    3 = Daily email to remind owners of open tickets =
     3= Daily email to remind owners of open tickets
    44
    5 == Description ==
     5== Description
    66
    7 This is a script for sending daily reminder emails of tickets owned (like one's notice scripts, or todo scripts).
     7This is a script for sending daily reminder emails of tickets owned, like one's notice scripts, or todo scripts.
    88
    99The script searches the ticket status, and if one's status is not closed, it collects by owner and sends each of them a html mail.
    1010
    11 This 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...
     11This is a Python 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 database:
     12 * MySQL: mysql-python
     13 * PostgreSQL: psycopg2
     14 * SQLite: sqlite2 or sqlite3
     15And of course you'll need Python 2.6 as well.
    1216
    1317It is tested on Trac 0.11 and 0.12 with PostgreSQL 3.10 and Python 2.6 on a Gentoo box.
    14 (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 ;) )
    15 
    16 I know it could be written more efficient, and a nicer code. For now it is enough :)
    1718
    1819Feel free to adopt it to your needs, please test it, use it!
    … …  
    2021'''UPDATE:'''
    2122One should change line 103 if upgrading from Trac 11.x to Trac 12.x due to database changes:
    22 {{{
    23 #!python
     23{{{#!python
    2424detail = detail + "  created at " + str(time.strftime('%Y. %B %d. (%A) %H:%M:%S',time.gmtime(int(tkt[0]/1000000))))
    2525}}}
    26 Please take care of indentation!
    27 (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)
     26
     27Please take care of indentation! The Trac 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.
    2828
    2929See also: TracReminderScript, TicketRemindScript
    3030
    31 == Bugs/Feature Requests ==
     31== Bugs/Feature Requests
    3232
    3333Existing bugs and feature requests for DailyReminderScriptForTracScript are
    … …  
    3535
    3636If you have any issues, create a
    37 [http://trac-hacks.org/newticket?component=DailyReminderScriptForTracScript&owner=ethanole new ticket].
     37[/newticket?component=DailyReminderScriptForTracScript new ticket].
    3838
    39 == Download ==
     39[[TicketQuery(component=DailyReminderScriptForTracScript&group=type,format=progress)]]
     40
     41== Download
    4042
    4143Download the zipped source from [download:dailyreminderscriptfortracscript here].
    4244
    43 == Source ==
     45== Source
    4446
    4547You can check out DailyReminderScriptForTracScript from [http://trac-hacks.org/svn/dailyreminderscriptfortracscript here] using Subversion, or [source:dailyreminderscriptfortracscript browse the source] with Trac.
    4648
    47 == Example ==
     49== Example
    4850
    49 One should put in a cronjob, ie:
    50 
    51 '''/etc/cron.d/trac_remind.cron'''
    52 {{{
    53 #!sh
     51One should put in a cronjob '''/etc/cron.d/trac_remind.cron''':
     52{{{#!sh
    54530 0 * * mon-fri root /path/to/this/script/trac_reminder_report.py
    5554}}}
    56 (don't forget to put a MAILTO=your.address@your.domain.tld into the cron file, the script prints out the recipients names where the mails had been sent)
    5755
    58 == Recent Changes ==
     56Don't forget to put a MAILTO=your.address@your.domain.tld into the cron file, the script prints out the recipients names where the mails had been sent.
     57
     58== Recent Changes
    5959
    6060[[ChangeLog(dailyreminderscriptfortracscript, 3)]]
    6161
    62 == Author/Contributors ==
     62== Author/Contributors
    6363
    6464'''Author:''' [wiki:ethanole] [[BR]]
    65 '''Maintainer:''' [wiki:ethanole] [[BR]]
     65'''Maintainer:''' [[Maintainer]] [[BR]]
    6666'''Contributors:'''