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)