0.233 2018-05-09 (PERLANCAR)
- Handle case where meta table already exists but the
schema_version.* row does not exist.
- [doc] Formatting.
0.232 2018-05-09 (PERLANCAR)
- [Bugfix] Fix improper commit introduced in 0.230.
0.231 2018-05-09 (PERLANCAR) (UPDATE: this release is broken)
- No functional changes.
- [doc] Fix documentation typos & formatting.
0.230 2018-05-09 (PERLANCAR) (UPDATE: this release is broken)
- Introduce component support.
0.22 2017-06-24 (PERLANCAR)
- No functional changes.
- [Build] Fix build that tries to load Data::Sah compile-time modules
[RT#122145].
- Switch from Log::Any to Log::ger.
0.21 2017-06-15 (PERLANCAR)
- [Bugfix] Fix logic bug, don't test diff when schema is still at
latest_v=1.
0.20 2015-09-06 (PERLANCAR)
- No functional changes.
- [dist] Move spec prereqs from RuntimeRequires to
DevelopRecommends to reduce deps but still allow indicating spec
requirement.
0.19 2015-04-30 (PERLANCAR)
- No functional changes.
- [doc] Clearer code in example.
0.18 2015-04-29 (PERLANCAR)
- Allow an install/upgrade step to contain coderef, which will be
called with $dbh as argument.
0.17 2015-04-24 (PERLANCAR)
- Test database schemas are equal between one created directly with
latest version's SQL vs upgraded from v1.
- [doc] Fix documentation: twdb argument is required not optional.
0.16 2015-04-22 (PERLANCAR)
- sql_schema_spec_ok(): Test return value from
create_or_update_db_schema().
0.15 2015-04-22 (PERLANCAR)
- Add module: Test::SQL::Schema::Versioned.
- Add test for sanity check.
- Replace Log::Any with Log::Any::IfLOG.
0.14 2015-04-16 (PERLANCAR)
- Add sanity check for when current_v > latest_v.
0.13 2015-01-03 (PERLANCAR)
- No functional changes.
- Rebuild (Generate TODO.md).
0.12 2014-09-12 (PERLANCAR)
- Add dep to Scalar::Util::Numeric (required by autogenerated
validator code by Data::Sah) [CT].
0.11 2014-09-09 (PERLANCAR)
- No functional changes.
- Rename dist from SHARYANTO-SQL-Schema to SQL-Schema-Versioned.
0.10 2014-09-06 (PERLANCAR)
- Allow creating from an earlier version using 'install_v<VERSION>' in
the spec and set option 'create_from_version' => <VERSION> when
calling the function. This is useful for testing database migration.
0.09 2013-09-06 (SHARYANTO)
- Document that 'latest_v' is required in spec. On the other hand, ...
- Provide default for 'latest_v' if not specified in spec.
0.08 2013-04-13 (SHARYANTO)
- No functional changes. Add another FAQ item and mention more prior arts
(sqitch, DBIx::Migration).
0.07 2013-04-12 (SHARYANTO)
- No functional changes. Add a couple of FAQ items.
0.06 2013-04-03 (SHARYANTO)
- No functional changes. Fix incomplete example in Synopsis.
0.05 2013-04-03 (SHARYANTO)
- No functional changes. doc: recommend Postgres, mention how to use the
module in a program/script, mention Database::Migrator in See Also.
0.04 2013-03-14 (SHARYANTO)
[BUG FIXES]
- Put creating 'meta' table inside transaction, so if 'install' phase
fails, the meta table is not created (at least on Postgres which has
transactional DDL).
0.03 2013-03-01 (SHARYANTO)
[INCOMPATIBLE CHANGES]
- Change 'sqls' argument (an array of SQL statement strings) to 'spec'
(a hash of series of SQL statement strings). This is so that we can
have/see 'install' which is the SQL statements for the latest version.
0.02 2013-02-28 (SHARYANTO)
- Add error handling for when upgrade fails.
- Wrap each upgrade within transaction block.
- Test under Postgres.
0.01 2013-02-28 (SHARYANTO)
- First release.