def certification_mobile_state(host, phone):
try:
sql = mobile_certification.format(1, phone)
db.db_base(host, sql)
except Exception as e:
print("error_info:{}".format(str(e)))
def u_user_info(host, username, idcard, phone):
sql = update_user_info % (username, idcard, 1, phone)
db.db_base(host, sql)
def insert_ocr_back_info(host, phone, ocr_img_path_info):
sql = insert_ocr_info % (query_mobile_info(
host, phone), 1, ocr_img_path_info, get_local_time(), 1, 'back')
db.db_base(host, sql)
def query_mobile_info(host, phone):
sql = select_user_info.format(phone)
return db.db_base(host, sql)[0]['id']