Strategies for Data Loading and DB Initialization for Integration Tests

By : sblundy
Source: Stackoverflow.com
Question!

I'm developing an integration testing framework for a data intensive J2EE enterprise application and I'm trying to decide upon a strategy for initializing and populating the database. We have a fairly complex model.

The system will have to:

  1. Initialize the system itself
  2. Load users
  3. Load application test data

The test data won't be as complex as the system will handle, load and stress testing is the domain of a specialized test team. We're interested in how well the UI's display what is in the system and that functions integration correctly from top to bottom.

By : sblundy


Answers

Unitils provides support for both loading the test data and keeping the test DB schema up-to-date. In order for the latter to work, your schema change scripts need to follow a particular naming convention.

By : Dónal


DBUnit is a pretty good framework for loading data into a test database.

By : nathan


I have used activex in my applications before. i place the object tags in the ASP.NET form and the following JavaScript works for me.

function onEventHandler(arg1, arg2){
    // do something
}

window.onload = function(){
    var yourActiveXObject = document.getElementById('YourObjectTagID');
    if(typeof(yourActiveXObject) === 'undefined' || yourActiveXObject === null){
        alert('Unable to load ActiveX');
        return;
    }

    // attach events
    var status = yourActiveXObject.attachEvent('EventName', onEventHandler);
}
By : Zuhaib


This video can help you solving your question :)
By: admin