def create_book(cursor, row): _row = sqlite3.Row(cursor, row) book = Book() book.id = _row["book_id"] book.Author = _row["Author"] book.ISBNNumber = _row["ISBNNumber"] book.bookTitle = _row["bookTitle"] book.YearPublished = _row["YearPublished"] librarian = Librarian() librarian.id = _row["librarian_id"] librarian.first_name = _row["first_name"] librarian.last_name = _row["last_name"] library = Library() library.id = _row["library_id"] library.title = _row["library_name"] book.librarian = librarian book.location = library return book
def create_book(cursor, row): _row = sqlite3.Row(cursor, row) book = Book() book.id = _row["book_id"] book.author = _row["author"] book.isbn = _row["isbn"] book.title = _row["title"] book.year_published = _row["year_published"] librarian = Librarian() librarian.id = _row["librarian_id"] librarian.first_name = _row["first_name"] librarian.last_name = _row["last_name"] library = Library() library.id = _row["library_id"] library.title = _row["library_name"] book.librarian = librarian book.location = library return book
def create_book(cursor, row): _row = sqlite3.Row(cursor, row) book = Book() book.id = _row['book_id'] book.author = _row['author'] book.isbn = _row['isbn'] book.title = _row['title'] book.year_published = _row['year_published'] librarian = Librarian() librarian.id = _row['librarian_id'] librarian.first_name = _row['first_name'] librarian.last_name = _row['last_name'] library = Library() library.id = _row['library_id'] library.title = _row['library_name'] book.librarian = librarian book.location = library return book
def list_librarians(request): if request.method == 'GET': with sqlite3.connect(Connection.db_path) as conn: conn.row_factory = sqlite3.Row db_cursor = conn.cursor() db_cursor.execute(""" select l.id, l.location_id, l.user_id, u.first_name, u.last_name, u.email from libraryapp_librarian l join auth_user u on l.user_id = u.id """) all_librarians = [] dataset = db_cursor.fetchall() for row in dataset: lib = Librarian() lib.id = row["id"] lib.location_id = row["location_id"] lib.user_id = row["user_id"] lib.first_name = row["first_name"] lib.last_name = row["last_name"] lib.email = row["email"] all_librarians.append(lib) template_name = 'librarians/list.html' context = {'all_librarians': all_librarians} return render(request, template_name, context)