all: add specific download check for ASE

[sean-freeman]

ASE uses numeric filename without prefix or suffix, and therefore cannot be detected once the file is removed. Suggest additional weekly GH Action...

Part 1:

• Fuzzy search for SAP ASE 16 RDBMS Linux on x86_64 64bit
• Sort Descending order, use first item (index [0])

Part 2:

• Extract version substring (e.g. 16.0.04.06); parse to get SP 04 and Patch Level 06
• Search for Client file as ASEBC16004P_6 ; if Patch Level 00, then search ASEBC16004_0
• Identify replacement line using filename prefix ASEBC160

Low priority.

[sean-freeman]

Idea for catching SAP ASE

sap_sso_login(username, password)

# Special catch:
# Check for SAP ASE RDBMS Linux on x86_64 64bit media that uses prefix 5105 followed by 5-9
# Ignore 5105[0-4] used by ECC 6.0, NWAS 7.5/7.52 ABAP, MaxDB, Oracle DB
# Filter to avoid catch of 5105[5] used by NWAS JAVA, 5105[6] for IBM Db2 LUW, or 5105[7] for ECC IDES
# As Title ID may be duplicated, sort by fastkey as proxy for date released
# Then sort by Description to ascertain latest version sequence
import re
if re.search('^5105[5-9]', input_search_file):
    special_flag = 1
    special_query = search_software_fuzzy('SAP ASE 16 RDBMS Linux on x86_64 64bit')
    if any('SAP ASE' in sublist['Description'] for sublist in special_query):
        if any('RDBMS' in sublist['Description'] for sublist in special_query):
            special_query_sorted1 = sorted(special_query, key=lambda sublist: sublist['Fastkey'], reverse=True)
            special_query_sorted2 = sorted(special_query_sorted1, key=lambda sublist: sublist['Description'], reverse=True)
            print(special_query_sorted2[0]['Title'])
else:
    special_flag = 0

query_result = search_software_fuzzy(input_search_file)
if len(query_result) >= 2 and special_flag == 0:

[sean-freeman]

I would suggest this code is ineffective, it would have to be run weekly to detect changes and could not easily be used in on-the-fly detection and replacement of an inaccessible media file with the latest media file.

For notes:

### SAP Software media files prefixes:
# 5105[0] == ECC 6.0 / BS7i2016
# 5105[1] == NWAS 7.5/7.52 ABAP
# 5105[2] == Oracle DB
# 5105[3] == ECC IDES / Oracle DB
# 5105[4] == MaxDB / Oracle DB
# 5105[5] == NWAS JAVA
# 5105[6] == IBM Db2 LUW
# 5105[7] == ECC IDES / Oracle DB / ASE
# 5105[8] == unassigned?
# 5105[9] == unassigned?