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.