Skip to content

Migration script formatting in CHANGELOG.md for minor versions #171

Description

@JulienLach

Hello,

Formatting the minor version migration scripts in the changelog.md would be greatly appreciated. It would make it easier to read and reduce errors.

Current :

-- 2. Backfill supplier invoices (operation_type_select IN (1, 2)) -- from AccountingSituation of the invoice's partner UPDATE account_invoice inv SET vat_system_select = sit.vat_system_select FROM account_accounting_situation sit WHERE sit.partner = inv.partner AND sit.company = inv.company AND sit.vat_system_select IN (1, 2) AND inv.operation_type_select IN (1, 2) AND inv.status_select IN (1, 2, 3) AND inv.vat_system_select IS NULL;

Excpected :

-- 2. Backfill supplier invoices (operation_type_select IN (1, 2)) -- from AccountingSituation of the invoice's partner

UPDATE account_invoice inv SET vat_system_select = sit.vat_system_select FROM account_accounting_situation sit 
WHERE sit.partner = inv.partner AND sit.company = inv.company AND sit.vat_system_select IN (1, 2) 
AND inv.operation_type_select IN (1, 2) AND inv.status_select IN (1, 2, 3) AND inv.vat_system_select IS NULL;

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions