Hi friends!
For this code:
from sqlalchemy import *
import MySQLdb
def connect(user, passwd, dbname, host):
return MySQLdb.connect(user=user, passwd=passwd,
db=dbname, host=host)
if __name__ == '__main__':
db = create_engine('mysql://', creator=connect('user', 'pass',
'demo',
'192.168.1.2'))
db.echo = True
metadata = BoundMetaData(db)
users = Table('users', metadata,
Column('user_id', Integer, primary_key=True),
Column('name', String(40)),
Column('age', Integer),
)
users.create()
emails = Table('emails', metadata,
Column('email_id', Integer, primary_key=True),
Column('address', String),
Column('user_id', Integer, ForeignKey('users.user_id')),
)
emails.create()
I recive following error:
Traceback (most recent call last):
File "./test.py", line 22, in ?
users.create()
File "/usr/lib/python2.4/site-packages/sqlalchemy/schema.py", line
284, in create
self.metadata.create_all(connectable=connectable,
checkfirst=checkfirst, tables=[self])
File "/usr/lib/python2.4/site-packages/sqlalchemy/schema.py", line
862, in create_all
connectable.create(self, checkfirst=checkfirst, tables=tables)
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 413, in create
self._run_visitor(self.dialect.schemagenerator, entity,
connection=connection, **kwargs)
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 433, in _run_visitor
conn = self.contextual_connect()
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 496, in contextual_connect
return Connection(self, close_with_result=close_with_result, **kwargs)
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 196, in __init__
self.__connection = connection or engine.raw_connection()
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 514, in raw_connection
return self.connection_provider.get_connection()
File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/default.py",
line 42, in get_connection
return self._pool.connect()
File "/usr/lib/python2.4/site-packages/sqlalchemy/pool.py", line 97,
in connect
return _ConnectionFairy(self).checkout()
File "/usr/lib/python2.4/site-packages/sqlalchemy/pool.py", line 175,
in __init__
self._connection_record = pool.get()
File "/usr/lib/python2.4/site-packages/sqlalchemy/pool.py", line 110,
in get
return self.do_get()
File "/usr/lib/python2.4/site-packages/sqlalchemy/pool.py", line 316,
in do_get
return self.create_connection()
File "/usr/lib/python2.4/site-packages/sqlalchemy/pool.py", line 93,
in create_connection
return _ConnectionRecord(self)
File "/usr/lib/python2.4/site-packages/sqlalchemy/pool.py", line 131,
in __init__
self.connection = self.__connect()
File "/usr/lib/python2.4/site-packages/sqlalchemy/pool.py", line 155,
in __connect
connection = self.__pool._creator()
TypeError: 'Connection' object is not callable
Python 2.4, MySQLdb 1.2.1, SQLAlchemy 0.3.0
Thank in advance!
--
Basil Shubin
Freelance Software Developer
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
