I am starting looking into what type of object come back for different
column types from mysql.
I am using version 0.2.3 with mysql version 5
Here is error with a print statement near the problem turned on
[EMAIL PROTECTED]:~/src/myranch/packages/screen/screen/views 276> python
test1.py
coltype: 'tinyint' args: '(2)'
args! ['2']
coltype: 'tinyint' args: '(2)'
args! ['2']
coltype: 'smallint' args: '(2)'
args! ['2']
coltype: 'smallint' args: '(2)'
args! ['2']
coltype: 'int' args: '(2)'
args! ['2']
coltype: 'int' args: '(2)'
args! ['2']
coltype: 'int' args: '(2)'
args! ['2']
coltype: 'int' args: '(2)'
args! ['2']
coltype: 'bigint' args: '(10)'
args! ['10']
coltype: 'bigint' args: '(10)'
args! ['10']
coltype: 'double' args: '(10,4)'
args! ['10', '4']
coltype: 'double' args: '(10,4)'
args! ['10', '4']
coltype: 'float' args: '(10,4)'
args! ['10', '4']
Traceback (most recent call last):
File "test1.py", line 9, in ?
table = Table('testing', metadata, autoload=True)
File "/home/mike/src/SQLAlchemy-0.2.3/lib/sqlalchemy/schema.py", line
96, in __call__
metadata.engine.reflecttable(table)
File "/home/mike/src/SQLAlchemy-0.2.3/lib/sqlalchemy/engine/base.py",
line 484, in reflecttable
self.dialect.reflecttable(conn, table)
File
"/home/mike/src/SQLAlchemy-0.2.3/lib/sqlalchemy/databases/mysql.py",
line 207, in reflecttable
coltype = coltype(*[int(a) for a in args])
TypeError: __init__() takes at most 2 arguments (3 given)
Here is the python code:
from pkg_resources import require
require('SQLAlchemy')
from sqlalchemy import *
engine = create_engine("mysql:///wood_memorial")
metadata = BoundMetaData(engine)
table = Table('testing', metadata, autoload=True)
here is the create for the table:
use wood_memorial
create table testing (
type_tiny TINYINT(2) DEFAULT 1,
type_utiny TINYINT(2) unsigned DEFAULT 2,
type_small SMALLINT(2) DEFAULT 1,
type_usmall SMALLINT(2) unsigned DEFAULT 2,
type_int INT(2) DEFAULT 2,
type_uint INT(2) unsigned,
type_integer INTEGER(2) DEFAULT 2,
type_uinteger INTEGER(2) unsigned,
type_bigint BIGINT(10),
type_ubigint BIGINT(10) unsigned,
type_double DOUBLE(10,4),
type_udobule DOUBLE(10,4) unsigned,
type_float FLOAT(10,4),
type_ufloat FLOAT(10,4) unsigned,
type_decimal DECIMAL(10,4),
type_udecimal DECIMAL(10,4) unsigned,
type_numeric NUMERIC(10,4),
type_unumeric NUMERIC(10,4) unsigned,
type_date DATE,
type_time TIME,
type_timestape TIMESTAMP,
type_datetime DATETIME,
type_year YEAR,
type_char_ascii CHAR(10) ASCII,
type_char_unicode CHAR(10) ASCII,
type_varchar VARCHAR(10),
type_unum enum('1','2','3')
)
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
