Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

sql::translator::parser::dbix::class5.18(3) [mojave man page]

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 => { dbic_schema => $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
dbic_schema The DBIx::Class schema (either an instance or a class name) to be parsed. This argument is in fact optional - instead one can supply it later at translation time as an argument to "translate" in SQL::Translator. In other words both of the following invocations are valid and will produce conceptually identical output: my $yaml = SQL::Translator->new( parser => 'SQL::Translator::Parser::DBIx::Class', parser_args => { dbic_schema => $schema, }, producer => 'SQL::Translator::Producer::YAML', )->translate; my $yaml = SQL::Translator->new( parser => 'SQL::Translator::Parser::DBIx::Class', producer => 'SQL::Translator::Producer::YAML', )->translate(data => $schema); 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.18.2 2014-01-22 SQL::Translator::Parser::DBIx::Class(3)

Check Out this Related Man Page

SQL::Translator::Schema::Trigger(3pm)			User Contributed Perl Documentation		     SQL::Translator::Schema::Trigger(3pm)

NAME
SQL::Translator::Schema::Trigger - SQL::Translator trigger object SYNOPSIS
use SQL::Translator::Schema::Trigger; my $trigger = SQL::Translator::Schema::Trigger->new( name => 'foo', perform_action_when => 'before', # or after database_events => [qw/update insert/], # also update, update_on, delete fields => [], # if event is "update" on_table => 'foo', # table name action => '...', # text of trigger schema => $schema, # Schema object scope => 'row', # or statement ); DESCRIPTION
"SQL::Translator::Schema::Trigger" is the trigger object. METHODS
new Object constructor. my $schema = SQL::Translator::Schema::Trigger->new; perform_action_when Gets or sets whether the event happens "before" or "after" the "database_event". $trigger->perform_action_when('after'); database_event Obsolete please use database_events! database_events Gets or sets the events that triggers the trigger. my $ok = $trigger->database_events('insert'); fields Gets and set which fields to monitor for "database_event". $view->fields('id'); $view->fields('id', 'name'); $view->fields( 'id, name' ); $view->fields( [ 'id', 'name' ] ); $view->fields( qw[ id name ] ); my @fields = $view->fields; table Gets or set the table on which the trigger works, as a SQL::Translator::Schema::Table object. $trigger->table($triggered_table); on_table Gets or set the table name on which the trigger works, as a string. $trigger->on_table('foo'); action Gets or set the action of the trigger. $trigger->action( q[ BEGIN select ...; update ...; END ] ); is_valid Determine whether the trigger is valid or not. my $ok = $trigger->is_valid; name Get or set the trigger's name. my $name = $trigger->name('foo'); order Get or set the trigger's order. my $order = $trigger->order(3); scope Get or set the trigger's scope (row or statement). my $scope = $trigger->scope('statement'); schema Get or set the trigger's schema object. $trigger->schema( $schema ); my $schema = $trigger->schema; compare_arrays Compare two arrays. equals Determines if this trigger is the same as another my $is_identical = $trigger1->equals( $trigger2 ); AUTHORS
Anonymous, Ken Youens-Clark <kclark@cpan.org>. perl v5.14.2 2012-01-18 SQL::Translator::Schema::Trigger(3pm)
Man Page