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