How to update sample_name column in samples table?

[khoroshevskyi]

In pephub 0.11.0 we introduced new column sample_name in samples table, to get, update, and delete sample without initialization of full project. We need to update this column, using actual sample names. how to do it?

[khoroshevskyi]

Execute this command:

UPDATE samples SET sample_name = sample->>'sample_name';

[khoroshevskyi]

It is challenging to update a table with millions of rows efficiently. To address this, we need to perform batch updates.
To do so, we can use the next code:

UPDATE
    samples
SET
    sample_name = sample->>'sample_name'
WHERE
    id IN ( SELECT id FROM samples where sample_name IS NULL LIMIT 10000)