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' in the spec and set option 'create_from_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.