def to_csv(self):
"""Export table from json 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 = json2csv(table_name, header_values=header)
sort_csv(csv_outfile)
def test_json2csv():
"""Test json2csv function
creates a json file and tests the md5 sum calculation"""
json_file = create_file("""[ {"User": "******", "Country": "US", "Age": "25"} ]""", 'output.json')
output_json = json2csv(json_file, "output_json.csv", header_values=["User", "Country", "Age"])
obs_out = file_2string(output_json)
os.remove(output_json)
assert obs_out == 'User,Country,Age\nAlex,US,25\n'
def to_csv(self):
"""Export table from json 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 = json2csv(table_name, header_values=header)
sort_csv(csv_outfile)
def test_json2csv():
"""Test json2csv function
creates a json file and tests the md5 sum calculation"""
json_file = create_file(
"""[ {"User": "******", "Country": "US", "Age": "25"} ]""",
'output.json')
output_json = json2csv(json_file,
"test/output_json.csv",
header_values=["User", "Country", "Age"])
obs_out = file_2string(output_json)
assert obs_out == 'User,Country,Age\nAlex,US,25'
def test_json2csv():
"""Test json2csv function.
Creates a json file and tests the md5 sum calculation.
"""
json_file = create_file(
["""[ {"User": "******", "Country": "US", "Age": "25"} ]"""],
'output.json')
output_json = json2csv(json_file,
"output_json.csv",
header_values=["User", "Country", "Age"])
obs_out = file_2list(output_json)
os.remove(output_json)
assert obs_out == ['User,Country,Age', 'Alex,US,25']
def to_csv(self):
"""Export table from json engine to CSV file"""
keys = [columnname[0] for columnname in self.table.columns]
csv_outfile = json2csv(self.table_name(), header_values=keys)
return sort_csv(csv_outfile)
def to_csv(self):
"""Export table from json engine to CSV file"""
keys = self.table.get_insert_columns(join=False, create=True)
csv_outfile = json2csv(self.table_name(), header_values=keys)
return sort_csv(csv_outfile)
