How to custom keyword show failed step

Archive
,
1

I have create a custom keyword like:

@Keyword
	def VerifyClientEnable(String clientName){
		KeywordUtil key = new KeywordUtil()
		CustomLog log = new CustomLog()
		try{
			connectToLHDb();
			Statement stm = connection.createStatement()
			String query = "SELECT Top (1) * FROM Account a INNER JOIN PhotoStudioClient p ON a.AccountId = p.ClientId WHERE a.AccountName ='"+clientName+"'"
			ResultSet rs = stm.executeQuery(query)
				while(rs.next()){
					Object value = rs.getObject("IsEnabled")
					System.out.println("===== LOG =====")
					System.out.println("Value: " + value.toString())
					if(value.toString().equals("true")){
						KeywordUtil.markPassed("VerifyClientEnable PASSED 1")
						System.out.println("VerifyClientEnable PASSED 2")
						log.markStepPassed()
						logger.logPassed("VerifyClientEnable PASSED 3")
					}else{
						KeywordUtil.markFailed("VerifyClientEnable FAILED 1")
						System.out.println("VerifyClientEnable FAILED 2")
						log.markStepFailed("VerifyClientEnable FAILED 3")
						logger.logFailed("VerifyClientEnable FAILED 4")
					}
				}
			}catch(Exception e){
			
			System.out.println("VerifyClientEnable QUERY FAILED 1" + e)
			KeywordUtil.markFailed("VerifyClientEnable FAILED 2")
			log.markStepFailed("VerifyClientEnable FAILED 3")
			logger.logFailed("VerifyClientEnable FAILED 4")
		}
	return false
	}

================================

But it can not show fail step when execute query fail, or value = false
Please help!!!

2

What’s the output in case of failure?

3

Show error step, red line in log, and show message log

KeywordUtil.markFailed(“VerifyClientEnable FAILED 1”)
System.out.println(“VerifyClientEnable FAILED 2”)
log.markStepFailed(“VerifyClientEnable FAILED 3”)
logger.logFailed(“VerifyClientEnable FAILED 4”)

4

Oh, I meant actual output. Sorry for confusion.

5

by enclosing all other check’s in this loop, there may be a chance they are never executed if rs is empty
so … as @marek said … how do you simulate the failure and what is the actual output log?

6

sorry, if some things I do not understand.
I need query to database to get a column value.
=> if value = true mean test case is passed
=> otherwise if value = false test case is failed
when test case is failed I want to show error, failed step by “KeywordUtil.markFailed(errMes)”
but with my code below, it still show step is passed.
I don’t know why ?
please help me.