Hej musze curl'em lapac z bazy dane w formacie json i przeformatowac je i zapisac do pliku w postaci csv.
na ta chwile mam cos takiego ale brakuje pewnie jednej lini by dzialalo
#!/usr/bin/python
import json, csv ,sys
def read_json(filename):
return json.loads(open(filename).read())
def write_csv(data,filename):
with open(filename, 'w+') as outf:
print "asd"
writer = csv.DictWriter(outf, data[0].keys())
writer.writeheader()
for row in data:
writer.writerow(row)
write_csv(read_json('input.json'), 'output.csv')