DBICADMIN(1)

📦
version 0.082844 · 5 versions
, in opensuse-leap 16.0

💖 DBICADMIN(1) 💖

okay bestie, this is the dbicadmin page from the User Contributed Perl Documentation and it's literally the utility for administrating DBIx::Class schemata. we're about to go through every flag, every action, every little JSON string — no skipping, periodt. 🫶✨

🌸 NAME 🌸

dbicadmin — utility for administrating DBIx::Class schemata.

✨ SYNOPSIS ✨

okay so the basic shape is:

dbicadmin: [-I] [long options...]

and here's the deploy-a-schema-to-a-database moment:

deploy a schema to a database
dbicadmin --schema=MyApp::Schema \
  --connect='["dbi:SQLite:my.db", "", ""]' \
  --deploy

then updating an existing record is giving:

update an existing record
dbicadmin --schema=MyApp::Schema --class=Employee \
  --connect='["dbi:SQLite:my.db", "", ""]' \
  --op=update --set='{ "name": "New_Employee" }'

💅 OPTIONS 💅

okay now the actual menu, bestie. it's split into actions and arguments, and we're doing all of them. 🎀

🎀 Actions 🎀

  • --create — creates version diffs, and it needs preversion — like, don't forget that part. 💀
  • --upgrade — upgrade the database to the current schema. glow-up time. ✨
  • --install — install the schema version tables into an existing database. 🛠️
  • --deploy — deploy the schema to the database. main character energy. 👑
  • --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 — this is the compatibility option, so all of the actions above can be supplied as --op=<action>. iykyk. 🎀
  • --help — display this help. literally the save button for your confusion. 🙈

🦋 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 it in the 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 — that's the whole mood. 💖

🌈 LICENSE 🌈

you may distribute this code under the same terms as Perl itself. slay. 🫶

and that's the whole page, bestie — perl v5.42.0 · 2025-01-22 · DBICADMIN(1). go admin those schemata. 💅✨

📦 where this page comes from