def test_mysql_mysqldb_connect_args_default(self):
session._init_connection_args(
url.make_url("mysql+mysqldb://u:p@host/test"), self.args)
self.assertEqual(self.args['connect_args'], {
'charset': 'utf8',
'use_unicode': 0
})
def test_queuepool_args(self):
args = {}
session._init_connection_args(
url.make_url("mysql://*****:*****@host/test"), args,
max_pool_size=10, max_overflow=10)
self.assertEqual(args['pool_size'], 10)
self.assertEqual(args['max_overflow'], 10)
def test_queuepool_args(self):
session._init_connection_args(url.make_url("mysql://*****:*****@host/test"),
self.args,
max_pool_size=10,
max_overflow=10)
self.assertEqual(self.args['pool_size'], 10)
self.assertEqual(self.args['max_overflow'], 10)
def test_mysql_connect_args_default(self):
args = {}
session._init_connection_args(
url.make_url("mysql+mysqldb://u:p@host/test"), args)
self.assertTrue(
'connect_args' not in args
)
def test_mysqlconnector_raise_on_warnings_override(self):
session._init_connection_args(
url.make_url(
"mysql+mysqlconnector://u:p@host/test"
"?raise_on_warnings=true"),
self.args
)
self.assertFalse('raise_on_warnings' in self.args['connect_args'])
def test_mysqlconnector_raise_on_warnings_default(self):
args = {}
session._init_connection_args(
url.make_url("mysql+mysqlconnector://u:p@host/test"),
args)
self.assertEqual(
args,
{'connect_args': {'raise_on_warnings': False}}
)
def test_mysqlconnector_raise_on_warnings_override(self):
args = {}
session._init_connection_args(
url.make_url(
"mysql+mysqlconnector://u:p@host/test"
"?raise_on_warnings=true"),
args
)
self.assertTrue(
'connect_args' not in args
)
def test_sqlite_file_pool_args(self):
session._init_connection_args(url.make_url("sqlite:///somefile.db"),
self.args,
max_pool_size=10,
max_overflow=10)
# queuepool arguments are not peresnet
self.assertTrue('pool_size' not in self.args)
self.assertTrue('max_overflow' not in self.args)
self.assertFalse(self.args['connect_args'])
# NullPool is the default for file based connections,
# no need to specify this
self.assertTrue('poolclass' not in self.args)
def test_sqlite_file_pool_args(self):
session._init_connection_args(
url.make_url("sqlite:///somefile.db"), self.args,
max_pool_size=10, max_overflow=10)
# queuepool arguments are not peresnet
self.assertTrue('pool_size' not in self.args)
self.assertTrue(
'max_overflow' not in self.args)
self.assertFalse(self.args['connect_args'])
# NullPool is the default for file based connections,
# no need to specify this
self.assertTrue('poolclass' not in self.args)
def test_sqlite_memory_pool_args(self):
for _url in ("sqlite://", "sqlite:///:memory:"):
session._init_connection_args(url.make_url(_url),
self.args,
max_pool_size=10,
max_overflow=10)
# queuepool arguments are not peresnet
self.assertTrue('pool_size' not in self.args)
self.assertTrue('max_overflow' not in self.args)
self.assertEqual(self.args['connect_args']['check_same_thread'],
False)
# due to memory connection
self.assertTrue('poolclass' in self.args)
def test_sqlite_memory_pool_args(self):
for _url in ("sqlite://", "sqlite:///:memory:"):
session._init_connection_args(
url.make_url(_url), self.args,
max_pool_size=10, max_overflow=10)
# queuepool arguments are not peresnet
self.assertTrue(
'pool_size' not in self.args)
self.assertTrue(
'max_overflow' not in self.args)
self.assertEqual(self.args['connect_args']['check_same_thread'],
False)
# due to memory connection
self.assertTrue('poolclass' in self.args)
def test_postgresql_connect_args_default(self):
session._init_connection_args(
url.make_url("postgresql://*****:*****@host/test"), self.args)
self.assertEqual(self.args['client_encoding'], 'utf8')
self.assertFalse(self.args['connect_args'])
def test_postgresql_connect_args_default(self):
session._init_connection_args(
url.make_url("postgresql://*****:*****@host/test"), self.args)
self.assertEqual(self.args['client_encoding'], 'utf8')
self.assertFalse(self.args['connect_args'])
def test_mysql_mysqldb_connect_args_default(self):
session._init_connection_args(
url.make_url("mysql+mysqldb://u:p@host/test"), self.args)
self.assertEqual(self.args['connect_args'],
{'charset': 'utf8', 'use_unicode': 0})
def test_mysqlconnector_raise_on_warnings_default(self):
session._init_connection_args(
url.make_url("mysql+mysqlconnector://u:p@host/test"), self.args)
self.assertEqual(self.args['connect_args']['raise_on_warnings'], False)
def test_mysqlconnector_raise_on_warnings_override(self):
session._init_connection_args(
url.make_url("mysql+mysqlconnector://u:p@host/test"
"?raise_on_warnings=true"), self.args)
self.assertFalse('raise_on_warnings' in self.args['connect_args'])
def test_mysqlconnector_raise_on_warnings_default(self):
session._init_connection_args(
url.make_url("mysql+mysqlconnector://u:p@host/test"),
self.args)
self.assertEqual(self.args['connect_args']['raise_on_warnings'], False)
