[Trac] Query tickets from the command line

2011-06-14 Thread W. Martin Borgert

Hi,

this issue has been discussed some years back:

http://www.mail-archive.com/trac-users@googlegroups.com/msg06606.html

My Trac system (still 0.11, sorry) runs on a dedicated server
with PostgreSQL, so accessing the database directly is not
possible.

The most practical solution seems to be to download the query
as CSV with the right parameters. Are there any better options?

TIA!

--
You received this message because you are subscribed to the Google Groups Trac 
Users group.
To post to this group, send email to trac-users@googlegroups.com.
To unsubscribe from this group, send email to 
trac-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/trac-users?hl=en.



Re: [Trac] Query tickets from the command line

2011-06-14 Thread Erik Andersson
On Tue, Jun 14, 2011 at 2:20 PM, W. Martin Borgert deba...@debian.orgwrote:

 Hi,

 this issue has been discussed some years back:

 http://www.mail-archive.com/trac-users@googlegroups.com/msg06606.html

 What is your use case? It might help if we understand better what you are
trying to achieve.

 My Trac system (still 0.11, sorry) runs on a dedicated server
 with PostgreSQL, so accessing the database directly is not
 possible.

Why not? Can you connect with ssh to the server?

Cheers / Erik


 The most practical solution seems to be to download the query
 as CSV with the right parameters. Are there any better options?

 TIA!

 --
 You received this message because you are subscribed to the Google Groups
 Trac Users group.
 To post to this group, send email to trac-users@googlegroups.com.
 To unsubscribe from this group, send email to
 trac-users+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/trac-users?hl=en.



-- 
You received this message because you are subscribed to the Google Groups Trac 
Users group.
To post to this group, send email to trac-users@googlegroups.com.
To unsubscribe from this group, send email to 
trac-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/trac-users?hl=en.



Re: [Trac] Query tickets from the command line

2011-06-14 Thread W. Martin Borgert

Quoting Erik Andersson kir...@gmail.com:

On Tue, Jun 14, 2011 at 2:20 PM, W. Martin Borgert deba...@debian.orgwrote:

this issue has been discussed some years back:

http://www.mail-archive.com/trac-users@googlegroups.com/msg06606.html


What is your use case? It might help if we understand better what you are
trying to achieve.


Tickets with certain properties (custom flag xxx=1) should
be listed in a documentation (id, summary).


My Trac system (still 0.11, sorry) runs on a dedicated server
with PostgreSQL, so accessing the database directly is not
possible.


Why not? Can you connect with ssh to the server?


Not all Trac users have an account on the server (nor do I want
to have them direct access to the database). The query on the
command line must be limited in the same way it is in Trac.

Cheers

--
You received this message because you are subscribed to the Google Groups Trac 
Users group.
To post to this group, send email to trac-users@googlegroups.com.
To unsubscribe from this group, send email to 
trac-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/trac-users?hl=en.