Request for latest database dump

Request a website or interface feature.
n3ziniuka5
Posts: 2
Joined: Wed Apr 04, 2018 2:17 pm

Request for latest database dump

Postby n3ziniuka5 » Wed Apr 04, 2018 2:42 pm

Hello,

I'd like to have all the data in my local database. However, looking at api, there is no way to get ids of all series. It would be great to get an up to date database dump, it has been a year since the last dump - viewtopic.php?f=3&t=7550

Also, dumps in .sql format are quite hard to work with if you only need partial information. For example, if I only need a title and a rating, I still need to import the whole thing and then reimport to another database. I think it would make sense for the dump to have many files, 1 for each series. The file content would be data about series, including all episodes, in json format. Example (filename would be 153021.json):

Code: Select all

{
  "data": {
    "id": 153021,
    "seriesName": "The Walking Dead",
    "aliases": [],
    "banner": "graphical/153021-g49.jpg",
    "seriesId": "78582",
    "status": "Continuing",
    "firstAired": "2010-10-31",
    "network": "AMC",
    "networkId": "",
    "runtime": "45",
    "genre": [
      "Drama",
      "Horror"
    ],
    "overview": "The world we knew is gone. An epidemic of apocalyptic proportions has swept the globe causing the dead to rise and feed on the living. In a matter of months society has crumbled. In a world ruled by the dead, we are forced to finally start living. Based on a comic book series of the same name by Robert Kirkman, this AMC project focuses on the world after a zombie apocalypse. The series follows a police officer, Rick Grimes, who wakes up from a coma to find the world ravaged with zombies. Looking for his family, he and a group of survivors attempt to battle against the zombies in order to stay alive.",
    "lastUpdated": 1522867473,
    "airsDayOfWeek": "Sunday",
    "airsTime": "9:00 PM",
    "rating": "TV-MA",
    "imdbId": "tt1520211",
    "zap2itId": "EP01324002",
    "added": "2010-03-30 01:30:16",
    "addedBy": 76261,
    "siteRating": 9,
    "siteRatingCount": 1488,
    "episodes": [
      {
        "id": 5266516,
        "airedSeason": 6,
        "airedSeasonID": 627501,
        "airedEpisodeNumber": 1,
        "episodeName": "First Time Again",
        "firstAired": "2015-10-11",
        "guestStars": [],
        "director": "Greg Nicotero",
        "directors": [
          "Greg Nicotero"
        ],
        "writers": [
          "Scott M. Gimple",
          "Matthew Negrete"
        ],
        "overview": "Rick and the group continue to have trouble assimilating into Alexandria. Multiple threats lead the community to adopt a mindset of hardness, while Rick's group must take a step back from the violence they've come to embrace.",
        "language": {
          "episodeName": "en",
          "overview": "en"
        },
        "productionCode": "",
        "showUrl": "",
        "lastUpdated": 1477727084,
        "dvdDiscid": "",
        "dvdSeason": null,
        "dvdEpisodeNumber": null,
        "dvdChapter": null,
        "absoluteNumber": 68,
        "filename": "episodes/153021/5266516.jpg",
        "seriesId": 153021,
        "lastUpdatedBy": 438052,
        "airsAfterSeason": null,
        "airsBeforeSeason": null,
        "airsBeforeEpisode": null,
        "thumbAuthor": 429786,
        "thumbAdded": "2015-09-30 10:19:29",
        "thumbWidth": "400",
        "thumbHeight": "225",
        "imdbId": "tt4211958",
        "siteRating": 7.7,
        "siteRatingCount": 60
      },
      ...
    ]
  }
}


After importing the initial dump I would be able to update the data by using the "/updated" endpoint.

Coco
Site Admin
Posts: 2671
Joined: Tue Mar 13, 2007 10:16 pm
Location: Canada

Re: Request for latest database dump

Postby Coco » Sun Apr 08, 2018 12:54 pm

We are not splitting the DB dumps. We don't even provide them very often in the first place, if you want to use them fine but they are not designed for normal users to use nor will they ever be. Anything designed for users to use will come from the API and if you can't talk us into adding it to the API it won't be something we support.
Please don't PM me. Post in the forums instead unless there is a very good reason for a PM or I won't respond.

n3ziniuka5
Posts: 2
Joined: Wed Apr 04, 2018 2:17 pm

Re: Request for latest database dump

Postby n3ziniuka5 » Mon Apr 09, 2018 7:06 am

What about an api endpoint that would return a list of all show ids? That way it would be possible to eventually get the data about every show. Or have daily id exports, like "The Movie Database".

Edalex
Posts: 6
Joined: Wed Jan 06, 2010 1:04 pm

Re: Request for latest database dump

Postby Edalex » Thu May 10, 2018 2:26 pm

v2 api has "Updates" endpoint with list of updated ids. You just need to find out if new ids are there too.