---
name: "dbicadmin"
section: "1p"
platform: "linux"
package: "libdbix-class-perl"
version: "0.082844-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/dbicadmin"
---

# dbicadmin(1p)

utility for administrating DBIx::Class schemata

## 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**

  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