Hi Catonano.
What version of SQLAlchemy are you using ?
I haven't had a look at SQLAlchemy the last 3 month. Maybe something has
changed in SQLAlchemy.
If you look at the code in AlchemyEngineUtility.getEngine you see that
the engine returned is the plain engine from SQLAlchemy.
It seems that the problem is not in ZAlchemy.
Regards
Jürgen
catonano wrote:
Hello people, hello Jurgen,
last time I wrote, I was at the point that aTable =
sqlalchemy.Table('aTable', z3c.zalchemy.metadata, autoload=True)
doesn't work. I also promised that I would have seen if I could help
with that; Sorry I still can't help.
I would love to succeed in zopezing my MySql database, before anything
else.
So I tried to use the example in the zalchemy readme file as it is. It
doesn't work either !
Please help me !
The work session follows.
PyCrust 0.9.5 - The Flakiest Python Shell
Python 2.4.3 (#69, Mar 29 2006, 17:35:34) [MSC v.1310 32 bit (Intel)] on
win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlalchemy
>>> import z3c.zalchemy
>>> from z3c.zalchemy.datamanager import AlchemyEngineUtility
>>> engineUtility =
AlchemyEngineUtility('tender','mysql:///root:[EMAIL PROTECTED]/tender',echo=False)
>>> aTable = sqlalchemy.Table('zalch',
... z3c.zalchemy.metadata,
... sqlalchemy.Column('id', sqlalchemy.Integer,
... sqlalchemy.Sequence('atable_id'), primary_key=True),
... sqlalchemy.Column('value', sqlalchemy.Integer),
... redefine=True)
>>> class A(object):
... pass
...
>>> sqlalchemy.mapper(A, aTable) is not None
True
>>> from zope.component import provideUtility
>>> provideUtility(engineUtility)
>>> z3c.zalchemy.createTable('zalch')
>>> import transaction
>>> txn = transaction.begin()
>>> session = z3c.zalchemy.getSession
>>> session()
[2006-11-05 14:53:19,500] [pool] : Error on connect(): (Connection
failed) (OperationalError) (1045, "Access denied for user
'ODBC'@'localhost' (using password: NO)")
<sqlalchemy.orm.session.Session object at 0x0200D990>
>>>
It tries to connect to MySql with [EMAIL PROTECTED] usng password: no
But the engineUtility I created had a completely different URL ! Maybe I
wrote the url incorrectly ?
Also a simpler url gives the same url.
Look at this
Py 0.9.5
Python 2.4.3 (#69, Mar 29 2006, 17:35:34) [MSC v.1310 32 bit (Intel)] on
win32
Type "help", "copyright", "credits" or "license" for more information.
import sqlalchemy
import z3c.zalchemy
from z3c.zalchemy.datamanager import AlchemyEngineUtility
engineUtility = AlchemyEngineUtility('tender', 'mysql:///[EMAIL PROTECTED]')
eng = engineUtility.getEngine()
eng.connect()
[2006-11-06 01:04:57,983] [pool] : Error on connect(): (Connection
failed) (OperationalError) (1045, "Access denied for user
'ODBC'@'localhost' (using password: NO)")
Traceback (most recent call last):
File "<input>", line 1, in ?
File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 477, in
connect
File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 179, in
__init__
File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 500, in
raw_connection
File "build\bdist.win32\egg\sqlalchemy\engine\default.py", line 42, in
get_connection
File "build\bdist.win32\egg\sqlalchemy\pool.py", line 95, in connect
File "build\bdist.win32\egg\sqlalchemy\pool.py", line 172, in __init__
File "build\bdist.win32\egg\sqlalchemy\pool.py", line 108, in get
File "build\bdist.win32\egg\sqlalchemy\pool.py", line 294, in do_get
File "build\bdist.win32\egg\sqlalchemy\pool.py", line 91, in
create_connection
File "build\bdist.win32\egg\sqlalchemy\pool.py", line 131, in __init__
File "build\bdist.win32\egg\sqlalchemy\pool.py", line 155, in __connect
File "build\bdist.win32\egg\sqlalchemy\engine\default.py", line 33, in
connect
DBAPIError: (Connection failed) (OperationalError) (1045, "Access denied
for user 'ODBC'@'localhost' (using password: NO)")
What's wrong with these sessions ?
Thanks so much for any hint
Bye
Catonano
_______________________________________________
Zope3-users mailing list
Zope3-users@zope.org
http://mail.zope.org/mailman/listinfo/zope3-users
