Changelog

PFUPipelineTools 0.1.13 (2025-05-15)

• pl_upsert() gains new arguments round_double_columns and digits and calls round_double_cols() if requested.
• round_double_cols() rounds double-precision columns in a data frame to assist the compress() function in the database.
• pl_upsert() gains new argument compress, which defaults to FALSE. If set to TRUE, compress_rows() is called internally within pl_upsert().
• New functions install_compress_function(), remove_compress_function(), and compress_rows() assist with compressing rows in the remote database.
• pl_filter_collect() gains new argument ... in which filtering expressions can be placed. ... replaces the myriad other arguments that provided filtering for possible columns. This is a breaking change, but the new approach provides significant flexibility for users of this function. Plus, the code is much cleaner inside pl_filter_collect()!
• In several places, code no longer passes conn when both schema and fk_parent_tables are known.
• Added a safety check in pl_destroy() to disable destroying “MexerDB”.
• pl_collect_from_hash() and pl_filter_collect() gain new argument version_string that provides capability to filter downloads by version. The default value (NULL) downloads all versions. Multiple versions can be downloaded by passing a vector of strings. Supplying c() (an empty vector) downloads a table with no rows.
• pl_collect_from_hash() is now more convenient with default arguments for schema and fk_parent_tables that pull values from conn. This new behavior for pl_collect_from_hash() is now consistent with pl_filter_collect().
• New tests for new features.
  • Now up to 233 tests, all passing
  • Test coverage now reported to be 25.27%, but that’s an undercount. Many (most?) functions are not tested on continuous integration platforms and CRAN.

PFUPipelineTools 0.1.12 (2024-12-09)

• Improved defaults for arguments to pl_filter_collect().
• No new tests.
  • Still at 143 tests, all passing
  • Test coverage now reported to be 27.37%

PFUPipelineTools 0.1.11 (2024-12-09)

• Updates to many accessing functions for the database.
• Added several new tests for new accessing functions.
  • Now up to 143 tests, all passing
  • Test coverage now at 92.73%

PFUPipelineTools 0.1.10 (2024-08-01)

• Eliminated the IEAMW column everywhere. The Dataset column is now doing the work of the IEAMW column.

PFUPipelineTools 0.1.9 (2024-07-30)

• Added new “date” option for foreign key columns.
• Now using “value” column instead of “x”.
• Now allowing foreign key tables to contain more than only the ID column and the foreign key column. This is particularly useful for, e.g., the energy type table: EnergyTypeID EnergyType FullName Description 1 E Energy Energy is a thermal quantification of energy. 2 X Exergy Exergy is a work quantification of energy.
• New functions for interacting with databases, including
  • pl_filter_collect()
  • load_schema_table()
  • load_fk_tables()
  • schema_dm()
  • pl_upload_schema_and_simple_tables()
  • set_not_null_constraints_on_fk_cols()
  • pl_upsert()
  • encode_fks()
  • decode_fks()
  • encode_fk_values()
  • encode_fk_keys()
• Removed stash_cache() and associated tests. We no longer save the pipeline cache. It seemed like a good idea at the time, but we never looked at saved caches.
• New function self_name() is helpful in many places.
• Several new functions to assist with database schema, etc.

PFUPipelineTools 0.1.8 (2023-12-21)

• Added a statement of need to README.Rmd.
• No new tests
  • Still at 24 tests, all passing.
  • Test coverage remains at 100%.

PFUPipelineTools 0.1.7 (2023-12-08)

• Added package dependencies for test coverage workflow.
• No new tests
  • Still at 24 tests, all passing.
  • Test coverage remains at 100%.

PFUPipelineTools 0.1.6 (2023-12-04)

• Add the package dependencies to the code coverage GitHub action.
• No new tests
  • Still at 24 tests, all passing.
  • Test coverage remains at 100%.

PFUPipelineTools 0.1.5 (2023-12-04)

• Add the develop and release-* branches to GitHub actions for R-CMD-CHECK.
• No new tests
  • Still at 24 tests, all passing.
  • Test coverage remains at 100%.

PFUPipelineTools 0.1.4 (2023-12-03)

• Attempting to fix a bug in the continuous integration process. Builds are failing due to missing external dependencies.
• No new tests
  • Still at 24 tests, all passing.
  • Test coverage remains at 100%.

PFUPipelineTools 0.1.3 (2023-12-03)

• New function read_pin_version()
• Added GitHub actions for generating website.
• Beginning code coverage support.
• No new tests
  • Still at 24 tests, all passing.
  • Test coverage remains at 100%.

PFUPipelineTools 0.1.2 (2023-08-08)

• First release to be assigned a Zenodo DOI.
• Added several new tests to get to 100% coverage.

PFUPipelineTools 0.1.1 (2023-06-06)

• Initial release
• Added a NEWS.md file to track changes to the package.
• Added first tests.
  • Only 2 tests, both passing.
  • Test coverage is low (17 %) but will improve.