def create_books():
with open("../anapioficeandfire/books.json") as book_file:
books = json.load(book_file)
for d in books:
id = d["url"].split("/").pop()
name = d["name"]
isbn = d["isbn"]
numberOfPages = d["numberOfPages"]
publisher = d["publisher"]
country = d["country"]
mediaType = d["mediaType"]
released = d["released"].split("T")[0]
b = Book.query.get(id)
if not b:
b = Book(id=id, name=name, isbn=isbn, numberOfPages=numberOfPages,
publisher=publisher, country=country, mediaType=mediaType,
released=released)
else:
b.name = name
b.isbn = isbn
b.numberOfPages = numberOfPages
b.publisher = publisher
b.country = country
b.mediaType = mediaType
b.released = released
db.session.add(b)
print(b)
