[wp-meta] [Making WordPress.org] #3027: Events API: Two meetups returned for same date in same city

[Making WordPress.org]

#3027: Events API: Two meetups returned for same date in same city
--------------------+-----------------
 Reporter:  dd32    |      Owner:
     Type:  defect  |     Status:  new
 Priority:  normal  |  Milestone:
Component:  API     |   Keywords:
--------------------+-----------------
 The Adelaide meetup group is seeing some odd results in the events API:

 http://api.wordpress.org/events/1.0/?location=Adelaide,%20SA
 https://www.dropbox.com/s/sdvqegjdm7lb6tq/Screenshot%202017-08-07%2011.42.30.png?dl=0

 They use a monthly-repeating meetup, entitled `WordPress Adelaide Monthly
 Meetup`, and then edit the title to be `WordPress Adelaide August Meetup`.

 Looking in the database, theres two `source_id`'s: `zdxnhlywlblb` &
 `hfllbnywlblb` - it looks like when they edit the meetup out of the series
 it creates a new meetup, and the WordPress.org ingester fails to realise
 it already had that in the DB (because the source_id changed, but the URL
 stayed the same)

 Looking at the database, it looks like this has happened in a few other
 locations as well. Perhaps we should consider keying it unique by `type,
 url` in addition to `type, source_id`.

--
Ticket URL: <https://meta.trac.wordpress.org/ticket/3027>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org