I want to execute the code below :
Select * from res_users;
from a python methode in openerp. My module look like that :
def my_sql_method(self,cr,uid) :
#it is my method which execute my sql code
How can i do that ?
NB: I don't want to execute my sql code in postgresql (easy)
A sample code is pasted here. You can refer the below code.
def move_line_get(self, cr, uid, invoice_id):
res = 
cr.execute('SELECT * FROM account_invoice_tax WHERE invoice_id=%s', (invoice_id,))
for t in cr.dictfetchall():
if not t['amount'] \
and not t['tax_code_id'] \
and not t['tax_amount']:
'price': t['amount'] or 0.0,
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 8/22/14, 10:13 PM|
|Seen: 3362 times|
|Last updated: 3/16/15, 8:10 AM|