Would it be wrong to assume that the desired function could be added as a
hybrid
attribute <https://docs.sqlalchemy.org/en/14/orm/extensions/hybrid.html>,
then queried through the class obj?
*Example:*
from sqlalchemy.ext.hybrid import hybrid_property
class *GeneralBeqReq*(Base):
...
@hybrid_property
def is_id_valid(self):
# some logic here
*if* self.id % 3 == 0:
*return* True
*else:*
*return* False
On Wednesday, April 28, 2021 at 5:01:32 AM UTC-4 Simon King wrote:
> Parameters that you pass to the Query.filter function are eventually
> going to be rendered into an SQL statement, so your is_id_valid
> function probably needs to return something built from SQLAlchemy's
> SQL expression language:
> https://docs.sqlalchemy.org/en/14/core/tutorial.html
>
> If you can explain the sort of validation that is_id_valid needs to
> do, we might be able to help more.
>
> Simon
>
>
> On Wed, Apr 28, 2021 at 6:33 AM Gyanaranjan Nayak <[email protected]>
> wrote:
> >
> > I have a function with name is_id_valid(id) which returns either True or
> False.
> >
> > I want to pass this function inside a sqlalchemy query inside the filter
> condition.
> > My query example is :
> >
> > a = session.query(GeneralBeqReq).filter(GeneralBeqReq.c.BeqReqStatus ==
> 1,
> > is_id_valid (GeneralBeqReq.c.id) == True).all()
> >
> > When I run the above query It is throwing the following error.
> >
> > AttributeError: Neither 'Column' object nor 'Comparator' object has an
> attribute 'strip'
> >
> >
> > Can you please guide me how to use this function inside my query ?
> >
> >
> > --
> > 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 [email protected].
> > To view this discussion on the web visit
> https://groups.google.com/d/msgid/sqlalchemy/f388cfb8-0b0d-4ab3-8e26-84c4eb91b4a9n%40googlegroups.com
> .
>
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/52a15f82-9ce5-4179-b46e-72526dc72441n%40googlegroups.com.
