PlugIns.JdbcSlim.UserGuide.4TheMappingBetweenTestDataAndCommands.UnusedInputColumnsAreFlagged

PlugIns JdbcSlim UserGuide 4TheMappingBetweenTestDataAndCommands

Unused Input column names like [AGE] below are flagged as fail.
In such a case either

the command should be adjusted or
the column should be removed.
To avoid that the input columns are flagged red add the flag outputFlagUnusedInputColumns=false

Import

fitnesse.fixtures

SetUp

Plugins=fitnesse.testsystems.slim.CustomTableAliasPlugin CustomComparators=glob:fitnesse.testsystems.slim.GlobComparator

Library

page driver

echo fixture

variable defined: TestPageName=TestPage

script
given Jdbc Slim test page	TestPage
and test content is	!\|SQLCommand\|TestDatabase\|select Profession from TestData where NAME= '%NAME%' and CITY= '%CITY%'\| \|NAME \|CITY \|AGE \|PROFESSION? \| \|James \|London \|43 \| \| \|Bert \|Washington \|50 \| \| \|Kim \|New York \|60 \| \|
when page	TestPage	is tested and HTML is extracted
then	\d	assertions pass,	2	fail,	3	are ignored	0	exceptions thrown
and cell	AGE	has result	fail
show Symbol	$HTML_Input
show Symbol	$HTML_Result
get collapsed executon log for page	TestPage

If you must keep the column for any reason

To avoid that the input columns are flagged red add the flag outputFlagUnusedInputColumns=false

SQLCommand	TestDatabase	select Profession from TestData where NAME= '%NAME%' and CITY= '%CITY%'	outputFlagUnusedInputColumns=false
NAME	CITY	AGE	PROFESSION?
James	London	43
Bert	Washington	50
Kim	New York	60

tear down