DBIx::C...t::Help(3)

💅 DBIx::Class::Migration::Script::Help(3) — aka the dbic-migration cheat sheet, bestie edition 🎀

okay so this page is literally the handbook for DBIx::Class::Migration::Script::Help — it's the summary of all the commands, and honestly? iconic. it's giving "table of contents but make it cute." every command, every option, every flag is down below, no cap, nothing skipped ✨

---

🌸 NAME 🌸

DBIx::Class::Migration::Script::Help — the summary of the commands, periodt 💖

---

🦋 USAGE 🦋

dbic-migration [options] Command

---

👑 COMMANDS 👑

so here's the rundown of everything that's available, bestie — read it and weep (with joy) 😭

🎀 Informational Commands

• help — the tl;dr of the commandline help 🌸
• help [word] — the detailed help for [command] or [option], i.e. the deep dive you actually want 💅
• version — tells you which version of DBIx::Class::Migration you're running rn ⭐
• status — the current database and schema version, your vibe check for the DB 🦋

🔥 Preparing and using Migrations

• prepare — makes deployment files for your schema_class ✨
• install — installs a version into the database ✅
• upgrade — upgrades the database, we love a glow-up 💖
• downgrade — downgrades the database, going back, no shame 🫶
• install_if_needed — installs the database if it's not installed already (if it is installed, it just... doesn't, lowkey efficient) 🙈
• install_version_storage — populates the DBIC:DH metadata tables 👑

🧚 Commands for working with Fixtures

• dump_named_sets — creates fixture sets for the named sets 🍓
• dump_all_sets — dumps all available fxture sets 🌈
• populate — deploys the current database from fixtures 🌸

💀 Utility Commands

• drop_tables — drops all tables in the target database. CAREFUL! like, for real, be careful, this is the main character of destructive commands 😭
• delete_table_rows — truncates all the tables (no data, keep structure) — empty out the data but leave the structure standing, bestie 💅
• make_schema — reverse engineers your database into DBIx::Class 🔄
• diagram — creates an image schematic of your schema, so you can look at it, we love a visual 🎨

⭐ Command options

• include / include/s (I, lib/s) — adds the listed paths to @INC
• schema_class (S) — the DBIx::Class::Schema subclass you are migrating
• target_dir (D) — where to put (or find) your migration files
• sandbox_dir — specify an alternative path for your database sandbox
• username (U) — the username, the name says it all, no blurb provided 🙈
• password (P) — the password, again, no blurb, it's literally just this 💀
• dsn — connection info to the database you are migrating
• force_overwrite (O) — allows overwriting of existing migration files
• to_version (V) — use the given migration version
• database / database/s — the type of database we are preparing migrations for
• fixture_set / fixture_set/s — controls the fixture sets used for dumping or populating
• sandbox_class (T) — makes any of SqliteSandbox, MySQLSandbox, PostgresqlSandbox
• dbic_fixture_class — names an alternative subclass of DBIx::Class::Fixtures
• dbic_connect_attrs — passes custom args to DBIx::Class::Schema->connect
• dbi_connect_attrs — passes custom args to DBI via DBIx::Class::Schema->connect
• extra_schemaloader_args — passes custom args to DBIx::Class::Migration::SchemaLoader
• dbic_fixtures_extra_args — passes custom args to DBIx::Class::Fixtures

---

✨ EXAMPLE ✨

here's one to screenshot and keep, bestie 🫶

dbic-migration status \
  --libs="lib" \
  --schema_class='MyApp::Schema' \
  --dsn='DBI:SQLite:myapp.db'

---

🌈 SEE ALSO 🌈

go off, read these next:

• DBIx::Class::Migration
• DBIx::Class::Migration::Script
• DBIx::Class::Migration::Features
• DBIx::Class::Migration::Tutorial

---

💜 AUTHOR 💜

see DBIx::Class::Migration for author information 👑

---

🎀 COPYRIGHT & LICENSE 🎀

see DBIx::Class::Migration for copyright and license information 💖

---

and that's the whole page, bestie — perl v5.42.0, dated 2020-06-03, so this manual page is a lil vintage but she still ate 💅✨ bye mwah 🫶