[wp-meta] [Making WordPress.org] #2720: Sync WordCamp and Meetup.com event changes

[Making WordPress.org]

#2720: Sync WordCamp and Meetup.com event changes
----------------------------------------+-----------------------
 Reporter:  iandunn                     |       Owner:
     Type:  defect                      |      Status:  assigned
 Priority:  normal                      |   Milestone:
Component:  Make (Get Involved) / P2    |  Resolution:
 Keywords:  needs-patch good-first-bug  |
----------------------------------------+-----------------------

Comment (by iandunn):

 According to #3027, meetup.com will change the `source_id` when events are
 edited :|

 One potential way to deal with this would be to add a cron job that
 queries meetup.com and wordcamp.org for all the upcoming events in the
 database, and then sync's their details.

 Another way would be to add a multi-column unique key constraint to the
 database table. That would prevent duplicates from being inserted. We
 could detect if the `INSERT` failed for that reason, and then attempt an
 `UPDATE` instead.

 This is closely related to #3027 and #3321, so I think we should take
 those into account when considering solutions. There may be an elegant
 solution which solves all of those cases; whereas coming up with 3
 independent solutions could get messy.

--
Ticket URL: <https://meta.trac.wordpress.org/ticket/2720#comment:6>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org