def test_insert(self):
c = wcdb_login()
cur = c.cursor(buffered=True)
cur.execute("DELETE from crises")
wcdb_insert('crises', "crisisId", "'CRI_001'")
c = wcdb_login()
cur = c.cursor(buffered=True)
cur.execute("select * from crises")
b = cur.fetchall()
self.assertTrue(b == [('CRI_001', '', 'Natural Disaster', None, None,
None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None,
None)])
def test_insert_4(self):
c = wcdb_login()
cur = c.cursor(buffered=True)
cur.execute("DELETE from crises")
wcdb_insert('crises', "crisisId,kind", "'CRI_55','Act of Terrorism'")
cur.execute("select * from crises")
b = cur.fetchall()
self.assertTrue(b == [('CRI_55', '', 'Act of Terrorism', None, None,
None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None,
None)])
def test_login(self):
c = wcdb_login()
self.assertTrue(type(c) == mysql.connector.connection.MySQLConnection)
def test_create_tables(self):
wcdb_create_tables()
c = wcdb_login()
cur = c.cursor(buffered=True)
cur.execute("show tables")
b = cur.fetchall()