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)
