On Jan 18, 2011, at 3:48 PM, F.A.Pinkse wrote:
> Hi All,
>
> I need a last push....and I hope someone here in SQLAlcheny cab give me some.
>
> My application uses elixir on a sqlite database.
>
> I Have a table Person with a field birthdate, now I want to sort on the month
> of this field.
>
> From examples and a lot of peeking I have worked out how to add Userdefined
> functions.
>
>
> session.bind = metadata.bind
>
> def monthfrom(date):
> return datetime.strptime(date, '%Y-%m-%d %H:%M:%S').month
>
> con = session.bind.connect().connection
> con.create_function("monthfrom", 1, monthfrom)
>
> but now come the part I have made very little progress on.
>
> personslist=Person.query.filter(Person.birthdate!=None).order_by("func.monthfrom(:date)",
> {"date": datetime(2000, 1, 2, 0, 0, 0), })
you're looking for order_by(func.monthfrom(datetime(2000, 1, 2, 0, 0, 0))).
Alternatively, if you want to pass in the "date" parameter separately, you
could say
order_by(func.monthfrom(bindparam("date"))).params(date=datetime(2000, 1, 2, 0,
0, 0))
>
> I get an SQLAlchemy.exc.OperationalError
>
> Thanks.
>
>
> Frans.
>
> --
> 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.
>
--
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.
