[SQLObject] Bigint support

[John Arbash Meinel]

I was wondering if there are any plans to support a 'BIGINT' column.
(Basically it is just a 64-bit integer/long long).

As far as I know, mysql, postgres, and sqlite all have BIGINT support.

I personally use it in some databases where I'm tracking file size,
which can easily be > 2GB, or if you want to track the size of a filesystem.

I realize that there is Decimal column, where you can specify the size
and precision.

Basically, I'm trying to create a local sqlite cache from a postgres
database, and I would like to maintain the rows. I can manually create
the table, and sqlobject seems fine with creating and returning integers
that are > 32-bits.

The problem is that I would like to use SQLObject's ability to
automatically create tables.

The only thing I found was this:
http://pythonpaste.org/archives/message/20050607.111618.f34eb3db.en.html#sqlobject-discuss

Which basically didn't persue the idea.


I think this would work:

class SOBigIntCol(SOIntCol):
    def _sqlType(self):
        return 'BIGINT'

class BigIntCol(IntCol):
    baseClass = SOBigIntCol

John
=:->

signature.asc
Description: OpenPGP digital signature