Or something along the lines of
Clinical.string_value.replace(' ', '_').op...
On Monday, December 28, 2015 at 11:49:38 AM UTC-6, Horcle wrote:
>
> I am iteratively building a complex query. For one step, I have
>
> a[i] = a[i].filter(Clinical.string_value.op('=')([value[i]])).subquery()
>
>
> I would like to simply just replace the value in Clinical.string value
> such that all spaces are turned into underscores. My naive approach is to
> do this as
>
> replace(Clinical.string_value, ' ', '_'), but I know the syntax is invalid
> in this context. How do I plug this into my SQLAlch statement? I found the
> replace method here:
> http://docs.sqlalchemy.org/en/latest/core/sqlelement.html#sqlalchemy.sql.expression.func,
>
> but it does not seem to fit my use case.
>
> Thanks in advance!
>
> Greg--
>
--
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 post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
