def test50013(self): input_text = \ """foo /*!50013 DEFINER=`user_a`@`localhost` SQL SECURITY DEFINER */ bar""" expected = \ """foo bar""" actual = "\n".join(strip_definer(line) for line in input_text.splitlines()) self.assertEqual(actual, expected)
def test50013(self): input_text = \ """foo /*!50013 DEFINER=`user_a`@`localhost` SQL SECURITY DEFINER */ bar""" expected = \ """foo bar""" actual = "\n".join( strip_definer(line) for line in input_text.splitlines()) self.assertEqual(actual, expected)
def test50017(self): input_text = \ """/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`10.175.209.87`*/ /*!50003 TRIGGER `event_summary_index_queue_insert` AFTER INSERT ON `event_summary` FOR EACH ROW BEGIN INSERT INTO `event_summary_index_queue` SET uuid=NEW.uuid, update_time=NEW.update_time; END */;;""" expected = \ """/*!50003 CREATE*/ /*!50003 TRIGGER `event_summary_index_queue_insert` AFTER INSERT ON `event_summary` FOR EACH ROW BEGIN INSERT INTO `event_summary_index_queue` SET uuid=NEW.uuid, update_time=NEW.update_time; END */;;""" actual = "\n".join(strip_definer(line) for line in input_text.splitlines()) self.assertEqual(actual, expected)
def test50017(self): input_text = \ """/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`10.175.209.87`*/ /*!50003 TRIGGER `event_summary_index_queue_insert` AFTER INSERT ON `event_summary` FOR EACH ROW BEGIN INSERT INTO `event_summary_index_queue` SET uuid=NEW.uuid, update_time=NEW.update_time; END */;;""" expected = \ """/*!50003 CREATE*/ /*!50003 TRIGGER `event_summary_index_queue_insert` AFTER INSERT ON `event_summary` FOR EACH ROW BEGIN INSERT INTO `event_summary_index_queue` SET uuid=NEW.uuid, update_time=NEW.update_time; END */;;""" actual = "\n".join( strip_definer(line) for line in input_text.splitlines()) self.assertEqual(actual, expected)