def run(self, *args): start_time = time() source_data = csv2dic(am.file_b, am.file_b_key) mod_rows_counter = merge_files(am.file_a, source_data, am.file_a_key, am.columns) self.ids["status_label"].text = "Finished in {0:.2f} seconds. Rows modified: {1:.0f}".format( time() - start_time, mod_rows_counter ) self.ids["b1"].disabled = False self.ids["b2"].disabled = False self.ids["b3"].disabled = False
#!/usr/bin/env python from sys import argv from time import time from lib.csvmerge import merge_files import lib.csvUtil from os import getcwd, system start_time = time() cur_path = getcwd() if len(argv) is not 6: print("CSV MERGER - Usage:") print("param 1: File to modify patch") print("param 2: Data file patch") print("param 3: index key from modify file") print("param 4: index key from data file") print("param 5: columns to append from data file, divided by \",\"") exit() keyColumnMergeFile = argv[3] keyColumnSourceFile = argv[4] columns = str(argv[5]).split(",") sourceFilePath = ''.join([cur_path, '/', argv[2]]) sourceFileData = lib.csvUtil.csv2dic(sourceFilePath, keyColumnSourceFile) mergeFilePath = argv[1] mod_rows_counter = merge_files(mergeFilePath, sourceFileData, keyColumnMergeFile, columns) print("Finished in {0:.2f} seconds. Rows modified: {1:.0f}".format(time() - start_time, mod_rows_counter))