def main():
db = connect()
pid = db.get_backend_pid()
print "Run 'sudo kill -KILL " + str(pid) + "' on server to test functions"
time.sleep(10)
print 'connection_is_ready\t' + str(pgsql.connection_is_ready(db))
print 'connection_is_open\t' + str(pgsql.connection_is_open(db))
if pgsql.connection_is_open(db):
db.close()
sys.exit(0)
def main():
# Create 10 database connections
connections = []
builders = []
results = []
for i in range(0, 10):
connections.append(connect())
# Create queries
for db in connections:
builder = pgsql.Builder(db).select('*').from_('metatags')
builders.append(builder)
# Wait for connections and results to become available
done = False
while not done:
# Done when no more operations are left
if len(builders) == 0 and len(results) == 0:
done = True
continue
for builder in builders:
if builder.isReady():
results.append(builder.asObject())
builders.remove(builder)
elif not pgsql.connection_is_open(builder.db):
builders.remove(builder)
for result in results:
if result.isReady():
print result.next()
results.remove(result)
time.sleep(0.01)
for i in connections:
if pgsql.connection_is_open(i):
i.close()
sys.exit(0)
