odoo sql

店小2

odoo 中虽然系统已经代码进行封装　搜索，查询，写入新建都不用ｓｑｌ
但是在有的时候用ｓｑｌ的话会很方便　，而且还会提高效率

        cr.execute('SELECT rel.purchase_id '


     'FROM purchase_invoice_rel AS rel, account_invoice AS inv ' + purchase_clause +
                   'WHERE rel.invoice_id = inv.id ' + clause)
        res = cr.fetchall()


SELECT po.id AS po_id,po.name,
                             po.amount_total-COALESCE(sum(pol.product_qty* pol.price_unit),0) AS sum_uninvoiced
                      FROM purchase_order AS po
                      LEFT JOIN purchase_order_line AS pol  ON pol.order_id=po.id
                      WHERE pol.invoiced=True
                      GROUP BY po.id order by po.id