Skip to content

Instantly share code, notes, and snippets.

@aeaia
Last active July 2, 2019 12:01
Show Gist options
  • Select an option

  • Save aeaia/7e30918aaacf42a36d0d945a4b458185 to your computer and use it in GitHub Desktop.

Select an option

Save aeaia/7e30918aaacf42a36d0d945a4b458185 to your computer and use it in GitHub Desktop.
8 canonical places affected by the rake to create place suggestions from recreatiton.goc coordinate pairs had a master source place that existed before the rake and potentially were overwritten. These are the diffs. Because of the bug/uninformed use of the suggestions tool, none of these was actually overwritten.
irb(main):001:0> Place.find(66539011).diffs
Place Load (1.8ms) SELECT "places".* FROM "places" WHERE "places"."enabled" = 't' AND "places"."id" = 66539011 LIMIT 1
Diff Load (4.8ms) SELECT "diffs".* FROM "diffs" WHERE "diffs"."diffable_id" = 66539011 AND "diffs"."diffable_type" = 'Place'
=> #<ActiveRecord::Associations::CollectionProxy [
#<Diff id: 3921064, diffable_id: 66539011, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"id"=>[nil, 48405877], "loc"=>[nil, "POINT (-109.48819 38.64933)"], "city"=>[nil, "Moab"], "state"=>[nil, "UT"], "country"=>[nil, "USA"], "address1"=>[nil, "Moab Field Office"], "address2"=>[nil, "82 East Dogwood"], "place_id"=>[nil, 66539011], "postal_code"=>[nil, "84532"]}], "deleted"=>[]}}, created_at: "2019-06-24 13:28:25", updated_at: "2019-06-24 13:28:25", organization_id: 1000, action: "U", app_key_id: nil>,
#<Diff id: 3918026, diffable_id: 66539011, diffable_type: "Place", details: {"details"=>{"wifi"=>[nil, false], "chain"=>[nil, false], "accessible"=>[nil, true], "credit_cards"=>[nil, false], "private_property"=>[nil, false]}, "locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405188, "city"=>nil, "state"=>"UT", "country"=>"USA", "address1"=>"Upper Big Bend", "latitude"=>38.649916360520905, "longitude"=>-109.4864886704214, "postal_code"=>nil}]}}, created_at: "2019-06-10 13:56:28", updated_at: "2019-06-10 13:56:28", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3918024, diffable_id: 66539011, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"loc"=>["POINT (-109.48087790412015 38.64938756319265)", "POINT (-109.4864886704214 38.649916360520905)"]}], "deleted"=>[]}}, created_at: "2019-06-10 13:56:12", updated_at: "2019-06-10 13:56:12", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3918023, diffable_id: 66539011, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"loc"=>["POINT (-109.481 38.64758)", "POINT (-109.48087790412015 38.64938756319265)"], "timezone_id"=>[105, nil]}], "deleted"=>[]}}, created_at: "2019-06-10 13:52:07", updated_at: "2019-06-10 13:52:07", organization_id: 1000, action: "U", app_key_id: 83>]>
irb(main):002:0> Place.find(66539027).diffs
Place Load (1.2ms) SELECT "places".* FROM "places" WHERE "places"."enabled" = 't' AND "places"."id" = 66539027 LIMIT 1
Diff Load (2.3ms) SELECT "diffs".* FROM "diffs" WHERE "diffs"."diffable_id" = 66539027 AND "diffs"."diffable_type" = 'Place'
=> #<ActiveRecord::Associations::CollectionProxy [
#<Diff id: 3921059, diffable_id: 66539027, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"id"=>[nil, 48405868], "loc"=>[nil, "POINT (-109.6046 38.538)"], "city"=>[nil, "Moab"], "state"=>[nil, "UT"], "country"=>[nil, "USA"], "address1"=>[nil, "Moab Field Office"], "address2"=>[nil, "82 East Dogwood"], "place_id"=>[nil, 66539027], "postal_code"=>[nil, "84532"]}], "deleted"=>[]}}, created_at: "2019-06-24 13:28:23", updated_at: "2019-06-24 13:28:23", organization_id: 1000, action: "U", app_key_id: nil>,
#<Diff id: 3918035, diffable_id: 66539027, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"loc"=>["POINT (-109.60378508474302 38.538540095446166)", "POINT (-109.60365725466421 38.538437255248624)"], "timezone_id"=>[105, nil]}], "deleted"=>[]}}, created_at: "2019-06-10 14:03:11", updated_at: "2019-06-10 14:03:11", organization_id: 1000, action: "U", app_key_id: 83>]>
irb(main):003:0> Place.find(66540437).diffs
Place Load (1.2ms) SELECT "places".* FROM "places" WHERE "places"."enabled" = 't' AND "places"."id" = 66540437 LIMIT 1
Diff Load (5.3ms) SELECT "diffs".* FROM "diffs" WHERE "diffs"."diffable_id" = 66540437 AND "diffs"."diffable_type" = 'Place'
=> #<ActiveRecord::Associations::CollectionProxy [
#<Diff id: 3922505, diffable_id: 66540437, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"id"=>[nil, 48408765], "loc"=>[nil, "POINT (-108.22527 32.91425)"], "city"=>[nil, ""], "state"=>[nil, "NM"], "country"=>[nil, "USA"], "address1"=>[nil, ""], "address2"=>[nil, ""], "place_id"=>[nil, 66540437], "postal_code"=>[nil, ""]}], "deleted"=>[]}}, created_at: "2019-06-24 13:36:56", updated_at: "2019-06-24 13:36:56", organization_id: 1000, action: "U", app_key_id: nil>,
#<Diff id: 3918383, diffable_id: 66540437, diffable_type: "Place", details: {"locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405249, "city"=>nil, "state"=>"New Mexico", "country"=>nil, "address1"=>"State Highway 15", "latitude"=>32.91425129592285, "longitude"=>-108.2240895849351, "postal_code"=>"USA"}]}, "campground_details"=>{"laundry"=>[nil, false], "propane"=>[nil, false], "showers"=>[nil, false], "big_rigs"=>[nil, false], "firewood"=>[nil, false], "fifty_amp"=>[nil, false], "full_hookup"=>[nil, false], "paved_sites"=>[nil, false], "sites_count"=>[9, 12], "dump_station"=>[nil, false], "pull_through"=>[nil, false], "sewer_hookup"=>[nil, false], "swimming_pool"=>[nil, false], "rec_facilities"=>[nil, false]}}, created_at: "2019-06-11 12:15:53", updated_at: "2019-06-11 12:15:53", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3918382, diffable_id: 66540437, diffable_type: "Place", details: {"locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405249, "city"=>nil, "state"=>"New Mexico", "country"=>nil, "address1"=>"State Highway 15", "latitude"=>32.91425129592285, "longitude"=>-108.2240895849351, "postal_code"=>"USA"}]}, "parking_details"=>{"id"=>[nil, 16114124], "rv"=>[nil, true], "lot"=>[nil, true], "free"=>[nil, true], "place_id"=>[nil, 66540437]}}, created_at: "2019-06-11 12:15:18", updated_at: "2019-06-11 12:15:18", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3918381, diffable_id: 66540437, diffable_type: "Place", details: {"details"=>{"price_rating"=>[nil, 0]}, "locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405249, "city"=>nil, "state"=>"New Mexico", "country"=>nil, "address1"=>"State Highway 15", "latitude"=>32.91425129592285, "longitude"=>-108.2240895849351, "postal_code"=>"USA"}]}}, created_at: "2019-06-11 12:15:12", updated_at: "2019-06-11 12:15:12", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3918380, diffable_id: 66540437, diffable_type: "Place", details: {"details"=>{"wifi"=>[nil, false], "chain"=>[nil, false], "accessible"=>[nil, false], "credit_cards"=>[nil, false], "private_property"=>[nil, false]}, "locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405249, "city"=>nil, "state"=>"New Mexico", "country"=>nil, "address1"=>"State Highway 15", "latitude"=>32.91425129592285, "longitude"=>-108.2240895849351, "postal_code"=>"USA"}]}}, created_at: "2019-06-11 12:15:08", updated_at: "2019-06-11 12:15:08", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3918378, diffable_id: 66540437, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"state"=>[nil, "New Mexico"], "address1"=>[nil, "State Highway 15"], "postal_code"=>[nil, "USA"], "timezone_id"=>[105, nil]}], "deleted"=>[]}}, created_at: "2019-06-11 12:14:04", updated_at: "2019-06-11 12:14:04", organization_id: 1000, action: "U", app_key_id: 83>]>
irb(main):004:0> Place.find(66529362).diffs
Place Load (1.2ms) SELECT "places".* FROM "places" WHERE "places"."enabled" = 't' AND "places"."id" = 66529362 LIMIT 1
Diff Load (3.8ms) SELECT "diffs".* FROM "diffs" WHERE "diffs"."diffable_id" = 66529362 AND "diffs"."diffable_type" = 'Place'
=> #<ActiveRecord::Associations::CollectionProxy [
#<Diff id: 3922007, diffable_id: 66529362, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"id"=>[nil, 48407766], "loc"=>[nil, "POINT (-90.9830556 36.9625)"], "city"=>[nil, "VAN BUREN"], "state"=>[nil, "MO"], "country"=>[nil, "USA"], "address1"=>[nil, "PO BOX 490"], "address2"=>[nil, ""], "place_id"=>[nil, 66529362], "postal_code"=>[nil, "63965"]}], "deleted"=>[]}}, created_at: "2019-06-24 13:33:56", updated_at: "2019-06-24 13:33:56", organization_id: 1000, action: "U", app_key_id: nil>,
#<Diff id: 3880805, diffable_id: 66529362, diffable_type: "Place", details: {"locations"=>{"changes"=>[], "deleted"=>[{"id"=>48404956, "city"=>"Van Buren", "state"=>"MO", "country"=>"United States", "address1"=>nil, "latitude"=>36.952225, "timezone"=>"America/Chicago", "longitude"=>-90.99428, "postal_code"=>"63965"}]}, "parking_details"=>{"lot"=>[nil, true], "free"=>[nil, true]}}, created_at: "2019-06-03 19:15:35", updated_at: "2019-06-03 19:15:35", organization_id: 1, action: "U", app_key_id: 85>,
#<Diff id: 3880804, diffable_id: 66529362, diffable_type: "Place", details: {"details"=>{"price_rating"=>[nil, 0]}, "locations"=>{"changes"=>[], "deleted"=>[{"id"=>48404956, "city"=>"Van Buren", "state"=>"MO", "country"=>"United States", "address1"=>nil, "latitude"=>36.952225, "timezone"=>"America/Chicago", "longitude"=>-90.99428, "postal_code"=>"63965"}]}}, created_at: "2019-06-03 19:15:27", updated_at: "2019-06-03 19:15:27", organization_id: 1, action: "U", app_key_id: 85>, #<Diff id: 3880803, diffable_id: 66529362, diffable_type: "Place", details: {"details"=>{"pets"=>[nil, true], "chain"=>[nil, false], "restrooms"=>[nil, true], "accessible"=>[nil, true], "private_property"=>[nil, false]}, "locations"=>{"changes"=>[], "deleted"=>[{"id"=>48404956, "city"=>"Van Buren", "state"=>"MO", "country"=>"United States", "address1"=>nil, "latitude"=>36.952225, "timezone"=>"America/Chicago", "longitude"=>-90.99428, "postal_code"=>"63965"}]}}, created_at: "2019-06-03 19:15:22", updated_at: "2019-06-03 19:15:22", organization_id: 1, action: "U", app_key_id: 85>,
#<Diff id: 3880802, diffable_id: 66529362, diffable_type: "Place", details: {"locations"=>{"changes"=>[], "deleted"=>[{"id"=>48404956, "city"=>"Van Buren", "state"=>"MO", "country"=>"United States", "address1"=>nil, "latitude"=>36.952225, "timezone"=>"America/Chicago", "longitude"=>-90.99428, "postal_code"=>"63965"}]}, "contact_info"=>{"id"=>[nil, 15185684], "place_id"=>[nil, 66529362]}, "social_handles"=>[[], [{"id"=>3598, "url"=>"https://www.tripadvisor.com/Attraction_Review-g60926-d274436-Reviews-Big_Spring-Van_Buren_Missouri.html", "network"=>"TripAdvisor", "place_id"=>66529362}]]}, created_at: "2019-06-03 19:15:09", updated_at: "2019-06-03 19:15:09", organization_id: 1, action: "U", app_key_id: 85>]>
irb(main):005:0> Place.find(66540442).diffs
Place Load (1.0ms) SELECT "places".* FROM "places" WHERE "places"."enabled" = 't' AND "places"."id" = 66540442 LIMIT 1
Diff Load (5.4ms) SELECT "diffs".* FROM "diffs" WHERE "diffs"."diffable_id" = 66540442 AND "diffs"."diffable_type" = 'Place'
=> #<ActiveRecord::Associations::CollectionProxy [
#<Diff id: 3922389, diffable_id: 66540442, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"id"=>[nil, 48408533], "loc"=>[nil, "POINT (-108.214415 32.92537)"], "city"=>[nil, ""], "state"=>[nil, "NM"], "country"=>[nil, "USA"], "address1"=>[nil, ""], "address2"=>[nil, ""], "place_id"=>[nil, 66540442], "postal_code"=>[nil, ""]}], "deleted"=>[]}}, created_at: "2019-06-24 13:36:10", updated_at: "2019-06-24 13:36:10", organization_id: 1000, action: "U", app_key_id: nil>,
#<Diff id: 3918396, diffable_id: 66540442, diffable_type: "Place", details: {"locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405250, "city"=>nil, "state"=>"New Mexico", "country"=>"USA", "address1"=>"State Highway 15", "latitude"=>32.9251083424045, "longitude"=>-108.21378762911948, "postal_code"=>nil}]}, "campground_details"=>{"laundry"=>[nil, false], "propane"=>[nil, false], "showers"=>[nil, false], "big_rigs"=>[nil, false], "firewood"=>[nil, false], "fifty_amp"=>[nil, false], "tent_sites"=>[nil, true], "full_hookup"=>[nil, false], "paved_sites"=>[nil, false], "dump_station"=>[nil, false], "pull_through"=>[nil, false], "sewer_hookup"=>[nil, false], "swimming_pool"=>[nil, false], "rec_facilities"=>[nil, false]}}, created_at: "2019-06-11 12:24:21", updated_at: "2019-06-11 12:24:21", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3918395, diffable_id: 66540442, diffable_type: "Place", details: {"details"=>{"restrooms"=>[nil, true]}, "locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405250, "city"=>nil, "state"=>"New Mexico", "country"=>"USA", "address1"=>"State Highway 15", "latitude"=>32.9251083424045, "longitude"=>-108.21378762911948, "postal_code"=>nil}]}}, created_at: "2019-06-11 12:24:04", updated_at: "2019-06-11 12:24:04", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3918394, diffable_id: 66540442, diffable_type: "Place", details: {"hours"=>[{}, {"<default>"=>{"fri_open_close"=>["24hrs"], "mon_open_close"=>["24hrs"], "sat_open_close"=>["24hrs"], "sun_open_close"=>["24hrs"], "thu_open_close"=>["24hrs"], "tue_open_close"=>["24hrs"], "wed_open_close"=>["24hrs"]}}], "locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405250, "city"=>nil, "state"=>"New Mexico", "country"=>"USA", "address1"=>"State Highway 15", "latitude"=>32.9251083424045, "longitude"=>-108.21378762911948, "postal_code"=>nil}]}}, created_at: "2019-06-11 12:22:10", updated_at: "2019-06-11 12:22:10", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3918393, diffable_id: 66540442, diffable_type: "Place", details: {"alt_names"=>[[], ["McMillan Campground - Gila National Forest"]], "locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405250, "city"=>nil, "state"=>"New Mexico", "country"=>"USA", "address1"=>"State Highway 15", "latitude"=>32.9251083424045, "longitude"=>-108.21378762911948, "postal_code"=>nil}]}}, created_at: "2019-06-11 12:21:48", updated_at: "2019-06-11 12:21:48", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3918389, diffable_id: 66540442, diffable_type: "Place", details: {"name"=>["McMillan Campground", "McMillan Woods Youth Campground"], "locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405250, "city"=>nil, "state"=>"New Mexico", "country"=>"USA", "address1"=>"State Highway 15", "latitude"=>32.9251083424045, "longitude"=>-108.21378762911948, "postal_code"=>nil}]}}, created_at: "2019-06-11 12:18:48", updated_at: "2019-06-11 12:18:48", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3918388, diffable_id: 66540442, diffable_type: "Place", details: {"details"=>{"pets"=>[nil, true], "wifi"=>[nil, false], "chain"=>[nil, false], "accessible"=>[nil, false], "credit_cards"=>[nil, false], "private_property"=>[nil, false]}, "locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405250, "city"=>nil, "state"=>"New Mexico", "country"=>"USA", "address1"=>"State Highway 15", "latitude"=>32.9251083424045, "longitude"=>-108.21378762911948, "postal_code"=>nil}]}}, created_at: "2019-06-11 12:18:30", updated_at: "2019-06-11 12:18:30", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3918386, diffable_id: 66540442, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"loc"=>["POINT (-108.21367488493654 32.92510859592183)", "POINT (-108.21378762911948 32.9251083424045)"]}], "deleted"=>[]}}, created_at: "2019-06-11 12:18:08", updated_at: "2019-06-11 12:18:08", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3918385, diffable_id: 66540442, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"state"=>[nil, "New Mexico"], "country"=>[nil, "USA"], "address1"=>[nil, "State Highway 15"], "timezone_id"=>[105, nil]}], "deleted"=>[]}}, created_at: "2019-06-11 12:17:57", updated_at: "2019-06-11 12:17:57", organization_id: 1000, action: "U", app_key_id: 83>]>
irb(main):006:0> Place.find(66529463).diffs
Place Load (1.8ms) SELECT "places".* FROM "places" WHERE "places"."enabled" = 't' AND "places"."id" = 66529463 LIMIT 1
Diff Load (2.2ms) SELECT "diffs".* FROM "diffs" WHERE "diffs"."diffable_id" = 66529463 AND "diffs"."diffable_type" = 'Place'
=> #<ActiveRecord::Associations::CollectionProxy [
#<Diff id: 3922114, diffable_id: 66529463, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"id"=>[nil, 48407976], "loc"=>[nil, "POINT (-112.3666667 38.7583333)"], "city"=>[nil, "FILLMORE"], "state"=>[nil, "UT"], "country"=>[nil, "USA"], "address1"=>[nil, "390 SOUTH MAIN"], "address2"=>[nil, ""], "place_id"=>[nil, 66529463], "postal_code"=>[nil, "84631"]}], "deleted"=>[]}}, created_at: "2019-06-24 13:34:33", updated_at: "2019-06-24 13:34:33", organization_id: 1000, action: "U", app_key_id: nil>,
#<Diff id: 3881049, diffable_id: 66529463, diffable_type: "Place", details: {"details"=>{"wifi"=>[nil, false], "chain"=>[nil, false], "restrooms"=>[nil, true], "accessible"=>[nil, false], "private_property"=>[nil, false]}, "locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405001, "city"=>"Kanosh", "state"=>"UT", "country"=>nil, "address1"=>"Canyon Rd.", "latitude"=>38.753, "timezone"=>"America/Denver", "longitude"=>-112.3634, "postal_code"=>"84637"}]}}, created_at: "2019-06-04 11:58:33", updated_at: "2019-06-04 11:58:33", organization_id: 1000, action: "U", app_key_id: 83>]>
irb(main):007:0> Place.find(66549605).diffs
Place Load (1.1ms) SELECT "places".* FROM "places" WHERE "places"."enabled" = 't' AND "places"."id" = 66549605 LIMIT 1
Diff Load (3.8ms) SELECT "diffs".* FROM "diffs" WHERE "diffs"."diffable_id" = 66549605 AND "diffs"."diffable_type" = 'Place'
=> #<ActiveRecord::Associations::CollectionProxy [
#<Diff id: 3922513, diffable_id: 66549605, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"id"=>[nil, 48408780], "loc"=>[nil, "POINT (-80.6557725 25.399325)"], "city"=>[nil, "Homestead"], "state"=>[nil, "FL"], "country"=>[nil, "USA"], "address1"=>[nil, "40001 State Road 9336"], "address2"=>[nil, ""], "place_id"=>[nil, 66549605], "postal_code"=>[nil, "33034"]}], "deleted"=>[]}}, created_at: "2019-06-24 13:36:58", updated_at: "2019-06-24 13:36:58", organization_id: 1000, action: "U", app_key_id: nil>,
#<Diff id: 3919692, diffable_id: 66549605, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"loc"=>["POINT (-80.655 25.4008)", "POINT (-80.65505471059865 25.401036660918322)"], "address1"=>["Ingraham Hwy.", "Ingraham Highway"], "timezone_id"=>[168, nil]}], "deleted"=>[]}}, created_at: "2019-06-17 15:04:59", updated_at: "2019-06-17 15:04:59", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3919691, diffable_id: 66549605, diffable_type: "Place", details: {"hours"=>[{}, {"<default>"=>{"fri_open_close"=>["24hrs"], "mon_open_close"=>["24hrs"], "sat_open_close"=>["24hrs"], "sun_open_close"=>["24hrs"], "thu_open_close"=>["24hrs"], "tue_open_close"=>["24hrs"], "wed_open_close"=>["24hrs"]}}], "locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405481, "city"=>"Homestead", "state"=>"FL", "country"=>nil, "address1"=>"Ingraham Hwy.", "latitude"=>25.4008, "timezone"=>"America/New_York", "longitude"=>-80.655, "postal_code"=>"33034"}]}}, created_at: "2019-06-17 15:03:52", updated_at: "2019-06-17 15:03:52", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3919690, diffable_id: 66549605, diffable_type: "Place", details: {"locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405481, "city"=>"Homestead", "state"=>"FL", "country"=>nil, "address1"=>"Ingraham Hwy.", "latitude"=>25.4008, "timezone"=>"America/New_York", "longitude"=>-80.655, "postal_code"=>"33034"}]}, "campground_details"=>{"propane"=>[nil, false], "firewood"=>[nil, false], "fifty_amp"=>[nil, false], "full_hookup"=>[nil, false], "sewer_hookup"=>[nil, false]}}, created_at: "2019-06-17 15:03:36", updated_at: "2019-06-17 15:03:36", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3919689, diffable_id: 66549605, diffable_type: "Place", details: {"locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405481, "city"=>"Homestead", "state"=>"FL", "country"=>nil, "address1"=>"Ingraham Hwy.", "latitude"=>25.4008, "timezone"=>"America/New_York", "longitude"=>-80.655, "postal_code"=>"33034"}]}, "campground_details"=>{"laundry"=>[nil, false], "showers"=>[nil, true], "big_rigs"=>[nil, true], "paved_sites"=>[nil, true], "pull_through"=>[nil, false], "swimming_pool"=>[nil, false]}}, created_at: "2019-06-17 15:02:52", updated_at: "2019-06-17 15:02:52", organization_id: 1000, action: "U", app_key_id: 83>,
#<Diff id: 3919687, diffable_id: 66549605, diffable_type: "Place", details: {"details"=>{"wifi"=>[nil, false], "chain"=>[nil, false], "restrooms"=>[nil, true], "accessible"=>[nil, true], "private_property"=>[nil, false]}, "locations"=>{"changes"=>[], "deleted"=>[{"id"=>48405481, "city"=>"Homestead", "state"=>"FL", "country"=>nil, "address1"=>"Ingraham Hwy.", "latitude"=>25.4008, "timezone"=>"America/New_York", "longitude"=>-80.655, "postal_code"=>"33034"}]}}, created_at: "2019-06-17 15:01:14", updated_at: "2019-06-17 15:01:14", organization_id: 1000, action: "U", app_key_id: 83>]>
irb(main):008:0> Place.find(66526241).diffs
Place Load (1.2ms) SELECT "places".* FROM "places" WHERE "places"."enabled" = 't' AND "places"."id" = 66526241 LIMIT 1
Diff Load (4.0ms) SELECT "diffs".* FROM "diffs" WHERE "diffs"."diffable_id" = 66526241 AND "diffs"."diffable_type" = 'Place'
=> #<ActiveRecord::Associations::CollectionProxy [
#<Diff id: 3922790, diffable_id: 66526241, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"id"=>[nil, 48409333], "loc"=>[nil, "POINT (-121.7667 44.03336)"], "city"=>[nil, ""], "state"=>[nil, "OR"], "country"=>[nil, "USA"], "address1"=>[nil, ""], "address2"=>[nil, ""], "place_id"=>[nil, 66526241], "postal_code"=>[nil, ""]}], "deleted"=>[]}}, created_at: "2019-06-24 13:38:41", updated_at: "2019-06-24 13:38:41", organization_id: 1000, action: "U", app_key_id: nil>,
#<Diff id: 3874522, diffable_id: 66526241, diffable_type: "Place", details: {"locations"=>{"changes"=>[{"loc"=>["POINT (-121.7672476 43.8927418)", "POINT (-121.76491015732591 44.039211309933734)"], "timezone_id"=>[146, nil]}], "deleted"=>[]}}, created_at: "2019-04-26 01:50:09", updated_at: "2019-04-26 01:50:09", organization_id: 1000, action: "U", app_key_id: 120>,
#<Diff id: 3874521, diffable_id: 66526241, diffable_type: "Place", details: {"locations"=>{"changes"=>[], "deleted"=>[{"id"=>48403275, "city"=>"Bend", "state"=>"OR", "country"=>"USA", "address1"=>"Cascade Lakes Scenic Byway", "latitude"=>43.8927418, "timezone"=>"America/Los_Angeles", "longitude"=>-121.7672476, "postal_code"=>"97413"}]}, "contact_info"=>{"website"=>["https://www.devilslakewisconsin.com/camping/", "https://www.fs.usda.gov/recarea/deschutes/recarea/?recid=38846"]}}, created_at: "2019-04-26 01:45:54", updated_at: "2019-04-26 01:45:54", organization_id: 1000, action: "U", app_key_id: 120>,
#<Diff id: 3874520, diffable_id: 66526241, diffable_type: "Place", details: {"locations"=>{"changes"=>[], "deleted"=>[{"id"=>48403275, "city"=>"Bend", "state"=>"OR", "country"=>"USA", "address1"=>"Cascade Lakes Scenic Byway", "latitude"=>43.8927418, "timezone"=>"America/Los_Angeles", "longitude"=>-121.7672476, "postal_code"=>"97413"}]}, "contact_info"=>{"website"=>["http://traveloregon.com/see-do/recreation/camping-recreation/fishing/hiking/devils-lake-campground/", "https://www.devilslakewisconsin.com/camping/"]}}, created_at: "2019-04-26 01:43:51", updated_at: "2019-04-26 01:43:51", organization_id: 1000, action: "U", app_key_id: 120>]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment