def test_different_update_comparisson(self):
sql_info_1 = SqlInfo("UPDATE phpbb_sessions\
SET session_user_id = -1, session_start = 1319238613, session_time = 1319238613, session_page = 0, session_logged_in = 0\
WHERE session_id = '1'\
AND session_ip = '7f000001'")
sql_info_2 = SqlInfo("UPDATE phpbb_sessions\
SET user = -1, session_start = 213124, session_time = 1319238613, session_page = 0, session_logged_in = 0\
WHERE session_id = '5'\
AND session_ip = '7f000001'")
self.assertFalse(sql_info_1.compare(sql_info_2))
def test_different_types_comparisson(self):
sql_info_1 = SqlInfo("INSERT INTO users (name, email) VALUES ('joao', '*****@*****.**')")
sql_info_2 = SqlInfo("DELETE FROM users WHERE id = 5")
self.assertFalse(sql_info_1.compare(sql_info_2))
def test_different_delete_comparisson(self):
sql_info_1 = SqlInfo("DELETE FROM users WHERE id = 1")
sql_info_2 = SqlInfo("DELETE FROM cool_users WHERE id = 5")
self.assertFalse(sql_info_1.compare(sql_info_2))
def test_equal_delete_comparisson(self):
sql_info_1 = SqlInfo("DELETE FROM users WHERE id = 1")
sql_info_2 = SqlInfo("DELETE FROM users WHERE id = 5")
self.assertTrue(sql_info_1.compare(sql_info_2))
def test_different_insert_comparisson(self):
sql_info_1 = SqlInfo("INSERT INTO users (name, email) VALUES ('joao', '*****@*****.**')")
sql_info_2 = SqlInfo("INSERT INTO cool_users (name, email) VALUES ('maria', '*****@*****.**')")
self.assertFalse(sql_info_1.compare(sql_info_2))
def test_equal_insert_comparisson(self):
sql_info_1 = SqlInfo("INSERT INTO users (name, email) VALUES ('joao', '*****@*****.**')")
sql_info_2 = SqlInfo("INSERT INTO users (name, email) VALUES ('maria', '*****@*****.**')")
self.assertTrue(sql_info_1.compare(sql_info_2))
