Last active
August 18, 2022 16:55
Star
You must be signed in to star a gist
Simple Object Pool pattern to Create Connection Pool
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from datetime import datetime | |
from multiprocessing import Lock | |
import mysql.connector | |
USER = "root" | |
PASSWD = "admin" | |
HOST = 'localhost' | |
DB = "db_test" | |
class Connection: | |
def __init__(self, user, pw, host, db): | |
self.created = datetime.now() | |
self.conn = mysql.connector.connect(user=user, password=pw, host=host, database=db) | |
def get_conn(self): | |
return self.conn | |
def close_conn(self): | |
return self.conn.close() | |
class ConnectionPool: | |
def __init__(self, conn_number): | |
self.conn_number = conn_number | |
self.pool = [] | |
self.init_pool() | |
@staticmethod | |
def create_new_conn(): | |
return Connection(USER, PASSWD, HOST, DB) | |
def init_pool(self): | |
for i in range(self.conn_number): | |
conn = self.create_new_conn() | |
self.pool.append(conn.get_conn()) | |
def get_conn(self): | |
try: | |
with Lock(): | |
return self.pool.pop() | |
except IndexError: | |
raise Exception("Connection Full") | |
def return_conn(self, conn: Connection): | |
with Lock(): | |
self.pool.append(conn) | |
if __name__ == 'main': | |
from threading import Thread | |
pool = ConnectionPool(1) | |
def try_connection(pid): | |
print("Conn from pid ", pid) | |
try: | |
conn = pool.get_conn() | |
print(conn.get_server_info()) | |
# try pulling connection without returning it | |
# pool.return_conn(conn) | |
except Exception as e: | |
print(str(e)) | |
proc = [] | |
for i in range(200): | |
proc.append(Thread(target=try_connection, args=(i,))) | |
[p.start() for p in proc] | |
[p.join() for p in proc] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment