If we want to search comparing two values from the database, now is not possible. We want do something like:

q  = OOQuery('account_invoice')
q.select(['id', 'number']).where([
    ('account_id', '!=', 'partner_id.account_id')
])

Then to inform that a condition is not a field we should use the Literal class as following:

q  = OOQuery('account_invoice')
q.select(['id', 'number']).where([
    ('amount_total', '>', Literal(100))
])

When custom joins are used, the as_ parameter doesn't have any effect on that field.

def dummy_fk(table, field):
    fks = {
        'table_2': {
            'constraint_name': 'fk_contraint_name',
            'table_name': 'table',
            'column_name': 'table_2',
            'foreign_table_name': 'table2',
            'foreign_column_name': 'id'
        }
    }
    return fks[field]

OOQuery('table', dummy_fk).select(
    [InnerJoin('table_2.name')], as_={"table_2.name": "t2_name"}
).where([])

# SELECT "b"."name" AS "table_2.name" FROM "table" AS "a" INNER JOIN "table2" AS "b" ON ("a"."table_2" = "b"."id")

Expected behaviour

OOQuery('table', dummy_fk).select(
    ['table_2.name'], as_={"table_2.name": "t2_name"}
).where([])

# SELECT "b"."name" AS "t2_name" FROM "table" AS "a" INNER JOIN "table2" AS "b" ON ("a"."table_2" = "b"."id")

• LeftJoin
• RightJoin
• InnerJoin (is de default by now)

Cas real trobat:

inv_obj = self.pool.get('account.invoice')
search_params = [
    ('pending_state.active', '=', True),
    ('pending_state.pending_days', '>', 0),
    ('type', '=', 'out_invoice'),
    ('state', '=', 'open')
]
q = OOQuery(inv_obj, cursor, uid)
sql = q.select(['id']).where(search_params)

Si es mira el valor de sql (fent un list(sql)) es veu que el valor dels parametres que es passen son els següents:

(True, None, 'out_invoice', 'open')

S'ha transformat el 0 a un None. Llavors el postgres no troba els registres en que el camp pending_days siguin > 0 ja que en realitat executa INTEGER > NULL que sempre és False.

This line is modifying the query domain given to the parser of the where clause and leaving it empty.

This makes that a query coded like this to fail.

params = [('id', 'in', (1,2,3,4))]
sql = OOQuery(self, cursor, uid).select(['name']).where(params)
assert params, "Params are empty!"

To avoid unexpected behavior, the could be done by consulting the query params instead of emptying it.

Continues #29 with a new syntax:

q = OOQuery('account_invoice')
q.select([
    LeftJoin('partner_id').RightJoin('parent_id.name')
]).where([
(RightOuterJoin('company_id.name'), '=', 'Tiny splr')
])