Writing Test Case for Database Connectivity

[manorhce]

I am writing test cases for my application my problem is the modules which is used to connect to database, for that I am writing test cases and it connects to database and loads the database

My Point is that can Perl provides mock database object so that every time it will not connect database, It will create database mock object

UPDATE

I am writing like below

  
ok($db = Denali::DB->new(), "Connect");
isa_ok($db,  "Denali::DB");

my $dddd = Denali::DB->connect();

[kcott]

G'day manorhce,

DBD::Mock might do what you want. I haven't tried it myself.

[moritz]

A common solution is to use an SQLite database for testing, which uses a local file for storing the database. That means it requires no setup for username, password or a database server.