[openstreetmap/openstreetmap-website] Backfill note subscriptions (PR #5304)

[Anton Khorev]

Part two of  #5283.

Creates a subscription for every note commented by a non-anonymous user. Does this by:
- iterating through batches of note comments
- getting distinct non-null (user, note) pairs
- inserting these pairs using `upsert_all`, this skips already existing pairs
You can view, comment on, or merge this pull request online at:

  https://github.com/openstreetmap/openstreetmap-website/pull/5304

-- Commit Summary --

  * Backfill note subscriptions

-- File Changes --

    A db/migrate/20241023004427_backfill_note_subscriptions.rb (14)
    M db/structure.sql (1)

-- Patch Links --

https://github.com/openstreetmap/openstreetmap-website/pull/5304.patch
https://github.com/openstreetmap/openstreetmap-website/pull/5304.diff

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/5304
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/pull/5304 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20241106/0669808b/attachment.htm>