Skip to content

CHANGELOG.md

Latest commit

 

History

History
374 lines (256 loc) · 36.1 KB

CHANGELOG.md

File metadata and controls

374 lines (256 loc) · 36.1 KB
Raw

📦 Changelog

conventional commits semantic versioning

All notable changes to this project will be documented in this file

1.18.0 (2026-09-03)

🍕 Features

  • added skills proposal (ffea019)
  • remove obsolete restore-db script (a1210f7)

1.17.0 (2026-09-03)

🍕 Features

  • added ai coding assistent skills (916c810)
  • added Github listing script (0eba12f)
  • added placeholder CRs for Glykou et.al. 2021 data (2451251)
  • added placeholder CRs for new dendro submissions (eb7cffd)
  • added restore db script (399e48a)
  • improved copy-table script (b83ee0f)

📝 Documentation

  • enhance clarity and consistency across multiple documentation files (80c9bc8)
  • refine language and clarity in ARCHITECTURE.md (457d52c)

1.16.0 (2026-05-28)

🍕 Features

  • add database dump and restore scripts (aa3aba2)
  • add help option to dump-database script (de4dc73)
  • add proposal template for design proposals (37c5671)
  • implement schema dump script with PostgreSQL DDL generation (33f9a01)

📝 Documentation

  • ai: add scoped repo instructions (1394bda)
  • add system documentation set (0618188)

1.15.2 (2026-04-30)

🐛 Bug Fixes

  • resolve submission command path in hook scripts (f926a75)

1.15.1 (2026-04-02)

🐛 Bug Fixes

  • facet: align analysis_entity_ages overlap with BP ranges (a063e9a)

1.15.0 (2026-03-27)

🍕 Features

  • update method descriptions and abbreviations in tbl_methods based on input from Johan Linderholm (9609e68)

1.14.1 (2026-02-12)

🐛 Bug Fixes

  • update comments and formatting in property value tables SQL script (241e1ca)

1.14.0 (2026-02-12)

🍕 Features

  • add new tables for storing generic key-value properties (#412) (86d426a)

1.13.2 (2026-02-12)

🐛 Bug Fixes

  • correct SQL file references in SEAD_MODEL_COMMENTS and COUNTRY_CODES scripts (8a4b71c)

1.13.1 (2026-02-11)

🐛 Bug Fixes

  • disable password (assume .pgpass) (d292d8a)
  • moved load of comments away from SEAD model (#441) (b1d92be)

1.13.0 (2026-02-10)

🍕 Features

  • add February 2026 release entries to sqitch plans across multiple projects (3536770)

🐛 Bug Fixes

  • correct command execution in tag_projects function and ensure strict error handling (6e5a87c)

1.12.0 (2026-02-10)

🍕 Features

  • add country codes to utility table (e6d1cca)
  • add utility functions for singularization and entity name conversion, and create full-text search materialized view (5c5b2de)

1.11.0 (2026-02-10)

🍕 Features

  • add project review document for SEAD Change Control System (16eb89f)
  • add script to update repository topics with a specified topic (f224f61)
  • add SQLFluff configuration for consistent SQL formatting (b20658a)
  • iniial commit for radiocarbon pilot data (59194bd)

1.10.0 (2026-02-01)

🍕 Features

  • add aDNA accession link deployment scripts (#395) (35030dc)
  • enhance aDNA accession link script with distinct selection (c37b855)

1.9.0 (2026-02-01)

🍕 Features

  • implement post-deploy hook for ancient DNA method and dataset updates (43e60fd)

1.8.0 (2026-02-01)

🍕 Features

  • add dataset and method files for ancient DNA analysis (e729851)
  • add post-deploy hook for ancient DNA dataset insertion (3479f47)
  • add two separate methods for aDNA data (#366) (3f5def4)

1.7.0 (2026-01-20)

🍕 Features

  • add AI agent guidelines for SEAD Change Control System (9327005)
  • add comprehensive release notes for December 2023 major release (d396a09)

1.6.0 (2026-01-20)

🍕 Features

  • add AI assistant instructions for SEAD Change Control System (f1b987b)

🐛 Bug Fixes

  • clean up psql.sh formatting and improve command echoing (9582a3f)
  • remove 'docs' entry from .gitignore and ensure proper newline at end of file (3525449)

1.5.0 (2025-11-20)

🍕 Features

  • add DDL for site types including tables and initial data (82001c7)
  • add script to generate SQL comment statements from CSV (a266049)

🐛 Bug Fixes

  • correct casing of 'Evaluation_date' to 'evaluation_date' in site preservation status table (#217) (2e3ed23)
  • correct environment variable loading and improve argument handling in psql script (cbc7e0c)
  • remove duplicate issue reference in analysis ages facet description (2a73122)

🧑‍💻 Code Refactoring

  • enhance fn_table_columns function to include additional metadata and improve view definition (2482975)
  • remove default values for source_filename and target_folder in export_excel_sheets function (99dc133)
  • simplify patch-cr script by using utility script (4a92f45)
  • streamline sync-comments script and improve usage instructions (53c8198)

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)

1.4.3 (2025-05-14)

🐛 Bug Fixes

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

1.4.2 (2025-05-14)

🐛 Bug Fixes

1.4.1 (2025-05-09)

🐛 Bug Fixes

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)

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)

1.2.2 (2025-04-22)

🐛 Bug Fixes

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

1.2.1 (2025-04-22)

🧑‍💻 Code Refactoring

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

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)

(2025-04-19)

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)

