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))