this is unrelated to the URL scheme. i committed a one liner in 1539
that does not include the blank parameters in the keyword argument
list if not found in the URL.
to see why PG was doing this, try this:
psycopg2.connect(database='blabla2', user='blalbla1',
password='blabla', host='')
On May 28, 2006, at 2:59 PM, Valentino Volonghi aka Dialtone wrote:
On Sun, 28 May 2006 14:51:55 -0400, Michael Bayer
<[EMAIL PROTECTED]> wrote:
On May 28, 2006, at 2:36 PM, Valentino Volonghi aka Dialtone wrote:
The new way of specifiying the dabatase parameters that uses an
url is worse than the previous one IMHO since it doesn't allow
me to avoid specifying an host and a port and I have to rely on
passing my own QueuePool() which causes the other problems though.
Any solution?
how about:
postgres://username:password@/databasename
with the following string:
postgres://dialtone:pwd@/stiq
======================================================================
=========
[ERROR]: stiq.test.test_ui.TestCase.testMostBasic
File "/Volumes/dati/Sviluppo/stiq/stiq/test/utils.py", line 61, in
setUp
d = super(BaseUITest, self).setUp()
File "/Volumes/dati/Sviluppo/stiq/stiq/test/utils.py", line 24, in
setUp
database.dropDatabaseTable()
File "/Volumes/dati/Sviluppo/stiq/stiq/storage/postgres.py", line
137, in dropDatabaseTable
if isinstance(e.orig, psycopg2.ProgrammingError):
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/schema.py",
line 227, in drop
self.engine.drop(self)
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/engine/
base.py", line 384, in drop
self._run_visitor(self.dialect.schemadropper, entity,
connection=connection, **kwargs)
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/engine/
base.py", line 401, in _run_visitor
conn = self.contextual_connect()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/engine/
base.py", line 461, in contextual_connect
return Connection(self, close_with_result=close_with_result,
**kwargs)
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/engine/
base.py", line 177, in __init__
self.__connection = connection or engine.raw_connection()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/engine/
base.py", line 479, in raw_connection
return self.connection_provider.get_connection()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/engine/
default.py", line 34, in get_connection
return self._pool.connect()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/pool.py",
line 84, in connect
return ConnectionFairy(self).checkout()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/pool.py",
line 130, in __init__
self.connection = pool.get()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/pool.py",
line 102, in get
return self.do_get()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/pool.py",
line 229, in do_get
return self._creator()
File "/Volumes/dati/Sviluppo/sqlalchemy/lib/sqlalchemy/engine/
default.py", line 27, in <lambda>
self._pool = poolclass(lambda: dbapi.connect(*cargs, **cparams),
**kwargs)
psycopg2.OperationalError: could not translate host name
"user=dialtone" to address: No address associated with nodename
-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and
Risk!
Fully trained technicians. The highest number of Red Hat
certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?
cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users