I know this is an old thread, but there isn't much on the web around
generate_series and SQLA, so I thought I might revive it.
One of the suggestion was to use:
s = func.generate_series(4,5,6).alias(cols=['a'])
select([func.current_date() + s.c.a])
Unfortunately, alias doesn't take a `cols` ar
OK r4566 of trunk also allows text() within select_from(), so you can
use textual bind params (denoted by a colon ':'):
generate_series = text("generate_series(:x, :y, :z) as s(a)")
s = select([(func.current_date() +
literal_column("s.a")).label("dates")]).select_from(generate_series)
# lo
On Apr 26, 2008, at 4:01 AM, Luke Iannini wrote:
>
> Hm, yes, so is:
>
> Traceback (most recent call last):
> File "/Users/LukeIannini/Checkout/trunk/adpinion_web/
> HistoryAlchemy.py", line 46, in
>allstats = union_all(stats, zeros)
> File "/Library/Python/2.5/site-packages/SQLAlchemy-0.
Hm, yes, so is:
Traceback (most recent call last):
File "/Users/LukeIannini/Checkout/trunk/adpinion_web/
HistoryAlchemy.py", line 46, in
allstats = union_all(stats, zeros)
File "/Library/Python/2.5/site-packages/SQLAlchemy-0.4.1-py2.5.egg/
sqlalchemy/sql/expression.py", line 498, in unio
On Apr 25, 8:46 am, Michael Bayer <[EMAIL PROTECTED]> wrote:
> On Apr 25, 2008, at 9:04 AM, Luke Iannini wrote:
>
>
>
>
>
> > Hi all,
> > Is there a way to use generate_series with SQLAlchemy?
>
> >http://www.postgresql.org/docs/8.2/interactive/functions-srf.html
>
> > generate_series = select([co
On Apr 25, 2008, at 9:04 AM, Luke Iannini wrote:
>
> Hi all,
> Is there a way to use generate_series with SQLAlchemy?
>
> http://www.postgresql.org/docs/8.2/interactive/functions-srf.html
>
> generate_series = select([column('i')],
>from_obj=[func.generate_series(bindparam('start'),
> bindpa