High and low about Java and Web programming
At a Java conference at my Company (TM) I signed up for a “fitnesse and webtest” presentation. Well, I’d like to go through the basics of FIT, how you use it in fitnesse, testing GUI/Web with webtest and database connection with dbFit. Wow, how to do this in only 45 minutes. I guess (since I’m [...]
Found the solution for the todays date problem, just test for sql date.
So, the final dbfit query in fitnesse is (modified names ofcourse)
!|Query|SELECT count (*) as nr FROM table1 t1 WHERE treated=Date(Current_Date)|
|nr|
|1|
Didn’t get time to solve the fitnesse count problem yet but found another interresting one. When using dbfit to check the database after an webtest gui operation I needed to test for todays date. So, I need a defined variable to use like “and date_added=’${today}’”. We have a fixture that gets the date ok but [...]
Gained some knowledge today when I found how to test for no result from a qurey. Skip the data row after the result set format).
!|Query|!-
SELECT
c.wheels
FROM
CAR c
-!|
|wheels?|
Ran into some (from my perspective) shortcomings of fitnesse/dbFit. Working with local declarations and variables and specially date/timestamp formats is not an easy thing to do. Would have been nice to have a better support for this, but then again, you can always make your own fixtures.
Another “all-dayer” with fitnesse, much copy-paste operations and thoughts [...]
I like the cleaness of fitnesse and in combination with dbFit, own fixtures and selenium it works great. But you can still find a few downsides with it - the html actions that can be performed is not complete and better javascript / ajax support would be great. But ofcourse, this could be built in.
