DBICDUMP(1p) User Contributed Perl Documentation DBICDUMP(1p)NAME
dbicdump - Dump a schema using DBIx::Class::Schema::Loader
SYNOPSIS
dbicdump <configuration_file>
dbicdump [-I <lib-path>] [-o <loader_option>=<value> ]
<schema_class> <connect_info>
Examples:
$ dbicdump schema.conf
$ dbicdump -o dump_directory=./lib
-o components='["InflateColumn::DateTime"]'
MyApp::Schema dbi:SQLite:./foo.db
$ dbicdump -o dump_directory=./lib
-o components='["InflateColumn::DateTime"]'
MyApp::Schema dbi:SQLite:./foo.db '{ quote_char => """ }'
$ dbicdump -Ilib -o dump_directory=./lib
-o components='["InflateColumn::DateTime"]'
-o preserve_case=1
MyApp::Schema dbi:mysql:database=foo user pass '{ quote_char => "`" }'
$ dbicdump -o dump_directory=./lib
-o components='["InflateColumn::DateTime"]'
MyApp::Schema 'dbi:mysql:database=foo;host=domain.tld;port=3306' user pass
On Windows that would be:
$ dbicdump -o dump_directory=.lib ^
-o components="[q{InflateColumn::DateTime}]" ^
-o preserve_case=1 ^
MyApp::Schema dbi:mysql:database=foo user pass "{ quote_char => q{`} }"
Configuration files must have schema_class and connect_info sections, an example of a general config file is as follows:
schema_class MyApp::Schema
lib /extra/perl/libs
# connection string
<connect_info>
dsn dbi:mysql:example
user root
pass secret
</connect_info>
# dbic loader options
<loader_options>
components InflateColumn::DateTime
components TimeStamp
</loader_options>
Using a config file requires Config::Any installed.
The optional "lib" key is equivalent to the "-I" option.
DESCRIPTION
Dbicdump generates a DBIx::Class schema using "make_schema_at" in DBIx::Class::Schema::Loader and dumps it to disk.
You can pass any DBIx::Class::Schema::Loader::Base constructor option using "-o <option>=<value>". For convenience, option names will have
"-" replaced with "_" and values that look like references or quote-like operators will be "eval"-ed before being passed to the
constructor.
The "dump_directory" option defaults to the current directory if not specified.
SEE ALSO
DBIx::Class::Schema::Loader, DBIx::Class.
AUTHOR
Dagfinn Ilmari Manns?ker "<ilmari@ilmari.org>"
CONTRIBUTORS
Caelum: Rafael Kitover <rkitover@cpan.org>
alnewkirk: Al Newkirk <awncorp@cpan.org>
LICENSE
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2011-10-31 DBICDUMP(1p)
Check Out this Related Man Page
Catalyst::TraitFor::Model::DBIC::Schema::Replicated(3pm)User Contributed Perl DocumentatioCatalyst::TraitFor::Model::DBIC::Schema::Replicated(3pm)NAME
Catalyst::TraitFor::Model::DBIC::Schema::Replicated - Replicated storage support for Catalyst::Model::DBIC::Schema
SYNOPSiS
__PACKAGE__->config({
traits => ['Replicated']
connect_info =>
['dbi:mysql:master', 'user', 'pass'],
replicants => [
['dbi:mysql:slave1', 'user', 'pass'],
['dbi:mysql:slave2', 'user', 'pass'],
['dbi:mysql:slave3', 'user', 'pass'],
],
balancer_args => {
master_read_weight => 0.3
}
});
DESCRIPTION
Sets your storage_type to DBIx::Class::Storage::DBI::Replicated and connects replicants provided in config. See that module for supported
resultset attributes.
The default "balancer_type" in DBIx::Class::Storage::DBI::Replicated is "::Random".
Sets the "master_read_weight" in DBIx::Class::Storage::DBI::Replicated::Balancer::Random to 1 by default, meaning that you have the same
chance of reading from master as you do from replicants. Set to 0 to turn off reads from master.
CONFIG PARAMETERS
replicants
Array of connect_info settings for every replicant.
The following can be set via "connect_info" in Catalyst::Model::DBIC::Schema, or as their own parameters. If set via separate parameters,
they will override the settings in "connect_info".
pool_type
See "pool_type" in DBIx::Class::Storage::DBI::Replicated.
pool_args
See "pool_args" in DBIx::Class::Storage::DBI::Replicated.
balancer_type
See "balancer_type" in DBIx::Class::Storage::DBI::Replicated.
balancer_args
See "balancer_args" in DBIx::Class::Storage::DBI::Replicated.
SEE ALSO
Catalyst::Model::DBIC::Schema, DBIx::Class, DBIx::Class::Storage::DBI::Replicated, Catalyst::TraitFor::Model::DBIC::Schema::Caching
AUTHOR
See "AUTHOR" in Catalyst::Model::DBIC::Schema and "CONTRIBUTORS" in Catalyst::Model::DBIC::Schema.
COPYRIGHT
See "COPYRIGHT" in Catalyst::Model::DBIC::Schema.
LICENSE
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2011-05-15 Catalyst::TraitFor::Model::DBIC::Schema::Replicated(3pm)