CHANGELOG

2.0.0 (2018-11-28)

  • Removed the sequence created by the document. Replaced it by a simple counter on latest document

Note

You can use this script before migration to update the database:

CREATE FUNCTION update_attachment() RETURNS void AS $$
    DECLARE
        -- declarations
        target RECORD;
    BEGIN
        FOR target IN select uuid, version from attachment_document where version_number is null LOOP
            UPDATE attachment_document SET version_number = CAST(substring(target.version from '..$') as Integer) WHERE uuid = target.uuid AND version = target.version;
        END LOOP;
    END;
$$ LANGUAGE plpgsql;

CREATE FUNCTION update_sequence() RETURNS void AS $$
    DECLARE
        -- declarations
        seq RECORD;
    BEGIN
        FOR seq IN select id, seq_name from system_sequence where code ilike 'Attachment.Document#%' LOOP
            EXECUTE 'DROP SEQUENCE ' || quote_ident(seq.seq_name);
            DELETE FROM system_sequence where id = seq.id;
        END LOOP;
    END;
$$ LANGUAGE plpgsql;

ALTER TABLE attachment_document DROP CONSTRAINT anyblok_pk_attachment_document;
ALTER TABLE attachment_document ADD COLUMN version_number INTEGER;
select update_attachment();
select update_sequence();
ALTER TABLE attachment_document ADD PRIMARY KEY (uuid, version_number);
UPDATE system_blok SET installed_version = '2.0.0' WHERE name = 'attachment';
DROP FUNCTION update_attachment();
DROP FUNCTION update_sequence();

1.2.0 (2018-09-14)

  • Allow to get another field to represent the file
  • PR #4: Added a column name on the template to identify them easyly (@GohuHQ)
  • PR #3: Fixed option name for wkhtmltopdf (@GohuHQ)

1.1.1 (2018-06-05)

  • Fix the mixins come from anyblok_mixins

1.1.0 (2018-05-16)

  • [ADD] add Mixin Mixin.LatestDocument and Mixin.VersionedDocument to help the developer to get latest_document or versioned_document

1.0.2 (2018-02-24)

  • [REF] Anyblok 0.17.0 changed setter to add application and application groups, So I had to adapt the existing to use new setter

1.0.1 (2018-01-11)

  • [FIX] Mixin.WkHtml2Pdf check also if the configuration changed for Template.check_if_file_must_be_generated

1.0.0 (2018-01-10)

  • [ADD] attachment blok: stock versionned file
  • [ADD] report blok: create versionned file from template
  • [ADD] report-format blok: template type
  • [ADD] wkhtml2pdf blok: convert html to pdf in the template