You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Create a new table charts_x_entities with columns chartId and entityId (both primary keys, both foreign keys, both indexed)
Write a script that runs ~weekly and updates this table, using a simple DELETE FROM charts_x_entities; INSERT INTO ... destroy-and-recreate behavior.
The script instantiates every grapher, downloads its data, looks at grapher.tableForSelection, etc.
Get rid (-> migration) of the config field data.availableEntities and the code writing it; it is only used for Algolia indexing.
Think about handling selectedEntityNames/availableEntityNames for chart types like Marimekko, scatter, slope; where currently selection just highlights entities, but leaves unselected entities visible
The new table charts_x_entities may also be useful for upcoming country pages.
The text was updated successfully, but these errors were encountered:
For #3388, we need a more accurate representation of the
availableEntities
field that is currently part of a chart's config.We want it to
grapher.tableForSelection
EntitySelectionMode
Implementation & progress
In discussion with @danyx23:
charts_x_entities
with columnschartId
andentityId
(both primary keys, both foreign keys, both indexed)DELETE FROM charts_x_entities; INSERT INTO ...
destroy-and-recreate behavior.grapher.tableForSelection
, etc.data.availableEntities
and the code writing it; it is only used for Algolia indexing.selectedEntityNames
/availableEntityNames
for chart types like Marimekko, scatter, slope; where currently selection just highlights entities, but leaves unselected entities visiblecharts_x_entities
may also be useful for upcoming country pages.The text was updated successfully, but these errors were encountered: