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_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__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_create_pool_from_conn(self):
default_conf = conf()
key = "t1"
conn = mariadb.connect(pool_name=key, **default_conf)
cursor = conn.cursor()
del mariadb._CONNECTION_POOLS["t1"]
self.assertEqual(mariadb._CONNECTION_POOLS, {})
try:
cursor.execute("SELECT 1")
except mariadb.ProgrammingError:
pass
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_pool_getter(self):
default_conf= conf()
conn= mariadb.connect(pool_name="getter_test", pool_size=4, **default_conf)
p= mariadb._CONNECTION_POOLS["getter_test"]
self.assertEqual(p.pool_name, "getter_test")
self.assertEqual(p.pool_size, 4)
if "pool_reset_connection" in default_conf:
self.assertEqual(p.pool_reset_connection, default_conf["pool_reset_connection"])
else:
self.assertEqual(p.pool_reset_connection, True)
self.assertEqual(p.max_size, 64)
del mariadb._CONNECTION_POOLS["getter_test"]
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 test_pool_connection_reset(self):
default_conf= conf()
conn= mariadb.connect(pool_name="reset_test", pool_size=1, **default_conf)
cursor= conn.cursor()
cursor.execute("SELECT 1")
cursor.close()
conn.close()
conn= mariadb.connect(pool_name="reset_test")
cursor= conn.cursor()
cursor.execute("SELECT 2")
row= cursor.fetchone()
self.assertEqual(row[0], 2)
del mariadb._CONNECTION_POOLS["reset_test"]
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 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 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()
