465 |
|
|
466 |
return name_map |
return name_map |
467 |
|
|
468 |
def table_to_dbf(table, filename): |
def table_to_dbf(table, filename, records = None): |
469 |
"""Create the dbf file filename from the table""" |
"""Create the dbf file filename from the table""" |
470 |
dbf = dbflib.create(filename) |
dbf = dbflib.create(filename) |
471 |
|
|
486 |
dbf.add_field(name_map[col.name], dbflib_fieldtypes[col.type], |
dbf.add_field(name_map[col.name], dbflib_fieldtypes[col.type], |
487 |
width, prec) |
width, prec) |
488 |
|
|
489 |
for i in range(table.NumRows()): |
if records is None: |
490 |
|
records = range(table.NumRows()) |
491 |
|
|
492 |
|
recNum = 0 |
493 |
|
for i in records: |
494 |
record = {} |
record = {} |
495 |
for key, value in table.ReadRowAsDict(i).items(): |
for key, value in table.ReadRowAsDict(i).items(): |
496 |
record[name_map[key]] = value |
record[name_map[key]] = value |
497 |
dbf.write_record(i, record) |
dbf.write_record(recNum, record) |
498 |
|
recNum += 1 |
499 |
dbf.close() |
dbf.close() |
500 |
|
|
501 |
def table_to_csv(table, filename): |
def table_to_csv(table, filename, records = None): |
502 |
"""Export table to csv file.""" |
"""Export table to csv file.""" |
503 |
|
|
504 |
file = open(filename,"w") |
file = open(filename,"w") |
510 |
header = header + "\n" |
header = header + "\n" |
511 |
file.write(header) |
file.write(header) |
512 |
|
|
513 |
for i in range(table.NumRows()): |
if records is None: |
514 |
|
records = range(table.NumRows()) |
515 |
|
|
516 |
|
for i in records: |
517 |
record = table.ReadRowAsDict(i) |
record = table.ReadRowAsDict(i) |
518 |
if len(record): |
if len(record): |
519 |
line = "%s" % record[columns[0].name] |
line = "%s" % record[columns[0].name] |