Scroll to navigation

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 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
compatibility option all of the above can be supplied as --op=<action>
display this help

Arguments

Supply the config file for parsing by Config::Any
Supply the connect info as trailing options e.g. --connect-info dsn=<dsn> user=<user> password=<pass>
Supply the connect info as a JSON-encoded structure, e.g. an --connect=["dsn","user","pass"]
The class of the schema to load
Where in the config to find the connection_info, supply in form MyApp::Model::DB
The resultset to operate on for data manipulation
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

AUTHORS

See "AUTHORS" in DBIx::Class

LICENSE

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

2022-05-21 perl v5.34.0