dbfit:reference:databaseunittests:helloworld

Trace: » commandreference » connecttothedatabase » runningthetest » trafficlights

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

//Previous page: [[:dbfit:reference:DatabaseUnitTests:InstallingDbFit|Installing DbFit]] Next page: [[:dbfit:reference:DatabaseUnitTests:ManagingWikiContent|Managing Wiki content]] Parent page: [[:dbfit:reference:DatabaseUnitTests|Database unit tests]]//
======Hello World from the database======
%% Let's run a quick test to make sure that you have everything set up correctly and that FitNesse can connect to your test database. In doing so, we'll also explain how to manage tests with FitNesse. FitNesse is a collaborative Wiki site for building and executing tests. Tests are described by tables that contain both input values and expected results. FitNesse runs tests by reading HTML files, looking for tables, and using data in the tables to execute tests and compare results to expectations. To keep things simple for now, we'll just run a query and verify the results. %%
[[:dbfit:reference:DatabaseUnitTests:HelloWorld:CreateaNewPage|Step 1: Creating a new test page]]
[[:dbfit:reference:DatabaseUnitTests:HelloWorld:SettingUpTheEnvironment|Step 2: Setting up the environment]]
[[:dbfit:reference:DatabaseUnitTests:HelloWorld:ConnectToTheDatabase|Step 3: Connect to the database]]
[[:dbfit:reference:DatabaseUnitTests:HelloWorld:TestingaSimpleQuery|Step 4: Testing a simple query]]
[[:dbfit:reference:DatabaseUnitTests:HelloWorld:RunningTheTest|Step 5: Running the test]]
[[:dbfit:reference:DatabaseUnitTests:HelloWorld:TrafficLights|Traffic lights]]
===A note on transaction management===
%% To make tests automatically repeatable, DbFit executes each test in a separate transaction, and rolls back on the end of the test. You can commit or rollback manually as well if you want to persist the effects of a test (this will be explained in %%[[:dbfit:reference:CommandReference|Command reference]]%%). Note, however, that it is a very good practice to make tests repeatable. If you intend to persist anything, make sure that unique constraints do not prevent the test from repeating. %%
//Previous page: [[:dbfit:reference:DatabaseUnitTests:InstallingDbFit|Installing DbFit]] Next page: [[:dbfit:reference:DatabaseUnitTests:ManagingWikiContent|Managing Wiki content]] Parent page: [[:dbfit:reference:DatabaseUnitTests|Database unit tests]]//

Views

Navigation

Personal Tools

Search

Toolbox