def test_query_3(self):
c = WCDB_login()
t = WCDB_query(c, 'drop table if exists Test3;')
t = WCDB_query(
c, """
create table Test3(
orgID int unsigned,
contactInfoID int unsigned)
;
""")
self.assertTrue(t == None)
def test_query_1(self):
c = WCDB_login()
t = WCDB_query(c, 'drop table if exists Test1;')
t = WCDB_query(
c, """
create table Test1(
crisisID int unsigned,
personID int unsigned)
;
""")
self.assertTrue(t == None)
def test_create_3(self):
c = WCDB_login()
WCDB_create(c)
t = WCDB_query(c, 'select * from People;')
self.assertTrue(t == ())
def test_create_1(self):
c = WCDB_login()
WCDB_create(c)
t = WCDB_query(c, 'select name from Crises;')
self.assertTrue(t == ())
def test_query_5(self):
c = WCDB_login()
t = WCDB_query(c, 'show tables;')
self.assertTrue(t != None)
self.assertTrue(type(t) is tuple)
def test_query_2(self):
c = WCDB_login()
t = WCDB_query(c, 'select * from Crises;')
self.assertTrue(t != None)
self.assertTrue(type(t) is tuple)
def test_create_4(self):
c = WCDB_login()
WCDB_create(c)
t = WCDB_query(c, 'select * from Resources;')
self.assertTrue(t == ())