def checkBuildFile(worksheetBuild, worksheetBuildFileName):
try:
getColumnLetterFromString(worksheetBuild,
file_TC_BUILD_Column['enable_header'])
getColumnLetterFromString(worksheetBuild,
file_TC_BUILD_Column['testN_header'])
getColumnLetterFromString(worksheetBuild,
file_TC_BUILD_Column['testID_header'])
getColumnLetterFromString(worksheetBuild,
file_TC_BUILD_Column['testType_header'])
getColumnLetterFromString(worksheetBuild,
file_TC_BUILD_Column['stepID_header'])
getColumnLetterFromString(worksheetBuild,
file_TC_BUILD_Column['stepDescr_header'])
getColumnLetterFromString(worksheetBuild,
file_TC_BUILD_Column['precondition_header'])
getColumnLetterFromString(worksheetBuild,
file_TC_BUILD_Column['action_header'])
getColumnLetterFromString(worksheetBuild,
file_TC_BUILD_Column['expected_header'])
getColumnLetterFromString(worksheetBuild,
file_TC_BUILD_Column['timeStep_header'])
getColumnLetterFromString(worksheetBuild,
file_TC_BUILD_Column['sampleTime_header'])
getColumnLetterFromString(worksheetBuild,
file_TC_BUILD_Column['tolerance_header'])
except ValueError:
debugPrint("In file ", worksheetBuildFileName)
exit()
def extractFunctionNameOLD(worksheet, functionDictionary, dictionaryType, colName='A'):
returnValue = 0
columnDescriptionLetter, columnActionLetter, columnExpectedResLetter = getColumnPosition(worksheet, dictionaryType)
functionName = ""
for rows in worksheet.iter_cols(min_col=1, max_col=1, values_only=True):
for rowNum, cellValue in enumerate(rows, start=1):
if isinstance(cellValue, str) and len(cellValue) > 2:
# print(str(rowNum) + " " + cellValue)
if rowNum == 1:
if cellValue == "functions":
continue
else:
print("Error - function files wrong formatted - the first column does not have header "
"'functions' ")
exit()
if rowNum == 2 and cellValue[0] == "=":
print("Error - function files wrong formatted - the second rows does not contain a function name")
exit()
elif len(cellValue) > 2:
if cellValue[0] != "=":
# creo una
if cellValue not in functionDictionary:
# aggiorno la vecchia funzione (se esiste) con l'ultima riga trova
if functionName != "":
functionDictionary[functionName]['endRow'] = rowNum - 1
# creo una nuova funzione
functionName = cellValue
functionDictionary[cellValue] = {'startRow': rowNum, 'endRow': rowNum, 'data': []}
else:
print("MError - duplicated values found : " + cellValue)
exit()
if dictionaryType == "action":
s = singleTestStep(worksheet[columnDescriptionLetter + str(rowNum)].value,
worksheet[columnActionLetter + str(rowNum)].value,
worksheet[columnExpectedResLetter + str(rowNum)].value)
elif dictionaryType == "verify":
s = singleTestStep(worksheet[columnDescriptionLetter + str(rowNum)].value,
"",
worksheet[columnExpectedResLetter + str(rowNum)].value)
else:
debugPrint("dictionary type chosen not correct - shall be either 'action' or 'verify'")
functionDictionary[functionName]['data'].append(s)
else:
print("MINOR - Wrong value type found in function file at row num " + str(rowNum) + " and col A")
returnValue = 1
continue
functionDictionary[functionName]['endRow'] = rowNum
return returnValue
def checkActionFile(worksheetAction, worksheetActionFileName):
try:
getColumnIndexFromString(worksheetAction,
file_Tools_Verify_Column['fieldType_header'])
getColumnLetterFromString(worksheetAction,
file_Tools_Verify_Column['fieldType_header'])
getColumnLetterFromString(worksheetAction,
file_Tools_Verify_Column['value_header'])
getColumnLetterFromString(worksheetAction,
file_Tools_Verify_Column['stepDescr_header'])
getColumnLetterFromString(
worksheetAction, file_Tools_Verify_Column['precondition_header'])
getColumnLetterFromString(worksheetAction,
file_Tools_Verify_Column['expected_header'])
getColumnLetterFromString(worksheetAction,
file_Tools_Verify_Column['timeStep_header'])
getColumnLetterFromString(
worksheetAction, file_Tools_Verify_Column['sampleTime_header'])
getColumnLetterFromString(worksheetAction,
file_Tools_Verify_Column['tolerance_header'])
except ValueError:
debugPrint("In file ", worksheetActionFileName)
exit()
def getColumnPosition(worksheet, dictionaryType):
columnDescriptionLetter = ""
columnActionLetter = ""
columnExpectedResLetter = ""
if dictionaryType == "action":
columnDescriptionLetter = getColumnLetterFromString(
worksheet, file_Tools_Actions_Column['stepDescr_header'])
if columnDescriptionLetter == "":
debugPrint("Column" +
file_Tools_Actions_Column['stepDescr_header'] +
"not found")
exit()
columnActionLetter = getColumnLetterFromString(
worksheet, file_Tools_Actions_Column['action_header'])
if columnActionLetter == "":
debugPrint("Column" +
file_Tools_Actions_Column['stepDescr_header'] +
"not found")
exit()
columnExpectedResLetter = getColumnLetterFromString(
worksheet, file_Tools_Actions_Column['expected_header'])
if columnExpectedResLetter == "":
debugPrint("Column" +
file_Tools_Actions_Column['stepDescr_header'] +
"not found")
exit()
elif dictionaryType == "verify":
columnDescriptionLetter = getColumnLetterFromString(
worksheet, file_Tools_Verify_Column['stepDescr_header'])
if columnDescriptionLetter == "":
debugPrint("Column" +
file_Tools_Verify_Column['stepDescr_header'] +
"not found")
exit()
columnExpectedResLetter = getColumnLetterFromString(
worksheet, file_Tools_Verify_Column['expected_header'])
if columnExpectedResLetter == "":
debugPrint("Column" +
file_Tools_Verify_Column['stepDescr_header'] +
"not found")
exit()
else:
debugPrint(
"dictionary type chosen not correct - shall be either 'action' or 'verify'"
)
return columnDescriptionLetter, columnActionLetter, columnExpectedResLetter