Adrian Witas > Test-DBUnit > Test::DBUnit::Generator

Download:
Test-DBUnit-0.20.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  1
Open  0
View/Report Bugs
Module Version: 0.22   Source  

NAME ^

Test::DBUnit::Generator - dbunit dataset generator

SYNOPSIS ^

    use Test::DBUnit::Generator;

    my $connection = DBIx::Connection->new(
        name     => 'test',
        dsn      => $ENV{DB_TEST_CONNECTION},
        username => $ENV{DB_TEST_USERNAME},
        password => $ENV{DB_TEST_PASSWORD},
    );

    my $generator = Test::DBUnit::Generator->new(
        connection      => $connection,
        datasets => {
            emp => 'SELECT * FROM emp',
            dept => 'SELECT * FROM demp',
        },
    );
    
    print $generator->xml_dataset;
    print $generator->dataset;


    pritn $generator->schema_validator(
        has_table        => 1,
        has_columns      => 1,
        has_pk           => 1,
        has_fk           => 1,
        has_index        => 1,
    );

DESCRIPTION ^

This class generates xml or perl test datasets based on passed in sql. Additionally it can generate schema validator code.

ATTRIBUTES

connection
datasets_order

Specifies order of the dataset in the generation result.

    my $generator = Test::DBUnit::Generator->new(
        connection      => $connection,
        datasets_order   => ['emp', 'dept'],
        datasets => {
            emp => 'SELECT * FROM emp',
            dept => 'SELECT * FROM demp',
        },
    );
datasets

METHODS

xml_dataset

Returns xml content that contains dataset

dataset

Generated dataset as perl code

_inscrease_tests_no
schema_validator

Generates schema validation code. Takes the following options as paramters:

has_table => 1, has_columns => 1, has_pk => 1, has_fk => 1, has_index => 1,

_has_table
_dataset_order
_has_columns
_has_pk
_has_fk
_has_index
_select_dataset

Returns dataset structure

syntax highlighting: