def addRecord(data): """ The incoming 'data' paramater should be a tuple of two dictionaries in the following format: ("author":{"first_name":"John", "last_name":"Doe"}, "book":{"title":"Some book", "isbn":"1234567890", "publisher":"Packt"} ) """ # Create an instance of the Book and Person classes and populate them with the values # collected from the 'Add' dialog and passed in as the tuple of dictionaries. book = Book() book.title = data['book']['title'] book.isbn = data['book']['isbn'] book.publisher = data['book']['publisher'] author = Person() author.first_name = data['author']['first_name'] author.last_name = data['author']['last_name'] book.person = author # Create a session, connect to the database, commit and close the connection. session = connectToDatabase() session.add(book) session.commit() session.close
def add_record(session, data): book = Book() book.title = data["book"]["title"] book.isbn = data["book"]["isbn"] book.publisher = data["book"]["publisher"] author = Person() author.first_name = data["author"]["first_name"] author.last_name = data["author"]["last_name"] book.person = author # try: session.add(book) session.commit()
def add_record(session, data): """ Data should be a dictionary of two dictionaries in the following format: {"author":{"first_name":"John", "last_name":"Doe"}, "book":{"title":"Some book", "isbn":"1234567890", "publisher":"Packt"} } """ book = Book() book.title = data["book"]["title"] book.isbn = data["book"]["isbn"] book.publisher = data["book"]["publisher"] author = Person() author.first_name = data["author"]["first_name"] author.last_name = data["author"]["last_name"] book.person = author session.add(book) session.commit()
def addBook(): global apiInfo orgBook = Book() form = EditBookForm() if request.method == 'GET': form.id.data = orgBook.id form.name.data = orgBook.name form.price.data = orgBook.price form.isbn.data = orgBook.isbn form.isObsolete.data = orgBook.isObsolete form.bookType.data = orgBook.bookType if request.method == 'POST' and form.validate( ): # Equivalent to validate_on_submit() newBook = Book() newBook.name = request.form['name'] newBook.isbn = request.form['isbn'] newBook.price = request.form['price'] newBook.isObsolete = form.isObsolete.data # TODO (bug) request.form['<booelan>'] does not return newBook.bookType = request.form['bookType'] # TODO (bug) Error when doing the api-call addedBook = json.loads( requests.post(app.config['API_ROOT_URL'] + '/books', json=vars(newBook)).content) newBook.id = addedBook['id'] flash('Added book {}'.format(vars(newBook))) return redirect('/books') return render_template('books/edit.html', actionTitle='Add book', appTitle=app.config['APP_TITLE'], api=apiInfo, book=vars(orgBook), form=form)
def addRecord(data): """ Data should be a tuple of two dictionaries in the following format: ("author":{"first_name":"John", "last_name":"Doe"}, "book":{"title":"Some book", "isbn":"1234567890", "publisher":"Packt"} ) """ book = Book() book.title = data["book"]["title"] book.isbn = data["book"]["isbn"] book.publisher = data["book"]["publisher"] author = Person() author.first_name = data["author"]["first_name"] author.last_name = data["author"]["last_name"] book.person = author # connect to session and commit data to database session = connectToDatabase() session.add(book) session.commit() session.close()