def update_mfa_info(tenant_id, data_platform_id, applicant_id, is_mfa_enabled): if is_mfa_enabled == True: sql = "UPDATE phyllo_schema.dp_applicant_login_info SET is_mfa_enabled = 't' WHERE tenant_id = '{}' AND " \ "data_platform_id = '{}' AND applicant_id = '{}'".format(tenant_id, data_platform_id, applicant_id) else: sql = "UPDATE phyllo_schema.dp_applicant_login_info SET is_mfa_enabled = 'f' WHERE tenant_id = '{}' AND " \ "data_platform_id = '{}' AND applicant_id = '{}'".format(tenant_id, data_platform_id, applicant_id) dbhelper.execute_update(sql)
def update_login_cookies(tenant_id, data_platform_id, applicant_id, url, cookies): temp_cookies = str(cookies) temp_cookies = temp_cookies.replace("'", "''") sql = "UPDATE phyllo_schema.dp_applicant_login_info SET login_url = '{}', login_cookies = '{}' WHERE tenant_id = '{}' AND " \ "data_platform_id = '{}' AND applicant_id = '{}'".format( url, temp_cookies, tenant_id, data_platform_id, applicant_id) dbhelper.execute_update(sql)
def update_resume_from(tenant_id, data_platform_id, applicant_id, resume_from): sql = "UPDATE phyllo_schema.dp_applicant_login_info SET resume_from = '{}' WHERE tenant_id = '{}' AND " \ "data_platform_id = '{}' AND applicant_id = '{}'".format( resume_from, tenant_id, data_platform_id, applicant_id) dbhelper.execute_update(sql)
def update_login_status(tenant_id, data_platform_id, applicant_id, login_type, login_status): sql = "UPDATE phyllo_schema.dp_applicant_login_info SET login_type = '{}', login_status = '{}' WHERE tenant_id = '{}' AND " \ "data_platform_id = '{}' AND applicant_id = '{}'".format( login_type, login_status, tenant_id, data_platform_id, applicant_id) dbhelper.execute_update(sql)
def update_password(tenant_id, data_platform_id, applicant_id, password): sql = "UPDATE phyllo_schema.dp_applicant_login_info SET pwd = '{}' WHERE tenant_id = '{}' AND " \ "data_platform_id = '{}' AND applicant_id = '{}'".format( password, tenant_id, data_platform_id, applicant_id) dbhelper.execute_update(sql)
def update_username(tenant_id, data_platform_id, applicant_id, username): sql = "UPDATE phyllo_schema.dp_applicant_login_info SET username = '******' WHERE tenant_id = '{}' AND " \ "data_platform_id = '{}' AND applicant_id = '{}'".format( username, tenant_id, data_platform_id, applicant_id) dbhelper.execute_update(sql)