Hoppa till innehåll
Du måste vara registrerad för att kunna interagera med communityn.
Alla inlägg Personer Utmärkelser
Etiketter (Visa alla)
odoo accounting v14 pos v15
Om detta forum
Denna fråga har flaggats
developmentdatabasepostgresqlqueryodoo8
1 Besvara
15865 Vyer
Avatar
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..

Avatar
Avbryt
Avatar
Emipro Technologies Pvt. Ltd.
Bästa svar

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.

Avatar
Avbryt
santhosh
Författare

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
Författare

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

Relaterade inlägg Svar Vyer Verksamhet
Invoices Analysis with pos_order included
database postgresql query odoo8.0
Avatar
0
maj 20
4404
Odoo OpenERP Server Error Traceback (most recent call last):
development installation database odoo8
Avatar
0
juni 16
12493
How to stop or restrict creating more than 2 users in odoo? Löst
development postgresql openerp odoo8
Avatar
Avatar
1
apr. 15
6769
Save user input (field.char) into a database
database field postgresql query
Avatar
0
mars 15
6213
How can we display data from another database? Löst
development database external integration postgresql
Avatar
Avatar
Avatar
Avatar
Avatar
4
dec. 23
39027