dbicadmin - utility for administrating DBIx::Class schemata
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" }'
Create version diffs needs preversion
Upgrade the database to the current schema
Install the schema version tables to an existing database
Deploy the schema to the database
Select data from the schema
Insert data into the schema
Update data in the schema
Delete data from the schema
compatiblity option all of the above can be suppied as --op=<action>
display this help
The class of the schema to load
The resultset to operate on for data manipulation
Where in the config to find the connection_info, supply in form MyApp::Model::DB
Supply the config file for parsing by Config::Any
Supply the connect info as additonal options ie -I dsn=<dsn> user=<user> password=<pass>
Supply the connect info as a json string
The directory where sql diffs will be created
The RDBMs flavour you wish to use
Supply a version install
The previous version to diff against
JSON data used to perform data operations
JSON string to be used for the second argument for search
JSON string to be used for the where clause of search
Be forceful with some operations
Turn on DBIx::Class trace output
Be less verbose
Same as perl's -I, prepended to current @INC
See "CONTRIBUTORS" in DBIx::Class
You may distribute this code under the same terms as Perl itself
To install DBIx::Class, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::Class
CPAN shell
perl -MCPAN -e shell install DBIx::Class
For more information on module installation, please visit the detailed CPAN module installation guide.