import mysql.connector import re import json import os import sys import csv import codecs sys.path.append(r"F:\BQS_ETL v0.2\lib") import dbconfig_importer import json_parser db_config = r"F:\BQS_ETL v0.2\cfg\database_config.json" tmp_dir = r"D:\mili\Datamart\rawdata_csv_py\dwdata" cnx = dbconfig_importer.connect(db_config) #sys.stdout = os.fdopen(sys.stdout.fileno(), w, 0) ################### # truncate ################### query_cursor = cnx.cursor() query = ("SELECT a.id, a.apply_code, a.return_code, a.hit_rules " "FROM creditx_anti_fraud a ") # in the req_json, result.eventType: blacklist, faceRecognition, loan, sendDynamic, verify rows_counter = 0
import mysql.connector import re import datetime import json import os import sys import csv import codecs sys.path.append(r"F:\BQS_ETL v0.2\lib") import dbconfig_importer import json_parser creditx_db_config = r"F:\BQS_ETL v0.2\cfg\creditx_database_config.json" tmp_dir = r"F:\CreditX\tmp" creditx_cnx = dbconfig_importer.connect(creditx_db_config) # for features #sys.stdout = os.fdopen(sys.stdout.fileno(), 'w', 0) version = '0' #################### # start_dt & end_dt #################### if len(sys.argv) > 1: start_dt = datetime.datetime.strptime(sys.argv[1], '%Y-%m-%d') else: start_dt = datetime.datetime(2017, 6, 28).replace(hour=0, minute=0, second=0, microsecond=0)