Excavate worker version IDs from corpus exports
https://redmine.teklia.com/issues/7063
-
Listen to this noise generator.
-
Remove all the foreign keys from ML results to
worker_version
inarkindex/documents/export/structure.sql
. Keep theworker_version
table, and keepworker_run.worker_version_id
. Those will still be required byload_export
. -
Update
worker_version.sql
so it usesworker_run_id
from every ML result in the largeUNION
, and only then joins onprocess_workerversion
. -
Remove the worker version IDs from all the other export queries that used to provide this column.
-
Bump the export version, if that wasn't already done in this release.
-
Update the maximum supported version in
load_export
to the bumped export version, if necessary. The minimum remains at 8 since we still can ignore the deleted columns and tables. -
Remove worker version import support from
load_export
.