def test_insert_message(self):
expected = ([1], ['test_message'])
dbUtil.insert_message(self.conn, 'test_table', 'test_message')
actual = dbUtil.getAllMsgs(self.conn, 'test_table')
eq_(actual, expected)
def test_search_msg_by_kword(self):
expected = (1, 'test_message', 'test_table',)
dbUtil.insert_message(self.conn, 'test_table', 'test_message')
actual = dbUtil.search_msg_by_kword(self.conn, 'test_message')
eq_((actual[0].nos[0], actual[0].msgs[0], actual[0].table_name), expected)
def test_get_single_msg(self):
expected = 'test_message'
dbUtil.insert_message(self.conn, 'test_table', 'test_message')
actual = dbUtil.get_single_msg(self.conn, 'test_table', 1)
eq_(actual, expected)
def test_getAllMsgs(self):
expected = ([1], ['test_message'])
dbUtil.insert_message(self.conn, 'test_table', 'test_message')
(no_list, msg_list) = dbUtil.getAllMsgs(self.conn, 'test_table')
actual = (no_list, msg_list)
eq_(actual, expected)
def test_insert_message_rollback02(self):
expected = ()
dbUtil.insert_message(self.conn, 'test_table', 'test_message')
dbUtil.insert_message(self.conn, 'not_exist_table', 'rollback_message')
self.conn.rollback()
actual = dbUtil.getAllMsgs(self.conn, 'test_table')
eq_(actual, expected)
def test_getRandomMsgs(self):
expected = ('test_table', 1, 'test_message')
dbUtil.insert_message(self.conn, 'test_table', 'test_message')
constants.SELECT_ALL_TABLES_SQL = 'sql/select_all_tables_one_table.sql'
(table_name, nos, msgs) = dbUtil.getRandomMsgs(self.conn)
actual = (table_name, nos[0], msgs[0])
eq_(actual, expected)
constants.SELECT_ALL_TABLES_SQL = 'sql/select_all_tables.sql'
def test_delete_message(self):
expected = True
dbUtil.insert_message(self.conn, 'test_table', 'test_message')
actual = dbUtil.delete_message(self.conn, 'test_table', 1)
eq_(actual, expected)
