GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  DBIX::CLASS::MIGRATION::SQLITESANDBOX (3)

.ds Aq ’

NAME

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

CONTENTS

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
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 DBIX::CLASS::MIGRATION::SQLITESANDBOX (3) 2015-03-24

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.