def test_import3 (self) :
c = _mysql.connect(
host = "z",
user = "******",
passwd = "Ez0CbTAuV~",
db = "cs327e_iwo")
tree = ET.parse(StringIO("<WorldCrises></WorldCrises>"))
root = tree.getroot()
WCDB3_setup(c)
WCDB3_import(c, root)
self.assert_(len(query(c, "select * from Organization;"))==0)
def test_import2 (self) :
c = _mysql.connect(
host = "z",
user = "******",
passwd = "Ez0CbTAuV~",
db = "cs327e_iwo")
tree = ET.parse(StringIO("<Bar><PersonKind id=\"1\"><Name>Cela</Name></PersonKind><Person id=\"12\"><Name><Suffix>Waza</Suffix></Name></Person><Person id=\"7\"><Name><FirstName>Kozak</FirstName></Name></Person><Organization hcwd=\"45\"><Location><Locality>Austin</Locality></Location><ContactInfo><PostalAddress><Locality>Marchew</Locality></PostalAddress></ContactInfo></Organization><Crisis bazyl=\"123\"><Kind va=\"12\"/><StartDateTime><Date>34</Date></StartDateTime></Crisis><Crisis bazyl=\"0\"><Name>Cela</Name><Location><Locality>Austin</Locality></Location><Location><Locality>Boston</Locality><Country>USA</Country></Location><ExternalResources><ImageURL>www</ImageURL><VideoURL>d</VideoURL><ImageURL>ccc</ImageURL></ExternalResources><StartDateTime><Date>34</Date><Time>33</Time></StartDateTime></Crisis></Bar>")) #importing the XML
root = tree.getroot()
WCDB3_setup(c)
WCDB3_import(c, root)
self.assert_(len(query(c, "select * from Person;"))==2)
