i will try that and i saw the plain sql string approach too but i got some basic stuff working at the moment.
cheers Markus Am So., 29. Jan. 2023 um 12:40 Uhr schrieb Jun Omae <[email protected]>: > On Sun, Jan 29, 2023 at 8:26 PM Markus Rosjat <[email protected]> > wrote: > > then I expect to pass data to insert_into_table to work with a tuple like > > > > ("ttmsd_webhook_types", > > ("name"), > > (("MS Teams",), > > ("Discord",)) > > ) > > The columns should be a list or a tuple. > > - ("name"), > + ["name"], > > > for initial data that should be fine since i know what i add but if i > want to update my types later on I always need to get the count of the id > sequence first to not mess up. > > If you need other operations than simple inserting rows, use directly > queries such SELECT/INSERT/UPDATE/DELETE using > self.env.db_transaction() and cursor.execute(). > > -- > 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/CAEVLMahR1TA%3DfV0ZoQp2CQW0w062w3XaKqt%3Dy29oHH097V4ZRg%40mail.gmail.com > . > -- 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/CAJ4osOnLKOMT8bmO8686mWEXOPxqZ0JDc%2BjVCA%3Dm_ZXwE%3DuFSA%40mail.gmail.com.
