Toru Yamaguchi > Test-Fixture-DBI > Test::Fixture::DBI

Download:
Test-Fixture-DBI-0.07.tar.gz

Dependencies

Annotate this POD

CPAN RT

Open  0
View/Report Bugs
Module Version: 0.07   Source  

NAME ^

Test::Fixture::DBI - load fixture data to database.

SYNOPSIS ^

  use DBI;
  use File::Temp qw(tempfile);
  use Test::More;
  use Test::Fixture::DBI;

  my ( undef, $filename ) = tempfile;
  my $dbh = DBI->connect( "dbi:SQLite:dbname=$filename", "", "" );

  construct_database(
    dbh => $dbh,
    database => '/path/to/schema.yaml',
  );

  construct_fixture(
    dbh => $dbh,
    fixture => '/path/to/fixture.yaml',
  );

DESCRIPTION ^

Test::Fixture::DBI is fixture test library for DBI.

SETUP ^

Before using this module, you must create database definition and fixture data. The following is creating database definition using make_database_yaml.pl.

  $ make_database_yaml.pl -d "dbi:mysql:dbname=social;host=testdb" -u root -p password -o /path/to/schema.yaml

Next step is create fixture,

  $ make_fixture_yaml.pl -d "dbi:mysql:dbname=social;host=testdb" -u root -p password -t activity -n id \
    -e "SELECT * FROM activity WHERE app_id = 12 ORDER BY created_on DESC LIMIT 10" -o /path/to/fixture.yaml

FUNCTIONS ^

construct_database( %specs )

The following is %specs details

dbh

Required parameter. dbh is DBI's DBI::db object;

database

Required parameter. database is ARRAYREF or SCALAR. specify database name.

schema

Optional parameter. schema is ARRAYREF. if schema parameter is specified, then load particular schema from database.

procedure

Optional parameter. procedure is ARRAYREF. if procedure parameter is specified, then load particular procedures from database.

function

Optional parameter. function is ARRAYREF. if function parameter is specified, then load particular functions from database.

index

Optional parameter. index is ARRAYREF. if index parameter is specified, then load particular indexes from database.

construct_fixture( %specs )

The following is %specs details

dbh

Required parameter. dbh is DBI's DBI::db object;

fixture

Required parameter. fixture is SCALAR or ARRAYREF, Specify fixture files.

opts

Optional parameter. opts is HASHREF. opts has bulk_insert key. if the bulk_insert value is true, then using bulk insert on loading fixture data.

construct_trigger( %specs )

The following is %specs details

dbh

Required parameter. dbh is DBI's DBI::db object;

database

Optional parameter. database is SCALAR. specify database name.

schema

Optional parameter. schema is ARRAYREF. if schema parameter is specified, then create particular triggers related specified schema on the database.

AUTHOR ^

Toru Yamaguchi <zigorou@cpan.org>

Yuji Shimada <xaicron@cpan.org>

SEE ALSO ^

Test::Fixture::DBIC::Schema
Test::Fixture::DBIxSkinny

LICENSE ^

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

syntax highlighting: