Re: [sqlalchemy] Use of in_() for relationships

2018-04-19 Thread Mike Bayer
On Thu, Apr 12, 2018 at 10:14 AM, Mike Bayer  wrote:
> there may have been a very old issue for this but if there was, it's
> long forgotten.


found it:

https://bitbucket.org/zzzeek/sqlalchemy/issues/1140/implement-in_-for-relations




feel free to propose how you think this feature
> should work as well as if you have resources to work on it.  thanks!
>
>
> On Thu, Apr 12, 2018 at 9:54 AM, Anvith Shivakumara  
> wrote:
>> I get the 'NotImplementedError: in_() is not supported for relationship'
>> exception.
>>
>> Is there any plan to implement this in the near future? ls there any
>> particular reason for not having this implemented?
>>
>> Thanks
>> Anvith
>>
>> --
>> SQLAlchemy -
>> The Python SQL Toolkit and Object Relational Mapper
>>
>> http://www.sqlalchemy.org/
>>
>> To post example code, please provide an MCVE: Minimal, Complete, and
>> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
>> description.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "sqlalchemy" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to sqlalchemy+unsubscr...@googlegroups.com.
>> To post to this group, send email to sqlalchemy@googlegroups.com.
>> Visit this group at https://groups.google.com/group/sqlalchemy.
>> For more options, visit https://groups.google.com/d/optout.

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.


Re: [sqlalchemy] Use of in_() for relationships

2018-04-12 Thread Anvith Shivakumara
I will give has() or any() a try as suggested by Julien.

@Mike, I would love to give this feature some more thought, but maybe a 
couple of days later. :(

On Thursday, 12 April 2018 19:44:37 UTC+5:30, Mike Bayer wrote:
>
> there may have been a very old issue for this but if there was, it's 
> long forgotten.  feel free to propose how you think this feature 
> should work as well as if you have resources to work on it.  thanks! 
>
>
> On Thu, Apr 12, 2018 at 9:54 AM, Anvith Shivakumara  > wrote: 
> > I get the 'NotImplementedError: in_() is not supported for relationship' 
> > exception. 
> > 
> > Is there any plan to implement this in the near future? ls there any 
> > particular reason for not having this implemented? 
> > 
> > Thanks 
> > Anvith 
> > 
> > -- 
> > SQLAlchemy - 
> > The Python SQL Toolkit and Object Relational Mapper 
> > 
> > http://www.sqlalchemy.org/ 
> > 
> > To post example code, please provide an MCVE: Minimal, Complete, and 
> > Verifiable Example. See http://stackoverflow.com/help/mcve for a full 
> > description. 
> > --- 
> > You received this message because you are subscribed to the Google 
> Groups 
> > "sqlalchemy" group. 
> > To unsubscribe from this group and stop receiving emails from it, send 
> an 
> > email to sqlalchemy+...@googlegroups.com . 
> > To post to this group, send email to sqlal...@googlegroups.com 
> . 
> > Visit this group at https://groups.google.com/group/sqlalchemy. 
> > For more options, visit https://groups.google.com/d/optout. 
>

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.


Re: [sqlalchemy] Use of in_() for relationships

2018-04-12 Thread Mike Bayer
there may have been a very old issue for this but if there was, it's
long forgotten.  feel free to propose how you think this feature
should work as well as if you have resources to work on it.  thanks!


On Thu, Apr 12, 2018 at 9:54 AM, Anvith Shivakumara  wrote:
> I get the 'NotImplementedError: in_() is not supported for relationship'
> exception.
>
> Is there any plan to implement this in the near future? ls there any
> particular reason for not having this implemented?
>
> Thanks
> Anvith
>
> --
> SQLAlchemy -
> The Python SQL Toolkit and Object Relational Mapper
>
> http://www.sqlalchemy.org/
>
> To post example code, please provide an MCVE: Minimal, Complete, and
> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
> description.
> ---
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to sqlalchemy+unsubscr...@googlegroups.com.
> To post to this group, send email to sqlalchemy@googlegroups.com.
> Visit this group at https://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.


Re: [sqlalchemy] Use of in_() for relationships

2018-04-12 Thread Julien Cigar
On Thu, Apr 12, 2018 at 06:54:08AM -0700, Anvith Shivakumara wrote:
> I get the 'NotImplementedError: in_() is not supported for relationship' 
> exception.

maybe you want .has() or .any() ?

for ex:
session.query(SomeClass).filter(
  SomeClass.somecollection.any(someproperty='blabla')
)

> 
> Is there any plan to implement this in the near future? ls there any 
> particular reason for not having this implemented?
> 
> Thanks
> Anvith
> 
> -- 
> SQLAlchemy - 
> The Python SQL Toolkit and Object Relational Mapper
> 
> http://www.sqlalchemy.org/
> 
> To post example code, please provide an MCVE: Minimal, Complete, and 
> Verifiable Example.  See  http://stackoverflow.com/help/mcve for a full 
> description.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to sqlalchemy+unsubscr...@googlegroups.com.
> To post to this group, send email to sqlalchemy@googlegroups.com.
> Visit this group at https://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.


-- 
Julien Cigar
Belgian Biodiversity Platform (http://www.biodiversity.be)
PGP fingerprint: EEF9 F697 4B68 D275 7B11  6A25 B2BB 3710 A204 23C0
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.


signature.asc
Description: PGP signature