def test_exportXML1(self):
db = _mysql.connect(host="z",
user="******",
passwd="U865dZpL0E",
db="cs327e_wigu")
truncateAllTables(db)
db.query(
"INSERT INTO Crises (crisisId, name, kind, "
"streetAddress, city, stateOrProvince, postalCode, country, "
"dateAndTime, fatalities, injuries, populationIll, populationDisplaced, "
"environmentalImpact, politicalChanges, culturalChanges, "
"jobsLost, damageInUSD, reparationCost, regulatoryChanges) "
"VALUES (001, 'Katrina', 'Natural Disaster', NULL, 'New Orleans', 'Louisiana', NULL, 'United States', STR_TO_DATE('2005-08-26T09:00:00', '%Y-%m-%dT%H:%i:%s'), 1300, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10000000000, NULL, NULL)"
)
writer = StringIO()
exportXML(writer)
self.assert_(writer.getvalue() == u"<?xml version=\"1.0\" ?>\n"\
u"<root>\n"\
u" <crises>\n"\
u" <crisis>\n"\
u" <crisisId>CRI_1</crisisId>\n"\
u" <name>Katrina</name>\n"\
u" <kind>Natural Disaster</kind>\n"\
u" <city>New Orleans</city>\n"\
u" <stateOrProvince>Louisiana</stateOrProvince>\n"\
u" <country>United States</country>\n"\
u" <dateAndTime>2005-08-26T09:00:00</dateAndTime>\n"\
u" <fatalities>1300</fatalities>\n"\
u" <damageInUSD>10000000000</damageInUSD>\n"\
u" </crisis>\n"\
u" </crises>\n"\
u" <orgs/>\n"\
u" <people/>\n"\
u" <resources/>\n"\
u" <crisisResources/>\n"\
u" <waysToHelp/>\n"\
u" <crisisWaysToHelp/>\n"\
u" <contactInfos/>\n"\
u" <orgContactInfos/>\n"\
u" <citations/>\n"\
u" <crisisCitations/>\n"\
u" <orgCitations/>\n"\
u" <personCitations/>\n"\
u" <urls/>\n"\
u" <crisisUrls/>\n"\
u" <orgUrls/>\n"\
u" <personUrls/>\n"\
u" <crisisOrgs/>\n"\
u" <crisisPeople/>\n"\
u" <orgPeople/>\n"\
u"</root>\n")
def test_exportXML2(self):
db = _mysql.connect(host="z",
user="******",
passwd="U865dZpL0E",
db="cs327e_wigu")
truncateAllTables(db)
db.query("INSERT INTO Orgs (orgId, name, kind, "
"streetAddress, city, stateOrProvince, postalCode, country, "
"foundingMission, dateFounded, dateAbolished, majorEvents) "\
"VALUES (001, 'FEMA', 'Government Agency', '500 C Street SW', 'Washington, D.C.', NULL, '20472', 'USA', 'Support and protect citizens including during disaster or recovery', STR_TO_DATE('1979-04-01', '%Y-%m-%d'), STR_TO_DATE(NULL, '%Y-%m-%d'), 'First establishment of a federal emergency management in U.S. by Congressional Act of 1803')")
writer = StringIO()
exportXML(writer)
self.assert_(writer.getvalue() == u"<?xml version=\"1.0\" ?>\n"\
u"<root>\n"\
u" <crises/>\n"\
u" <orgs>\n"\
u" <org>\n"\
u" <orgId>ORG_1</orgId>\n"\
u" <name>FEMA</name>\n"\
u" <kind>Government Agency</kind>\n"\
u" <streetAddress>500 C Street SW</streetAddress>\n"\
u" <city>Washington, D.C.</city>\n"\
u" <postalCode>20472</postalCode>\n"\
u" <country>USA</country>\n"\
u" <foundingMission>Support and protect citizens including during disaster or recovery</foundingMission>\n"\
u" <dateFounded>1979-04-01</dateFounded>\n"\
u" <majorEvents>First establishment of a federal emergency management in U.S. by Congressional Act of 1803</majorEvents>\n"\
u" </org>\n"\
u" </orgs>\n"\
u" <people/>\n"\
u" <resources/>\n"\
u" <crisisResources/>\n"\
u" <waysToHelp/>\n"\
u" <crisisWaysToHelp/>\n"\
u" <contactInfos/>\n"\
u" <orgContactInfos/>\n"\
u" <citations/>\n"\
u" <crisisCitations/>\n"\
u" <orgCitations/>\n"\
u" <personCitations/>\n"\
u" <urls/>\n"\
u" <crisisUrls/>\n"\
u" <orgUrls/>\n"\
u" <personUrls/>\n"\
u" <crisisOrgs/>\n"\
u" <crisisPeople/>\n"\
u" <orgPeople/>\n"\
u"</root>\n")
def test_exportXML1(self):
db = _mysql.connect(host="z", user="******", passwd="U865dZpL0E", db="cs327e_wigu")
truncateAllTables(db)
db.query("INSERT INTO Crises (crisisId, name, kind, "
"streetAddress, city, stateOrProvince, postalCode, country, "
"dateAndTime, fatalities, injuries, populationIll, populationDisplaced, "
"environmentalImpact, politicalChanges, culturalChanges, "
"jobsLost, damageInUSD, reparationCost, regulatoryChanges) "
"VALUES (001, 'Katrina', 'Natural Disaster', NULL, 'New Orleans', 'Louisiana', NULL, 'United States', STR_TO_DATE('2005-08-26T09:00:00', '%Y-%m-%dT%H:%i:%s'), 1300, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10000000000, NULL, NULL)")
writer = StringIO()
exportXML(writer)
self.assert_(writer.getvalue() == u"<?xml version=\"1.0\" ?>\n"\
u"<root>\n"\
u" <crises>\n"\
u" <crisis>\n"\
u" <crisisId>CRI_1</crisisId>\n"\
u" <name>Katrina</name>\n"\
u" <kind>Natural Disaster</kind>\n"\
u" <city>New Orleans</city>\n"\
u" <stateOrProvince>Louisiana</stateOrProvince>\n"\
u" <country>United States</country>\n"\
u" <dateAndTime>2005-08-26T09:00:00</dateAndTime>\n"\
u" <fatalities>1300</fatalities>\n"\
u" <damageInUSD>10000000000</damageInUSD>\n"\
u" </crisis>\n"\
u" </crises>\n"\
u" <orgs/>\n"\
u" <people/>\n"\
u" <resources/>\n"\
u" <crisisResources/>\n"\
u" <waysToHelp/>\n"\
u" <crisisWaysToHelp/>\n"\
u" <contactInfos/>\n"\
u" <orgContactInfos/>\n"\
u" <citations/>\n"\
u" <crisisCitations/>\n"\
u" <orgCitations/>\n"\
u" <personCitations/>\n"\
u" <urls/>\n"\
u" <crisisUrls/>\n"\
u" <orgUrls/>\n"\
u" <personUrls/>\n"\
u" <crisisOrgs/>\n"\
u" <crisisPeople/>\n"\
u" <orgPeople/>\n"\
u"</root>\n")
def test_exportXML2(self):
db = _mysql.connect(host="z", user="******", passwd="U865dZpL0E", db="cs327e_wigu")
truncateAllTables(db)
db.query("INSERT INTO Orgs (orgId, name, kind, "
"streetAddress, city, stateOrProvince, postalCode, country, "
"foundingMission, dateFounded, dateAbolished, majorEvents) "\
"VALUES (001, 'FEMA', 'Government Agency', '500 C Street SW', 'Washington, D.C.', NULL, '20472', 'USA', 'Support and protect citizens including during disaster or recovery', STR_TO_DATE('1979-04-01', '%Y-%m-%d'), STR_TO_DATE(NULL, '%Y-%m-%d'), 'First establishment of a federal emergency management in U.S. by Congressional Act of 1803')")
writer = StringIO()
exportXML(writer)
self.assert_(writer.getvalue() == u"<?xml version=\"1.0\" ?>\n"\
u"<root>\n"\
u" <crises/>\n"\
u" <orgs>\n"\
u" <org>\n"\
u" <orgId>ORG_1</orgId>\n"\
u" <name>FEMA</name>\n"\
u" <kind>Government Agency</kind>\n"\
u" <streetAddress>500 C Street SW</streetAddress>\n"\
u" <city>Washington, D.C.</city>\n"\
u" <postalCode>20472</postalCode>\n"\
u" <country>USA</country>\n"\
u" <foundingMission>Support and protect citizens including during disaster or recovery</foundingMission>\n"\
u" <dateFounded>1979-04-01</dateFounded>\n"\
u" <majorEvents>First establishment of a federal emergency management in U.S. by Congressional Act of 1803</majorEvents>\n"\
u" </org>\n"\
u" </orgs>\n"\
u" <people/>\n"\
u" <resources/>\n"\
u" <crisisResources/>\n"\
u" <waysToHelp/>\n"\
u" <crisisWaysToHelp/>\n"\
u" <contactInfos/>\n"\
u" <orgContactInfos/>\n"\
u" <citations/>\n"\
u" <crisisCitations/>\n"\
u" <orgCitations/>\n"\
u" <personCitations/>\n"\
u" <urls/>\n"\
u" <crisisUrls/>\n"\
u" <orgUrls/>\n"\
u" <personUrls/>\n"\
u" <crisisOrgs/>\n"\
u" <crisisPeople/>\n"\
u" <orgPeople/>\n"\
u"</root>\n")
def test_exportXML3(self):
db = _mysql.connect(host="z",
user="******",
passwd="U865dZpL0E",
db="cs327e_wigu")
truncateAllTables(db)
db.query("INSERT INTO People (personId, name, kind, streetAddress, city, stateOrProvince, postalCode, country) "\
"VALUES (001, 'George Clooney', 'Actor / Actress', '8817 Lookout Mountain Ave', 'Los Angeles', 'California', '90046-1819', 'USA')")
writer = StringIO()
exportXML(writer)
self.assert_(writer.getvalue() == u"<?xml version=\"1.0\" ?>\n"\
u"<root>\n"\
u" <crises/>\n"\
u" <orgs/>\n"\
u" <people>\n"\
u" <person>\n"\
u" <personId>PER_1</personId>\n"\
u" <name>George Clooney</name>\n"\
u" <kind>Actor / Actress</kind>\n"\
u" <streetAddress>8817 Lookout Mountain Ave</streetAddress>\n"\
u" <city>Los Angeles</city>\n"\
u" <stateOrProvince>California</stateOrProvince>\n"\
u" <postalCode>90046-1819</postalCode>\n"\
u" <country>USA</country>\n"\
u" </person>\n"\
u" </people>\n"\
u" <resources/>\n"\
u" <crisisResources/>\n"\
u" <waysToHelp/>\n"\
u" <crisisWaysToHelp/>\n"\
u" <contactInfos/>\n"\
u" <orgContactInfos/>\n"\
u" <citations/>\n"\
u" <crisisCitations/>\n"\
u" <orgCitations/>\n"\
u" <personCitations/>\n"\
u" <urls/>\n"\
u" <crisisUrls/>\n"\
u" <orgUrls/>\n"\
u" <personUrls/>\n"\
u" <crisisOrgs/>\n"\
u" <crisisPeople/>\n"\
u" <orgPeople/>\n"\
u"</root>\n")
def test_exportXML3(self):
db = _mysql.connect(host="z", user="******", passwd="U865dZpL0E", db="cs327e_wigu")
truncateAllTables(db)
db.query("INSERT INTO People (personId, name, kind, streetAddress, city, stateOrProvince, postalCode, country) "\
"VALUES (001, 'George Clooney', 'Actor / Actress', '8817 Lookout Mountain Ave', 'Los Angeles', 'California', '90046-1819', 'USA')")
writer = StringIO()
exportXML(writer)
self.assert_(writer.getvalue() == u"<?xml version=\"1.0\" ?>\n"\
u"<root>\n"\
u" <crises/>\n"\
u" <orgs/>\n"\
u" <people>\n"\
u" <person>\n"\
u" <personId>PER_1</personId>\n"\
u" <name>George Clooney</name>\n"\
u" <kind>Actor / Actress</kind>\n"\
u" <streetAddress>8817 Lookout Mountain Ave</streetAddress>\n"\
u" <city>Los Angeles</city>\n"\
u" <stateOrProvince>California</stateOrProvince>\n"\
u" <postalCode>90046-1819</postalCode>\n"\
u" <country>USA</country>\n"\
u" </person>\n"\
u" </people>\n"\
u" <resources/>\n"\
u" <crisisResources/>\n"\
u" <waysToHelp/>\n"\
u" <crisisWaysToHelp/>\n"\
u" <contactInfos/>\n"\
u" <orgContactInfos/>\n"\
u" <citations/>\n"\
u" <crisisCitations/>\n"\
u" <orgCitations/>\n"\
u" <personCitations/>\n"\
u" <urls/>\n"\
u" <crisisUrls/>\n"\
u" <orgUrls/>\n"\
u" <personUrls/>\n"\
u" <crisisOrgs/>\n"\
u" <crisisPeople/>\n"\
u" <orgPeople/>\n"\
u"</root>\n")
def test_exportXML4(self):
db = _mysql.connect(host="z",
user="******",
passwd="U865dZpL0E",
db="cs327e_wigu")
truncateAllTables(db)
db.query("INSERT INTO Citations (citationId, citation) "\
"VALUES ('101', 'http://www.ncdc.noaa.gov/extremeevents/specialreports/Hurricane-Katrina.pdf')")
writer = StringIO()
exportXML(writer)
self.assert_(writer.getvalue() == u"<?xml version=\"1.0\" ?>\n"\
u"<root>\n"\
u" <crises/>\n"\
u" <orgs/>\n"\
u" <people/>\n"\
u" <resources/>\n"\
u" <crisisResources/>\n"\
u" <waysToHelp/>\n"\
u" <crisisWaysToHelp/>\n"\
u" <contactInfos/>\n"\
u" <orgContactInfos/>\n"\
u" <citations>\n"\
u" <citationPair>\n"\
u" <citationId>CIT_101</citationId>\n"\
u" <citation>http://www.ncdc.noaa.gov/extremeevents/specialreports/Hurricane-Katrina.pdf</citation>\n"\
u" </citationPair>\n"\
u" </citations>\n"\
u" <crisisCitations/>\n"\
u" <orgCitations/>\n"\
u" <personCitations/>\n"\
u" <urls/>\n"\
u" <crisisUrls/>\n"\
u" <orgUrls/>\n"\
u" <personUrls/>\n"\
u" <crisisOrgs/>\n"\
u" <crisisPeople/>\n"\
u" <orgPeople/>\n"\
u"</root>\n")
def test_exportXML4(self):
db = _mysql.connect(host="z", user="******", passwd="U865dZpL0E", db="cs327e_wigu")
truncateAllTables(db)
db.query("INSERT INTO Citations (citationId, citation) "\
"VALUES ('101', 'http://www.ncdc.noaa.gov/extremeevents/specialreports/Hurricane-Katrina.pdf')")
writer = StringIO()
exportXML(writer)
self.assert_(writer.getvalue() == u"<?xml version=\"1.0\" ?>\n"\
u"<root>\n"\
u" <crises/>\n"\
u" <orgs/>\n"\
u" <people/>\n"\
u" <resources/>\n"\
u" <crisisResources/>\n"\
u" <waysToHelp/>\n"\
u" <crisisWaysToHelp/>\n"\
u" <contactInfos/>\n"\
u" <orgContactInfos/>\n"\
u" <citations>\n"\
u" <citationPair>\n"\
u" <citationId>CIT_101</citationId>\n"\
u" <citation>http://www.ncdc.noaa.gov/extremeevents/specialreports/Hurricane-Katrina.pdf</citation>\n"\
u" </citationPair>\n"\
u" </citations>\n"\
u" <crisisCitations/>\n"\
u" <orgCitations/>\n"\
u" <personCitations/>\n"\
u" <urls/>\n"\
u" <crisisUrls/>\n"\
u" <orgUrls/>\n"\
u" <personUrls/>\n"\
u" <crisisOrgs/>\n"\
u" <crisisPeople/>\n"\
u" <orgPeople/>\n"\
u"</root>\n")
def test_exporXML_3(self): t1 = ['crises'] v = exportXML(t1) self.assertFalse(v == "")
def test_exporXML_2(self): t1 = ['crises'] v = exportXML(t1) self.assertTrue(v != "<root>\n</root>")
def test_exporXML_1(self): t1 = [] v = exportXML(t1) self.assertTrue(v == "<root>\n</root>")