0.239 2021-08-08 Released-By: PERLANCAR; Urgency: low
- No functional changes.
- [ux] Show more concrete example in Synopsis.
0.238 2021-08-08 Released-By: PERLANCAR; Urgency: low
- No functional changes.
- [doc] In Synopsis, point out where to find more concrete
examples.
0.237 2019-01-13 Released-By: PERLANCAR
- Write spec's summary to meta's schema_summary.
0.236 2018-06-06 Released-By: PERLANCAR
- No functional changes.
- Mention component name in logging statement.
0.235 2018-05-10 Released-By: PERLANCAR
- No functional changes.
- [doc] Forgot to update FAQ on using Log::Any::For::DBI to
Log::ger::DBI::Query.
0.234 2018-05-10 Released-By: PERLANCAR
- No functional changes.
- [dist] Bump dep versions: DBIx::Diff::Schema=0.091,
Test::WithDB=0.100.
0.233 2018-05-09 Released-By: PERLANCAR
- Handle case where meta table already exists but the
schema_version.* row does not exist.
- [doc] Formatting.
0.232 2018-05-09 Released-By: PERLANCAR
- [Bugfix] Fix improper commit introduced in 0.230.
0.231 2018-05-09 Released-By: PERLANCAR; Broken: yes
- UPDATE: this release is broken.
- No functional changes.
- [doc] Fix documentation typos & formatting.
0.230 2018-05-09 Released-By: PERLANCAR; Broken: yes
- UPDATE: this release is broken.
- Introduce component support.
0.22 2017-06-24 Released-By: 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 Released-By: PERLANCAR
- [Bugfix] Fix logic bug, don't test diff when schema is still at
latest_v=1.
0.20 2015-09-06 Released-By: 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 Released-By: PERLANCAR
- No functional changes.
- [doc] Clearer code in example.
0.18 2015-04-29 Released-By: PERLANCAR
- Allow an install/upgrade step to contain coderef, which will be
called with $dbh as argument.
0.17 2015-04-24 Released-By: 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 Released-By: PERLANCAR
- sql_schema_spec_ok(): Test return value from
create_or_update_db_schema().
0.15 2015-04-22 Released-By: PERLANCAR
- Add module: Test::SQL::Schema::Versioned.
- Add test for sanity check.
- Replace Log::Any with Log::Any::IfLOG.
0.14 2015-04-16 Released-By: PERLANCAR
- Add sanity check for when current_v > latest_v.
0.13 2015-01-03 Released-By: PERLANCAR
- No functional changes.
- Rebuild (Generate TODO.md).
0.12 2014-09-12 Released-By: PERLANCAR
- Add dep to Scalar::Util::Numeric (required by autogenerated
validator code by Data::Sah) [CT].
0.11 2014-09-09 Released-By: PERLANCAR
- No functional changes.
- Rename dist from SHARYANTO-SQL-Schema to SQL-Schema-Versioned.
0.10 2014-09-06 Released-By: 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 Released-By: 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 Released-By: SHARYANTO
- No functional changes. Add another FAQ item and mention more prior arts
(sqitch, DBIx::Migration).
0.07 2013-04-12 Released-By: SHARYANTO
- No functional changes. Add a couple of FAQ items.
0.06 2013-04-03 Released-By: SHARYANTO
- No functional changes. Fix incomplete example in Synopsis.
0.05 2013-04-03 Released-By: 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 Released-By: 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 Released-By: 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 Released-By: SHARYANTO
- Add error handling for when upgrade fails.
- Wrap each upgrade within transaction block.
- Test under Postgres.
0.01 2013-02-28 Released-By: SHARYANTO
- First release.