def setUp(self):
"""Function: setUp
Description: Initialization for unit testing.
Arguments:
"""
self.base_dir = "test/integration"
self.config_dir = os.path.join(self.base_dir, "config")
self.config_name = "master_mysql_cfg"
self.cfg = gen_libs.load_module(self.config_name, self.config_dir)
self.svr = mysql_class.MasterRep(self.cfg.name,
self.cfg.sid,
self.cfg.user,
self.cfg.japd,
os_type=getattr(
machine, self.cfg.serv_os)(),
host=self.cfg.host,
port=self.cfg.port,
defaults_file=self.cfg.cfg_file)
self.svr2 = mysql_class.MasterRep(self.cfg.name,
self.cfg.sid,
self.cfg.user,
"testmenopwd",
os_type=getattr(
machine, self.cfg.serv_os)(),
host=self.cfg.host,
port=self.cfg.port,
defaults_file=self.cfg.cfg_file)
self.err_msg = "Couldn't connect to database. MySQL error 1045:"
def setUp(self):
"""Function: setUp
Description: Initialization for unit testing.
Arguments:
"""
self.name = "Mysql_Server"
self.server_id = 10
self.sql_user = "******"
self.sql_pass = "******"
self.machine = getattr(machine, "Linux")()
self.host = "host_server"
self.port = 3307
self.defaults_file = "def_cfg_file"
self.extra_def_file = "extra_cfg_file"
self.rep_user = "******"
self.rep_japd = "rep_japd"
self.mysqlrep = mysql_class.MasterRep(self.name,
self.server_id,
self.sql_user,
self.sql_pass,
os_type=self.machine,
defaults_file=self.defaults_file,
rep_user=self.rep_user,
rep_japd=self.rep_japd)
def test_ssl_disabled2(self):
"""Function: test_ssl_disabled2
Description: Test with ssl_disabled attribute.
Arguments:
"""
mysqldb = mysql_class.MasterRep(
self.cfg.name, self.cfg.sid, self.cfg.user, self.cfg.japd,
os_type=self.machine, ssl_disabled=True)
self.assertEqual(mysqldb.ssl_disabled, True)
def test_ssl_verify_id(self):
"""Function: test_ssl_verify_id
Description: Test with ssl_verify_id attribute.
Arguments:
"""
mysqldb = mysql_class.MasterRep(
self.cfg.name, self.cfg.sid, self.cfg.user, self.cfg.japd,
os_type=self.machine)
self.assertEqual(mysqldb.ssl_verify_id, False)
def test_version(self):
"""Function: test_version
Description: Test with version attribute.
Arguments:
"""
mysqlrep = mysql_class.MasterRep(
self.name, self.server_id, self.sql_user, self.sql_pass,
os_type=self.machine)
self.assertEqual(mysqlrep.version, None)
def test_indb_buf_write(self):
"""Function: test_indb_buf_write
Description: Test with indb_buf_write attribute.
Arguments:
"""
mysqlrep = mysql_class.MasterRep(
self.name, self.server_id, self.sql_user, self.sql_pass,
os_type=self.machine)
self.assertEqual(mysqlrep.indb_buf_write, None)
def test_ssl_client_key2(self):
"""Function: test_ssl_client_key2
Description: Test with ssl_client_key attribute.
Arguments:
"""
mysqlrep = mysql_class.MasterRep(
self.name, self.server_id, self.sql_user, self.sql_pass,
os_type=self.machine, ssl_client_key="KeyFile")
self.assertEqual(mysqlrep.ssl_client_key, "KeyFile")
def test_ssl_client_ca(self):
"""Function: test_ssl_client_ca
Description: Test with ssl_client_ca attribute.
Arguments:
"""
mysqlrep = mysql_class.MasterRep(
self.name, self.server_id, self.sql_user, self.sql_pass,
os_type=self.machine)
self.assertEqual(mysqlrep.ssl_client_ca, None)
def test_ssl_disabled(self):
"""Function: test_ssl_disabled
Description: Test with ssl_disabled attribute.
Arguments:
"""
mysqldb = mysql_class.MasterRep(
self.name, self.server_id, self.sql_user, self.sql_pass,
os_type=self.machine)
self.assertEqual(mysqldb.ssl_disabled, False)
def test_no_host(self):
"""Function: test_no_host
Description: Test with no host arg.
Arguments:
"""
mysqlrep = mysql_class.MasterRep(
self.name, self.server_id, self.sql_user, self.sql_pass,
os_type=self.machine)
self.assertEqual(mysqlrep.host, "localhost")
def test_ssl_config(self):
"""Function: test_ssl_config
Description: Test config with ssl attributes set.
Arguments:
"""
mysqlrep = mysql_class.MasterRep(
self.name, self.server_id, self.sql_user, self.sql_pass,
os_type=self.machine, ssl_client_ca="CAFile")
self.assertEqual(mysqlrep.config, self.config2)
def test_ssl_verify_id2(self):
"""Function: test_ssl_verify_id2
Description: Test with ssl_verify_id attribute.
Arguments:
"""
mysqldb = mysql_class.MasterRep(
self.name, self.server_id, self.sql_user, self.sql_pass,
os_type=self.machine, ssl_verify_id=True)
self.assertEqual(mysqldb.ssl_verify_id, True)
def test_no_port(self):
"""Function: test_no_port
Description: Test with no port arg.
Arguments:
"""
mysqlrep = mysql_class.MasterRep(
self.name, self.server_id, self.sql_user, self.sql_pass,
os_type=self.machine)
self.assertEqual(mysqlrep.port, 3306)
def test_no_default(self):
"""Function: test_no_default
Description: Test with no default file.
Arguments:
"""
mysqlrep = mysql_class.MasterRep(
self.name, self.server_id, self.sql_user, self.sql_pass,
os_type=self.machine)
self.assertEqual(mysqlrep.defaults_file, self.results)
def test_no_host(self):
"""Function: test_no_host
Description: Test with no host arg.
Arguments:
"""
mysqldb = mysql_class.MasterRep(
self.cfg.name, self.cfg.sid, self.cfg.user, self.cfg.japd,
os_type=getattr(machine, self.cfg.serv_os)(), port=self.cfg.port)
self.assertEqual(mysqldb.host, "localhost")
def test_conn(self):
"""Function: test_conn
Description: Test with conn attribute.
Arguments:
"""
mysqldb = mysql_class.MasterRep(
self.cfg.name, self.cfg.sid, self.cfg.user, self.cfg.japd,
os_type=getattr(machine, self.cfg.serv_os)(), host=self.cfg.host)
self.assertEqual(mysqldb.conn, None)
def test_no_default(self):
"""Function: test_no_default
Description: Test with no default file.
Arguments:
"""
mysqldb = mysql_class.MasterRep(
self.cfg.name, self.cfg.sid, self.cfg.user, self.cfg.japd,
os_type=getattr(machine, self.cfg.serv_os)(), host=self.cfg.host,
port=self.cfg.port)
self.assertEqual(mysqldb.defaults_file, self.results)
def test_no_extra_def_file(self):
"""Function: test_no_extra_def_file
Description: Test with no extra_def_file arg.
Arguments:
"""
mysqldb = mysql_class.MasterRep(
self.cfg.name, self.cfg.sid, self.cfg.user, self.cfg.japd,
os_type=getattr(machine, self.cfg.serv_os)(), host=self.cfg.host,
port=self.cfg.port)
self.assertEqual(mysqldb.extra_def_file, None)
def test_sql_pass(self):
"""Function: test_sql_pass
Description: Test with sql_pass attribute.
Arguments:
"""
mysqldb = mysql_class.MasterRep(
self.cfg.name, self.cfg.sid, self.cfg.user, self.cfg.japd,
os_type=getattr(machine, self.cfg.serv_os)(), host=self.cfg.host,
port=self.cfg.port)
self.assertEqual(mysqldb.sql_pass, self.cfg.japd)
def test_ssl_client_ca2(self):
"""Function: test_ssl_client_ca2
Description: Test with ssl_client_ca attribute.
Arguments:
"""
mysqldb = mysql_class.MasterRep(
self.cfg.name, self.cfg.sid, self.cfg.user, self.cfg.japd,
os_type=getattr(machine, self.cfg.serv_os)(), host=self.cfg.host,
port=self.cfg.port, ssl_client_ca="CAFile")
self.assertEqual(mysqldb.ssl_client_ca, "CAFile")
def test_ssl_client_flag(self):
"""Function: test_ssl_client_flag
Description: Test with ssl_client_flag attribute.
Arguments:
"""
mysqlrep = mysql_class.MasterRep(
self.name, self.server_id, self.sql_user, self.sql_pass,
os_type=self.machine)
self.assertEqual(mysqlrep.ssl_client_flag,
mysql.connector.ClientFlag.SSL)
def test_default(self):
"""Function: test_default
Description: Test get_log_info method.
Arguments:
"""
mysqlrep = mysql_class.MasterRep(self.name,
self.server_id,
self.sql_user,
self.sql_pass,
self.machine,
defaults_file=self.defaults_file)
self.assertEqual((mysqlrep.get_log_info()), (None, None))
def test_ssl_client_flag(self):
"""Function: test_ssl_client_flag
Description: Test with ssl_client_flag attribute.
Arguments:
"""
mysqldb = mysql_class.MasterRep(
self.cfg.name, self.cfg.sid, self.cfg.user, self.cfg.japd,
os_type=getattr(machine, self.cfg.serv_os)(), host=self.cfg.host,
port=self.cfg.port)
self.assertEqual(mysqldb.ssl_client_flag,
mysql.connector.ClientFlag.SSL)
def test_ssl_config5(self):
"""Function: test_ssl_config5
Description: Test config with ssl attributes set.
Arguments:
"""
mysqlrep = mysql_class.MasterRep(
self.name, self.server_id, self.sql_user, self.sql_pass,
os_type=self.machine, ssl_client_ca="CAFile",
ssl_client_key="KeyFile", ssl_client_cert="CertFile",
ssl_client_flag=4096, ssl_disabled=True)
self.assertEqual(mysqlrep.config, self.config6)
def test_ssl_config2(self):
"""Function: test_ssl_config2
Description: Test config with ssl attributes set.
Arguments:
"""
mysqldb = mysql_class.MasterRep(
self.cfg.name, self.cfg.sid, self.cfg.user, self.cfg.japd,
os_type=getattr(machine, self.cfg.serv_os)(), host=self.cfg.host,
port=self.cfg.port, ssl_client_key="KeyFile",
ssl_client_cert="CertFile")
self.assertEqual(mysqldb.config, self.config3)
def test_default(self, mock_hosts):
"""Function: test_default
Description: Test show_slv_hosts method.
Arguments:
"""
mock_hosts.return_value = True
mysqlrep = mysql_class.MasterRep(self.name,
self.server_id,
self.sql_user,
self.sql_pass,
self.machine,
defaults_file=self.defaults_file)
self.assertTrue(mysqlrep.show_slv_hosts())
def setUp(self):
"""Function: setUp
Description: Initialization for unit testing.
Arguments:
"""
self.base_dir = "test/integration"
self.config_dir = os.path.join(self.base_dir, "config")
self.config_name = "master_mysql_cfg"
cfg = gen_libs.load_module(self.config_name, self.config_dir)
self.svr = mysql_class.MasterRep(
cfg.name, cfg.sid, cfg.user, cfg.japd,
os_type=getattr(machine, cfg.serv_os)(), host=cfg.host,
port=cfg.port, defaults_file=cfg.cfg_file)
self.svr.connect()
def test_value(self, mock_stat, mock_log):
"""Function: test_value
Description: Test with values returned.
Arguments:
"""
mock_log.return_value = True
mock_stat.return_value = self.show_stat
mysqldb = mysql_class.MasterRep(self.name, self.server_id,
self.sql_user, self.sql_pass,
self.machine,
defaults_file=self.defaults_file)
mysqldb.upd_mst_status()
self.assertEqual((mysqldb.exe_gtid), ("23678"))
def test_min(self):
"""Function: test_min
Description: Test with minimum number of arguments.
Arguments:
"""
mysqlrep = mysql_class.MasterRep(
self.name, self.server_id, self.sql_user, self.sql_pass,
os_type=self.machine, defaults_file=self.defaults_file)
self.assertEqual(
(mysqlrep.name, mysqlrep.server_id, mysqlrep.sql_user,
mysqlrep.sql_pass, mysqlrep.machine, mysqlrep.host,
mysqlrep.port),
(self.name, self.server_id, self.sql_user, self.sql_pass,
self.machine, "localhost", 3306))
def test_host(self):
"""Function: test_host
Description: Test with passing host arg.
Arguments:
"""
mysqlrep = mysql_class.MasterRep(
self.name, self.server_id, self.sql_user, self.sql_pass,
os_type=self.machine, host=self.host)
self.assertEqual(
(mysqlrep.name, mysqlrep.server_id, mysqlrep.sql_user,
mysqlrep.sql_pass, mysqlrep.machine, mysqlrep.host,
mysqlrep.port),
(self.name, self.server_id, self.sql_user, self.sql_pass,
self.machine, self.host, 3306))
