[sqlalchemy] Re: I need a final push

Hi All, After some additional peeking around I decided to do a test with SQLAlchemy alone. I took the tutorial fr0m the book Essential SQLAlchemy as my guide. This is what I got working. # testing the func following the tutorial in the book Essential SQLALchemy #pg.25 from sqlalchemy

[sqlalchemy] Re: I need a final push

HEllo Michael, Thanks for your answer. I tried order_by(func.monthfrom(datetime(2000, 1, 2, 0, 0, 0))) but get the error: global name func not defined. I guess something must be put in front of it. Any idea before I dig in. My app works with Elixir. Tnaks. Frans. -- You received

[sqlalchemy] I need a final push

Hi All, I need a last pushand 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

[sqlalchemy] order_by(datetime)

Hi All. I have a datetime column in my model. If I do an .order_by I get year-month-day but how do I do an order_by to get month-day-year? or even a day-month-year Thanks, Frans. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to

[sqlalchemy] Re: order_by(datetime)

to consult the documentation for your database on the recommended way to break dates up into components. On Jan 10, 2011, at 5:35 AM, F.A.Pinkse wrote: Hi All. I have a datetime column in my model. If I do an .order_by I get year-month-day but how do I do an order_by to get month-day-year

[sqlalchemy] Re: Not.How to do a not contains()

is interpreted as not, which is a synonym for sqlalchemy.not_(): ~Person.address.contains(foo) not_(Person.address.contains(foo)) On Jan 4, 2011, at 5:37 AM, F.A.Pinkse wrote: Hi All, I can do a .filter(Person.address.contians(someaddress)) but how do I do the negated version? meaning