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 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()