NAME

Test::DBIC - Facilitates Automated Testing for DBIx::Class

SYNOPSIS

In your test script add this block:

BEGIN {
    use Test::DBIC;

    eval 'require DBD::SQLite';
    if ($@) {
        plan skip_all => 'DBD::SQLite not installed';
    } else {
        plan tests => 1;  # change this to the correct number of tests
    }
};

my $schema = Test::DBIC->init_schema(
    sample_data_file => 't/var/sample_data.txt',
);

DESCRIPTION

This module facilitates testing of DBIx::Class components.

It is planned that this module will supercede or be superceeded by the testing module distributed within DBIx::Class. The hope is for this merge to happen in the 0.09x release of DBIx::Class.

This module allows you to use the testing functionality before it is released as a core component of DBIx::Class. In other words, the API might change, but if you need to test, this module is available as a bleeding-edge version before the next major version of DBIx::Class is released.

Methods

db_dir

Gets/sets the directory where SQLite database files will be stored.

Test::DBIC->db_dir(catdir('t', 'var'));

db_file

Gets/sets the name of the main SQLite database file.

Test::DBIC->db_file('test.db');

init_schema

Removes the test database under db_dir and then sets up a new test database and returns a DBIx::Class schema object for your test to use.

Parameters are:

existing_namespace

Look for ResultSource (table definition) classes under this namespace, rather than in the schema namespace specified by schema_class.

namespace

Subclass ResultSet objects into this namespace. Objects that you get back will be under this namespace.

no_deploy

If true, will not set up a test database nor populate it with sample data.

sqlt_deploy

If true, will call the experimental $schema->deploy(). Also triggered if the DBICTEST_SQLT_DEPLOY environment variable is set.

The default is to read the file t/lib/sqlite.sql and execute the SQL within.

eval_deploy

If true, and if using sqlt_deploy, will not die when the test database fails to initialize.

no_populate

If true, will not populate the test database with sample data.

clear

If true, will delete any existing data in the test database before populating with sample data.

sample_data

Specifies data to use when populating the test database.

The format is:

'sample_data' => [
    ResultSourceName => [
        ['column1', 'column2', 'column3'],
        ['data1', 'data2', 'data3'],
        ['data1', 'data2', 'data3'],
    ],
    ResultSourceName => [
        ...
    ],
],

The ResultSourceName is the string passed to $schema->resultset.

sample_data_file

Specifies a file which contains data to use when populating the test database.

The format for the file is:

ResultSourceName
column1, column2, column3
data1, data2, data3
data1, data2, data3
---
ResultSourceName
...

The ResultSourceName is the string passed to $schema->resultset.

Data for multiple tables may be specified, with a separator line of --- between them.

schema_class

The name of the DBIx::Class schema to use. Defaults to Test::DBIC::Schema.

deploy_schema

Called by init_schema. Creates tables in the test database.

clear_schema

Called before populating the test database, if clear has been set to true. Deletes data from known tables.

populate_schema

Called by init_schema. Loads sample data into the test database.

SEE ALSO

DBIx::Class

AUTHOR

Nathan Gray <kolibrie@cpan.org>

based on DBICTest (from the testsuite of DBIx::Class) and DBIC::Test (from the testsuite of DBIx::Class::InflateColumn::Currency)

COPYRIGHT AND LICENSE

Copyright (C) 2007 by Nathan Gray

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or, at your option, any later version of Perl 5 you may have available.