Thank you for your reply.
Is this available for version 0.6 only ?
On Jun 3, 5:41 pm, Michael Bayer <mike...@zzzcomputing.com> wrote:
> On Jun 3, 2010, at 5:06 AM, Jan-Eric wrote:
>
>
>
>
>
> > Hi!
>
> > I have a problem with constructing a custom SQL statement.
> > I would like to create the following SQL
>
> > DATA_SUB( <somefixed-date>, INTERVAL <column-expression> MONTHS)
>
> > I tried the following approach:
>
> > -
> > sqlalchemy.func.DATE_SUB(startDate,sqlalchemy.literal_column("INTERVAL
> > %s MONTHS" % (exprColumn)))
> > this results in the following SQL:
> > DATE_SUB(%s, INTERVAL CASE WHEN (interval = %%s) THEN %%s WHEN
> > (interval = %%s) THEN %%s WHEN (interval = %%s) THEN %%s END MONTHS)
>
> > this doesn't work because % of the expression is escaped. How can I
> > prevent this ?
> > Should I use a different approach ?
>
> yes, you should use the compiler extension.
> http://www.sqlalchemy.org/docs/reference/ext/compiler.html
>
>
>
>
>
> > Thank you in advance!
>
> > Jan-Eric
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "sqlalchemy" group.
> > To post to this group, send email to sqlalch...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > sqlalchemy+unsubscr...@googlegroups.com.
> > For more options, visit this group
> > athttp://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
