On Sun, Mar 8, 2020 at 4:08 PM Velu Narasimman <[email protected]> wrote: > > Method: 1 > > When I just used the below, > detail['comments'] > > Query is read as > insert into ticket_time ( exclusion, time_submitted, seconds_worked, > submitter, worker, modified, comments, ticket_time_status, reason, > time_started, ticket) values ('on-premise', 1583650057, 7200.0, > 'sergio.martinez', 'sergio.martinez', 1583650057, u'BRD_PAG_009 Pago > Establecimientos BRD_ACT_015 Maduraci\\xf3n de Operaciones de Cr\\xe9dito', > 0, 'mentoring/review', 1583346600, 1693) returning > id,ticket,exclusion,reason,time_started >
Instead of constructing SQL statements, you should use DB API. Removing single-quote, double-quote and control characters to construct SQL statements is bad practice. See also https://trac.edgewall.org/wiki/TracDev/DatabaseApi -- Jun Omae <[email protected]> (大前 潤) -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/CAEVLMahP2-h477k_RF_7NPO%2B1Vq5qf_NOq0bm8HMf5zU_f%3DORA%40mail.gmail.com.
