def test_import_2(self):
c = WCDB_login()
nodes = WCDB_import(
'<root><crises><crisis>\
<crisisId>CRI_000</crisisId> \
<name>Katrina</name>\
<kind>Natural Disaster</kind>\
<streetAddress>1234 Broad Street</streetAddress>\
<city>Austin</city>\
<stateOrProvince>TX</stateOrProvince>\
<postalCode>78731</postalCode>\
<country>USA</country>\
<dateAndTime>2012-12-13T05:40:00</dateAndTime>\
<fatalities>1</fatalities>\
<injuries>3</injuries>\
<populationIll>5</populationIll>\
<populationDisplaced>3</populationDisplaced>\
<environmentalImpact>Oil spill</environmentalImpact>\
<politicalChanges>Regime changes</politicalChanges>\
<culturalChanges>Lost generation</culturalChanges>\
<jobsLost>999</jobsLost>\
<damageInUSD>999</damageInUSD>\
<reparationCost>999</reparationCost>\
<regulatoryChanges>Stricter levy building codes</regulatoryChanges>\
</crisis></crises></root>', c)
self.assertTrue(type(nodes) is str)
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_login_1(self):
connection = WCDB_login()
assert str(
type(connection)) == "<class 'MySQLdb.connections.Connection'>"
def test_import_3(self):
c = WCDB_login()
nodes = WCDB_import('<xml><xml><xml><xml></xml></xml></xml></xml>', c)
self.assertTrue(type(nodes) is str)
def test_create_4(self):
c = WCDB_login()
WCDB_create(c)
t = WCDB_query(c, 'select * from Resources;')
self.assertTrue(t == ())