dbicx::testdatabase(3pm) [debian man page]

DBICx::TestDatabase(3pm)				User Contributed Perl Documentation				  DBICx::TestDatabase(3pm)

NAME

       DBICx::TestDatabase - create a temporary database from a DBIx::Class::Schema

SYNOPSIS

       Given a DBIx::Class::Schema at "MyApp::Schema", create a test database like this:

	  use DBICx::TestDatabase;
	  my $schema = DBICx::TestDatabase->new('MyApp::Schema');

       Then you can use $schema normally:

	  $schema->resultset('Blah')->create({ blah => '123' });

       When your program exits, the temporary database will go away.

DESCRIPTION

       This module creates a temporary SQLite database, deploys your DBIC schema, and then connects to it.  This lets you easily test your DBIC
       schema.	Since you have a fresh database for every test, you don't have to worry about cleaning up after your tests, ordering of tests
       affecting failure, etc.

METHODS

   new($schema)
       Loads $schema and returns a connection to it.

   connect
       Alias for new.

ENVIRONMENT

       You can control the behavior of this module at runtime by setting environment variables.

   DBIC_KEEP_TEST
       If this variable is true, then the test database will not be deleted at "END" time.  Instead, a message containing the paths of the test
       databases will be printed.

       This is good if you want to look at the database your test generated, for debugging.

       (Note that the database will never exist on disk if you don't set this to a true value.)

AUTHOR

       Jonathan Rockway "<jrockway@cpan.org>"

LICENSE

       Copyright (c) 2007 Jonathan Rockway.

       This program is free software.  You may use, modify, and redistribute it under the same terms as Perl itself.

perl v5.10.1							    2010-12-15						  DBICx::TestDatabase(3pm)

SQL::Translator::Parser::DBIx::Class(3) 		User Contributed Perl Documentation		   SQL::Translator::Parser::DBIx::Class(3)

NAME

       SQL::Translator::Parser::DBIx::Class - Create a SQL::Translator schema from a DBIx::Class::Schema instance

SYNOPSIS

	## Via DBIx::Class
	use MyApp::Schema;
	my $schema = MyApp::Schema->connect("dbi:SQLite:something.db");
	$schema->create_ddl_dir();
	## or
	$schema->deploy();

	## Standalone
	use MyApp::Schema;
	use SQL::Translator;

	my $schema = MyApp::Schema->connect;
	my $trans  = SQL::Translator->new (
	     parser	 => 'SQL::Translator::Parser::DBIx::Class',
	     parser_args => {
		 package => $schema,
		 add_fk_index => 0,
		 sources => [qw/
		   Artist
		   CD
		 /],
	     },
	     producer	 => 'SQLite',
	    ) or die SQL::Translator->error;
	my $out = $trans->translate() or die $trans->error;

DESCRIPTION

       This class requires SQL::Translator installed to work.

       "SQL::Translator::Parser::DBIx::Class" reads a DBIx::Class schema, interrogates the columns, and stuffs it all in an $sqlt_schema object.

       Its primary use is in deploying database layouts described as a set of DBIx::Class classes, to a database. To do this, see "deploy" in
       DBIx::Class::Schema.

       This can also be achieved by having DBIx::Class export the schema as a set of SQL files ready for import into your database, or passed to
       other machines that need to have your application installed but don't have SQL::Translator installed. To do this see "create_ddl_dir" in
       DBIx::Class::Schema.

PARSER OPTIONS

   add_fk_index
       Create an index for each foreign key.  Enabled by default, as having indexed foreign key columns is normally the sensible thing to do.

   sources
       Arguments: @class_names

       Limit the amount of parsed sources by supplying an explicit list of source names.

SEE ALSO

       SQL::Translator, DBIx::Class::Schema

AUTHORS

       See "CONTRIBUTORS" in DBIx::Class.

LICENSE

       You may distribute this code under the same terms as Perl itself.

perl v5.16.2							    2012-08-16				   SQL::Translator::Parser::DBIx::Class(3)