def _save_file(path_file, path_save, name_zip_): try: _makeDir(path_save) save_date = _dateNowFormat(_save_tag_fileUpload) name_save = '%s%s' % (save_date, _basename(path_file)) file_save = _pathJoin([path_save, name_save]) name_zip_ = '%s-bak.zip' % name_zip_ file_zip_ = _pathJoin([path_save, name_zip_]) _fileMove(path_file, file_save) except: pass with zipfile.ZipFile(file_zip_, 'a') as zip: try: zip.write(file_save, _basename(file_save)) except: pass finally: zip.close() _fileRemove(file_save)
# -*- coding: utf-8 -*- __author__ = 'zappyk' import argparse, configparser from lib_zappyk._log import _log from lib_zappyk._os_file import _pathAbs, _pathJoin, _fileExist, _pathSep, _pathExpanduser from MergeTwoCsv2One import * from MergeTwoCsv2One.src.constants import * _project_ = get_project() _description_ = get_description() name_conf = '%s-config.ini' % _project_ path_conf = _pathAbs(_pathJoin(['.'])) file_conf = _pathAbs(_pathJoin([path_conf, name_conf])) name_logs = '%s-logger.ini' % _project_ path_logs = _pathAbs(_pathJoin(['.'])) file_logs = _pathAbs(_pathJoin([path_logs, name_logs])) default_stdin = CHAR_STD_INOUT default_stdout = CHAR_STD_INOUT default_typein = TYPE_IN_mmam default_typeout = TYPE_OUT_csv default_typeout = None list_typein = [TYPE_IN_mmam] list_typeout = [TYPE_OUT_csv,TYPE_OUT_xls] ###############################################################################
filename = args.sht_filename if args.sht_filename is not None else filename file_key = args.sht_file_key if args.sht_file_key is not None else file_key file_url = args.sht_file_url if args.sht_file_url is not None else file_url wks_name = args.wks_name if args.wks_name is not None else wks_name wks_rows_resize = args.wks_rows_resize if args.wks_rows_resize is not None else False wks_cell_update = args.wks_cell_update if args.wks_cell_update is not None else False wks_rows_resize = False if wks_cell_update else wks_rows_resize action_write_wait = args.action_write_wait if args.action_write_wait is not None else False second_write_wait = args.second_write_wait if args.second_write_wait is not None else None wks_read = True if args.action == 'r' else False wks_write = True if args.action == 'w' else False wks_update = True if args.action == 'u' else False servicej = _pathJoin([savejson, servicej]) if servicej is not None else servicej accountj = _pathJoin([savejson, accountj]) if accountj is not None else accountj tknstore = _pathJoin([savejson, tknstore]) if tknstore is not None else tknstore login_credential_servicej = False if servicej is None else True login_credential_accountj = False if accountj is None else not(login_credential_servicej) login_credential = True if (servicej or accountj) else False #csv_delimiter = ',' if csv_delimiter is None else csv_delimiter #csv_quotechar = '"' if csv_quotechar is None else csv_quotechar #csv_quoting = csv.QUOTE_MINIMAL if csv_quoting is None else csv_quoting csv_quoting = csv.QUOTE_NONE if csv_quoting is None else csv_quoting #csv_lineterminator= "\r\n" if csv_lineterminator is None else csv_lineterminator if second_write_wait is not None: (SLEEP_MULTIPLE_LINE
else: _makeDir(path_split) return (path_split) ############################################################################### if __name__ == '__main__': args = _getargs() base_sheet = args.base_sheet file_input = args.file_input #CZ#archiveset = args.archive_set tag_output = args.tag_output nameoutput = (tag_output, _basename(file_input)) pathoutput = (_basepath(file_input), ''.join(nameoutput)) fileoutput = _pathJoin(pathoutput) name_input = _basename(file_input) try: logs.info('[%s]' % _pathCurrent()) logs.info('Duplicate Worksheet "%s" to list sheetname %s' % (base_sheet, _duplicates_)) logs.info('Open file "%s" for duplicate:' % file_input) (workbook, xlsx_ext) = open_file_input(file_input) #CZ#except ExceptionFileInputNotParsed as e: #CZ# logs.error(str(e)) except Exception as e: logs.error(str(e))
#_______________________________________________________________________________________________________________________________________________________________ # # # curl --digest -u "url_username:url_password" -F "file=@path_file" -H "X-BOS-MFT=1" -H "X-BOS-MFT-CLIENTID=flow_name" url_address # # curl -u "url_username:url_password" -F "file=@path_file" -H "X-BOS-MFT=1" -H "X-BOS-MFT-CLIENTID=flow_name" url_address # #______________________________________________________________________________________________________________________________________________________________# # # # curl -u "%MFT_auth%" -F "file=@%MFT_file%" -H "X-BOS-MFT:1" -H "X-BOS-MFT-CLIENTID:%MFT_flow%" "%MFT_endp%" # # curl -u "tstmft0:tstmft0" -F "file=@C:\tmp\TST.txt" -H "X-BOS-MFT:1" -H "X-BOS-MFT-CLIENTID:TSTMFT0" "http://apps.payroll.it/bos-mft-server/mft" # #______________________________________________________________________________________________________________________________________________________________# exitcode = None messages = None move_file = None send_file = _pathJoin([ path_save, ('%s_send2payroll_%s' % (flow_name, _basename(path_file))) ]) if _fileExist(send_file): messages = _message_check % send_file logs.info(messages) move_file = send_file else: if _fileExist(path_file): try: #CZ#messages = _message_check % path_file ; logs.info(messages) _fileMove(path_file, send_file) move_file = path_file
logs.info('_%s_' % ('_' * len(path))) logs.info('|%s|' % path) logs.info('\ttitle: %s' % title[name]) logs.info('\tquery: %s' % query[name]) logs.error('Done') sql_section = None if sql_query is None else sql_section if sql_section is None: logs.error('Query [%s] not found!' % run_query) else: logs.info('title: %s' % sql_title) #CZ#logs.info('query: %s' % sql_query) #################### file_input = _pathJoin([_pathCurrent(), sql_title]) type_input = run_query #################### run_gui = True if sys.platform == 'win32' else run_gui run_gui = False if run_cmd else run_gui name_input = _basenameNotExt(file_input) exte_output = _basenameGetExt(file_output) type_output = TYPE_OUT_csv if (type_output is None) and ( exte_output[1:] == TYPE_OUT_csv) else type_output type_output = TYPE_OUT_xls if (type_output is None) and ( exte_output[1:] == TYPE_OUT_xls) else type_output file_output_csv = '.'.join([_basenameFullPathNotExt(file_input), TYPE_OUT_csv]) file_output_xls = '.'.join([_basenameFullPathNotExt(file_input), TYPE_OUT_xls])