Architecture Question - Connecting google books API and voting on favorite book
I am using the Google books API to pull books and show them on my site. This is working great. However, I want to be able to allow users to favorite books they want to remember and also upvote or downvote books. Normally this would be easy. But the problem is that the books are not in my database, they come from calls to the API.
The problem is, how do I link favorites or votes to a book if books onl come from the api? So I thought that I could implement a function in voting and favoriting that first checks to see if the book is in my database, if it isn't then it adds it immediately then adds the persons vote. This would allow me to only put books in the DB when someone does the first vote or first favorite. However, how do I implement that and is that the best course to take?
I would like to know how to do this as well. I would think that you can just take the data that is returned and run a create method on it to store it into the database. However, some kind of table should exists for that data.
Since the books aren't in your database, you'll want to find a way to uniquely identify them, and store entries in your database that correlate to them. Maybe you have a table of Favorites, each row has a user_id, and a book_id that matches the unique id that the API returns. Then you can check this table when displaying them. You could do the same thing for Votes.