def test_export(self):
connection = wcdb_login_mysql("cs329e_overflow")
query(connection, "use cs329e_overflow;")
connection.close()
allTableNames = ["test_import_1"]
allRowNames = ["col1", "col2"]
self.assertTrue(
wcdb_exportToXML(allTableNames, allRowNames, "cs329e_overflow") ==
True)
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_query_select(self):
connection = wcdb_login_mysql("cs327e_awo84")
t = query(connection, "select crisisId from crises;")
self.assertFalse(
str(t) ==
"(('0',), ('1',), ('2',), ('3',), ('4',), ('5',), ('6',), ('7',), ('8',), ('9',))"
)
def test_query_show(self):
connection = wcdb_login_mysql("cs327e_awo84")
t = query(connection, "show databases;")
self.assertTrue(
str(t) ==
"(('information_schema',), ('cs327e_awo84',), ('cs329e_awo84',), ('cs329e_overflow',))"
)
def test_query_create(self):
connection = wcdb_login_mysql("cs327e_awo84")
query(connection, "use cs329e_awo84;")
query(connection, "drop table if exists testwcdb;")
t = query(connection, "create table testwcdb (one int);")
self.assertTrue(t is None)
query(connection, "drop table if exists testwcdb;")
def test_removeDuplicates_4(self):
removeDuplicates(c)
s = "select * from orgs;"
t = query(c, s)
viewedRows = []
for row in t:
self.assertNotIn(row, viewedRows)
viewedRows.append(row)
self.assertTrue(True)
def test_removeDuplicates_4(self):
removeDuplicates(c)
s = "select * from orgs;"
t = query(c, s)
viewedRows = []
for row in t:
self.assertNotIn(row, viewedRows)
viewedRows.append(row)
self.assertTrue(True)
def test_createTables_2(self):
t = query(c, "Show Tables")
st = (('citations', ), ('contactInfos', ), ('crises', ),
('crisisCitations', ), ('crisisOrgs', ), ('crisisPeople', ),
('crisisResources', ), ('crisisUrls', ), ('crisisWaysToHelp', ),
('orgCitations', ), ('orgContactInfos', ), ('orgPeople', ),
('orgUrls', ), ('orgs', ), ('people', ), ('personCitations', ),
('personUrls', ), ('resources', ), ('urls', ), ('waysToHelp', ))
self.assertTrue(sorted(t) == sorted(st))
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_2(self):
s = "Show Tables"
t = query(c, s)
self.assertTrue(t == (('citations', ), ('contactInfos', ),
('crises', ), ('crisisCitations', ),
('crisisOrgs', ), ('crisisPeople', ),
('crisisResources', ), ('crisisUrls', ),
('crisisWaysToHelp', ), ('orgCitations', ),
('orgContactInfos', ), ('orgPeople', ),
('orgUrls', ), ('orgs', ), ('people', ),
('personCitations', ), ('personUrls', ),
('resources', ), ('urls', ), ('waysToHelp', )))
def test_import(self):
connection = wcdb_login_mysql("cs329e_overflow")
query(connection, "use cs329e_overflow;")
query(connection, "drop table if exists test_import_1;")
query(
connection,
"create table test_import_1 (col1 varchar(10), col2 varchar(10)) ;"
)
reader = StringIO.StringIO(
"<outer1><inner1></inner1><inner2></inner2></outer1>")
self.assertTrue(wcdb_importToMySQL(reader, "cs327e_awo84"))
def test_query_3(self):
s = "Show Databases"
t = query(c, s)
self.assertTrue(t == (('information_schema',), ('cs327e_python1',)))
def test_query_1(self):
c = login()
t = query(c, "show Databases;")
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'>")
def test_query_drop(self):
connection = wcdb_login_mysql("cs327e_awo84")
query(connection, "use cs329e_awo84;")
t = query(connection, "drop table if exists testwcdb;")
self.assertTrue
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):
s = "Show Tables"
t = query(c, s)
self.assertTrue(t == (('citations',), ('contactInfos',), ('crises',), ('crisisCitations',), ('crisisOrgs',), ('crisisPeople',), ('crisisResources',), ('crisisUrls',), ('crisisWaysToHelp',), ('orgCitations',), ('orgContactInfos',), ('orgPeople',), ('orgUrls',), ('orgs',), ('people',), ('personCitations',), ('personUrls',), ('resources',), ('urls',), ('waysToHelp',)))
def test_query_1(self):
s = "drop table if exists crisis"
t = query(c, s)
self.assertTrue(t == None)
def test_createTables_2(self):
t = query(c, "Show Tables")
st = (('citations',), ('contactInfos',), ('crises',), ('crisisCitations',), ('crisisOrgs',), ('crisisPeople',), ('crisisResources',), ('crisisUrls',), ('crisisWaysToHelp',), ('orgCitations',), ('orgContactInfos',), ('orgPeople',), ('orgUrls',), ('orgs',), ('people',), ('personCitations',), ('personUrls',), ('resources',), ('urls',), ('waysToHelp',))
self.assertTrue(sorted(t) == sorted(st))
def test_query_3(self):
s = "Show Databases"
t = query(c, s)
self.assertTrue(t == (('information_schema', ), ('cs327e_python1', )))
def test_query_1(self):
s = "drop table if exists crisis"
t = query(c, s)
self.assertTrue(t == None)