SVN integration could include ticket checking validity: 'trac-admin openticket 234'

[yonasj@…]

Presently in my SVN repo I have a script in hook/pre-commit

if ! $(echo "$LOG" | grep '[#]' >/dev/null) ; then
    echo Commit must reference a ticket >&2
    exit 1
fi

This only checks to make sure that all commits have a ticket referenced. It would be nice if I could use a trac-admin command to ensure the ticket is valid.

eg.

'trac-admin openticket 234'

trac rocks!

Thanks. Yonas.

[Christopher Lenz]

This is actually easy to do using the sqlite command-line utility:

sqlite /var/trac/projects/xyz \
       "SELECT COUNT(*) FROM ticket WHERE id = 1 AND status != 'closed'"

I don't think such a function should be added to TracAdmin, otherwise where would we stop?