Default page

Your IP: 216.73.216.96
Server IP: 147.93.97.220
Server: Linux srv843233 6.8.0-71-generic #71-Ubuntu SMP PREEMPT_DYNAMIC Tue Jul 22 16:52:38 UTC 2025 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.2.29
Buat File | Buat Folder

View File Name : pgbound_async.py

import psycopg2

def pg_wait(conn, env, timeout=0):
        while 1:
                state = conn.poll()
                if state == psycopg2.extensions.POLL_OK:
                        raise StopIteration
                elif state == psycopg2.extensions.POLL_WRITE:
                        yield env['x-wsgiorg.fdevent.writable'](conn.fileno(), timeout)
                elif state == psycopg2.extensions.POLL_READ:
                        yield env['x-wsgiorg.fdevent.readable'](conn.fileno(), timeout)
                else:
                        raise psycopg2.OperationalError("poll() returned %s" % state)


def application(env, start_response):

        start_response('200 OK', [('Content-Type', 'text/html')])

        connection = psycopg2.connect(database='uwsgi',user='uwsgi',password='uwsgi',host='192.168.173.100', async=1)

        for i in pg_wait(connection, env, 3):
                yield i

        print("connected")
        cursor = connection.cursor()

        cursor.execute("SELECT * FROM foo")

        for i in pg_wait(cursor.connection, env, 3):
                yield i

        print("query result available")

        for record in cursor:
                yield str(record)

        connection.close()