25.0.0 (2025-04-15)

Features

  • add sync-comments script setup/sync procedures for comments (22860e4)
  • add function to release allocated system IDs (b42ba76)
  • add geonames import script for database integration (bf3e8cb)
  • add index on geonames name column for improved query performance (f69c9fb)
  • add initial .tbls.yml configuration for database schema documentation (3d0d0e2)
  • add ls-cr script for listing change requests with various options (d5ceecf)
  • add overide of schemaspy main.html (79e9f96)
  • add patch-cr script for applying change requests to the database (7bf9772)
  • add pgsql wrapper script isql (b56b2ca)
  • add qualifier_id column to tbl_sample_dimensions (#356) (7f526c6)
  • add resolve function for submission name and update copy script generation (#367) (0480408)
  • add script for generating documentation using SchemaSpy with PostgreSQL support (0b35665)
  • add support for generating only SQL scripts in dump_submission function (0023ec1)
  • add sync-comments script for extracting and uploading comments from Excel to database (29e6ead)
  • add update-adna-cr script for managing ADNA submissions and database updates (ca021fa)
  • Add utility for storing and restoring view definitions (#324) (6234f94)
  • add UUID column to value types for improved data integrity (f9241a0)
  • add UUID columns to value qualifier and type tables, update clearinghouse system (ce16c8b)
  • backported 20241023_ALLOCATE_SYSTEM_IDS to 20190401_DDL_UTILITY_SCHEMA (96ab722)
  • create view for encoded dendro analysis values with enhanced data processing (61d61db)
  • enhance analysis value handling with new flags and improved data processing (8bfe557)
  • enhance analysis value processing with additional felling year estimations and uncertainty handling (c219870)
  • enhance analysis value processing with additional qualifiers and improved uncertainty handling (d2fdd77)
  • enhance dump-database script with additional options and improved usage instructions (72229f7)
  • enhance encoded dendro analysis values view with improved value handling and qualifiers (4a26fd5)
  • improve analysis value processing with case-insensitive qualifiers and uncertainty indicators (5ddf906)
  • improved deployment script (aebd6a5)
  • Increase size of descriptive field in dimensions (#323) (861d149)
  • release allocated IDs and update value types in new dendro lookups (ce5cc26)
  • update documentation layout by removing unnecessary columns and adding a new columns page (937bd3d)
  • update encoded dendro analysis values view with enhanced qualifiers and range handling (de4f51c)

Bug Fixes

  • 20240924_DDL_MEASURED_VALUES_REFACTOR create table using clearinghouse_worker role (#319) (d8ce710)
  • add cascade option to sead_utility.drop_view and sead_utility.drop_table procedures for improved flexibility (c3590c1)
  • add missing semicolon in DML scripts for geochronology and sample group facets (36107fc)
  • add source_name column to clearinghouse_submissions import in copy_in.sql (5c13fa0)
  • change client_min_messages setting to error for stricter error handling (b843ebf)
  • change perform to call for clearing_house_commit in generate_data function (c1caa21)
  • correct comment syntax in comments.sql for site_location_accuracy column (62450cd)
  • correct error message output and enhance colorize function for better usability (3a8691f)
  • correct folder existence check in commit-submission script (0b9f6de)
  • correct folder existence check in post-deploy hook script (c060568)
  • correct indentation in deploy script output (36496f5)
  • correct join condition in DML_NEW_DENDRO_LOOKUPS.sql (c40c550)
  • correct sort expression in DML facets SQL script (105dcd9)
  • correct syntax error (ab06208)
  • correct syntax for dropping table in SQL script (3e9b1d5)
  • correct usage message for compress option and remove commented-out SQL queries (e2ea119)
  • enhance view drop logic in 20220923_DDL_DEPRECATE_CHRON_CONTROLS.sql to prevent errors when views do not exist (0104b7b)
  • fix use of --force and source/target db in copy-database script (6501e64)
  • fixed script (#317) (1f9cb8f)
  • fixed typo (d5e0282)
  • fixed typo in variable names (dfbbf16)
  • handle empty deployment status in deploy-staging script (4b663b0)
  • improve error handling for unspecified target database in isql script (bbb6374)
  • improve error handling in restore_submission function (4e2c24f)
  • made idempotent (#144) (84c5501)
  • remove hash symbol from note URL in add-change-request script (7661886)
  • remove redundant integer type check in analysis value processing (204d722)
  • remove trailing comma in clearing_house_commit procedure parameters (aa7545c)
  • remove trailing comma in tbl_chronologies table definition (70031bc)
  • remove trailing commas in SQL update statements for tbl_methods (cebc8f9)
  • removed constraint (#168, cdc9aa3cfc9189cf8eb88141991be80615af14b4) (cdee3a7)
  • rename function for better clarity in utility script (52fa60b)
  • reorder projects in deployment list for correct sequence (9324086)
  • replace drop statements with sead_utility calls for consistency and improved error handling (bdf7233)
  • replace drop table statement with sead_utility.drop_table call for consistency (9f8d7b0)
  • replace drop table statement with sead_utility.drop_table call for consistency (46e574e)
  • replace drop view statements with sead_utility.drop_view calls for consistency and error handling (8b216e9)
  • Resolves #349 [deploy-staging} Mutual exclusion check of use of options fail (844d017)
  • Resolves #352 (6ea6b5b)
  • simplify post-deploy-hook argument handling (51203cb)
  • streamline reset-adna script (5de54b4)
  • update analysis value processing to use stripped values and enhance felling year estimations (d7c882d)
  • update clearing_house_commit call, add missing parameter (433485f)
  • update copy commands to include site_location_accuracy column in SQL scripts (bf22564)
  • update database port from 5432 to 5433 (e4835fd)
  • update drop_database function to specify postgres for execution (720057c)
  • update function name for clarity in Clearinghouse Transport System SQL (a3d45d5)
  • update reset-adna script to include additional patch commands (dbfe329)
  • update root folder resolution and add warning for missing data folder in commit-submission script (053202e)
  • update view drop logic in 20221121_DML_QSE_DENDRO_DATING.sql to prevent breaking changes (18d0601)