Skip to content
  • Maintainer
  • Developer

    I've modified step 2 to insert records for tables which do not have the verifications fields. Example:

    exec INSERT INTO upload_states (
      upload_id, 
      verification_state, 
      verification_started_at,
      verification_retry_at, 
      verification_retry_count, 
      verification_checksum,
      verification_failure, 
      verified_at
    )
    SELECT 
      id,
      2,
      NOW(),
      Null,
      0,
      'abc',
      Null,
      NOW()
    FROM uploads
    LIMIT 5000

    ⬆️ inserts 5000 "succeeded" records. An offset could probably be used to insert a further 5000 "failed" records if needed 😊

    Edited by Chloe Fons
0% Loading or .
You are about to add 0 people to the discussion. Proceed with caution.
Please register or to comment