wiki:DailyReminderScriptForTracScript

Version 1 (modified by ethanole, 4 years ago) (diff)

New hack DailyReminderScriptForTracScript, created by ethanole

A daily reminder script for Trac

Description

This is a script for sending daily reminder emails of tickets owned (like one's notice scripts, or todo scripts).

The 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.

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...

It is tested on Trac 0.11 with PostgreSQL 3.10 on a Gentoo box. (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 TicketReminder script, and just customized it ;) )

I know it could be written more efficient, and a nicer code. For now it is enough :)

Feel free to adopt it to your needs, please test it, use it!

Bugs/Feature Requests

Existing bugs and feature requests for DailyReminderScriptForTracScript are here.

If you have any issues, create a new ticket.

Download

Download the zipped source from here.

Source

You can check out DailyReminderScriptForTracScript from here using Subversion, or browse the source with Trac.

Example

One should put in a cronjob, ie:

'''/etc/cron.d/trac_remind.cron'''
0 0 * * mon-fri root /path/to/this/script/trac_reminder_report.py

(don't forget to put a MAILTO=your.address@… into the cron file, the script prints out the recipients names where the mails had been sent)

Recent Changes

[8683] by rjollos on 2010-09-08 10:04:47
Importing attachment from project's wiki page.
[7854] by ethanole on 2010-04-16 17:17:46
New hack DailyReminderScriptForTracScript, created by ethanole

Author/Contributors

Author: ethanole
Maintainer: ethanole
Contributors: