On 2017-09-05 16:52, Richard PALO wrote:
> Le 05/09/2017 à 15:14, Richard PALO a écrit :
> > any hint on how to do this?
> >
> noticing an interesting example in the python-sql overview,
> I tried the following and it seems to hack it out:
> > account_move = Table('account_move')
> > account_journal = Table('account_journal')
> > ir_sequence = Table('ir_sequence')
> >
> > j1 = account_journal.join(
> > account_move,
> > condition=account_move.journal_id == account_journal.id)
> >
> > j2 = j1.join(
> > ir_sequence,
> > condition=ir_sequence.id == account_journal.sequence_id)
> >
> > j3 = j2.join(Table('account_account'))
> > j3.condition = j3.right.id == account_journal.default_debit_account_id
You should write instead:
account_account1 = Table('account_account')
j3 = j2.join(account_account1,
condition=account_account1.id ==
account_journal.default_debit_account_id)
> > j4 = j3.join(Table('account_account'))
> > j4.condition = j4.right.id == account_journal.default_credit_account_id
Idem, it is better to not rely on the right/left parameter.
> > query = j4.select(
> > account_journal.id, account_journal.code, account_journal.name,
> > account_journal.type,
> > ir_sequence.name.as_('sequence_name'),
> > j3.right.code.as_('default_debit_account'),
> > j4.right.code.as_('default_credit_account'),
> > distinct_on=account_journal.id)
> >
> > print(query)
> > cur.execute(*query)
> >
> > for jnl in cur:
> > print(jnl.id, jnl.code, jnl.name, jnl.type, jnl.sequence_name,
> > jnl.default_debit_account, jnl.default_credit_account)
> >
> >
>
> The print statement pretty much shows the query I intended though what I don't
> get now is why python-sql needs the 'distinct_on' clause to avoid excessive
> output...
> that is, neither psql nor phppgadmin sql need it to work correctly.
>
> Is this an anomalie that perhaps should have an issue filed?
It is difficult to say it without seeing the executed SQL.
--
Cédric Krier - B2CK SPRL
Email/Jabber: [email protected]
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/
--
You received this message because you are subscribed to the Google Groups
"python-sql" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
