Stack Overflow
Stack Overflow

Questions tagged [dbfit]

Questions related to DbFit, a framework for writing unit- and integration-tests for database code. It is based on FitNessese.

DbFit is a framework for writing unit- and integration- tests for database code, enabling developers to manipulate database objects in a relational form, making database TDD much easier then with xUnit-style tools. It is based on FitNessese (http://fitnesse.org).

Features

  • Regression testing for queries and SQL statements
  • Functional testing for stored procedures and functions
  • Automatic transaction control and various short-cuts to make writing test scripts easier and more efficient
  • Support for DB2, Oracle, SQL Server (java and .net versions), MySql 5 and Derby (only java)

Major Links

62 questions
0
votes
2 answers

Dbfit for Netezza not working

Hi I am new to dbFit and while trying to use dbFit for Netezza giving error Cannot load Netezza database driver org.netezza.Driver. Code and error details are as below: Code: !path lib/*.jar !| dbfit.NetezzaTest | !| Connect | ip | user| password…
Dham
  • 11
  • 4
0
votes
1 answer

Parametrise or Share DB connection within a test suit

is there any way to share the DB connection within all testcases of a suite? (I don't like specifying the DB connection in every testcase) (also if there is any way to parametrise it will make me happy) Anto
Anto
  • 63
  • 9
0
votes
1 answer

dbfit - How to assert that an item is not returned in the results

I am creating dbfit test cases and I encountered a scenario where I need to check that an item is not included in the results returned by the query. How can I do that? Thanks,
Ali Haydar
  • 41
  • 7
0
votes
1 answer

DBFit : Test that executes other tests

I have a bunch of tests that run individually and I would like to create one single test (let's call it root test) which will call the others one by one, so as I have the complete test suite able to run with a single click and have the results for…
Dimitrios Ntakoulas
  • 7
  • 4
0
votes
1 answer

Fitnesse and dbFit: unable to use variable in store query

!|DatabaseEnvironment|ORACLE| |Connect|${HOSTNAME}|${USERNAME}|${PASSWORD}| |set option|bind symbols|false| !|Query|!-select acct_id ts from dual-!| |acct_id?| |>>acct_id| |Set Parameter|acct_id|<
Geeme
  • 395
  • 2
  • 6
  • 18
0
votes
1 answer

DBfit server on local machine problems with fixtures and constructors

I installed DBfit as specified here: http://dbfit.github.io/dbfit/docs/getting-started.html Configured the test and the database; Ran the startFitnesse.bat; Defined a test; But when the I run the test the output is this: Including the suggested…
Mindaugas Bernatavičius
  • 3,757
  • 4
  • 31
  • 58
0
votes
1 answer

Why cannot DbFit be imported in SuiteSetUp?

I have had DbFit running in Standalone mode for a while and have had the fixture import in my SetUp wiki like #SetUp content [...] !|Import| |dbfit.fixture| [...] and with a test wiki like #DbTestWiki content !|DatabaseEnvironment|ORACLE| …
D. Josefsson
  • 1,052
  • 7
  • 21
0
votes
1 answer

DBFit jdbc.SQLServerException: Incorrect syntax near the keyword 'as'

I'm a stackoverflow newbie and also new to DBFit. I have already done a successful DBFit test, however in one of my new tests, I'm getting an exception error: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'as'. …
libran_6
  • 16
  • 6
0
votes
2 answers

How can I sort the results of a 'compare stored queries' fixture using DBFIT?

is it possible to sort the results of a 'compare stored queries' fixture in DBFIT so that the failed results return to the top of the results grid? Thanks!
Wayne
  • 1
0
votes
1 answer

Fitnesse/dbFit : columns that are not verified

Do you have any ideas if it is possible to create a column that contains only description of a row and is not verified by dbFit. For instance, I have a such table: !|Query|select 1 as sth from dual| |sth|description| |1|this rows contains 1| The…
Rarar
  • 419
  • 2
  • 6
  • 19
0
votes
1 answer

Large dataset comparison timeouts in DbFit

Query is sum up the top 500 account balances grouped by currencies, used in comparison query from a new SQL 2012 server and existing server to validate no changes in the new 2012 server. Set timeout property to |set option|command|900| and to no…
Nobody
  • 549
  • 1
  • 10
  • 24
0
votes
1 answer

Getting the identity value from a table with single identity column in FitNesse

Does FitNesse/dbFit support inserting into a table with a single identity column and then returning that value into a variable? For example: create table TestTable ( ID int identity(1,1) ) !|Insert|TestTable| |ID? | |>>TestID …
sduplooy
  • 14,340
  • 9
  • 41
  • 60
0
votes
1 answer

DBfit - comparing 2 tables actual and expected

i am writing tests using DbFit and FitNesse for some our reporting stored procedures. To make life easy, we have designed a generic way to store input data and expected data in 2 tables and comparing the output table with the expected table, for…
Selvakumar Esra
  • 1,154
  • 2
  • 15
  • 30
0
votes
1 answer

Highlighting wrong columns

I'm using Fitnesse + dbFit to verify data in one database table. If at least one column in a record is wrong the whole record is highlighted. Do you know if Fitnesse can highlight only wrong columns ? My table has over 100 columns and even if I get…
Rarar
  • 419
  • 2
  • 6
  • 19
0
votes
1 answer

DbFit exception using SQL server 2008

New to dbFit. Downloaded version dbfit 1.1 which successful executed the queries, except for one query. That query would then timeout. When I then update with fixes for the timeout - https://github.com/jediwhale/fitsharp, will fail. Then returns the…
Nobody
  • 549
  • 1
  • 10
  • 24
1 2 3
4
5