[sqlalchemy] difference for type BigInteger between 0.6.6 and 0. 7.0b2

2011-03-07 Thread Mike Bernson

from sqlalchemy import *

meta = MetaData()

stx_setup = Table(stx_setup, meta,
Column('id', BigInteger(display_width=20), primary_key=True, autoincrement=T
rue),
Column('cost_center', Integer(display_width=1), index=True, nullable=True),
Column('AdministratorLicense', String(length=16), nullable=True),
Column('MDDOLicense', String(length=16), nullable=True),
Column('DONLicense', String(length=16), nullable=True),
Column('AssessorLicense', String(length=16), nullable=True),
Column('VendorNumber', String(length=4), nullable=True),
Column('ContractNumber', String(length=9), nullable=True),
Column('HospiceContractNumber', String(length=9), nullable=True),
Column('ServiceGroup', String(length=1), nullable=True),
)

The above code work in 0.6.6 and gives an following error in 0.7b2
Traceback (most recent call last):
  File simple.py, line 6, in module
Column('id', BigInteger(display_width=20), primary_key=True, 
autoincrement=True),
TypeError: __init__() got an unexpected keyword argument 'display_width'

Did not see anything in the 0.7 migration notes about this.

Is this a bug ?


--
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.



Re: [sqlalchemy] difference for type BigInteger between 0.6.6 and 0. 7.0b2

2011-03-07 Thread Michael Bayer
display_width is a MySQL option so you'd want to use 
sqlalchemy.dialects.mysql.BIGINT / mysql.INTEGER for that.   Not sure why 
0.6.6's base BigInteger type allows it.


On Mar 7, 2011, at 5:38 PM, Mike Bernson wrote:

 from sqlalchemy import *
 
 meta = MetaData()
 
 stx_setup = Table(stx_setup, meta,
Column('id', BigInteger(display_width=20), primary_key=True, 
 autoincrement=T
 rue),
Column('cost_center', Integer(display_width=1), index=True, nullable=True),
Column('AdministratorLicense', String(length=16), nullable=True),
Column('MDDOLicense', String(length=16), nullable=True),
Column('DONLicense', String(length=16), nullable=True),
Column('AssessorLicense', String(length=16), nullable=True),
Column('VendorNumber', String(length=4), nullable=True),
Column('ContractNumber', String(length=9), nullable=True),
Column('HospiceContractNumber', String(length=9), nullable=True),
Column('ServiceGroup', String(length=1), nullable=True),
 )
 
 The above code work in 0.6.6 and gives an following error in 0.7b2
 Traceback (most recent call last):
  File simple.py, line 6, in module
Column('id', BigInteger(display_width=20), primary_key=True, 
 autoincrement=True),
 TypeError: __init__() got an unexpected keyword argument 'display_width'
 
 Did not see anything in the 0.7 migration notes about this.
 
 Is this a bug ?
 
 
 -- 
 You received this message because you are subscribed to the Google Groups 
 sqlalchemy group.
 To post to this group, send email to sqlalchemy@googlegroups.com.
 To unsubscribe from this group, send email to 
 sqlalchemy+unsubscr...@googlegroups.com.
 For more options, visit this group at 
 http://groups.google.com/group/sqlalchemy?hl=en.
 

-- 
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.