def init_db(self): try: self.pool = mysql.connector.pooling.MySQLConnectionPool( pool_size=5, **self.dbConfig) except NameError: ran_num = random.random() name_my_pool = 'pool%s' % str(ran_num) try: self.pool = mariadb.ConnectionPool( pool_size=5, pool_name=name_my_pool, pool_reset_connection=False, host=self.dbConfig['host'], user=self.dbConfig['user'], password=self.dbConfig['password'], database=self.dbConfig['database']) except mariadb.ProgrammingError: ran_num = random.random() name_my_pool = 'pool%s' % str(ran_num) self.pool = mariadb.ConnectionPool( pool_size=5, pool_name=name_my_pool, pool_reset_connection=False, host=self.dbConfig['host'], user=self.dbConfig['user'], password=self.dbConfig['password'], database=self.dbConfig['database'])
def test_pool_add(self): default_conf = conf() pool = mariadb.ConnectionPool(pool_name="test_pool_add") try: mariadb.ConnectionPool(pool_name="test_pool_add") except mariadb.ProgrammingError as e: pass del pool
def test_pool_add(self): default_conf = conf() pool = mariadb.ConnectionPool(pool_name="test_pool_add") try: mariadb.ConnectionPool(pool_name="test_pool_add") except mariadb.ProgrammingError as e: pass pool.close() self.assertEqual(mariadb._CONNECTION_POOLS, {})
def test_conpy69(self): conn = create_connection() cursor1 = conn.cursor() cursor1.execute("CREATE SCHEMA IF NOT EXISTS 中文考试") default_conf = conf() default_conf["database"] = "中文考试" pool = mariadb.ConnectionPool(pool_name="test_conpy69") try: pool.set_config(**default_conf) except: del pool raise for i in range(1, 6): pool.add_connection() conn = mariadb.connect(pool_name="test_conpy69") cursor = conn.cursor() cursor.execute("select database()") row = cursor.fetchone() self.assertEqual(row[0], "中文考试") cursor.execute( "CREATE TABLE t1 (a varchar(255)) character set utf8mb4") cursor.execute("insert into t1 values (?)", ("123.45 中文考试", )) cursor.execute("select a from t1") row = cursor.fetchone() self.assertEqual(row[0], "123.45 中文考试") cursor1.execute("DROP SCHEMA 中文考试") del pool
def test_pool_add(self): default_conf= conf() pool= mariadb.ConnectionPool(pool_name="test") pool1= mariadb.ConnectionPool(pool_name="test1") pool.set_config(**default_conf) pool1.set_config(**default_conf) conn= create_connection() pool.add_connection(conn) try: pool.add_connection(conn) except mariadb.PoolError as e: pass try: pool1.add_connection(conn) except mariadb.PoolError as e: pass del pool, pool1
def initConnectionPool(): global pool pool = mariadb.ConnectionPool(user=user, password=password, host=host, port=port, database=database, pool_name="app", pool_size=8) return pool
def test__CONNECTION_POOLS(self): default_conf = conf() pool = mariadb.ConnectionPool(pool_name="test_use", **default_conf) conn = mariadb.connect(pool_name="test_use") cursor = conn.cursor() cursor.execute("SELECT 1") row = cursor.fetchone() self.assertEqual(row[0], 1) del cursor del pool
def test_connection_pool_add(self): default_conf= conf() pool= mariadb.ConnectionPool(pool_name="test1") pool.set_config(**default_conf) for i in range(1,6): pool.add_connection() try: pool.add_connection() except mariadb.PoolError: pass del pool
def test_connection_pool_conf(self): pool= mariadb.ConnectionPool(pool_name="test") default_conf= conf() conn= create_connection() try: pool.add_connection(conn) except mariadb.PoolError: pass pool.set_config(**default_conf) pool.add_connection(conn) c= pool.get_connection() self.assertEqual(c, conn) del pool
def __init__(self, mariadb_config): username = mariadb_config['username'] password = mariadb_config['password'] host = mariadb_config['host'] port = int(mariadb_config['port']) database = mariadb_config['database'] pool_name = mariadb_config['connectionpoolname'] pool_size = int(mariadb_config['connectionpoolsize']) print(pool_name) try: self.pool = mariadb.ConnectionPool(pool_name=pool_name, pool_size=pool_size, username=username, password=password, host=host, port=port, database=database) except mariadb.Error as ex: raise ex
def init_mariadb_datamanger(app: Flask, **config): if config is None: config = {} for suffix in ['HOST', 'USER', 'PASSWORD', 'DB', 'POOL_SIZE']: key = f'MARIADB_{suffix}' config.setdefault(suffix.lower(), app.config.get(key)) # print(config) mp = mariadb.ConnectionPool( **config, pool_name="web-app", ) app.mariadb_pool = mp app.mariadb = LocalProxy(get_maria_dm)
def test_connection_pool_maxconn(self): default_conf = conf() pool = mariadb.ConnectionPool(pool_name="test_max_size", **default_conf) connections = [] for i in range(1, 6): connections.append(pool.get_connection()) try: x = pool.get_connection() except mariadb.PoolError: pass for c in connections: c.close() x = pool.get_connection() del pool
def test_conpy40(self): default_conf= conf() pool = mariadb.ConnectionPool(pool_name = 'pool1') try: pool.set_config(pool_size = 3) except mariadb.PoolError: pass pool.set_config(**default_conf) for j in range(3): c = mariadb.connect(**default_conf) pool.add_connection(c) del pool
def initialize () : global DB_CONFIG global SERVER_CONFIG global UDPServerSocket global my_hostname global db_pool global thread_count_high_water try : UDPServerSocket = socket.socket (family=socket.AF_INET, type=socket.SOCK_DGRAM) # Bind to address and ip UDPServerSocket.bind ((SERVER_CONFIG['LOCAL_IP'], SERVER_CONFIG['LISTENER_PORT'])) my_hostname = socket.gethostname () except e: print(f"Error in UDP socket set up: {e}") sys.exit(1) print("logger server listening") try: db_pool = mariadb.ConnectionPool ( # initialize db connection pool pool_name='db_pool' , pool_size=DB_CONFIG['POOLSIZE'] , pool_reset_connection = False , host=DB_CONFIG['HOSTNAME'] , port=DB_CONFIG['PORT'] , user=DB_CONFIG['USERNAME'] , passwd=DB_CONFIG['PASSWORD'] , database=DB_CONFIG['DATABASE'] ) #except mariadb.Error as e: #print(f"Error MariaDB Platform: {e}") #except : #continue thread_count_high_water = DB_CONFIG['POOLSIZE'] - 2 db_connection = get_db_connection () #---- Set start time, et. al. ts_thread = threading.Thread (target=set_initialize_timestamp, args=(get_db_connection(),)) ts_thread.start () ts_thread.join () # wait for thread to complete except mariadb.Error as e: print(f"Error MariaDB Platform: {e}") sys.exit(1) print ('database connection pool initialized') allowed_actions ['ping']['handler'] = ping_handler
def test_conpy40(self): default_conf = conf() pool = mariadb.ConnectionPool(pool_name='test_conpy40') try: pool.set_config(pool_size=3) except mariadb.PoolError: pass try: pool.set_config(**default_conf) except: pool.close() raise for j in range(3): c = mariadb.connect(**default_conf) pool.add_connection(c) pool.close()
def test_conpy69(self): if is_skysql(): self.skipTest("skipping on SkySQL") if is_maxscale(): self.skipTest( "skipping on Maxscale: bug https://jira.mariadb.org/browse/MXS-3921" ) conn = create_connection() conn.autocommit = True cursor1 = conn.cursor() cursor1.execute( "CREATE DATABASE IF NOT EXISTS `中文考试` CHARACTER SET 'utf8mb4'") cursor1.execute("COMMIT") default_conf = conf() default_conf["database"] = "中文考试" pool = mariadb.ConnectionPool(pool_name="test_conpy69") try: pool.set_config(**default_conf) except: pool.close() raise try: for i in range(1, 6): pool.add_connection() conn = mariadb.connect(pool_name="test_conpy69") conn.autocommit = True cursor = conn.cursor() cursor.execute("select database()") row = cursor.fetchone() self.assertEqual(row[0], "中文考试") cursor.execute( "CREATE TABLE t1 (a varchar(255)) character set utf8mb4") cursor.execute("insert into t1 values (?)", ("123.45 中文考试", )) cursor.execute("select a from t1", buffered=True) row = cursor.fetchone() self.assertEqual(row[0], "123.45 中文考试") cursor1.execute("DROP SCHEMA 中文考试") finally: pool.close()
def test_connection_pools(self): pool = mariadb.ConnectionPool(pool_name="test_connection") self.assertEqual(mariadb._CONNECTION_POOLS["test_connection"], pool) del pool self.assertEqual(mariadb._CONNECTION_POOLS, {})
def test_conpy39(self): try: pool = mariadb.ConnectionPool() except mariadb.ProgrammingError: pass
import scad_utils testing: bool = True if testing: fake_datetime = datetime.datetime(2020, 8, 7, 15, 10) app = Flask(__name__) app.config["SECRET_KEY"] = "clave ultra secreta" app.permanent_session_lifetime = datetime.timedelta(minutes=20) teacher_time_tolerance = datetime.timedelta(minutes=20) db = mariadb.ConnectionPool( user="******", password="******", host="localhost", pool_name="pul", pool_size=20, database="scad", ) # tmp_cursor: mysql.cursor.MySQLCursor = db.cursor() # tmp_cursor.execute("SET lc_time_names = 'es_PE';") # tmp_cursor.close() spanish_days: dict = { "Monday": "lunes", "Tuesday": "martes", "Wednesday": "miércoles", "Thursday": "jueves", "Friday": "viernes", "Saturday": "sábado", "Sunday": "domingo",