def test_gen_by_binlog(self): testBLDir = casedir + os.sep + "well_binlog_dir" agent = MySQLBinlogAgent() success, writeTo = agent.gen_sql_file_by_binlog(testBLDir, "mysql-bin", "mysql-bin.000164", 0, "group-test", "test-instance-id") self.assertTrue(success and writeTo, writeTo) expecteResultFile = testBLDir + os.sep + "testcase1.result" print writeTo, expecteResultFile srcMD5 = FileUtils.calc_file_md5sum(expecteResultFile) destMD5 = FileUtils.calc_file_md5sum(writeTo) self.assertTrue(srcMD5 == destMD5, (srcMD5, destMD5))
def test_gen_by_relaylog(self): time.sleep(1) fakeLocalSlave = TestFailoverAgent.genSlaveStatus("mysql-bin.000003", 59804379, "mysql-bin.000003", 59804379, "relay-log.000018", 3051347, 19) slowerSlaveStatus = TestFailoverAgent.genSlaveStatus("mysql-bin.000003", 59194130, "mysql-bin.000003", 59194130, None, None, 19) relayDir = self._relayCaseDir + os.sep + "working_slave_relay_files" agent = MySQLBinlogAgent() success, diffSize, writeTo = agent.gen_sql_file_by_relaylog(fakeLocalSlave, 20, "relay-log", relayDir, slowerSlaveStatus, "group-test", "test-instance-id") self.assertTrue(success, success) self.assertTrue(diffSize > 0, diffSize) self.assertTrue(writeTo != None, writeTo) expecteResultFile = relayDir + os.sep + "testcase1.result" print writeTo, expecteResultFile tmpMD5 = FileUtils.calc_file_md5sum(writeTo) expMD5 = FileUtils.calc_file_md5sum(expecteResultFile) self.assertTrue(tmpMD5 == expMD5, (tmpMD5, expMD5))