CODEWITHSUNDEEP
fitnessefitnesse-slimdbfit
Benny
Benny

Reputation: 432

How to generate dynamic values in fitnesse

I have to insert incremental values in a column of the table using Fitnesse. The incremental value I'll get from a stored procedure which returns the last inserted value. So I have to increment the value and store it.

For example: I'll get a value from the stored procedure output. And I have to increment the value by 1 and insert into the table.

Any ideas?

Expected output

!|insert|table1|
|col1|col2|col3|
|ACRDE0001|abc|def|
|ACRDE0002|abc|def|
|ACRDE0003|abc|def|
.
.
.
.

Upvotes: 1

Views: 1159

Answers (1)

Fried Hoeben
Fried Hoeben

Reputation: 3272

As far as I'm aware the only way to change (e.g. increment) a value you get during your test is by writing some code in a fixture. There is a pull request to allow more dynamic Slim expression directly in the wiki, but that has not been merged (let alone released) yet.

Your questions suggests that the value is something you get from a database and that you then want to send back the generated/incremented value with new records you insert. In that case I wonder whether the increment is actually that useful to actually have in your wiki (your test case is not about the generated values, is it?). Maybe your fixture could just retrieve the initial value (or have it supplied as constructor value) and the fixture could generate the a new value for each row and send them to the database.

Upvotes: 1

Related Questions