dbicadmin(1p)

dbicadmin1p

Utility for administrating dbix::class schemata

Usage

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

Releases

10 releases since Debian 4.0 (Etch); the text changed 8 times.

  1. 4.0
  2. 5.0
  3. 6.0
  4. 7
  5. 8
  6. 9
  7. 10–11
  8. 12
  9. 13

--attrs since Debian 6.0 (Squeeze); --class since Debian 6.0 (Squeeze); --config since Debian 6.0 (Squeeze); --config-file since Debian 8 (Jessie); --config-stanza since Debian 6.0 (Squeeze); --connect since Debian 6.0 (Squeeze); --connect-info since Debian 6.0 (Squeeze); --create since Debian 6.0 (Squeeze); --delete since Debian 6.0 (Squeeze); --deploy since Debian 6.0 (Squeeze); --force since Debian 6.0 (Squeeze); --help since Debian 6.0 (Squeeze); --insert since Debian 6.0 (Squeeze); --install since Debian 6.0 (Squeeze); --op since Debian 6.0 (Squeeze); --preversion since Debian 6.0 (Squeeze); --quiet since Debian 6.0 (Squeeze); --resultset since Debian 6.0 (Squeeze); --resultset-class since Debian 6.0 (Squeeze); --schema-class since Debian 6.0 (Squeeze); --select since Debian 6.0 (Squeeze); --set since Debian 6.0 (Squeeze); --sql-dir since Debian 6.0 (Squeeze); --sql-type since Debian 6.0 (Squeeze); --trace since Debian 6.0 (Squeeze); --update since Debian 6.0 (Squeeze); --upgrade since Debian 6.0 (Squeeze); --version since Debian 6.0 (Squeeze); --where since Debian 6.0 (Squeeze); -I since Debian 6.0 (Squeeze).

Authors

See "AUTHORS" in DBIx::Class

License

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

From libdbix-class-perl 0.082844-1 in Debian 13 (Trixie). Parsed by carta from the page's man source.