def test_run_sql_query():
    conn = psycopg2.connect("dbname=production_dev user=openerp password=endKjw7hdHHG host=dodman.erp.zone")
    cur = conn.cursor()
    cur.execute("""
    SELECT so.name,
    so.state, so.create_date, so.write_date,
        so.id,
        ROUND(so.amount_untaxed) - ROUND(sum(sol.product_uom_qty*sol.price_unit))
    FROM sale_order so
    LEFT JOIN sale_order_line sol ON so.id = sol.order_id
    WHERE so.state != 'cancel'
    AND sol.optional IS NOT TRUE
    GROUP BY so.id
    HAVING abs(ROUND(so.amount_untaxed,2) - ROUND(sum(sol.product_uom_qty*sol.price_unit),2)) > 0.1
    order by so.create_date DESC
    """)
    result = cur.fetchall()
    print result
    assert not result
    cur.close()
    conn.close()