Mailing List Archive

updating Trac database with direct SQL requests
Hi,

I'd like to update some custom or standard fields in the database of one of
my Trac instances using SQL requests. I run this instance on my laptop with
tracd and I'm always the only user (I turned this instance into a personal
task manager, sort of).

I've had a look at the *ticket*, *ticket_change* and *ticket_custom* tables
and I feel comfortable at dealing with the data in those 3 tables.

Yet I wonder if updating the database with SQL requests while tracd is
running could have side effects in case there are some locks of any sort, or
if this could affect some caching mechanism ?

Thanks in advance,

phep

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/7b0ac5d8-5533-13bc-02f6-4ddb1e6e74a6%40wakzo.net.
Re: updating Trac database with direct SQL requests [ In reply to ]
On Sunday, December 26, 2021 at 11:21:57 PM UTC-8 phep wrote:

> Hi,
>
> I'd like to update some custom or standard fields in the database of one
> of my Trac instances using SQL requests. I run this instance on my laptop
> with tracd and I'm always the only user (I turned this instance into a
> personal task manager, sort of).
>
> I've had a look at the *ticket*, *ticket_change* and *ticket_custom*
> tables and I feel comfortable at dealing with the data in those 3 tables.
>
> Yet I wonder if updating the database with SQL requests while tracd is
> running could have side effects in case there are some locks of any sort,
> or if this could affect some caching mechanism ?
>
> Thanks in advance,
>
> phep
>

There is some caching, so your best move would be to stop the server, make
the database edits, start the server.

Ryan

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/26d556ee-6ad8-4ef5-ad52-3fa8fad127efn%40googlegroups.com.