Skip to Content
This question has been flagged
developmentdatabasepostgresqlqueryodoo8
1 Reply
15942 डेटा देखने का तरीका
अवतार
santhosh

Hi,

i want change the value of a column in particular table using pgsql query from different .py file example i want execute query of res.partner in main.py which is in web module.how can i do this any idea from you.

Can you help me...

Thanks in advance..

अवतार
खारिज करें
अवतार
Emipro Technologies Pvt. Ltd.
Best Answer

Hi,

In any where you can execute query if you get cursor (cr). So, in web module you can get the cursor using following way.

cr = request.session.cr

cr.execute("update res_partner set column1='value1' ")

I hope it is help to execute query in any where into openerp.

अवतार
खारिज करें
santhosh
लेखक

Thanks for you replay @Emipro Technologies i have one more question how to commit the query

Emipro Technologies Pvt. Ltd.

cr.commit() thats it.

santhosh
लेखक

Again thanks @Emipro Technologies i want to do this update activity while restoring dump how can i do this. any idea

Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
Invoices Analysis with pos_order included
database postgresql query odoo8.0
अवतार
0
मई 20
4483
Odoo OpenERP Server Error Traceback (most recent call last):
development installation database odoo8
अवतार
0
जून 16
12577
How to stop or restrict creating more than 2 users in odoo? Solved
development postgresql openerp odoo8
अवतार
अवतार
1
अप्रैल 15
6902
Save user input (field.char) into a database
database field postgresql query
अवतार
0
मार्च 15
6287
How can we display data from another database? Solved
development database external integration postgresql
अवतार
अवतार
अवतार
अवतार
अवतार
4
दिस॰ 23
39115