Adapt traits dumping code to recent MV trait schema updates

jar398 / plotter

Utilities for updating an EOL graphdb

Other

1 stars 1 forks source link

Adapt traits dumping code to recent MV trait schema updates #8

Closed jar398 closed 3 years ago

jar398 commented 3 years ago

Find out what the changes are (Dec 2019 to Aug 2020) with
- (cd ../eol_website; git diff e4d4ba69 95b17579 -- doc/trait-schema.md) >schema-diff.tmp
change object_page_id to object_page
new properties: citation, method, remarks, sample_size, name_languagecode, trait_row_count, distinct_page_count ...
object_for_predicate - do not capture?

jhammock commented 3 years ago

indeed, object_for_predicate helps speed up some queries in the search page; it is not needed here.

jar398 commented 3 years ago

Actually I wonder if all the 'denormalized' properties can be omitted, i.e. they don't need columns in the traits dump? Anyone who cares can get the information from the MetaData table in the dump. I'm not sure exactly which properties this applies to. Will have to do some research to verify this hypothesis, but it's possible I don't need to make any changes at all here.

mvitale commented 3 years ago

Of the above properties, trait_row_count, distinct_page_count and object_for_predicate should be omitted. I'm not sure if you want to dump all of the Term name translations -- those are potentially subject to change -- but it's up to you.

jar398 commented 3 years ago

Done as far as I can tell