Programmatic queries

[Jason Dunham]

I would like to make a programmatic query of Trac. For example, during
my build process, I would like to get all of the tickets for some
component which were closed between the last build (or a user-supplied
date) and now, and pipe the results into a text file for further
processing.

I think I can write the SQL for that without too much problem, but I
don't know how to get the results in a useful output format.

Thanks for any tips,
Jason Dunham

[Noah Kantrowitz]

I would recommend using the Trac API (trac.ticket.query.Query) or using
XML-RPC (via the XmlRpcPlugin).

--Noah