DBIx::C...owngrade(3)

💖 NAME 💖

DBIx::Class::Migration::Script::Help::downgrade — Downgrade your existing database

Okay bestie, this is the DBIx::C...owngrade(3) page from User Contributed Perl Documentation, and we are literally here to downgrade a database. It's giving rewinding the timeline but make it schema-safe. 🕰️✨

🌸 SYNOPSIS 🌸

dbic-migration downgrade --schema_class MyApp::Schema --to_version 2

This is the exact command vibe, no cap. Run it and let the downgrade files do their thing. 💅

🦋 DESCRIPTION 🦋

So the whole point: run downgrade files to either bring the database into sync with the current schema version, or stop at an intermediate version specified via to_version. That's the tea. ☕✨

✨ OPTIONS ✨

This command accepts the following options. You may learn more about each option by typing dbic-migration help OPTION. The following is a summary. Bestie, there are quite a few, but we are not skipping a single one. 🫶

• includes (I, lib, libs, include) — Optional. Adds the listed paths to @INC. Handy during development when you want to use a development schema class. Literally dev-mode convenience. 🧚
• to_version — aliases: V, Optional. This is the target version of the database we are installing. The version named must be have been previously prepared. If not specified, we will use the current Schema class version. 🎯
• schema_class (S) — Accepts Str. Required. This is the schema we use as the basis for creating, managing and running your deployments. This should be the full package namespace defining your subclass of DBIx::Class::Schema. For example MyApp::Schema. If the schema_class cannot be loaded, a hard exception will be thrown. No soft landing, bestie. 💀
• target_dir (D) — Optional. When using a sandbox_class for generating developer level database sandboxes, you may wish to place the sandbox in a directory other than the default (which is under the share directory off the project root). Cute custom sandbox location moment. 🏖️
• sandbox_class — Aliases: T, sb. Accepts: String (default: SqliteSandbox). The class we use to create a developer level database sandbox. You can change this to either 'PostgresqlSandbox' or 'MySQLSandbox', which will create a sandbox using either DBIx::Class::Migration::MySQLSandbox or DBIx::Class::Migration::PostgresqlSandbox. Slay. 🐘🐬
• user — Aliases: U. That's it, bestie. It's just user. 👑
• password — Aliases: P. Same energy, just password. 🔐
• dsn — Connection information to an already created and running instance of a database. If you don't specify this, we will assume you want a developer level sandbox ( See sandbox_class in DBIx::Class::Migration::Script). So if you have a live DB, drop the dsn; if not, sandbox time. 🏖️
• dbic_fixture_class — Accepts: String to a Perl Class. Defaults to DBIx::Class::Fixtures. Lets you specify a fixture class. Fixture class = chosen, periodt. 🎀
• dbic_fixtures_extra_args — Accepts: HashRef. Optional. Allows you to pass custom arguments to DBIx::Class::Fixtures. Extra args, extra power. 💅
• dbic_connect_attrs — Accepts: HashRef, Optional. Lets you send custom attributes at connect time to either DBIx::Class or the underlying DBI and your storage DBD. Connect-time customization, iykyk. 🔌
• dbi_connect_attrs — Accepts: HashRef, Optional. Lets you send custom attributes at connect time to either DBIx::Class or the underlying DBI and your storage DBD. Same description, because the original lists them together under one description. 🫶

🌈 SEE ALSO 🌈

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

Go read these if you want the full lore. 📚✨

👑 AUTHOR 👑

See DBIx::Class::Migration for author information. Iconic of them to keep it centralized. 💖

🎀 COPYRIGHT & LICENSE 🎀

See DBIx::Class::Migration for copyright and license information. Legal bestie stuff, handled there. 🫶

---

Bye bestie! 💖 This page came from perl v5.42.0, dated 2020-06-03, and it's the DBIx::C...owngrade(3) manual — periodt. ✨