def get_user_book(email, isbn): bdao = BookDao() try: book = bdao.get_user_book(Book("", "", isbn, "", email)) except RecordNotFoundException: response.status = 404 return f"Book with isbn {isbn} not found." response.status = 200 return book.to_json()
def test_books_with_content_returns_200(self): self.assertEquals(0, Book.all().count()) book = Book(title="test", ident="1", author="author", notes="", image="http://example.com/image.gif", url="http://example.com") book.put() response = self.app.get('/books', expect_errors=True) self.assertEquals("200 OK", response.status)
def add_book(): name = request.args.get('name') author = request.args.get('author') published = request.args.get('published') try: book = Book(name=name, author=author, published=published) db.session.add(book) db.session.commit() return "Book added. book id={}".format(book.id) except Exception as e: return (str(e))
def post(self): args = self.parser.parse_args() db.session.add( Book(category_id=args.category_id, title=args.title, thumbnail_url=args.thumbnail_url, stock=args.stock, product_description=args.product_description, upc=args.upc)) db.session.commit() return {'title': args.title}
def main(): f = open("./storage/books.csv") reader = csv.reader(f) for isbn, title, author, year in reader: book = Book(isbn=isbn, title=title, author=author, year=year) db.session.add(book) print(f"Added book number {isbn} with title {title} .") print("There is no more books.") db.session.commit() print("Proccess successful.")
def test_book_3(self): s = Book(isbn='37', title = 'How to be bad', google_id = "22", datePublished = "2017-11-12", description = "Wrost book of all time.", image="https://cdn.business2community.com/wp-content/uploads/2016/03/Vd3MJo.jpg") testSession.add(s) testSession.commit() r = testSession.query(Book).filter_by(isbn = '37').one() self.assertEqual(str(r.isbn), '37') testSession.query(Book).filter_by(isbn = '37').delete() testSession.commit()
def get_random_object(self, route): try: url = self.api_root + route response = requests.get(url) # a jeson dictionary json_dict = response.json() # map to python object return Book(**json_dict) except: print('...Something went wrong') return None
def test_book_1(self): s = Book(isbn='20', title = 'C++', google_id = "45", datePublished = "2015-12-08", description = "It is a impressive book.", image="http://upload.wikimedia.org/wikipedia/en/thumb/6/6f/Pottermore.png/225px-Pottermore.png") testSession.add(s) testSession.commit() r = testSession.query(Book).filter_by(isbn = '20').one() self.assertEqual(str(r.isbn), '20') testSession.query(Book).filter_by(isbn = '20').delete() testSession.commit()
def test_books(self): book = Book(title="title", author="author", category="category", description="description",quantity=5) db.session.add(book) db.session.commit() # this works assert book in db.session self.client.get("/api/v1/resources/books/") # this raises an AssertionError assert book in db.session
def add_book(): title = request.json['title'] author = request.json['author'] pages = request.json['pages'] price = request.json['price'] new_book = Book(title, author, pages, price) db.session.add(new_book) db.session.commit() return jsonify(new_book)
def create_book(jwt): new_book_name = request.json.get('book_name') new_book_issue = request.json.get('book_issue') if new_book_name is None or new_book_issue is None: abort(400) try: book = Book(book_name=new_book_name, book_issue=new_book_issue) book.insert() return jsonify({'success': True, 'book': book.id}) except BaseException: abort(422)
def test_book_model_2(self): """Test querying the database by attribute using simple keywords""" with app.test_request_context(): data1 = Book("title1", "genre1", "year1", "isbn1", "$1.00", "pic.jpg") data2 = Book("title2", "genre2", "year2", "isbn2", "$2.00", "pic2.jpg") db.session.add(data1) db.session.commit() db.session.add(data2) db.session.commit() book = db.session.query(Book).filter_by(year="year2").first() self.assertEqual(book.author, "author2") db.session.delete(data1) db.session.commit() db.session.delete(data2) db.session.commit()
def test_min_book(self): s = Book(id="hi", title="try", author="1", publisher="2") db.session.add(s) db.session.commit() r = Book.query.get("hi") self.assertEqual(r.id, "hi") self.assertEqual(r.isbn, None) db.session.query(Book).filter_by(id="hi").delete() db.session.commit()
def test_get_unexistent_book(): """ Tests the GET /users/<email>/books/<isbn> endpoint with unexistent book. """ book = Book("The Truth About Chuck Norris", "Ian Spector, Angelo Vildasol", "1592403441", "29th 2007", "*****@*****.**") try: delete_user_book(book) except: pass http_return = get_user_book(book) assert http_return.status_code == 404
def insertBook(): book = Book(title='Harry Potter', reserved=False, dateRent=datetime(2020, 10, 13)) book.save() book1 = Book(title='Game of thrones', reserved=False, dateRent=datetime(2020, 10, 11)) book1.save() book2 = Book(title='Rangers', reserved=False, dateRent=datetime(2020, 10, 12)) book2.save() book3 = Book(title='Lord of the rings', reserved=False, dateRent=datetime(2020, 9, 11)) book3.save() book4 = Book(title='Treasure island', reserved=False, dateRent=datetime(2020, 10, 5)) book4.save()
def test_book_deletion(self): self.assertEquals(0, Book.all().count()) book = Book(title="test", ident="1", author="author", notes="", image="http://example.com/image.gif", url="http://example.com") book.put() self.assertEquals(1, Book.all().count()) book.delete() self.assertEquals(0, Book.all().count())
def test_add_book_1(self): written_by = "Haruki Murakami" kafka_on_the_shore = Book(title="Kafka on the Shore", isbn="1400079276") author = self.session.query(Author).filter_by(name=written_by).first() author.wrotes = [kafka_on_the_shore] self.session.commit() # test test = self.session.query(Author).filter_by(name=written_by).first() book = test.wrotes[0] self.assertEqual(book.title, "Kafka on the Shore") self.assertEqual(book.written_by[0].name, "Haruki Murakami")
def create_books(): book = load_json('books.json') for oneBook in book['Books']: title = oneBook['title'] id = oneBook['id'] newBook = Book(title=title, id=id) # After I create the book, I can then add it to my session. session.add(newBook) # commit the session to my DB. session.commit()
def populate_books(n=30, authors=None, tags=None): return [ Book(isbn=g.code.isbn(), authors=authors if authors else [], title=' '.join(g.text.title().split(' ')[:5]), original_title=' '.join(g.text.title().split(' ')[:5]), publisher=g.business.company(), pub_date=g.datetime.datetime().date(), language=g.person.language(), tags=tags if tags else [], description=g.text.sentence()) for _ in range(n) ]
def create_book(): if request.method == 'GET': form = BookForm() else: # POST form = BookForm(request.form) if form.validate(): book = Book('') form.populate_obj(book) db.session.add(book) db.session.commit() return redirect(url_for('edit_books')) return render_template('books_edit_page.html', form=form)
def test_book_views_return_correct_mime_type(self): self.assertEquals(0, Book.all().count()) book = Book(title="test", ident="1", author="author", notes="", image="http://example.com/image.gif", url="http://example.com") book.put() self.assertEquals(1, Book.all().count()) response = self.app.get('/books/%s' % book.ident, expect_errors=True) self.assertEquals(response.content_type, "application/json")
def create_book(): data = request.get_json() name = data['name'] author = data['author'] published = data['published'] try: book = Book(name=name, author=author, published=published) db.session.add(book) db.session.commit() return "Book name={} added successfully".format(book.name) except Exception as e: return (str(e))
def books_add(): form = BookForm(request.form) if request.method == "POST" and form.validate(): new_book = Book(title=form.data.get('title')) new_book.authors = form.data.get('authors') db.session.add(new_book) db.session.commit() flash("Book added") return redirect(url_for('books_view_all')) return render_template('books/add.html', **locals())
def insert_book(): book = Book(title=request.json['title'], first_author=request.json['first_author'], second_author=request.json['second_author'], publisher=request.json['publisher'], year_of_publication=request.json['year_of_publication'], author_id1=request.json['author_id1'], author_id2=request.json['author_id2'], publisher_id=request.json['publisher_id']) db.session.add(book) db.session.commit() return make_response(jsonify(response='OK'), 200)
def addbook(): form = AddFormBook() if form.validate_on_submit(): if Book.query.filter_by(bookname=form.name.data).first(): flash(u'Эта книга уже есть в библиотеке') return redirect(url_for("addbook")) book = Book(bookname=form.name.data) dbs.session.add(book) dbs.session.commit() flash(u'Книга:%s была добавлена в библиотеку' % book.bookname) return redirect(url_for("addbook")) return render_template('addbook.html', form=form, user=current_user)
def test_sending_email(self): self.assertEquals(0, Book.all().count()) book = Book(title="test", ident="1", author="author", notes="", image="http://example.com/image.gif", url="http://example.com") book.put() self.assertEquals(1, Book.all().count()) # TODO: needs assertion _email_new_book(book)
def _addBook(self, request): try: data = {field.name: getattr(request, field.name) for field in request.all_fields()} data['key'] = ndb.Key(Book, data['title']) del data['websafeKey'] r = Book(**data).put() return copyToForm(BookForm(), r.get()) except Exception, e: raise endpoints.BadRequestException(e.message)
def test_max_book(self): s = Book(isbn = str("a" * 30),id = str("a" * 20), title = str("a"*100),subtitle = str("a"*100), \ date_pub = datetime(1000,5,5),author = str("a"*100),publisher = str("a"*100),description = None) db.session.add(s) db.session.commit() r = Book.query.get(str("a" * 20)) self.assertEqual(r.id, str("a" * 20)) db.session.query(Book).filter_by(id='aaaaaaaaaaaaaaaaaaaa').delete() db.session.commit()
def create_book(): try: title = request.get_json()['title'] author = request.get_json()['author'] rating = request.get_json()['rating'] book = Book(title=title, author=author, rating=rating) book.insert() return jsonify({"success": True, "created": book.id}) except: abort(422)
def resync_database(data): rows = [] for row in data: rows.append( Book(row["title"], row["topic"], row["count"], row["cost"], row["id"])) try: db.session.query(Book).delete() db.session.bulk_save_objects(rows) db.session.commit() except: logging.error(f"Failed to resync the database.")