Replies: 2 comments 3 replies
-
|
First we need to add another field to differentiate where they come from eg source. CREATE TABLE VolumeSearchCache(
search_term TEXT, # text used to search on a source
source TEXT, # name of the upstream source
id INT, # id is unique to the source
name TEXT, # the name of the volume/series
start_year INT, # the year that this volume had it's first issue published
publisher TEXT, # name of the publisher
count_of_issues INT, # number of issues in this volume
image_url TEXT, # url for the cover for this volume, usually the same as the first issue
description TEXT, # description of the volume/series only used when searching in the GUI currently
timestamp DATE # date retrieved for expiration purposes
)As to the minimum set of fields, most likely |
Beta Was this translation helpful? Give feedback.
-
|
I only see publisher (maybe start year missing from some) as a possible issue there. The other sources use an array and don't create separate titles for say the Japanese and English prints as CV seems to do. |
Beta Was this translation helpful? Give feedback.
-
|
CV also has start_year missing from some comics so it's more like a highly recommended field |
Beta Was this translation helpful? Give feedback.
-
|
metron.cloud Does issue level detail too. |
Beta Was this translation helpful? Give feedback.
-
|
To get enough info it looks like it'll require another call for each id: |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
I'll start a new discussion just to keep things separate.
I'll post here the current DB layout and then a result for the same search across different APIs so we can see what we're working with. It might be useful...?
Sources: Comic Vine, Manga Updates, MyAnineList (via jikan). Which other sources to include? GCD doesn't have an API?
I'll cut genres etc. down to one.
Single search result record for various sources:
Comic Vine
Manga Updates
MyAnimeList via jikan
I've not taken a good look at it all yet. I presume the fields "volume, name, id, start_year, publisher, image, description, count_of_issues" from CV are the required minimum. They break down as: volume = ?, name = name, id = id, start_year = start_year, publisher = publisher: {name}, image = image: {super_url}, description = description, count_of_issues = count_of_issues
Map for MU: volume = ?, name = hit_title*, id = series_id, start_year = year, publisher = UNAVAILABLE**, image = image: {url: {original}} , description = description, count_of_issues = UNAVAILABLE***
*MU prefers romanji titles and so the hit_title is the search match result. The default title is "Hagane no Renkinjutsushi".
**A list of publisher is available via a series call.
***Series call has a last_chapter field.
Map for MAL (jikan): volume = ?, name = title_english*, id = mal_id, start_year = published: {prop: {from: {year}}}, publisher = serializations: {name}, image = images: {JPG: {large_image_url}} , description = synopsis, count_of_issues = volumes?
*CT is English dominant at this time so chose that but "title" is another option.
Beta Was this translation helpful? Give feedback.
All reactions