Hello,
I just getting started evaluating SQL Alchemy.
Not recalling the documentation very clearly I wrote the DB URL
as I expected it to work:
engine = create_engine('postgres://scott:[EMAIL PROTECTED]:5049/test')
although I got an engine object, trying e.get_default_schema_name()
gives me: psycopg.InterfaceError
Going back to the docs shows:
engine = \
create_engine('postgres://database=test&host=127.0.0.1&user=scott&password=tiger')
And using e.get_default_schema_name() gives me the expected "public".
response.
Why so verbose? It seems to be not using the fields defined as parts
of a URI and forcing the use of the query string (albeit incorrectly
since the "?" portion is missing). (Note I'm using psycopg V1.19)
Playing with:
lite = create_engine('sqlite:///:memory:')
However seems to be doing what I expected.
Cheers,
William.
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
