Changes for version 0.016
- More POD and documentation fixes (Volker++), (logie17++)
- changed the way I declare version requirements in my dist.ini filr in order address some bugs in the way version strings are interpreted in various versions of Perl.
Documentation
commandline tool to create and manage your migrations
Answers to Frequently Asked Questions
Features of DBIx::Class::Migration
How to use DBIx::Class::Migration
Add MySQL migration
Using a web framework
Final thoughts
Prepare your first Migration
Upgrade the Database
Bootstrap your project files
Test Your Database
Modules
Use your DB Sandbox to run Catalyst
Use the best tools together for sane database migrations
Autocreate a mysql sandbox
Utility to populate fixture data
Autocreate a postgresql sandbox
Control your Perl Migration Run Scripts
Give your Run Script a Schema
DB Sandbox Role
Schema Loader Factory
Tools to manage database Migrations
Build a target_dir in /share
Autocreate a Sqlite sandbox
Build a sandbox at target_dir
Build a tempory target_dir
Build a sandbox in a temporary directory
Use your fixtures in a test case.
Examples
- examples/MusicBase/app.psgi
- examples/MusicBase/bin/my-dbic-migration
- examples/MusicBase/dist.ini
- examples/MusicBase/lib/MusicBase/Schema.pm
- examples/MusicBase/lib/MusicBase/Schema/MigrationScript.pm
- examples/MusicBase/lib/MusicBase/Schema/Result/Artist.pm
- examples/MusicBase/lib/MusicBase/Schema/Result/ArtistCd.pm
- examples/MusicBase/lib/MusicBase/Schema/Result/Cd.pm
- examples/MusicBase/lib/MusicBase/Schema/Result/Country.pm
- examples/MusicBase/lib/MusicBase/Schema/Result/Track.pm
- examples/MusicBase/lib/MusicBase/Schema/ResultSet/Artist.pm
- examples/MusicBase/lib/MusicBase/Web.pm
- examples/MusicBase/lib/MusicBase/Web/Controller/Root.pm
- examples/MusicBase/lib/MusicBase/Web/Model/Schema.pm
- examples/MusicBase/lib/MusicBase/Web/View/HTML.pm
- examples/MusicBase/share/etc/musicbase_web.pl
- examples/MusicBase/share/etc/musicbase_web_test.pl
- examples/MusicBase/share/fixtures/1/all_tables/_dumper_version
- examples/MusicBase/share/fixtures/1/all_tables/artist/1.fix
- examples/MusicBase/share/fixtures/1/all_tables/artist/2.fix
- examples/MusicBase/share/fixtures/1/all_tables/cd/1.fix
- examples/MusicBase/share/fixtures/1/all_tables/cd/2.fix
- examples/MusicBase/share/fixtures/1/all_tables/cd/3.fix
- examples/MusicBase/share/fixtures/1/all_tables/track/1.fix
- examples/MusicBase/share/fixtures/1/all_tables/track/2.fix
- examples/MusicBase/share/fixtures/1/all_tables/track/3.fix
- examples/MusicBase/share/fixtures/1/all_tables/track/4.fix
- examples/MusicBase/share/fixtures/1/all_tables/track/5.fix
- examples/MusicBase/share/fixtures/1/all_tables/track/6.fix
- examples/MusicBase/share/fixtures/1/all_tables/track/7.fix
- examples/MusicBase/share/fixtures/1/conf/all_tables.json
- examples/MusicBase/share/fixtures/2/all_tables/_dumper_version
- examples/MusicBase/share/fixtures/2/all_tables/artist/1.fix
- examples/MusicBase/share/fixtures/2/all_tables/artist/2.fix
- examples/MusicBase/share/fixtures/2/all_tables/cd/1.fix
- examples/MusicBase/share/fixtures/2/all_tables/cd/2.fix
- examples/MusicBase/share/fixtures/2/all_tables/cd/3.fix
- examples/MusicBase/share/fixtures/2/all_tables/country/1.fix
- examples/MusicBase/share/fixtures/2/all_tables/country/2.fix
- examples/MusicBase/share/fixtures/2/all_tables/country/3.fix
- examples/MusicBase/share/fixtures/2/all_tables/track/1.fix
- examples/MusicBase/share/fixtures/2/all_tables/track/2.fix
- examples/MusicBase/share/fixtures/2/all_tables/track/3.fix
- examples/MusicBase/share/fixtures/2/all_tables/track/4.fix
- examples/MusicBase/share/fixtures/2/all_tables/track/5.fix
- examples/MusicBase/share/fixtures/2/all_tables/track/6.fix
- examples/MusicBase/share/fixtures/2/all_tables/track/7.fix
- examples/MusicBase/share/fixtures/2/conf/all_tables.json
- examples/MusicBase/share/fixtures/2/conf/countries.json
- examples/MusicBase/share/fixtures/2/countries/_dumper_version
- examples/MusicBase/share/fixtures/2/countries/country/1.fix
- examples/MusicBase/share/fixtures/2/countries/country/2.fix
- examples/MusicBase/share/fixtures/2/countries/country/3.fix
- examples/MusicBase/share/fixtures/3/all_tables/_dumper_version
- examples/MusicBase/share/fixtures/3/all_tables/artist/1.fix
- examples/MusicBase/share/fixtures/3/all_tables/artist/2.fix
- examples/MusicBase/share/fixtures/3/all_tables/artist/3.fix
- examples/MusicBase/share/fixtures/3/all_tables/artist_cd/1-1.fix
- examples/MusicBase/share/fixtures/3/all_tables/artist_cd/1-2.fix
- examples/MusicBase/share/fixtures/3/all_tables/artist_cd/2-3.fix
- examples/MusicBase/share/fixtures/3/all_tables/artist_cd/3-4.fix
- examples/MusicBase/share/fixtures/3/all_tables/cd/1.fix
- examples/MusicBase/share/fixtures/3/all_tables/cd/2.fix
- examples/MusicBase/share/fixtures/3/all_tables/cd/3.fix
- examples/MusicBase/share/fixtures/3/all_tables/cd/4.fix
- examples/MusicBase/share/fixtures/3/all_tables/country/1.fix
- examples/MusicBase/share/fixtures/3/all_tables/country/2.fix
- examples/MusicBase/share/fixtures/3/all_tables/country/3.fix
- examples/MusicBase/share/fixtures/3/all_tables/country/4.fix
- examples/MusicBase/share/fixtures/3/all_tables/country/5.fix
- examples/MusicBase/share/fixtures/3/all_tables/country/6.fix
- examples/MusicBase/share/fixtures/3/all_tables/track/1.fix
- examples/MusicBase/share/fixtures/3/all_tables/track/2.fix
- examples/MusicBase/share/fixtures/3/all_tables/track/3.fix
- examples/MusicBase/share/fixtures/3/all_tables/track/4.fix
- examples/MusicBase/share/fixtures/3/all_tables/track/5.fix
- examples/MusicBase/share/fixtures/3/all_tables/track/6.fix
- examples/MusicBase/share/fixtures/3/all_tables/track/7.fix
- examples/MusicBase/share/fixtures/3/conf/all_tables.json
- examples/MusicBase/share/fixtures/3/conf/countries.json
- examples/MusicBase/share/fixtures/3/countries/_dumper_version
- examples/MusicBase/share/fixtures/3/countries/country/1.fix
- examples/MusicBase/share/fixtures/3/countries/country/2.fix
- examples/MusicBase/share/fixtures/3/countries/country/3.fix
- examples/MusicBase/share/fixtures/3/countries/country/4.fix
- examples/MusicBase/share/fixtures/3/countries/country/5.fix
- examples/MusicBase/share/fixtures/3/countries/country/6.fix
- examples/MusicBase/share/html/index.tt
- examples/MusicBase/share/migrations/MySQL/deploy/3/001-auto-__VERSION.sql
- examples/MusicBase/share/migrations/MySQL/deploy/3/001-auto.sql
- examples/MusicBase/share/migrations/SQLite/deploy/1/001-auto-__VERSION.sql
- examples/MusicBase/share/migrations/SQLite/deploy/1/001-auto.sql
- examples/MusicBase/share/migrations/SQLite/deploy/2/001-auto-__VERSION.sql
- examples/MusicBase/share/migrations/SQLite/deploy/2/001-auto.sql
- examples/MusicBase/share/migrations/SQLite/deploy/3/001-auto-__VERSION.sql
- examples/MusicBase/share/migrations/SQLite/deploy/3/001-auto.sql
- examples/MusicBase/share/migrations/SQLite/downgrade/2-1/001-auto.sql
- examples/MusicBase/share/migrations/SQLite/downgrade/3-2/001-auto.sql
- examples/MusicBase/share/migrations/SQLite/upgrade/1-2/001-add_country.sql
- examples/MusicBase/share/migrations/SQLite/upgrade/1-2/003-change_artist.sql
- examples/MusicBase/share/migrations/SQLite/upgrade/2-3/001-create_artist_cd.sql
- examples/MusicBase/share/migrations/SQLite/upgrade/2-3/002-populate_artist_cd.sql
- examples/MusicBase/share/migrations/SQLite/upgrade/2-3/003-alter_cd.sql
- examples/MusicBase/share/migrations/SQLite/upgrade/2-3/004-alter_country.sql
- examples/MusicBase/share/migrations/SQLite/upgrade/2-3/005-new_countries.pl
- examples/MusicBase/share/migrations/SQLite/upgrade/2-3/006-new_artist.pl
- examples/MusicBase/share/migrations/_common/deploy/1/002-demo.pl
- examples/MusicBase/share/migrations/_common/upgrade/1-2/002-insert_countries.pl
- examples/MusicBase/share/migrations/_source/deploy/1/001-auto-__VERSION.yml
- examples/MusicBase/share/migrations/_source/deploy/1/001-auto.yml
- examples/MusicBase/share/migrations/_source/deploy/2/001-auto-__VERSION.yml
- examples/MusicBase/share/migrations/_source/deploy/2/001-auto.yml
- examples/MusicBase/share/migrations/_source/deploy/3/001-auto-__VERSION.yml
- examples/MusicBase/share/migrations/_source/deploy/3/001-auto.yml
- examples/MusicBase/t/more-than-1.t
- examples/MusicBase/t/upgrade-1to2.t
- examples/MusicBase/t/upgrade-2to3.t
- examples/MusicBase/t/use.t
- examples/MusicBase/t/web.t