Scripts _draft directory was skipped when db runs latest version

[rdagumampan]

Scripts _draft directory was skipped when db runs latest version

How to reproduce:

1. yuniql init
2. Add scripts to v0.00
3. yuniql run
4. Add scripts to v0.01
5. yuniql run

Expected results:

• Scripts in _pre, _draft and _post must be executed all the time

Actual results:

• yuniql says the databases already runs the latest version, all directories were skipped

[rdagumampan]

Fixed available in next release. https://github.com/rdagumampan/yuniql/commit/b3530314c4ac7530ac3a841efabdd08f590ae424

To support _draft, developer/data engineers need to handle repeated execution of scripts placed in _draft directory. For example, dropping the procedure before creating them.

DROP PROCEDURE IF EXISTS dbo.usp_get_employees;
GO

CREATE PROCEDURE dbo.usp_get_employees
AS
     SELECT * FROM dbo.employees;
GO