Insert query in odoo 13

Question

res = [( 9999 ,  20109 ), ( 10000 ,  20110 )]
self .env.cr.execute( """INSERT INTO magic_res_partner (magic_uniq_id, magic_customer_number) VALUES                     %s  """ ,  tuple (res))

Error is %s
ERROR: not all arguments converted during string formatting

any solution

Prakash · Accepted Answer

Hello,
Inserting two values so two times use %s, %s  and res contains list of tuple so iterate in for loop and insert value one by one.
Example,
res = [(9999, 20109), (10000, 20110)]
for r in res:
self.env.cr.execute("""INSERT INTO magic_res_partner (magic_uniq_id, magic_customer_number) VALUES (%s, %s) """,     tuple(r))

相關帖文	回覆	瀏覽次數
How can I display data from database in form view query	0 9月 23	6220
How can i write update query in a function? 已解決 query	3 1月 20	12672
ParseError: "duplicate key value violates unique constraint "res_groups_name_uniq"? query	0 12月 23	8065
warehouse and location query query	0 3月 15	3233
How to create a method that will display values from database to a selection type field? query	0 3月 15	3460

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！