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)