def test_importToSql_3(self):
string="""<root><crises>
<crisis>
<crisisId>CRI_003</crisisId>
<name>Great Depression in US</name>
<kind>Human Error Disaster</kind>
<streetAddress></streetAddress>
<city></city>
<stateOrProvince></stateOrProvince>
<postalCode></postalCode>
<country>USA</country>
<dateAndTime>1929-10-29T00:00:00</dateAndTime>
<fatalities>40000</fatalities>
<injuries>0</injuries>
<populationIll>0</populationIll>
<populationDisplaced>200000</populationDisplaced>
<environmentalImpact></environmentalImpact>
<politicalChanges>New Deal, Increased Size of Government, creation of the Securities and Exchange Commission (SEC) and the Federal Deposit Insurance Corporation (FDIC)</politicalChanges>
<culturalChanges>Generaton that lived through the Great Depression stayed frugal, wary of banks, and suspicious of the stock market</culturalChanges>
<jobsLost>11000000</jobsLost>
<damageInUSD>0</damageInUSD>
<reparationCost>160000000</reparationCost>
<regulatoryChanges>Strict trading and banking regulations</regulatoryChanges>
</crisis>
</crises></root>"""
inputstr = fromstring(string)
c = login()
create(c)
importToSQL(inputstr)
t = query(
c,
"select country from crises where country='USA';")
self.assertTrue(str(t[0][0]) == str('USA'))
def test_create_3(self): h= "z" u = "abatista" p = "TCgfNXdb.p" d = "cs327e_abatista" c = login(h, u, p, d) create(c) t = query( c, "select * from people") self.assertFalse(t is None)
def test_query_3(self):
c = login()
create(c)
t = query(c, "select * from crises;")
self.assertTrue(str(type(t)) == "<type 'tuple'>")
def test_query_2(self):
c = login()
create(c)
t = query(c, "show tables;")
self.assertTrue(str(type(t)) == "<type 'tuple'>")