Generic support for a new bigint/int8 data type

[Former user]

It would be nice to have a generic (not database specific) bigint/biginteger/int8 data type as part of the sqlalchemy.types that would use the corresponding type with a specific database.

It would use the following types on:

• Postgres: bigint
• SQLite: bigint
• MySQL: bigint
• Oracle: NUMBER
• MS-SQL: bigint
• MSAccess: NUMBER (8 bytes)
• Firebird: bigint
• Informix: INT8
• DB2/Informix IDS: BIGINT

[Former user]

Patch for sqltypes, mysql, and sqlite

[Former user]

I've added a patch to add a global BIGINT sqltype. I only added database support in MySQL and Sqlite, since those are the only databases that I can test immediately. Other databases need to be updated. The changes aren't difficult, but I didn't want to tackle the other databases without being able to test it.

[Mike Bayer]

it would be nice to have the patch in unified diff format (which you can do most easily via "svn diff")...as well as at least the PG dialect's patch, and a test case in test/sql/testtypes.py NumericTest.

[Mike Bayer]

we've got BigInteger in 0.6 trunk now, need to just add those particular implementations to each dialect.

[Mike Bayer]

this is completed for all DB's in trunk except for informix, which hasn't been converted to 0.6 at all, in 53f1c775db8f58ed33f3e35bbb3bd36961442c0c. Note that it compiles to BIGINT for the generic case (i.e. SQLite, others).

[Mike Bayer]

Removing milestone: 0.6.0 (automated comment)