Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
DBIx::Class::MigrationUserlContributedDPIx::Class::Migration::SqliteSandbox(3)

NAME
       DBIx::Class::Migration::SqliteSandbox - Autocreate a Sqlite sandbox

SYNOPSIS
	   use DBIx::Class::Migration;

	   my $migration = DBIx::Class::Migration->new(
	     schema_class=>'Local::Schema',
	     db_sandbox_class=>'DBIx::Class::Migration::SqliteSandbox'),

	   $migration->prepare;
	   $migration->install;

       Please note "db_sandbox_class" is a lazy	built attribute, and it	will
       default to DBIx::Class::Migration::SqliteSandbox.

DESCRIPTION
       In order	to help	you jumpstart your database design and deployment, by
       default we will automatically create a sqlite based file	database in
       your "target-dir".

       This is the default supported option as documented in
       DBIx::Class::Migration and in DBIx::Class::Migration::Tutorial.
       DBD::SQLite is useful for your initial development and for when you are
       trying to build quick prototypes	but for	production and more serious
       work I recommend	you target a different database.  You can use
       MySQL::Sandbox to make it easy to create	local MySQL sandboxes for
       development, including replication clusters.  For a more	simple (and
       limited)	approach you can also use DBIx::Class::Migration::MySQLSandbox
       or DBIx::Class::Migration::PgSandbox.

       Nothing else is required	to install in order to use this	default
       option.

       Since Sqlite is a simple, single	file database that doesn't run
       persistently we don't create any	helper scripts.	 If you	want to	access
       the database directly you can do	so with	the "sqlite3" commandline tool
       which you should	get when you get DBD::Sqlite.  To access the sandbox
       database:

	   sqlite3 [target_dir]/[schema_class].db

       For example, if your "schema_class" is "MyApp::Schema" and your sandbox
       is in the default "share":

	   sqlite3  MyApp-Web/share/myapp-schema.db

       You can also follow the tutorial	DBIx::Class::Migration::Tutorial since
       the bulk	of the tutorial	uses the sqlite	sandbox.

SEE ALSO
       DBIx::Class::Migration, DBD::Sqlite.

AUTHOR
       See DBIx::Class::Migration for author information

COPYRIGHT & LICENSE
       See DBIx::Class::Migration for copyright	and license information

perl v5.24.1			  2016DBIx::Class::Migration::SqliteSandbox(3)

NAME | SYNOPSIS | DESCRIPTION | SEE ALSO | AUTHOR | COPYRIGHT & LICENSE

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=DBIx::Class::Migration::SqliteSandbox&sektion=3&manpath=FreeBSD+12.0-RELEASE+and+Ports>

home | help