コンテンツへスキップ
メニュー
この質問にフラグが付けられました
13 返信
14244 ビュー

Hi,

Due to some reason I need to run sql insert query for creating order lines.
The challenge is I need to map taxes to each order line but, due to I'm not having each line reference "ID"  before,  I can't perform insert onto many2many relation.

Thanks!

アバター
破棄

Sushma, you know the order id, after that your trying to insert order lines into the particular order.So you can get line ids using order id and already you know the tax id, then tell me what's your problem.

最善の回答

Hi,

At least you need record id to map with many2many relation.

アバター
破棄
最善の回答

Hello ,

        The id will be automatically created , you dont have to give an id to the record.

        Other than Using Query , You Can Try

        sale_order_line_id = self.env['sale.order.line'].create({
            'order_id':order_id,
            'product_id':product_id,
            'product_uom_qty':quantity,
            'price_unit':unit_price
})

    in this manner give every detailes of the order line and you can create an order line by code

    the line will appear on the order which's id is given as the order_id

アバター
破棄
著作者

Hi,

My question is about creating through sql queries not orm. So i would like to know, identical to mapping many2many using orm [(6,0, ids)], can we perform something with SQL queries.

Thanks.

最善の回答

Hi Sushma,

This is how inserts in query

query = """ INSERT INTO {rel} ({id1}, {id2})

                        (SELECT a, b FROM unnest(%s) AS a, unnest(%s) AS b)

                        EXCEPT (SELECT {id1}, {id2} FROM {rel} WHERE {id1} IN %s)

                    """.format(**parts)


Regards,

アバター
破棄
最善の回答

Hello, 

Check below link i think it's help you 

https://stackoverflow.com/questions/34362637/sql-many2many-query
アバター
破棄
最善の回答

Yes we can insert using query.

many2many have a relational table. so insert into the relational table, it will work

アバター
破棄
著作者

Thanks for reply.

Indeed there is different relation for many2many, but my question is while creating parent record how we run SQL query for many2many without ID.

you mean while creating order lines you have insert into many2many relation table

著作者

Yes something like while create order lines wanted to add taxes for each lines through sql query

do you have the tax_id while create the order line

著作者

Yes oblivious, I guess you're diverting something else, please read my posted question once.

Thanks

so your problem is order line id is not available to link it

関連投稿 返信 ビュー 活動
1
3月 22
14094
1
7月 21
4044
1
10月 20
4950
1
7月 19
5290
1
2月 18
4268