def putBookInDb(bookKey):
debugList = []
authorsList = []
# get the book json & create the Book record
### Book ###
bookJson = getItemJson(bookKey)
bookUID = getUIDfromBookKey(bookKey)
b = Book(_bookId=bookUID, _bookJson=json.dumps(bookJson))
if 'title' in bookJson:
b._title = bookJson['title']
if 'subtitle' in bookJson:
b._subtitle = bookJson['subtitle']
db.session.add(b)
db.session.commit() # commit to get the ID
pb = PhysicalBook(_bookId=b._id)
db.session.add(pb)
# list of authors from book record
authors = getAuthorsFromBook(bookJson)
if (authors != 0):
for item in authors:
authorsList.append(item)
else:
debugList.append("No Authors from Book " + bookUID)
# get the works record - may give more authors - only taking the first work
works = getWorksFromBook(bookJson)
if (works != 0):
# workUID = works[0][7:]
workJson = getItemJson(works[0])
b._workJson = json.dumps(workJson)
# list of authors from work record
authors = getAuthorsFromWork(workJson)
if (authors != 0):
for item in authors:
authorsList.append(item)
else:
debugList.append("No Author from Work for Book " + bookUID)
else:
debugList.append("No Works from Book " + bookUID)
# go through the authors list, remove duplicates, and add the Author and BookAuthor records
authorsNoDup = list(dict.fromkeys(authorsList))
for item in authorsNoDup:
authorUID = item[
9:] # the portion of the openlibrary key to use for the db key
authorJson = getItemJson(item)
# create the author record if it doesn't already exist
### Author ###
authorRecord = Author.query.filter_by(_authorId=authorUID).first()
if not authorRecord:
a = Author(_authorId=authorUID, _json=json.dumps(authorJson))
if 'name' in authorJson:
a._name = authorJson['name']
db.session.add(a)
db.session.commit() # commit to get the ID
debugList.append("Added a record for Author " + authorUID)
### BookAuthor ###
ba = BookAuthor(_authorId=a._id, _bookId=b._id)
db.session.add(ba)
debugList.append("Added a BookAuthor record " + authorUID + "," +
bookUID)
db.session.commit() # final commit
return 0
def addBook():
debugList = []
booksAddedList = []
booksExistingList = []
booksNotFoundList = []
f_ISBNlist = open("isbn_list.txt")
for line in f_ISBNlist:
if line != '\n':
# TODO: check if the line is in the proper format
isbn = line[7:].rstrip() # isbn
bookKey = getBookKey(isbn) # open library key / url portion
if (bookKey != 0):
bookUID = getUIDfromBookKey(
bookKey) # open library key with url portion removed
bookRecord = Book.query.filter_by(_bookId=bookUID).first()
if not bookRecord: # book is not in db
putBookInDb(bookKey)
bookRecord = Book.query.filter_by(
_bookId=bookUID).first()
booksAddedList.append(
CommonFunctions.formatForBookTable(bookRecord))
else:
pb = PhysicalBook(_bookId=bookRecord._id)
db.session.add(pb)
booksExistingList.append(
CommonFunctions.formatForBookTable(bookRecord))
else: # not in openlibrary.org - check google books api
bookJsonG = getBookJsonGoog(isbn)
if 'totalItems' in bookJsonG:
if (bookJsonG['totalItems'] != 0):
bookUID = bookJsonG['items'][0]['id']
# check if it's in the db
bookRecord = Book.query.filter_by(
_bookId=bookUID).first()
if not bookRecord: # book is not in db
# Check to see if the book's title is unique
volumeInfo = bookJsonG['items'][0][
'volumeInfo']
if 'title' in volumeInfo:
title = volumeInfo['title']
sameTitleRecord = Book.query.filter_by(
_title=title).first()
if not sameTitleRecord:
# add the book to the db
b = Book(
_bookId=bookUID,
_title=title,
_bookJson=json.dumps(bookJsonG))
db.session.commit(
) # commit to get book id
pb = PhysicalBook(_bookId=b._id)
db.session.add(pb)
if 'subtitle' in volumeInfo:
b._subtitle = volumeInfo[
'subtitle']
db.session.add(b)
db.session.commit(
) # commit to get the ID
if 'authors' in volumeInfo:
for author in volumeInfo[
'authors']:
# TODO: check to see if the author is added to the db
sameAuthorRecord = Author.query.filter_by(
_name=author).first()
if not sameAuthorRecord:
# add the author to the db
a = Author(_name=author)
db.session.add(a)
db.session.commit(
) # commit to get the ID
authorId = a._id
else:
authorId = sameAuthorRecord_.id
# add the bookauthor to the db
ba = BookAuthor(
_authorId=authorId,
_bookId=b._id)
db.session.add(ba)
addedBook = Book.query.filter_by(
_bookId=bookUID).first()
booksAddedList.append(
CommonFunctions.formatForBookTable(
addedBook))
else:
pb = PhysicalBook(
_bookId=sameTitleRecord._id)
db.session.add(pb)
debugList.append(
"Book " + bookUID +
" is already in db by title")
else:
debugList.append("No title for Book " +
bookUID)
else:
pb = PhysicalBook(_bookId=bookRecord._id)
db.session.add(pb)
booksExistingList.append(
CommonFunctions.formatForBookTable(
bookRecord))
else:
booksNotFoundList.append("ISBN: " + isbn)
else: # something weird is wrong (reached API request limit, etc)
debugList.append(bookJsonG)
db.session.commit() # final commit
f_ISBNlist.close()
debugList.append("debugging on")
return [
booksAddedList, booksExistingList, booksNotFoundList, debugList
]
