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