[sqlalchemy] Re: How to jsonify Query result?

2015-07-13 Thread Jonathan Vanasco
The tuples are a variant of python's NamedTuple (sqlalchemy.utils._collections.KeyedTuple) and contain the column names in a `keys` method. You can just write a json adapter that handles instances of KeyedTuple and iterates over their K/V pairs. -- You received this message because you are

Re: Per package migration history and upgrades

2015-07-13 Thread Mike Bayer
On 7/13/15 12:46 AM, Mikko Ohtamaa wrote: Hi, I am trying to use Alembic in a way that the codebase is split to several Python packages and each package tracks their own tables and migration history independently. Effective each package has its own versions and env.py. Is this possible? I

Re: [sqlalchemy] Re: Dealing with l10n fields

2015-07-13 Thread Mike Bayer
On 7/12/15 4:33 PM, Lele Gaifax wrote: Mike Bayer mike...@zzzcomputing.com writes: I'm not sure if you're using the ORM, there are some neat new hooks in 1.0 that could be used for this, but let's assume you're doing pure Core. Yes, that's exactly my use case (btw, that's because I'm using

[sqlalchemy] identifying changes in database

2015-07-13 Thread Balaji Pattewar
Hi , I am new to the database world. I need to provide mechanism so that cache can check that what is changed in database. Now for per table basis I need to add something so that I can track what changed. Adding timestamp column to table I can check what is created and updated but for it

[sqlalchemy] sqlalchemy.exc.DataError: (psycopg2.DataError) integer out of range

2015-07-13 Thread Chengjun JIN
Hi all, I am trying to save data into postgresql via sqlchemy ORM. I encountered an error below: sqlalchemy.exc.DataError: (psycopg2.DataError) integer out of range I pinpoint the place where it goes wrong. I have a large number which is 2468432255.0. If I change to smaller number like

Re: [sqlalchemy] sqlalchemy.exc.DataError: (psycopg2.DataError) integer out of range

2015-07-13 Thread Mike Bayer
On 7/13/15 7:02 PM, Chengjun JIN wrote: Hi all, I am trying to save data into postgresql via sqlchemy ORM. I encountered an error below: sqlalchemy.exc.DataError: (psycopg2.DataError) integer out of range I pinpoint the place where it goes wrong. I have a large number which is