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	5782
How can i write update query in a function? 已解决 query	3 1月 20	12277
ParseError: "duplicate key value violates unique constraint "res_groups_name_uniq"? query	0 12月 23	7628
warehouse and location query query	0 3月 15	2916
How to create a method that will display values from database to a selection type field? query	0 3月 15	3038

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！