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)