[sqlalchemy] Re: mysql/sqlite date workaround

2016-05-16 Thread Михаил Доронин
Yeah, I know that there's a lot of corner cases in SQL compatibility, although it should be standardised. So of course I'm testing most of the code both in unit tests with sqlite and then manually in mysql (with not so granural tests of course). I just hoped that SQLalchemy solves this compatib

[sqlalchemy] Re: mysql/sqlite date workaround

2016-05-16 Thread Jonathan Vanasco
In my experience, doing anything that involves Dates or Times on more than once database will require a custom compiler -- especially when Sqlite is involved. This only appears to be problem with SqlAlchemy, because it is standardizing all these completely non-standard database behaviors. Us

Re: [sqlalchemy] mysql/sqlite date workaround

2016-05-16 Thread Mike Bayer
On 05/16/2016 04:34 PM, Михаил Доронин wrote: I've opened issue here , please read it, it's very brief. Now Mike Bayer says that it's not a sqlalchemy bug, and says that I can use cast to hint to mys

[sqlalchemy] Re: SQLAlchemy 1.0.13 released

2016-05-16 Thread mike bayer
Apparently, readthedocs has been not building for over a week, so at the moment the CHANGES link below is very stale. We are trying to get RTD to respond for help. In the meantime, here's a paste of the changelog for 1.0.13: 1.0.13 Released: May 16, 2016 orm [orm] [bug] Fixed bug in “ev

[sqlalchemy] SQLAlchemy 1.0.13 released

2016-05-16 Thread Mike Bayer
SQLAlchemy release 1.0.13 is now available. Release 1.0.13 fixes a variety of issues targeted at the 1.0 series that have been resolved over the past several weeks. Fixes include small issues repaired in the ORM, Core, Postgresql, Oracle, SQL Server dialects. Most issues are very minor with th

[sqlalchemy] mysql/sqlite date workaround

2016-05-16 Thread Михаил Доронин
I've opened issue here , please read it, it's very brief. Now Mike Bayer says that it's not a sqlalchemy bug, and says that I can use cast to hint to mysql to return datetime.date, but this won't wor