def save_books_genres(book: Books, genre: Genres):
"""Genre's books control and save in data base."""
flag = False
if book.genres is not None:
for i in range(len(book.genres)):
if book.genres[i].id is genre.id:
flag = True
if flag is False:
book.genres.append(genre)
session.add(book)
session.commit()
def save_books_readers(
book: Books,
reader: Readers):
"""Reader's books control and save in data base."""
flag = False
if book.readers is not None:
for i in range(len(book.readers)):
if book.readers[i].id is reader.id:
flag = True
if flag is False:
book.readers.append(reader)
session.add(book)
session.commit()
def save_reader(row: dict):
"""Reader's control and save in data base."""
try:
result: Readers = session.query(Readers) \
.filter(Readers.name == row.get('reader_name')) \
.one()
return result
except MultipleResultsFound:
print('Такой исполнитель уже есть в базе')
except NoResultFound:
result: Readers = Readers(name=row.get('reader_name'))
session.add(result)
session.commit()
return result
def save_author(row: dict):
"""Author's control and save in data base."""
try:
result: Authors = session.query(Authors) \
.filter(Authors.name == row.get('author_name')) \
.one()
return result
except MultipleResultsFound:
print('Такой автор уже есть в базе')
except NoResultFound:
result: Authors = Authors(name=row.get('author_name'))
session.add(result)
session.commit()
return result
def save_genre(row: dict):
"""Genre's control and save in data base."""
try:
result: Genres = session.query(Genres) \
.filter(Genres.name == row.get('genre_name')) \
.one()
return result
except MultipleResultsFound:
print('Такой жанр уже есть в базе')
except NoResultFound:
result: Genres = Genres(name=row.get('genre_name'))
session.add(result)
session.commit()
return result
def save_book(row: dict, author: Authors):
"""Book's control and save in data base."""
try:
result: Books = session.query(Books) \
.filter(Books.name == row.get('name')) \
.one()
return result
except MultipleResultsFound:
print('Такая книга уже есть в базе')
except NoResultFound:
result: Books = Books(name=row.get('name'),
description=row.get('description'),
book_url=row.get('book_url'),
author=author)
session.add(result)
session.commit()
return result