On Mon, Jul 09, 2012 at 03:12:16PM -0700, Russ wrote:
> I'm trying to use the new CTE support in SQLAlchemy in a way that will
> allow me to reference the recursion level as a field in the query
> result. This is easy in a straight SQL CTE by aliasing a constant in
> the non-recursive part, and then referencing the alias in the
> recursive part. The limited example below (tested in PostgreSQL)
> demonstrates this with a single field, and yields 0-10 inclusive:
>
> WITH RECURSIVE cte AS (
> SELECT 0 as x
> UNION ALL
> SELECT cte.x + 1 FROM cte WHERE cte.x < 10
> )
> SELECT * from cte;
>
> I can't figure out how to replicate this in SQLAlchemy, though.
> Specifically, I'm stumped on how to represent the "0 as x" part in
> SQLAlchemy. How do you do it? I've tried variations of this:
>
> select("0").alias(name="x")
select(literal(0).alias("x")) should do it, see the documentation at
http://docs.sqlalchemy.org/en/rel_0_7/core/expression_api.html#sqlalchemy.sql.expression.literal
>
> as column specs, but with no luck so far.
>
-Ryan Kelly
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
