Re: [ddsteps-user] Questions about DDSteps usage with a large project

[<kip...@ya...>]

> ... but does anyone have suggestions/anecdotes in regards to dealing with several developers running tests semi-frequently and possibly simultaneously (e.g. creating a database for each developer, or locking the database while tests run)?

yes, our team recently had to solve this problem as we have a environment in which developers have their own schemas, and there are also schema which are shared by everyone. our solution was to use placeholders in the Excel files. For example, we use ${MY.SCHEMA}.sometable to refer to schemas that are user specific; the placeholder is converted to, for example, hiverson.sometable at runtime. In cases where our unit tests create/read/update/delete data in shared tables, we use placeholders such as ${MY.UNIQUEID} in the sample data, where the placeholder is swapped with some unique string (e.g., a phone extension, email address, etc.).

i can send you the code that i whipped up for this if you'd like. in a nutshell, it's a custom class that extends the base DDSteps class and makes use of the DbUnit API directly. the db username is is retrieved from the jdbc connection and used as the schema name. the unique id is retrieved from an external properties file.

-clint

----- Original Message ----
From: Harlan Iverson <h.i...@gm...>
To: dds...@li...
Sent: Thursday, April 19, 2007 5:15:45 AM
Subject: [ddsteps-user] Questions about DDSteps usage with a large project


Hello,
I am investigating test solutions and DDSteps seems impressive, and very promising for my project's needs. I am left with a few questions though:
-           Can a test case load and combine fixture datasets from multiple excel sheets (similar to DbUnit's CompositeDataSet)? The goal being the ability to have shared/common data. If not, roughly how much of an undertaking would it be to add such functionality? 
-           Is loading XML Spreadsheets currently possible? If not, how much effort would be required for a basic implementation? The goal here is for test data to be stored as ASCII so that VCS diff/merge is possible.
-           This is somewhat DbUnit specific, but does anyone have suggestions/anecdotes in regards to dealing with several developers running tests semi-frequently and possibly simultaneously (e.g. creating a database for each developer, or locking the database while tests run)?


Thanks for your time, 
Harlan
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
ddsteps-user mailing list
dds...@li...
https://lists.sourceforge.net/lists/listinfo/ddsteps-user