dbicadmin - Man Page
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
compatibility option all of the above can be supplied as --op=<action>
- --help
display this help
Arguments
- --config-file or --config
Supply the config file for parsing by Config::Any
- --connect-info
Supply the connect info as trailing options e.g. --connect-info dsn=<dsn> user=<user> password=<pass>
- --connect
Supply the connect info as a JSON-encoded structure, e.g. an --connect=["dsn","user","pass"]
- --schema-class
The class of the schema to load
- --config-stanza
Where in the config to find the connection_info, supply in form MyApp::Model::DB
- --resultset or --resultset-class or --class
The resultset to operate on for data manipulation
- --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 "AUTHORS" in DBIx::Class
License
You may distribute this code under the same terms as Perl itself