my English is not so good for more information visit to
http://pyamf.org/ticket/702
http://pyamf.org/wiki/AddressBookExample
http://pyamf.org/browser/examples/trunk/addressbook
http://svn.pyamf.org/examples/trunk/addressbook/python
Hello, i test sqlalchemy + pyamf example
and i use PostgreSQL and firebirt engines and
i make little change change in client.py module
like it
#!/usr/bin/python
#
# Copyright (c) 2009 The PyAMF Project.
# See LICENSE.txt for details.
"""
Client for the SQLAlchemy Addressbook example.
@see: U{AddressBookExample<http://pyamf.org/wiki/AddressBookExample>}
wiki page.
@since: 0.5
"""
import logging
from optparse import OptionParser
from server import host, port, namespace
from pyamf.remoting.client import RemotingService
logging.basicConfig(
level=logging.INFO,
format='%(asctime)s %(levelname)-5.5s [%(name)s] %(message)s'
)
parser = OptionParser()
parser.add_option("-p", "--port", default=port,
dest="port", help="port number [default: %default]")
parser.add_option("--host", default=host,
dest="host", help="host address [default: %default]")
(options, args) = parser.parse_args()
url = 'http://%s:%d' % (options.host, int(options.port))
client = RemotingService(url, logger=logging)
service = client.getService('ExampleService')
ns = namespace + '.'
print service.insertDefaultData()
print 'Load users:'
for n in range(50):
print service.loadAll(ns + 'User')
and i get trace back like it
2009-12-10 11:13:12,052 INFO sqlalchemy.engine.base.Engine.0x...6170
select relname from pg_class c join pg_namespace n on n.oid=c.
relnamespace where n.nspname=current_schema() and lower(relname)=%
(name)s
2009-12-10 11:13:12,068 INFO sqlalchemy.engine.base.Engine.0x...6170
{'name': 'users_table'}
2009-12-10 11:13:12,068 INFO sqlalchemy.engine.base.Engine.0x...6170
select relname from pg_class c join pg_namespace n on n.oid=c.
relnamespace where n.nspname=current_schema() and lower(relname)=%
(name)s
2009-12-10 11:13:12,068 INFO sqlalchemy.engine.base.Engine.0x...6170
{'name': 'phone_numbers_table'}
2009-12-10 11:13:12,068 INFO sqlalchemy.engine.base.Engine.0x...6170
select relname from pg_class c join pg_namespace n on n.oid=c.
relnamespace where n.nspname=current_schema() and lower(relname)=%
(name)s
2009-12-10 11:13:12,068 INFO sqlalchemy.engine.base.Engine.0x...6170
{'name': 'emails_table'}
2009-12-10 11:13:12,068 INFO [root] Connecting to http://localhost:8000
Added user: Bill Lumbergh
Load users:
[<models.User object at 0x0131BA90>, <models.User object at
0x0131BC70>, <models.User object at 0x0131BDF0>, <models.User object
at
0x0131BF70>]
[<models.User object at 0x01329250>, <models.User object at
0x01329370>, <models.User object at 0x012B6AF0>, <models.User object
at
0x0131BE50>]
[<models.User object at 0x0131BD10>, <models.User object at
0x0131B550>, <models.User object at 0x0131BCB0>, <models.User object
at
0x01329570>]
[<models.User object at 0x01329850>, <models.User object at
0x01329970>, <models.User object at 0x01329AF0>, <models.User object
at
0x01329C70>]
[<models.User object at 0x01329F30>, <models.User object at
0x01329FF0>, <models.User object at 0x013119D0>, <models.User object
at
0x01329B50>]
[<models.User object at 0x01329930>, <models.User object at
0x013297B0>, <models.User object at 0x01329630>, <models.User object
at
0x01329310>]
[<models.User object at 0x0131B910>, <models.User object at
0x0131BB90>, <models.User object at 0x0131BA50>, <models.User object
at
0x0133A2D0>]
[<models.User object at 0x0133A590>, <models.User object at
0x0133A6B0>, <models.User object at 0x0131B9D0>, <models.User object
at
0x0131BB70>]
[<models.User object at 0x01329790>, <models.User object at
0x01329810>, <models.User object at 0x01329890>, <models.User object
at
0x01329E10>]
[<models.User object at 0x0133A330>, <models.User object at
0x0133A310>, <models.User object at 0x0133A130>, <models.User object
at
0x0133A910>]
[<models.User object at 0x0133ABD0>, <models.User object at
0x0133ACF0>, <models.User object at 0x013296B0>, <models.User object
at
0x013296F0>]
[<models.User object at 0x0131BCB0>, <models.User object at
0x0131BE30>, <models.User object at 0x0133A890>, <models.User object
at
0x0133A070>]
[<models.User object at 0x0133A370>, <models.User object at
0x0133A410>, <models.User object at 0x0133AE30>, <models.User object
at
0x0133AF50>]
[<models.User object at 0x01372230>, <models.User object at
0x01372350>, <models.User object at 0x0131BC30>, <models.User object
at
0x0133AE70>]
ErrorFault level=error code=u'TimeoutError' description=u'QueuePool
limit of size 5 overflow 10 reached, connection timed out, time
out 30'
Traceback:
u'[\'Traceback (most recent call last):\', \' File "build\\\
\bdist.win32\\\\egg\\\\pyamf\\\\remoting\\\\amf0.py", line 108, in __c
all__ *args, **kwargs)\', \' File "build\\\\bdist.win32\\\\egg\\\
\pyamf\\\\remoting\\\\amf0.py", line 61, in _getBody **kwar
gs)\', \' File "build\\\\bdist.win32\\\\egg\\\\pyamf\\\\remoting\\\
\gateway\\\\__init__.py", line 522, in callServiceRequest\', \'
File "build\\\\bdist.win32\\\\egg\\\\pyamf\\\\remoting\\\\gateway\\\
\__init__.py", line 233, in __call__\', \' File "build\\\\bd
ist.win32\\\\egg\\\\pyamf\\\\remoting\\\\gateway\\\\__init__.py", line
133, in __call__\', \' File "G:\\\\SVN\\\\examples\\\\addre
ssbook\\\\python\\\\controller.py", line 31, in loadAll return
session.query(klass).all()\', \' File "c:\\\\python25\\\\lib\\\\
site-packages\\\\SQLAlchemy-0.5.6-py2.5.egg\\\\sqlalchemy\\\\orm\\\
\query.py", line 1267, in all return list(self)\', \' File "
c:\\\\python25\\\\lib\\\\site-packages\\\\SQLAlchemy-0.5.6-py2.5.egg\\\
\sqlalchemy\\\\orm\\\\query.py", line 1361, in __iter__ r
eturn self._execute_and_instances(context)\', \' File "c:\\\\python25\
\\\lib\\\\site-packages\\\\SQLAlchemy-0.5.6-py2.5.egg\\\\sql
alchemy\\\\orm\\\\query.py", line 1364, in _execute_and_instances
result = self.session.execute(querycontext.statement, params=s
elf._params, mapper=self._mapper_zero_or_none())\', \' File "c:\\\
\python25\\\\lib\\\\site-packages\\\\SQLAlchemy-0.5.6-py2.5.egg\
\\\sqlalchemy\\\\orm\\\\session.py", line 754, in execute return
self.__connection(engine, close_with_result=True).execute(\', \
' File "c:\\\\python25\\\\lib\\\\site-packages\\\\SQLAlchemy-0.5.6-
py2.5.egg\\\\sqlalchemy\\\\orm\\\\session.py", line 719, in __c
onnection return self.transaction._connection_for_bind(engine)\',
\' File "c:\\\\python25\\\\lib\\\\site-packages\\\\SQLAlchemy
-0.5.6-py2.5.egg\\\\sqlalchemy\\\\orm\\\\session.py", line 329, in
_connection_for_bind conn = bind.contextual_connect()\', \'
File "c:\\\\python25\\\\lib\\\\site-packages\\\\SQLAlchemy-0.5.6-
py2.5.egg\\\\sqlalchemy\\\\engine\\\\base.py", line 1229, in conte
xtual_connect return self.Connection(self, self.pool.connect(),
close_with_result=close_with_result, **kwargs)\', \' File "c:\\
\\python25\\\\lib\\\\site-packages\\\\SQLAlchemy-0.5.6-py2.5.egg\\\
\sqlalchemy\\\\pool.py", line 142, in connect return _Connect
ionFairy(self).checkout()\', \' File "c:\\\\python25\\\\lib\\\\site-
packages\\\\SQLAlchemy-0.5.6-py2.5.egg\\\\sqlalchemy\\\\pool.p
y", line 304, in __init__ rec = self._connection_record = pool.get()
\', \' File "c:\\\\python25\\\\lib\\\\site-packages\\\\SQLA
lchemy-0.5.6-py2.5.egg\\\\sqlalchemy\\\\pool.py", line 161, in get
return self.do_get()\', \' File "c:\\\\python25\\\\lib\\\\si
te-packages\\\\SQLAlchemy-0.5.6-py2.5.egg\\\\sqlalchemy\\\\pool.py",
line 628, in do_get raise exc.TimeoutError("QueuePool limit
of size %d overflow %d reached, connection timed out, timeout %d" %
(self.size(), self.overflow(), self._timeout))\', \'TimeoutErr
or: QueuePool limit of size 5 overflow 10 reached, connection timed
out, timeout 30\']'
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
