converters = {} insertData = [] errorData = [] total = 0 complete = 0 today = date.today() # today = datetime.strptime('05/02/2020', "%d/%m/%Y").date() day = today.day month = today.month year = today.year fileName = "Lawsuit report.xlsx" sep = ';' logDbName = "LO_Input_result_" + str(year) + str(month) if day == 1: mongodb.create_db(DB_NAME=logDbName) mongodbresult = Mongodb(logDbName, WFF_ENV=wff_env) else: mongodbresult = Mongodb(logDbName, WFF_ENV=wff_env) ftpLocalUrl = common.getDownloadFolder() + fileName try: sys.argv[1] importLogId = str(sys.argv[1]) importLogInfo = mongodb.getOne(MONGO_COLLECTION=common.getSubUser( subUserType, 'Import'), WHERE={'_id': ObjectId(sys.argv[1])}) except Exception as SysArgvError: if not os.path.isfile(ftpLocalUrl): sys.exit()
sys.exit() todayString = today.strftime("%d/%m/%Y") starttime = int( time.mktime( time.strptime(str(todayString + " 00:00:00"), "%d/%m/%Y %H:%M:%S"))) endtime = int( time.mktime( time.strptime(str(todayString + " 23:59:59"), "%d/%m/%Y %H:%M:%S"))) collectionName = 'LO_input_report_' + str(year) + str(month) if day == 1: mongodb.create_db(collectionName) mongodbReport = Mongodb(collectionName) lnjc05InfoFull = mongodb.get( MONGO_COLLECTION=common.getSubUser(subUserType, 'LNJC05')) lnjc05ColName = 'LNJC05_' + str(year) + str(month) + str(day) mongodbReport.create_col(COL_NAME=lnjc05ColName) mongodbReport.remove_document(MONGO_COLLECTION=lnjc05ColName) mongodbReport.batch_insert(MONGO_COLLECTION=lnjc05ColName, insert_data=lnjc05InfoFull) listOfAccFull = mongodb.get(MONGO_COLLECTION=common.getSubUser( subUserType, 'List_of_account_in_collection')) listOfAccColName = 'List_of_account_in_collection_' + str(year) + str( month) + str(day)