Comments (6)
How about
future = conn.connect()
ioloop.add_future(future, lambda x: ioloop.stop())
ioloop.start()
...
On 31 May 2016 12:18, "Ahmad Yoosofan" [email protected] wrote:
My project needs time consuming queries. Therefore, Momoko seems the best
answer.But I couldn't even run the first sample of Momoko. What is the
problem of the following code:import psycopg2
import momoko
from tornado.ioloop import IOLoop
ioloop = IOLoop.instance()dsn= 'dbname=db1 user=postgres password=myPass host=127.0.0.1 port=5432'
conn = momoko.Connection(dsn=dsn)
future = ioloop.add_future(conn.connect(), lambda x: ioloop.stop())
ioloop.start()
print(type(future))
future.result() # raises exception on connection errorfuture = conn.execute("SELECT 1")
ioloop.add_future(future, lambda x: ioloop.stop())
ioloop.start()
cursor = future.result()
rows = cursor.fetchall()
for m1 in rows:
print(m1)Error : Python3 on Ubuntu 16.04 with latest packages
Traceback (most recent call last):
File "test.01.py", line 11, in
future.result() # raises exception on connection error
AttributeError: 'NoneType' object has no attribute 'result'—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
#143, or mute the thread
https://github.com/notifications/unsubscribe/AADjWdbbg0bP3uQ34MjF84FBrXG-WRh0ks5qG_zWgaJpZM4IqVOC
.
from momoko.
Btw,
You don't really need a future for connect
operation.
On 31 May 2016 12:31, "Zaar Hai" [email protected] wrote:
How about
future = conn.connect() ioloop.add_future(future, lambda x: ioloop.stop()) ioloop.start() ...
On 31 May 2016 12:18, "Ahmad Yoosofan" [email protected] wrote:
My project needs time consuming queries. Therefore, Momoko seems the best
answer.But I couldn't even run the first sample of Momoko. What is the
problem of the following code:import psycopg2
import momoko
from tornado.ioloop import IOLoop
ioloop = IOLoop.instance()dsn= 'dbname=db1 user=postgres password=myPass host=127.0.0.1 port=5432'
conn = momoko.Connection(dsn=dsn)
future = ioloop.add_future(conn.connect(), lambda x: ioloop.stop())
ioloop.start()
print(type(future))
future.result() # raises exception on connection errorfuture = conn.execute("SELECT 1")
ioloop.add_future(future, lambda x: ioloop.stop())
ioloop.start()
cursor = future.result()
rows = cursor.fetchall()
for m1 in rows:
print(m1)Error : Python3 on Ubuntu 16.04 with latest packages
Traceback (most recent call last):
File "test.01.py", line 11, in
future.result() # raises exception on connection error
AttributeError: 'NoneType' object has no attribute 'result'—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
#143, or mute the thread
https://github.com/notifications/unsubscribe/AADjWdbbg0bP3uQ34MjF84FBrXG-WRh0ks5qG_zWgaJpZM4IqVOC
.
from momoko.
Thank you, my problem solved. The corrected code is:
import psycopg2
import momoko
from tornado.ioloop import IOLoop
ioloop = IOLoop.instance()
dsn = "dbname=db user=postgres password=myPass host=127.0.0.1 port=5432"
conn = momoko.Pool(dsn=dsn)
future = conn.connect()
ioloop.add_future(future, lambda x: ioloop.stop())
ioloop.start()
future.result() # raises exception on connection error
future = conn.execute("SELECT 1")
ioloop.add_future(future, lambda x: ioloop.stop())
ioloop.start()
cursor = future.result()
rows = cursor.fetchall()
for m1 in rows:
print(m1)
from momoko.
Please change the sample of the first page on tutorial
from momoko.
Here is simpler code:
import psycopg2
import momoko
from tornado.ioloop import IOLoop
ioloop = IOLoop.instance()
dsn = "dbname=db user=postgres password=myPass host=127.0.0.1 port=5432"
conn = momoko.Pool(dsn=dsn)
ioloop.add_future(conn.connect(), lambda x: ioloop.stop())
ioloop.start()
future = conn.execute("SELECT 1")
ioloop.add_future(future, lambda x: ioloop.stop())
ioloop.start()
cursor = future.result()
rows = cursor.fetchall()
for m1 in rows: print(m1)
from momoko.
My bad - you do need to check future
's result for connect operation if you want to catch connection errors.
from momoko.
Related Issues (20)
- momoko makes IOError in ioloop HOT 3
- Behavior of .execute() wo parameters does not match psycopg2 HOT 1
- code in ConnectionContainer.all_dead conflicts with Pool.putconn HOT 4
- The future returned by Connection.execute will never resolve HOT 1
- self.conns.empty() in Pool.close will not work as expected by big chance HOT 3
- Pool fails to reconnect when using Unix-domain socket (OperationalError: server closed the connection unexpectedly) HOT 18
- Restarting PostgreSQL sometimes causes Pool.getconn() to hang HOT 5
- Momoko Pool trying to use dead connections HOT 3
- Writing tests for tornado app, which uses momoko for postgres DB. HOT 2
- Cannot add momoko HOT 1
- Please help me figure out why this code freezes forever HOT 8
- Any suggestion on how I'd commit/rollback using a connection pool? HOT 3
- when using RealDictCursor, Pool.register_json error HOT 2
- Typo in connection.py (socker instead of socket) HOT 2
- error if trying to connect pool while Postgress is not online HOT 2
- NamedTupleCursor factory test is executed even if MOMOKO_TEST_HSTORE is disabled HOT 1
- Debian packaging HOT 1
- AttributeError: 'Future' object has no attribute 'set_exc_info' HOT 5
- Not worked with python 3.7 HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from momoko.