Identity - Links identities to account 1

[Stefano Rivera]

Shadowfire:
Aug 29 19:13:41 <testtumble> hi
Aug 29 19:13:42 * Dazzle waves to testtumble
Aug 29 19:13:44 <testtumble> who am i
[Dazzle has address ~<email address hidden>]
Aug 29 19:13:44 <Dazzle> testtumble on shadowfire
Aug 29 19:15:23 <testtumble> i am testtumble on atrum
Aug 29 19:15:24 <Dazzle> Sure
Aug 29 19:15:30 <testtumble> x5YQqSXLSXXiENBZ
Aug 29 19:15:31 <Dazzle> Identity added
Aug 29 19:15:33 <testtumble> who am i
Aug 29 19:15:34 <Dazzle> tumbleweed is [UC]tumbleweed on titan, tumblehome on titan, tumbleweed on atrum, [UC]tumbleweed on moseisley, tumbleweed on shadowfire and testtumble on shadowfire

Atrum:
Aug 29 19:13:54 <testtumble> who am i?
Aug 29 19:13:55 <Dazzle> testtumble on atrum
Aug 29 19:15:24 <Dazzle> Please send me this message from testtumble on shadowfire: x5YQqSXLSXXiENBZ

[Stefano Rivera (stefanor)]

OK, the problem appears to be that
                account = event.session.query(Account) \
                        .join(Identity.account) \
                        .filter(func.lower(Identity.identity) == identity.lower()) \
                        .filter(func.lower(Identity.source) == source.lower()).first()

is generating

SELECT accounts.id AS accounts_id, accounts.username AS accounts_username FROM accounts, identities WHERE lower(identities.identity) = 'testtumble' AND lower(identities.source) = 'atrum' ORDER BY accounts.id