v1.4.4

1.4.4 (2025-05-18)

🐛 Bug Fixes

• deployed changes in clearinghouse commit system related to explicit columns (928b57a)
• fixes SQL syntax error (#371) (51ad21c)
• move create extension postgis above change roll (resolves #370) (982203b)
• resolves #379 (d3c87d7)
• update database URIs for staging and production targets (b3e3cdf)
• use explicit cplumns in import (Wrong site location accuracy (#378) (0868162)

🧑‍💻 Code Refactoring

• renamed function dbexec to execute_sql (cb7944b)

v1.4.3

1.4.3 (2025-05-14)

🐛 Bug Fixes

• install postgis when deploying from scratch (#375) (4c084bd)

v1.4.2

1.4.2 (2025-05-14)

🐛 Bug Fixes

• temporary patch added for (#374) (0d95a26)

v1.4.1

1.4.1 (2025-05-09)

🐛 Bug Fixes

• resolves #374 (constructions facet) (9ad8241)

v1.4.0

1.4.0 (2025-04-24)

🍕 Features

• add check for existence before deleting from facet_children table (57582a7)
• add dump-table-data script for exporting table data to CSV files (170b5b6)
• add on delete cascade to FK in analysis tables (resolved #371) (7f5659b)
• add qualifier_id column to tbl_sample_[group_]dimensions (resolves #334) (9f15b46)
• create view for typed analysis values to enhance data retrieval (c3be82f)

🐛 Bug Fixes

• correct issue link formatting in sqitch.plan (d518310)
• removed newline in record type name (3e1e7ad)
• update gzip command in export-database script to use '-n' flag for better compatibility (d64802f)

🧑‍💻 Code Refactoring

• replace typed_analysis_values view with a CTE (46da430)

v1.3.0

1.3.0 (2025-04-22)

🍕 Features

• add domain facet for aDNA (resolves #369) (f68af4e)
• add old tables and columns spreadsheet (6b8612b)

🐛 Bug Fixes

• improved logic when updating existing facet (f7de5e9)

v1.2.2

1.2.2 (2025-04-22)

🐛 Bug Fixes

• update category_id_operator to use '&&' for facet type analysis_entity_ages (684081a)

v1.2.1

1.2.1 (2025-04-22)

🧑‍💻 Code Refactoring

• removed fix that submission's id when restored (cb85475)

v1.2.0

1.2.0 (2025-04-22)

🍕 Features

• add transport system check before generating change request (e032154)
• parameterize id assignment when loading dumped submissions (429da7c)
• update semantic-release and plugins to specific versions for consistency (e36a45d)

🐛 Bug Fixes

• add call to refactoresd reset_public_sequence_ids in deployment scripts (fc208f1)
• add missing tbl_clearinghouse_submissions to list in dump_submission function (8da76cb)
• deployed transport system (1b957af)
• enhance usage messages (7dff5ba)
• improve log file naming (ffd6958)
• improve log message for new submission ID in dump_submission function (bb5794f)
• rename dump-submission to submission (e323eec)
• replace perform with call for reset_public_sequence_ids in multiple deployment scripts (5a84b8c)
• update faulty arguments in UDF call (6728b65)
• update source database name and improve script structure in reset-adna (8ab4bfd)
• update table exclusion condition in dump_submission function (e9b1c2f)

📝 Documentation

• add detailed documentation for commit-submission script (f78487c)

🧑‍💻 Code Refactoring

• replace hardcoded table list with dynamic retrieval in dump_submission function (443db08)

v1.1.0

1.1.0 (2025-04-19)

🍕 Features

• add January 2025 release entry to sqitch plan (b93673c)
• add release workflow and configuration for semantic-release (fe3ed4e)
• enhance release workflow with semantic-release plugins and configuration (240eab4)
• update release workflow with Node.js 20 and actions/checkout@v4 (000fb04)