[openstreetmap/openstreetmap-website] Backfill enhanced changeset stats (PR #6347)

[mmd]

@mmd-osm commented on this pull request.



> +      # Find changeset ids to be updated
+      ids_sql = <<~SQL.squish
+        SELECT id
+        FROM changesets
+        WHERE id BETWEEN #{start_id} AND #{end_id}
+          AND (
+            COALESCE(num_created_nodes, 0) +
+            COALESCE(num_modified_nodes, 0) +
+            COALESCE(num_deleted_nodes, 0) +
+            COALESCE(num_created_ways, 0) +
+            COALESCE(num_modified_ways, 0) +
+            COALESCE(num_deleted_ways, 0) +
+            COALESCE(num_created_relations, 0) +
+            COALESCE(num_modified_relations, 0) +
+            COALESCE(num_deleted_relations, 0)
+          ) IS DISTINCT FROM num_changes

fixed

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

Message ID: <openstreetmap/openstreetmap-website/pull/6347/review/3148357360 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20250823/4729531e/attachment-0001.htm>