PlugIns.JdbcFixtures.AnotherVersion

The version posted at .JdbcFixtures[?] was posted a few weeks before the 20041105 release of fitnesse. Unfortunately, those jdbc fixtures won't work with the 20041105 release. Here is a version (based on the code at .JdbcFixtures[?], but simplified a bit) updated to work w/ the current version of Fitnesse.

Download (code and .jar)

Here's a sample wiki page

classpath: fitnesse.jar
classpath: lib/mm.mysql-2.0.11.jar
classpath: lib/jdbcfixtures.jar

Import

fitnesse.jdbc

Jdbc Connection
driver	url	user	password
org.gjt.mm.mysql.Driver	jdbc:mysql://localhost:3306/someDatabase	me	secret

Delete

user

Select	user
firstName	lastName	email

Insert	user
firstName	lastName	email	gender	date_registered
John	Doe	john@doe.com	M	2005-01-18 11:01:53
Jane	Roe	jane@roe.com	F

Select	user
firstName	lastName	email	gender	date_registered
John	Doe	john@doe.com	M
Jane	Roe	jane@roe.com	F

Update	user
firstName	where	firstName
Jonathan		John
Jennifer		Jane

Select	user
firstName	lastName	email	gender	date_registered
Jonathan	Doe	john@doe.com	M
Jennifer	Roe	jane@roe.com	F

Keyboard Shortcuts ?

General

Go To

Edit Mode

Tools

Keyboard Shortcuts `?`