def get_list_CNBPID() -> List[str]:
"""
Return a list of all CNBPID (Key) from the database.
:return:
"""
# Load local database from .env file
database_path = config_get("LocalDatabasePath")
list_CNBPID = []
success, result_rows = LocalDB_query.get_all(database_path,
CNBP_blueprint.table_name,
"CNBPID")
for row in result_rows:
list_CNBPID.append(row[0]) # MRN is the first variable requested.
return list_CNBPID
def get_list_MRN() -> List[int]:
"""
Return a list_return of all MRN from the database.
:return:
"""
# Load local database from .env file
database_path = config_get("LocalDatabasePath")
list_MRN = []
success, result_rows = LocalDB_query.get_all(database_path,
CNBP_blueprint.table_name,
"MRN")
for row in result_rows:
list_MRN.append(row[0]) # MRN is the first variable requested.
return (
list_MRN
) # @todo: verify this is in integer? or string as that has dire consequences.
def get_list_StudyUID() -> List[List[str]]:
"""
Return a list_return of all StudyUID listS from the database.
:return:
"""
# Load local database from .env file
database_path = config_get("LocalDatabasePath")
list_StudyUID = []
success, result_rows = LocalDB_query.get_all(database_path,
CNBP_blueprint.table_name,
"StudyUID")
for row in result_rows:
list_StudyUID.append(
row[0]) # Values are always the first variable requested.
return (
list_StudyUID
) # @todo: verify this is in integer? or string as that has dire consequences.