dbicadmin(1p) [debian man page]

DBICADMIN(1p)						User Contributed Perl Documentation					     DBICADMIN(1p)

NAME

       dbicadmin - utility for administrating DBIx::Class schemata

SYNOPSIS

       dbicadmin: [-I] [long options...]

	 deploy a schema to a database
	 dbicadmin --schema=MyApp::Schema 
	   --connect='["dbi:SQLite:my.db", "", ""]' 
	   --deploy

	 update an existing record
	 dbicadmin --schema=MyApp::Schema --class=Employee 
	   --connect='["dbi:SQLite:my.db", "", ""]' 
	   --op=update --set='{ "name": "New_Employee" }'

OPTIONS

   Actions
       --create
	   Create version diffs needs preversion

       --upgrade
	   Upgrade the database to the current schema

       --install
	   Install the schema version tables to an existing database

       --deploy
	   Deploy the schema to the database

       --select
	   Select data from the schema

       --insert
	   Insert data into the schema

       --update
	   Update data in the schema

       --delete
	   Delete data from the schema

       --op
	   compatiblity option all of the above can be suppied as --op=<action>

       --help
	   display this help

   Arguments
       --schema-class
	   The class of the schema to load

       --resultset or --resultset-class or --class
	   The resultset to operate on for data manipulation

       --config-stanza
	   Where in the config to find the connection_info, supply in form MyApp::Model::DB

       --config
	   Supply the config file for parsing by Config::Any

       --connect-info
	   Supply the connect info as additional options ie -I dsn=<dsn> user=<user> password=<pass>

       --connect
	   Supply the connect info as a json string

       --sql-dir
	   The directory where sql diffs will be created

       --sql-type
	   The RDBMs flavour you wish to use

       --version
	   Supply a version install

       --preversion
	   The previous version to diff against

       --set
	   JSON data used to perform data operations

       --attrs
	   JSON string to be used for the second argument for search

       --where
	   JSON string to be used for the where clause of search

       --force
	   Be forceful with some operations

       --trace
	   Turn on DBIx::Class trace output

       --quiet
	   Be less verbose

       -I  Same as perl's -I, prepended to current @INC

AUTHORS

       See "CONTRIBUTORS" in DBIx::Class

LICENSE

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

perl v5.14.2							    2011-11-29							     DBICADMIN(1p)

Check Out this Related 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 => {
		 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)

Linux and UNIX Man Pages

dbicadmin(1p) [debian man page]

Check Out this Related Man Page