Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
developmentdatabasepostgresqlqueryodoo8
1 Odpowiedz
14975 Widoki
Awatar
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..

Awatar
Odrzuć
Awatar
Emipro Technologies Pvt. Ltd.
Najlepsza odpowiedź

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.

Awatar
Odrzuć
santhosh
Autor

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
Autor

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

Powiązane posty Odpowiedzi Widoki Czynność
Invoices Analysis with pos_order included
database postgresql query odoo8.0
Awatar
0
maj 20
3549
Odoo OpenERP Server Error Traceback (most recent call last):
development installation database odoo8
Awatar
0
cze 16
11534
How to stop or restrict creating more than 2 users in odoo? Rozwiązane
development postgresql openerp odoo8
Awatar
Awatar
1
kwi 15
5967
Save user input (field.char) into a database
database field postgresql query
Awatar
0
mar 15
5206
How can we display data from another database? Rozwiązane
development database external integration postgresql
Awatar
Awatar
Awatar
Awatar
Awatar
4
gru 23
37516