Re: [sqlalchemy] How to have MySQL store TIMESTAMP but return timezone-aware datetime objects

2019-06-28 Thread Charles-Axel Dein
Thanks so much for the detailed answer Mike, and for the quick fix! You're the best. On Thu, Jun 27, 2019 at 7:13 PM Mike Bayer wrote: > > > On Thu, Jun 27, 2019, at 12:02 PM, Charles-Axel Dein wrote: > > Hi, > > I'm trying to have a deleted_at column on my records. I u

[sqlalchemy] How to have MySQL store TIMESTAMP but return timezone-aware datetime objects

2019-06-27 Thread Charles-Axel Dein
Hi, I'm trying to have a deleted_at column on my records. I use MySQL and latest sqlalchemy as of writing. For historical reasons, I want to keep using the MySQL's TIMESTAMP columns. I would like to use timezone-aware datetime throughout my codebase. Everything in my DB is stored as UTC, so I

[sqlalchemy] Should an empty HSTORE be returned as an empty dict?

2013-03-11 Thread Charles-Axel Dein
Hi, Currently, when getting an empty HSTORE column from a model instance, it is returned as None. Do you think it would be more logical to have it returned as an empty dict? Thanks, Charles -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To

Re: [sqlalchemy] Keeping soft deletion atomic in spite of model methods calling commit

2012-12-21 Thread Charles-Axel Dein
Thanks Michael. Always spot on. And I don't think I can find a more authoritative source ;) On Wed, Dec 19, 2012 at 5:48 PM, Michael Bayer mike...@zzzcomputing.comwrote: On Dec 19, 2012, at 4:29 AM, charlax wrote: So the problem here is that the rollback does nothing, because there's a

Re: [sqlalchemy] Getting TimeoutError with SqlAlchemy

2012-09-11 Thread Charles-Axel Dein
Ok great! Thanks for the doc fix. Ok also for Session.remove(), I must admit Session.remove() is one of the part where the documentation is quite elliptical... On Tue, Sep 11, 2012 at 5:01 PM, Michael Bayer mike...@zzzcomputing.comwrote: On Sep 11, 2012, at 7:52 AM, charlax wrote: Hi, I

Re: [sqlalchemy] Getting TimeoutError with SqlAlchemy

2012-09-11 Thread Charles-Axel Dein
Wow. You're amazing. Far clearer now. Thanks a lot! On Tue, Sep 11, 2012 at 5:27 PM, Michael Bayer mike...@zzzcomputing.comwrote: On Sep 11, 2012, at 11:09 AM, Charles-Axel Dein wrote: Ok great! Thanks for the doc fix. Ok also for Session.remove(), I must admit Session.remove() is one