I wrote Given I load dataset "users" row 5 because the account I want is on line 5 of the spreadsheet. Got:
DATASET_ROW_NOT_FOUND: Dataset "users" has 3 row(s); row 5 does not exist (0-based).Three rows? The file has four lines. And when I tried row 1 earlier it gave me the second person, not the first. So either the header counts or it does not, and I cannot work out which from the message.
Accepted answer
The header is not a row. The CSV is parsed with columns taken from the first line, so a four-line file has three rows, and the message is counting those.
Indexes are 0-based, so with three rows the valid ones are 0, 1 and 2. row 1 giving you the second person is correct and not an off-by-one — it is the second data row.
Positional lookup is fragile anyway, because it silently changes meaning the moment somebody sorts the file. Name the row instead:
Given I load dataset "users" where "username" is "problem_user"That fails with No row in dataset "users" where username = "problem_user". when the row is gone, which is a failure you can read, rather than quietly handing you a different account.
We banned row <n> in review after somebody alphabetised a CSV and three scenarios kept passing against the wrong accounts. where costs nothing and the step reads better out loud.
Have the same question?
Ask it with the command you ran and the output you got, and it will be answered here.
Ask a question