Odoo Help


How can i execute SQL code in openerp server ?

ThackerS (ts)
on 8/22/14, 10:13 PM 5,593 views

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)

On 8/23/14, 12:53 AM

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_unit': t['amount'],
                'quantity': 1,
                'price': t['amount'] or 0.0,
                'account_id': t['account_id'],
                'tax_code_id': t['tax_code_id'],
                'tax_amount': t['tax_amount'],
                'account_analytic_id': t['account_analytic_id'],
        return res

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 8/22/14, 10:13 PM
Seen: 5593 times
Last updated: 3/16/15, 8:10 AM