Skip to content

Test GetOrganicResults job with sitelinks expanded UNIQUE constraint failed #129

@dimayefremov

Description

@dimayefremov

Снимок экрана 2021-05-04 в 12 57 04

Error happened if use JSON response from SERP API documentation

Снимок экрана 2021-05-04 в 13 02 23

Json response from GetOrganicResultsTest:
  "organic_results": [
      {
          "position": 1,
          "title": "Apple",
          "link": "https://www.apple.com/",
          "displayed_link": "https://www.apple.com/",
          "snippet": "Discover the innovative world of Apple and shop everything iPhone, iPad, Apple Watch, Mac, and Apple TV, plus explore accessories, entertainment, and expert device support.",
          "sitelinks_search_box": true,
          "sitelinks": {
              "expanded": [
                  {
                      "title": "iPhone",
                      "link": "https://www.apple.com/iphone/",
                      "snippet": "Explore iPhone, the world`s ..."
                  },
                  {
                      "title": "iPad",
                      "link": "https://www.apple.com/ipad/",
                      "snippet": "Compare iPad Models - iPad mini 4 - iPad Accessories - ..."
                  },
                  {
                      "title": "Mac",
                      "link": "https://www.apple.com/mac/",
                      "snippet": "MacBook Pro - MacBook - MacBook Air - iMac - Compare"
                  },
                  {
                      "title": "Music",
                      "link": "https://www.apple.com/music/",
                      "snippet": "Listen to your favorite music ad-free on all your devices, online ..."
                  },
                  {
                      "title": "Apple Support",
                      "link": "https://support.apple.com/",
                      "snippet": "Apple support is here to help. Learn more about popular ..."
                  },
                  {
                      "title": "Accessories",
                      "link": "https://www.apple.com/shop/accessories/all-accessories",
                      "snippet": "Shop Apple accessories for Apple Watch, iPhone, iPad, iPod, and ..."
                  }
              ]
          },
          "cached_page_link": "https://webcache.googleusercontent.com/search?q=cache:xEELJvdODswJ:https://www.apple.com/+&cd=1&hl=en&ct=clnk&gl=us"
      }
  ]

I think this case should be handled, if it can happen with real response data

Metadata

Metadata

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions