def dumpSQLCSVFiles(writers, records):
for record in records:
# fix datetime "%Y-%m-%d %H:%M:00"
datetime = record.date[0:4]+'-'+record.date[4:6]+'-'+record.date[6:8]+' '+ \
record.hrmn[0:2]+':'+record.hrmn[2:4]+':00'
# FIXME -- unmunge the temp_minmax readings
# FIXME -- vis_variable_flag precip_hist_contin
# temp_minmax[12]_minmax cloud_ceil_CAVOK precip_lq[1234]_trace_fl
# dump each record subset in the appropriate file.
key = (record.id_NCDC, record.id_USAF, datetime)
for component in weatherComponents:
vals = tuple( fixForSQL(getattr(record, field)) for field in weatherComponentFields[component] )
writers[component].writerow(key + vals)
def dumpSQLCSV(filename, records):
print('Writing ' + filename)
writer = csv.writer(open(filename, "wb"))
for record in records:
vals = [fixForSQL(getattr(record, slot)) for slot in record.__slots__]
writer.writerow(vals)
def dumpSQLCSV(filename, records):
print ('Writing '+filename)
writer = csv.writer(open(filename, "wb"))
for record in records:
vals = [fixForSQL(getattr(record, slot)) for slot in record.__slots__]
writer.writerow(vals)
