Finish the migration of BATCH_EFFECT/BATCH_EFFECT_STATISTICS split

arteymix commented 10 months ago

In b19444a02ed9779b27eaee4f98b8ce5f21430b52, I've introduced a new enumerated type for the batch effect and a new field for storing summary statistics that describe the batch effect.

The only missing part are two database migrations:

the BATCH_EFFECT column has to be migrated to VARCHAR(255)
existing batch effects starting with "This dataset may have a batch artifact" must be migrated to the new BATCH_EFFECT_STATISTICS field and BATCH_EFFECT_FAILURE has to be used as a value

This is described in the db.1.31.0.sql file.

arteymix commented 1 month ago

The database has been migrated. We can backport that commit if necessary.

arteymix commented 1 month ago

I'm reopening this so that we can backport the commit in the next patch release.

PavlidisLab / Gemma

Finish the migration of BATCH_EFFECT/BATCH_EFFECT_STATISTICS split #894