def to_csv(self): """Export table from xml engine to CSV file.""" for keys in list(self.script.tables): table_name = self.opts['table_name'].format(db=self.db_name, table=keys) header = self.script.tables[keys].get_insert_columns(join=False, create=True) csv_outfile = xml2csv(table_name, header_values=header) sort_csv(csv_outfile)
def to_csv(self): """Export table from xml engine to CSV file""" for keys in list(self.script.tables): table_name = self.opts['table_name'].format(db=self.db_name, table=keys) header = self.script.tables[keys].get_insert_columns(join=False, create=True) csv_outfile = xml2csv(table_name, header_values=header) sort_csv(csv_outfile)
def test_xml2csv(): """Test xml2csv function creates a xml file and tests the md5 sum calculation""" xml_file = create_file("<root>\n<row>\n" "<User>Alex</User>\n" "<Country>US</Country>\n" "<Age>25</Age>\n</row>\n" "<row>\n<User>Ben</User>\n" "<Country>US</Country>S\n" "<Age>24</Age>\n" "</row>\n</root>", 'output.xml') output_xml = xml2csv(xml_file, "output_xml.csv", header_values=["User", "Country", "Age"]) obs_out = file_2string(output_xml) os.remove(output_xml) assert obs_out == "User,Country,Age\nAlex,US,25\nBen,US,24\n"
def test_xml2csv(): """Test xml2csv function. Creates a xml file and tests the md5 sum calculation. """ xml_file = create_file([ '<root>', '<row>', '<User>Alex</User>', '<Country>US</Country>', '<Age>25</Age>', '</row>', '<row>', '<User>Ben</User>', '<Country>US</Country>', '<Age>24</Age>', '</row>', '</root>' ], 'output.xml') output_xml = xml2csv(xml_file, "output_xml.csv", header_values=["User", "Country", "Age"]) obs_out = file_2list(output_xml) os.remove(output_xml) assert obs_out == ['User,Country,Age', 'Alex,US,25', 'Ben,US,24']
def test_xml2csv(): """Test xml2csv function creates a xml file and tests the md5 sum calculation""" xml_file = create_file( "<root>\n<row>\n" "<User>Alex</User>\n" "<Country>US</Country>\n" "<Age>25</Age>\n</row>\n" "<row>\n<User>Ben</User>\n" "<Country>US</Country>S\n" "<Age>24</Age>\n" "</row>\n</root>", 'output.xml') output_xml = xml2csv(xml_file, "output_xml.csv", header_values=["User", "Country", "Age"]) obs_out = file_2string(output_xml) os.remove(output_xml) assert obs_out == "User,Country,Age\nAlex,US,25\nBen,US,24\n"
def test_xml2csv(): """Test xml2csv function. Creates a xml file and tests the md5 sum calculation. """ xml_file = create_file(['<root>', '<row>', '<User>Alex</User>', '<Country>US</Country>', '<Age>25</Age>', '</row>', '<row>', '<User>Ben</User>', '<Country>US</Country>', '<Age>24</Age>', '</row>', '</root>'], 'output.xml') output_xml = xml2csv(xml_file, "output_xml.csv", header_values=["User", "Country", "Age"]) obs_out = file_2list(output_xml) os.remove(output_xml) assert obs_out == ['User,Country,Age', 'Alex,US,25', 'Ben,US,24']
def to_csv(self): """Export table from xml engine to CSV file""" keys = [columnname[0] for columnname in self.table.columns] csv_outfile = xml2csv(self.table_name(), header_values=keys) return sort_csv(csv_outfile)
def to_csv(self): """Export table from xml engine to CSV file""" keys = self.table.get_insert_columns(join=False, create=True) csv_outfile = xml2csv(self.table_name(), header_values=keys) return sort_csv(csv_outfile)