DBIx::SchemaChecksum - Manage your datebase schema via checksums

2 ++

2 ++

When you're dealing with several instances of the same database (eg. developer, testing, stage, production), it is crucial to make sure that all databases use the same schema. This can be quite an hair-pulling experience, and this module should help ...

DOMM/DBIx-SchemaChecksum-1.104 - 26 Jan 2021 12:12:41 UTC

DBIx::SchemaChecksum::App - Manage your datebase schema via checksums

2 ++

2 ++

Manage your datebase schema via checksums * Use "checksum" to calculate the current checksum of your database. * Use "new_changes_file" to generate a new db update script based on the current checksum. * Use "apply_changes" to apply all update script...

DOMM/DBIx-SchemaChecksum-1.104 - 26 Jan 2021 12:12:41 UTC

scs.pl - run DBIx::SchemaChecksum, but really you should use dbchecksum

2 ++

2 ++

DOMM/DBIx-SchemaChecksum-1.104 - 26 Jan 2021 12:12:41 UTC

dbchecksum - wrapper script to run DBIx::SchemaChecksum

2 ++

2 ++

DOMM/DBIx-SchemaChecksum-1.104 - 26 Jan 2021 12:12:41 UTC

DBIx::SchemaChecksum::Driver::Pg - Pg driver for DBIx::SchemaChecksum

2 ++

2 ++

Get various extra schema info from postgres, if specified via "driveropts" * enum values * sequences * index definitions * triggers * functions...

DOMM/DBIx-SchemaChecksum-1.104 - 26 Jan 2021 12:12:41 UTC

DBIx::SchemaChecksum::App::Checksum - get the current DB checksum

2 ++

2 ++

Calculate the current checksum and report it. Use "--show_dump" to show the string dump on which the checksum is based....

DOMM/DBIx-SchemaChecksum-1.104 - 26 Jan 2021 12:12:41 UTC

DBIx::SchemaChecksum::Driver::SQLite - SQLite driver for DBIx::SchemaChecksum

2 ++

2 ++

Ignore some internal sqlite tables...

DOMM/DBIx-SchemaChecksum-1.104 - 26 Jan 2021 12:12:41 UTC

DBIx::SchemaChecksum::App::ApplyChanges - Apply changes based on current checksum

2 ++

2 ++

Apply all changes found in "sqlsnippetdir" based on the current checksum. For each file there will be a prompt asking if you want to apply the file. Use "--no_prompt" to always accept each change (useful for deployment scripts etc). Use "--dry_run" t...

DOMM/DBIx-SchemaChecksum-1.104 - 26 Jan 2021 12:12:41 UTC

DBIx::SchemaChecksum::App::ShowUpdatePath - Show the update path

2 ++

2 ++

Show the whole update path starting from the current checksum, or from the one provided via "--from_checksum". Use '"--output concat"' to concat all changes to STDOUT. Use '"--output psql --dbname your-db"' to print some "psql" commands to apply chan...

DOMM/DBIx-SchemaChecksum-1.104 - 26 Jan 2021 12:12:41 UTC

DBIx::SchemaChecksum::App::NewChangesFile - Generate a new changes-file

2 ++

2 ++

Generate a new, empty changes file template in "sqlsnippetdir" with the current checksum autofilled in. You can provide a "--change_name", which will be used to generate the filename, and will be stored as a comment inside the file. If you do not spe...

DOMM/DBIx-SchemaChecksum-1.104 - 26 Jan 2021 12:12:41 UTC