Changelog#
2023-06-01#
Added#
Add a
--filter-sql-json-path
option to the add command.
Changed#
Change schema prefix from
view_data_
tosummary_
.Upgrade to Python 3.10 and PostgreSQL 15.
2023-05-27#
Added#
KINGFISHER_SUMMARIZE_LOGGING_JSON
environment variabledev hash-md5
command
2021-12-21#
Changed#
The
field_list
column is now a JSONB object in which keys are paths and values are numbers of occurrences (instead ofNULL
).
2021-11-24#
Added#
Add a
--filter
option to the add command.
2021-11-02#
Added#
Add a
relatedprocesses_summary
table.
2021-09-15#
Changed#
Replace the
selected_collections
table in individual schema with aselected_collections
table in thesummaries
schema.
2021-08-10#
Fixed#
Fix support for release types of “embedded_release” and “record”.
2021-07-29#
Changed#
Replace similar tables with templated queries. This does not affect behavior.
2021-07-16#
Added#
Add a
name
column to theparties_summary
,procuringentity_summary
,tenderers_summary
andaward_suppliers_summary
tables.
Changed#
Rename
parties_id
columns to:parties_summary.party_id
buyer_summary.buyer_id
procuringentity_summary.procuringentity_id
tenderers_summary.tenderer_id
Rename document
documentType
counts:documenttype_counts
todocument_documenttype_counts
planning_documenttype_counts
toplanning_document_documenttype_counts
tender_documenttype_counts
totender_document_documenttype_counts
award_documenttype_counts
toaward_document_documenttype_counts
contract_documenttype_counts
tocontract_document_documenttype_counts
contract_implementation_documenttype_counts
tocontract_implementation_document_documenttype_counts
implementation_documenttype_counts
toimplementation_document_documenttype_counts
Rename milestone
type
counts:milestonetype_counts
tomilestone_type_counts
contract_milestonetype_counts
tocontract_milestone_type_counts
contract_implementation_milestonetype_counts
tocontract_implementation_milestone_type_counts
implementation_milestonetype_counts
toimplementation_milestone_type_counts
2021-07-08#
Changed#
Rename
total_documenttype_counts
todocumenttype_counts
.Rename
additionalidentifiers_ids
toadditionalclassifications_ids
on*_items_summary
tables
Fixed#
unique_identifier_attempt
uses party fields instead of deprecated fields.
2021-06-30#
Changed#
Columns are renamed for consistency.
2021-05-21#
Added#
dev stale
command--quiet
option
2021-02-25#
Changed#
Move
docs-table-ref
command underdev
group.add
command:--skip
developer’s option to skip SQL files.
2021-02-01#
Changed#
add
command: Errors if--name
value contains uppercase characters.Fix typo in
contract_implemetation_documenttype_counts
column (missing “n”).
2021-01-06#
Changed#
Remove
install
commandRemove
correct-user-permissions
commandRemove
views
schema, includingviews.read_only_user
andviews.mapping_sheets
tablesRemove
flatten_with_values
SQL function
2020-12-11#
Changed#
The
field_list
column is now a JSONB object in which keys are paths and values areNULL
2020-12-09#
Added#
add
command:--field-lists
option to add afield_list
column to all summary tables. Thefield-list
column is an array of all fields in the data.planning_summary
table: Aplanning
JSONB column for the planning object.contract_implementation_transactions_summary
table: Atransaction
JSONB column for the transaction object.
2020-11-11#
Changed#
Rename
ocdskingfisher-views-cli
tomanage.py
.Rename commands:
list-views
toindex
add-view
toadd
delete-view
toremove
Configure the database connection using a
KINGFISHER_SUMMARIZE_DATABASE_URL
environment variable or.env
file, instead of aKINGFISHER_VIEWS_DB_URI
environment variable orconfig.ini
file.
2020-11-05#
Added#
add-view
command: Add--no-field-counts
option.
Changed#
add-view
command: Remove--threads
option.Remove
refresh-views
command.Remove
field-counts
command.Improve performance.