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_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', )))