def fetch_dp_applicant_login_info(tenant_id, data_platform_id, applicant_id):
sql = "SELECT * FROM phyllo_schema.dp_applicant_login_info WHERE tenant_id = '{}' AND data_platform_id = '{}' " \
"AND applicant_id = '{}'".format(tenant_id, data_platform_id, applicant_id)
result = dbhelper.execute_select(sql)
if result != None and len(result) > 0:
return result[0]
return None
def fetch_login_path_instructions(data_platform_id, level):
if level is None:
level = 1
sql = "select * from phyllo_schema.dp_login_path where data_platform_id = '{}' and level = '{}' order by sequence_no".format(
data_platform_id, level)
return dbhelper.execute_select(sql)
def fetch_data_platform_id(data_platform_name):
sql = "select id from phyllo_schema.data_platform where name = '{}'".format(
data_platform_name)
return dbhelper.execute_select(sql)[0]['id']
def fetch_data_platforms():
sql = "select * from phyllo_schema.data_platform"
return dbhelper.execute_select(sql)
def fetch_data_platform_by_name(platform_name):
sql = "select * from phyllo_schema.data_platform WHERE name = '{}'".format(
platform_name)
return dbhelper.execute_select(sql)