[PonyORM-list] How to do a query?

Matthew Bell matthewrobertbell at gmail.com
Tue Dec 8 17:51:36 UTC 2015


Hi!

For testing, SQLite. In production, postgres. On the order of hundreds of
pairs.

Thanks!

On 8 December 2015 at 17:47, Alexander Kozlovsky <
alexander.kozlovsky at gmail.com> wrote:

> Hi Matthew! Two questions:
>
> 1) What database do you use?
> 2) How many pairs are in y potentially?
>
> On Tue, Dec 8, 2015 at 4:37 PM, Matthew Bell <matthewrobertbell at gmail.com>
> wrote:
>
>> Hello,
>>
>> I am trying to do this:
>>
>> Assuming X.a and X.b are both unicode:
>>
>>     y = [('1', '2'), ('3', '4')]
>>
>>     select(x for X in x if (x.a, x.b) not in y)
>>
>> This query doesn't work. How can I exclude the tuples in y from results?
>>
>> Thanks
>>
>> --
>> Regards,
>>
>> Matthew Bell
>>
>> _______________________________________________
>> ponyorm-list mailing list
>> ponyorm-list at ponyorm.com
>> /ponyorm-list
>>
>>
>
> _______________________________________________
> ponyorm-list mailing list
> ponyorm-list at ponyorm.com
> /ponyorm-list
>
>


-- 
Regards,

Matthew Bell
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </ponyorm-list/attachments/20151208/7e1a792d/attachment.html>


More information about the ponyorm-list mailing list