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)
