v0.1.9

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.