MONGO_URI_BR = "mongodb+srv://mdb_c_root:************************************/BookRepositoryDev?retryWrites=true&w=majority"
GOOGLE_API_KEY = "*****************************************"
MONGO_DBNAME = "BookRepository"
SECRET_KEY = "*******************************************************************************************************************************************"
MAIL_SERVER = "smtp.gmail.com"
MAIL_PORT = 587
MAIL_USERNAME = "*****************"
MAIL_PASSWORD = "*****************"
MAIL_USE_TLS = True
MAIL_USE_SSL = False
MAIL_DEFAULT_SENDER = "*****************"
USER_EMAIL_SENDER_EMAIL = "*****************"
ADMIN_PASSWORD = "*****************"
LOGGING_LEVEL="INFO"
USER_ENABLE_CHANGE_USERNAME = False
ENABLE_FILE_LOGGING = True
PRODUCTION = OFF
FDT = ON
APPDEBUG = ON

import os
from datetime import timedelta

from dotenv import load_dotenv
from pathlib import Path
env_path = Path(".") / ".env"
load_dotenv(dotenv_path=env_path)


class ConfigClass(object):
    """ Flask application config """
    # Flask settings
    SECRET_KEY = os.environ.get("SECRET_KEY")

    # Flask-MongoEngine settings
    MONGO_DB_URL = os.environ.get("MONGO_URI_BR")
    MONGODB_SETTINGS = {
        'host': MONGO_DB_URL
    }

    # Flask-User settings
    # Shown in email templates and page footers
    USER_APP_NAME = "Book Repository"
    USER_ENABLE_EMAIL = True      # Enable email authentication
    USER_ENABLE_USERNAME = True    # Enable username authentication
    USER_ENABLE_CONFIRM_EMAIL = True  # Enable email after registration
    USER_ENABLE_FORGOT_PASSWORD = True # Enable email after forgot password
    USER_ENABLE_CHANGE_PASSWORD = True # Enable email after password change
    USER_SEND_PASSWORD_CHANGED_EMAIL = True # Enable email after password change
    USER_REQUIRE_RETYPE_PASSWORD = True
    USER_ENABLE_CHANGE_USERNAME = False

    MAIL_SERVER = os.environ.get("MAIL_SERVER")
    MAIL_PORT = os.environ.get("MAIL_PORT")
    # TLS Port: 587, SSL Port: 465 --> TLS or SSL: True/False
    MAIL_USERNAME = os.environ.get("MAIL_USERNAME")
    MAIL_PASSWORD = os.environ.get("MAIL_PASSWORD")
    MAIL_USE_TLS = True
    MAIL_USE_SSL = False
    USER_EMAIL_SENDER_EMAIL = os.environ.get("USER_EMAIL_SENDER_EMAIL")

    # Flask Session Configuration for Session Protection and "Remember Me" function
    SESSION_PROTECTION = "strong"
    REMEMBER_COOKIE_DURATION = timedelta(seconds=3600) # Logged out after 1 hour (come back in without logging in too)
    SESSION_COOKIE_SECURE = True

    # Flask User Manager Configuration
    USER_COPYRIGHT_YEAR = 2020
    USER_CORPORATION_NAME = "GaffCo Consulting"

import os
...
from dotenv import load_dotenv
from pathlib import Path
env_path = Path(".") / ".env"
load_dotenv(dotenv_path=env_path)

from config import ConfigClass
...
# --- // Application Factory Setup (based on the Flask-User example for MongoDB)
# https://flask-user.readthedocs.io/en/latest/mongodb_app.html
# Setup Flask and load app.config
app = Flask(__name__, static_folder="static", template_folder="templates")
app.config.from_object(__name__ + ".ConfigClass")
...
# export PRODUCTION=ON | OFF in TEST
# PRODUCTION App -> Settings -> Reveal Config Vars -> KEY: PRODUCTION,
# VALUE: ON
if __name__ == "__main__":
    if not os.environ.get("MONGO_URI_BR"):
        raise ValueError(
            "MongoDB Uniform Resource Identifier is missing, which means that we can't access the database.")
    elif not os.environ.get("ADMIN_PASSWORD"):
        raise ValueError(
            "Admin Password is not set which means that the Admin user can not be created.")
    elif not os.environ.get("MAIL_SERVER"):
        raise ValueError(
            "Mail Server Configuration error: MAIL_SERVER is not defined.")
    elif not os.environ.get("MAIL_PORT"):
        raise ValueError(
            "Mail Server Configuration error: MAIL_PORT is not defined.")
    elif not os.environ.get("MAIL_USERNAME"):
        raise ValueError(
            "Mail Server Configuration error: MAIL_USERNAME is not defined.")
    elif not os.environ.get("MAIL_PASSWORD"):
        raise ValueError(
            "Mail Server Configuration error: MAIL_PASSWORD is not defined.")
    elif not os.environ.get("USER_EMAIL_SENDER_EMAIL"):
        raise ValueError(
            "Mail Server Configuration error: USER_EMAIL_SENDER_EMAIL is not defined.")
	elif os.environ.get("APPDEBUG") == "ON":
        app.run(host=os.environ.get("IP"),
                port=os.environ.get("PORT"), debug=True)
    else:
        app.run(host=os.environ.get("IP"),
                port=os.environ.get("PORT"), debug=False)

 # Flask-MongoEngine settings
    MONGO_DB_URL = os.environ.get("MONGO_URI_BR")
    MONGODB_SETTINGS = {
        'host': MONGO_DB_URL
    }

from flask_mongoengine import MongoEngine, MongoEngineSession, MongoEngineSessionInterface
...
# Setup Flask-MongoEngine --> MongoEngine --> PyMongo --> MongoDB
db = MongoEngine(app)

from flask_wtf.csrf import CSRFProtect, CSRFError
...
csrf = CSRFProtect(app)
csrf.init_app(app)
...
@app.errorhandler(CSRFError)
...
@app.errorhandler(CSRFError)
def handle_csrf_error(error):
    excuse = "Apologies, the Librarian Security Detail have omitted to secure this page! We're calling them back from their lunch-break to fix this. Please click on the pink pulsating buoy to go to the Home Page (registering or signing in) or Member's Page (signed in), or click on Sign Out below."
    try:
        app.logger.critical(f"{current_user.username} has encountered a 400 CSRF Error (Bad Request), {error.description}: [FAILURE].")
    except AttributeError:
        app.logger.critical(f"Unauthenticated user has encountered a 400 CSRF Error (Bad Request), {error.description}: [FAILURE].")
    finally:
        return render_template("oops.html", error=error.description, excuse=excuse, error_type="Client: 400 - Bad Request")

...
<input type="hidden" name="csrf_token" value="{{csrf_token()}}">
...

from flask_mongoengine import MongoEngine, MongoEngineSession, MongoEngineSessionInterface
...
# Use Flask Sessions with Mongoengine
app.session_interface = MongoEngineSessionInterface(db)
...

import logging
from logging.handlers import RotatingFileHandler
...
# Initialise rotating file logging in Development, not on Heroku
# Set after app initialisation
if os.environ.get("ENABLE_FILE_LOGGING") == "True":
    logging.basicConfig(
        handlers=[RotatingFileHandler("./logs/book_repository.log", maxBytes=100000, backupCount=10)],
        level=os.environ.get("LOGGING_LEVEL"),
        format="%(asctime)s — %(name)s — %(levelname)s — %(funcName)s:%(lineno)d — %(message)s"
    )
else:
    # Initialize logging to console, works on Heroku
    logging.basicConfig(
        level=os.environ.get("LOGGING_LEVEL"),
        format="%(asctime)s — %(name)s — %(levelname)s — %(funcName)s:%(lineno)d — %(message)s"
    )
...
app.logger.critical("Genre file can't be found. The filename is 'genre.json' and contains the Book Genres: [FAILURE] - (index.html).")
...
app.logger.critical("Genre file isn't a proper JSON file. Please correct the issues with the file 'genre.json' and try to load it again: [FAILURE] - (admin_dashboard.html).")
...
app.logger.critical(f"{current_user.username} has NOT loaded the Genre Collection to the Book Repository, 'genre.json' file has JSON Schema errors. Please correct the genre '{genre_genre}': [FAILURE] - (admin_dashboard.html).")

if os.environ.get("FDT") == "ON":
    from flask_debugtoolbar import DebugToolbarExtension
...
if os.environ.get("FDT") == "ON":
    app.debug = True
...
# Initiate the Flask Debug Toolbar Extension
if os.environ.get("FDT") == "ON":
    toolbar = DebugToolbarExtension(app)

from flask_mongoengine import MongoEngine, MongoEngineSession, MongoEngineSessionInterface
from flask_user import login_required, UserManager, UserMixin, current_user, roles_required
...
# --- // Classes -> MongoDB Collections: User, Book, Genre.
# Flask-User User Class (Collection) extended with email_confirmed_at
# Added username indexing and background-indexing for performance
class User(db.Document, UserMixin):
    # Active set to True to allow login of user
    active = db.BooleanField(default=True)

    # User authentication information
    username = db.StringField(default="")
    password = db.StringField()

    # User information
    first_name = db.StringField(default="")
    last_name = db.StringField(default="")
    email = db.StringField(default="")
    email_confirmed_at = db.DateTimeField()
    # Required for the e-mail confirmation, and subsequent login.

    # Relationships  (Roles: user or user and Admin)
    roles = db.ListField(db.StringField(), default=["user"])

    meta = {
        "auto_create_index": True,
        "index_background": True,
        "indexes": ["username"]
    }


# Book Class (Collection) linked to User Class via user=username
# Title indexing, ordering, and background-indexing for performance
class Book(db.Document):
    title = db.StringField(default="", maxlength=250)
    author = db.StringField(default="", maxlength=250)
    year = db.IntField(maxlength=4)
    ISBN = db.IntField(maxlength=13)
    short_description = db.StringField(default="", maxlength=2000)
    user = db.StringField(required=True)
    creation_date = db.DateTimeField(default=datetime.datetime.now)
    comments = db.StringField(default="", maxlength=3500)
    rating = db.IntField(choices=[1, 2, 3, 4, 5, 6, 7, 8, 9, 10])
    genre = db.StringField(default="")
    private_view = db.StringField(default="off")
    book_thumbnail = db.StringField(default="")

    meta = {
        "auto_create_index": True,
        "index_background": True,
        "indexes": ["title"],
        "ordering": ["title"]
    }


# Genre Class (Collection), loaded via 'genre.json'
# Genre indexing,ordering, and background-indexing for performance
class Genre(db.Document):
    genre = db.StringField(default="")
    description = db.StringField(default="")

    meta = {
        "auto_create_index": True,
        "index_background": True,
        "indexes": ["genre"],
        "ordering": ["genre"]
    }
...
# Setup Flask-User and specify the User data-model
user_manager = UserManager(app, db, User)

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="Description" content="Developer and Designer: Naoise Gaffney - 'Gaff'. Title: Book Repository. Reason: third 
        milestone project for the Code Institute's Diploma in Full Stack Development. Description: The 
        Book Repository is a digital or virtual library to store information about your books, such as 
        title, author, year published, ISBN, genre, rating, description, and your reflection and comments.
        The Book Repository provides a private and public search function too, using any combination of title, 
        author, ISBN, genre, and rating.">
    <link rel="apple-touch-icon" sizes="180x180" href="/static/images/apple-touch-icon.png">
    <link rel="icon" type="image/png" sizes="32x32" href="/static/images/favicon-32x32.png">
    <link rel="icon" type="image/png" sizes="16x16" href="/static/images/favicon-16x16.png">
    <link rel="manifest" href="/static/images/site.webmanifest">
    <title>{{ user_manager.USER_APP_NAME }}</title>

    <!--Import Google Icon Font-->
    <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
    <!--Import materialize.css-->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/materialize/1.0.0/css/materialize.min.css">
    <!-- Custom CSS -->
    <link rel="stylesheet" type="text/css" href="{{ url_for('static', filename = 'styles/style.css') }}">
    <!-- Cookie Consent by Osano: https://www.osano.com/cookieconsent/download/ -->
    <link rel="stylesheet" type="text/css"
        href="https://cdn.jsdelivr.net/npm/cookieconsent@3/build/cookieconsent.min.css" />

    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
      <script src="//cdnjs.cloudflare.com/ajax/libs/html5shiv/3.7/html5shiv.js"></script>
      <script src="//cdnjs.cloudflare.com/ajax/libs/respond.js/1.4.2/respond.js"></script>
    <![endif]-->

    {# *** Allow sub-templates to insert extra html to the head section *** #}
    {% block extra_css %}{% endblock %}
</head>

<body>
    <header>
        {% block body %}
        <nav class="nav-wrapper white">
            <div class="container">
                <a href="{{url_for('home_page')}}"><img src="/static/images/logo_bookstack_text_96_spacing.png"
                        height="60" alt="Book Repository Logo"></a>
                <a href="#" class="sidenav-trigger" data-target="mobile-links">
                    <i class="material-icons blue-text text-darken-4" id="matnavbar">menu</i>
                </a>
                <ul class="right hide-on-med-and-down blue darken-4 waves-effect" id="nav-mobile">
                    {% if call_or_get(current_user.is_authenticated) %}
                    {% if "Admin" in current_user.roles %}
                    <li>
                        <a href="{{ url_for('admin_dashboard')}}">Admin Page<i
                                class="material-icons right">admin_panel_settings</i></a>
                    </li>
                    {% endif %}
                    <li>
                        <a href="{{ url_for('member_page')}}">Member's Page<i
                                class="material-icons right">dashboard</i></a>
                    </li>
                    <li>
                        <a href="{{ url_for('user.edit_user_profile') }}">{{ current_user.username or current_user.email }}<i
                                class="material-icons right">account_box</i></a>
                    </li>
                    <li>
                        <a href="{{ url_for('user.logout') }}">Sign Out<i
                                class="material-icons right">pan_tool</i></a>
                    </li>
                    {% else %}
                    <li>
                        <a href="{{ url_for('home_page')}}">Home<i class="material-icons right">home</i></a>
                    </li>
                    <li>
                        <a href="{{ url_for('user.login') }}">Sign In<i
                                class="material-icons right">login</i></a>
                    </li>
                    <li>
                        <a href="{{ url_for('user.register')}}">Register<i
                                class="material-icons right">how_to_reg</i></a>
                    </li>
                    {% endif %}
                </ul>
            </div>
        </nav>
        <!-- Navigation for Mobile devices using a "Hamburger-menu" which must be defined outside of <nav></nav> to function in Materialize 1.0.0 -->
        <ul class="sidenav blue darken-4" id="mobile-links">
            {% if call_or_get(current_user.is_authenticated) %}
            {% if "Admin" in current_user.roles %}
            <li>
                <a href="{{ url_for('admin_dashboard')}}" class="white-text">Admin Page<i
                        class="material-icons white-text left">admin_panel_settings</i></a>
            </li>
            {% endif %}
            <li>
                <a href="{{ url_for('member_page')}}" class="white-text">Member's Page<i
                        class="material-icons white-text left">dashboard</i></a>
            </li>
            <li>
                <a href="{{ url_for('user.edit_user_profile') }}"
                    class="white-text">{{ current_user.username or current_user.email }}<i
                        class="material-icons white-text left">account_box</i></a>
            </li>
            <li>
                <a href="{{ url_for('user.logout') }}" class="white-text">Sign Out<i
                        class="material-icons white-text left">pan_tool</i></a>
            </li>
            {% else %}
            <li>
                <a href="{{ url_for('home_page')}}" class="white-text">Home<i
                        class="material-icons white-text left">home</i></a>
            </li>
            <li>
                <a href="{{ url_for('user.login') }}" class="white-text">Sign In<i
                        class="material-icons white-text left">login</i></a>
            </li>
            <li>
                <a href="{{ url_for('user.register')}}" class="white-text">Register<i
                        class="material-icons white-text left">how_to_reg</i></a>
            </li>
            {% endif %}
        </ul>
    </header>
    {% block menu %}
    {% endblock %}

    <div id="main-div" class="container center">
        {# One-time system messages called Flash messages #}
        {% block flash_messages %}
        {%- with messages = get_flashed_messages(with_categories=true) -%}
        {% if messages %}
        {% for category, message in messages %}
        {% if category=='error' %}
        {% set category='danger' %}
        {% endif %}
        <div class="message chip message-{{category}}">{{ message|safe }}</div>
        {% endfor %}
        {% endif %}
        {%- endwith %}
        {% endblock %}
    </div>

    {% block main %}
    {% block content %}{% endblock %}
    {% endblock %}

    <footer class="page-footer transparent">
        <div class="footer-copyright blue darken-4">
            <div class="left-align">{{ user_manager.USER_APP_NAME }} {{ user_manager.USER_APP_VERSION }}</div>
            <div class="center-align"><a class="modal-trigger" href="#about"><i class="material-icons white-text"
                        id="menu_book">menu_book</i></a></div>
            <div class="right-align">&copy; {{ user_manager.USER_COPYRIGHT_YEAR }}
                {{ user_manager.USER_CORPORATION_NAME }}</div>
        </div>
        <div class="container">
            <div id="about" class="modal center">
                <div class="modal-content">
                    <ul class="tabs blue darken-4 center">
                        <li class="tab">
                            <a href="#bookrepo" class="active blue darken-4 white-text waves-effect">Book Repository</a>
                        </li>
                        <li class="tab">
                            <a href="#gaff" class="active blue darken-4 white-text waves-effect">Gaff</a>
                        </li>
                        <li class="tab">
                            <a href="#code" class="active blue darken-4 white-text waves-effect">Code</a>
                        </li>
                    </ul>
                    <div id="bookrepo">
                        <p class="tab_content_heading"><img src="/static/images/logo_bookstack_text_96_spacing.png" height="75"
                                alt="Book Repository Logo"></p>
                        <p>A safe virtual repository for books, a digital version of your library that is searchable,
                            and where
                            you can share your book notes and thoughts with like-minded readers.
                        </p>
                    </div>
                    <div id="gaff">
                        <p class="flow-text blue-text text-darken-4 tab_content_heading">Naoise Gaffney - "Gaff"</p>
                        <p><img src="/static/images/Gaff.png" height="150" alt="Gaff"></p>
                        <p>Code Institute Learner and Developer of this Book Repository, a Milestone Project 3
                            (Data-Centric) for the Code
                            Institute Diploma in Full Stack Development. Full Stack Developer and UX Designer.</p>
                    </div>
                    <div id="code">
                        <p class="flow-text blue-text text-darken-4 tab_content_heading">Code on GitHub</p>
                        <p>Front-end: HTML 5, CSS 3, and JavaScript</p>
                        <p>Application: Python, Flask, Flask Extensions, and MongoEngine</p>
                        <p>Database: MongoDB</p>
                        <p>API: Goggle Books API</p>
                        <p>External Links: Amazon UK and ISBN Search</p>
                        <p><a href="https://github.com/NaoiseGaffney/BookRepository" target="_blank" rel="noopener"
                                class="pink-text text-darken-1 waves-effect">&nbsp;Book Repository on GitHub&nbsp;</a>
                        </p>
                    </div>
                    <div class="modal-footer">
                        <a href="#!" class="modal-close btn waves-effect waves-light blue darken-4">Thank You!<i
                                class="material-icons right">thumb_up</i></a>
                    </div>
                </div>
            </div>
        </div>

    </footer>
    {% endblock %}

    <!-- Compiled and minified JavaScript -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/materialize/1.0.0/js/materialize.min.js"></script>
    <!-- Initialise MaterializeCSS 1.0.0 Features -->
    <script src="{{ url_for('static', filename = 'scripts/vendor/materialize.js') }}"></script>
    <!-- Message Chip Timeout -->
    <script src="{{ url_for('static', filename = 'scripts/message.js') }}"></script>
    <!-- Cookie Consent by Osano: https://www.osano.com/cookieconsent/download/ -->
    <script src="https://cdn.jsdelivr.net/npm/cookieconsent@3/build/cookieconsent.min.js" data-cfasync="false"></script>
    <script src="{{ url_for('static', filename = 'scripts/vendor/cookies.js') }}"></script>

    {# *** Allow sub-templates to insert extra html to the bottom of the body *** #}
    {% block extra_js %}{% endblock %}
</body>

</html>

import json
from json.decoder import JSONDecodeError
...
from jsonschema import validate, ValidationError
...
# --- // Book Repository Main Routes (Endpoints): CRUD.
@app.route("/")
@app.route("/index")
@app.route("/index.html")
def home_page():
    """
    Landing/Home Page, accessible before sign in/login. If logged in, user is redirected to the Member's Page.
    At first access/touch the user 'admin' is created using environment variables for the password and email address.
    At first access/touch the genre collection for the books is created based on 'genre.json'. Both the user and genre
    creations are here as they will be created twice on Heroku if placed in the main code.
    """
    if current_user.is_authenticated:
        return redirect(url_for("member_page"))

    # Create admin user as first/default user, if admin does not exist.
    # Password and e-mail are set using environment variables.
    if not User.objects.filter(User.username == "admin"):
        try:
            user = User(
                username="admin",
                first_name="Administrator",
                last_name="Administrator",
                email=os.environ.get("MAIL_DEFAULT_SENDER"),
                email_confirmed_at=datetime.datetime.utcnow(),
                password=user_manager.hash_password(os.environ.get("ADMIN_PASSWORD"))
            )
            user.roles.append("Admin")
            user.save()

            flash("'admin' account created.", "success")
            app.logger.info("'admin' account is created at startup if the user doesn't exist: [SUCCESS] - (index.html).")
        except Exception:
            flash("'admin' account not created.", "danger")
            app.logger.critical("'admin' account is created at startup if the user doesn't exist: [FAILURE] - (index.html).")

    # Create the Genre Collection if it does not exist. Genre descriptions taken from https://bookriot.com/guide-to-book-genres/
    # First validation: Genre Collection exists. Second validation: FileNotFound ('genre.json').
    # Third validation: JSONDecodeError (valid JSON format). Fourth validation: correct JSON Schema = Genre Class.
    if not Genre.objects():
        try:
            with open("genre.json", "r", encoding="utf-8") as f:
                genre_dict = json.load(f)
        except FileNotFoundError:
            flash("'genre.json' can't be found.", "danger")
            app.logger.critical("Genre file can't be found. The filename is 'genre.json' and contains the Book Genres: [FAILURE] - (index.html).")
            return render_template("index.html")
        except json.decoder.JSONDecodeError:
            flash("'genre.json' isn't a proper JSON file.", "danger")
            app.logger.critical("Genre file isn't a proper JSON file. Please correct the issues with the file 'genre.json' and try to load it again: [FAILURE] - (admin_dashboard.html).")
            return render_template("index.html")

        genre_schema = {
            "type": "object",
            "properties": {
                "genre": {"type": "string"},
                "description": {"type": "string"},
            },
        }

        try:
            for genre in genre_dict:
                validate(instance=genre, schema=genre_schema)
        except ValidationError:
            genre_genre = genre["genre"]
            flash("'genre.json' has JSON Schema errors.", "danger")
            app.logger.critical(f"{current_user.username} has NOT loaded the Genre Collection to the Book Repository, 'genre.json' file has JSON Schema errors. Please correct the genre '{genre_genre}': [FAILURE] - (admin_dashboard.html).")
            return render_template("index.html")

        try:
            genre_instances = [Genre(**data) for data in genre_dict]
            Genre.objects.insert(genre_instances, load_bulk=False)
            flash("Genres Collection created.", "success")
            app.logger.info("Genres Collection created: [SUCCESS] - (index.html)")
        except Exception:
            flash("Genres Collection NOT created.", "danger")
            app.logger.critical("Genres Collection NOT created: [FAILURE] - (index.html)")
        finally:
            return render_template("index.html")

    return render_template("index.html")

{% extends "flask_user_layout.html" %}
{% block content %}
<section class="container center">
    <br>
    <div class="landing_page">
    <img class="landing_logo" src="/static/images/logo_bookstack_text_96_spacing.png" alt="Book Repository Logo" />
    </div>
    <br>
    <div class="landing_page">
    <h6>Welcome!</h6>
    <br>
    <p>The Book Repository is a digital or virtual library to store information about your books, such as
    title, author, year published, ISBN, genre, rating, description, and your reflection and comments.</p>
    <br>
    <p>The Book Repository provides a private and public search function too, using any combination of title,
    author, ISBN, genre, and rating.</p>
    </div>
</section>
{% endblock %}

@app.route("/members")
@app.route("/members/<int:page>")
@login_required
def member_page(page=1):
    """
    The "R" in CRUD, a virtual library or stack of books to browse in the Member's Page.
    """
    app.logger.info(f"{current_user.username} is accessing the Member's Page: [INFO] - (members.html).")
    genre_list = Genre.objects()
    books_pagination = Book.objects.filter(user=current_user.username).paginate(page=page, per_page=7)
    return render_template("members.html", books_pagination=books_pagination, page_prev=(page - 1), page_next=(page + 1), genre_list=genre_list)

{% extends "flask_user_layout.html" %}
{% block content %}
<div class="container">
    <h6>
        {% if call_or_get(current_user.is_authenticated) %}
        Home
        {% else %}
        <a href="{{ url_for('home_page')}}">Home</a>
        {% endif %}
        &nbsp; > &nbsp;<a href="{{ url_for('member_page') }}">Member's Page</a>&nbsp;<i
            class="material-icons prefix tooltipped blue-text text-darken-4" data-position="bottom" role="tooltip" data-tooltip="<p class='left-align'>To view a book, click on the 'book spine' or eye icon.</p><br>
        <p class='left-align'>To edit a book's details, click on the pencil icon for the book you want to edit.</p><br>
        <p class='left-align'>To delete a book, click on the rubbish bin/dust-bin icon and answer yes or no to the question.</p><br>
        <p class='left-align'>Use the page numbers to navigate to a different page.</p><br>
        <p class='left-align'>Click on the book title link to view the book on Amazon UK. Click on the ISBN link in the book details section to view the book on ISBN Search.</p><br>
        <p class='left-align'>To add a book, or search for books, or view the list of genres and their description, please click on the 'Book' icon under the navigation menu.</p>">help</i>

        <span class="book-dropdown right">
            <span class="white-text btn waves-effect waves-light right blue darken-4"><i
                    class="material-icons white-text">import_contacts</i></span>
            <span class="book-dropdown-content">
                <span><a href="{{ url_for('add_book')}}" class="blue-text btn text-darken-4 white">Add Book&nbsp;<i
                            class="material-icons blue-text text-darken-4 right">import_contacts</i><i
                            class="material-icons blue-text text-darken-4 right">plus_one</i></a></span>
                <span><br>&nbsp;<br></span>
                <span><a href="{{ url_for('search_book')}}" class="blue-text btn text-darken-4 white">Search
                        Books<i class="material-icons blue-text text-darken-4 right">search</i></a></span>
                <span><br>&nbsp;<br></span>
                <span><a href="#genre_list" class="blue-text btn text-darken-4 white modal-trigger">List
                        Genres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<i class="material-icons blue-text text-darken-4 right">list</i></a></span>
            </span>
        </span>
    </h6>
    <div id="genre_list" class="modal center">
        <div class="modal-content">
            <h6>Book Repository Genre List</h6>
            <table>
                <tr class="white-text blue darken-4">
                    <th>Book Genre</th>
                    <th>Genre Description</th>
                </tr>
                {% for genre in genre_list %}
                <tr class="{{loop.cycle('white','blue-grey lighten-5')}}">
                    <td>{{genre.genre}}</td>
                    <td>{{genre.description}}</td>
                </tr>
                {% endfor %}
            </table>
        </div>
        <div class="modal-footer">
            <a href="#!" class="modal-close btn waves-effect waves-light blue darken-4"><i
                    class="material-icons white-text right">done</i>&nbsp;Done!</a>
        </div>
    </div>
    {# Macro for creating navigation links #}
    {% macro render_navigation(pagination, endpoint) %}
    <div class="pagination">Page #:
        {% if page_prev == 0 %}
        &lt;&nbsp;
        {% else %}
        <a href="{{ url_for(endpoint, page=page_prev) }}">&lt;&nbsp;</a>
        {% endif %}
        {% if pagination.has_next %}
        <a href="{{ url_for(endpoint, page=page_next) }}">&gt;&nbsp;</a>
        {% else %}
        &gt;&nbsp;
        {% endif %}
        {% for page in pagination.iter_pages() %}
        {% if page %}
        {% if page != pagination.page %}
        <a href="{{ url_for(endpoint, page=page) }}">{{ page }}</a>
        {% else %}
        <span style="background-color: #0D47A1; color: white; padding: 1px 5px;">{{ page }}</span>
        {% endif %}
        {% else %}
        <span class="ellipsis">…</span>
        {% endif %}
        {% endfor %}
    </div>
    {% endmacro %}

    {{ render_navigation(books_pagination, 'member_page') }}

    {% if books_pagination.items %}

    <ul class="collapsible popout">
        {% if books_pagination %}
        {% for book in books_pagination.items %}
        <li class="row">
            <div class="collapsible-header">
                <div class="book_spine">
                    <div class="book_actions">
                        <a href="{{url_for('edit_book', book_id=book.id)}}"><i class="material-icons blue-text text-darken-4">create</i></a>
                        <a class="modal-trigger" href="#delete_book_{{book.id}}"><i class="material-icons pink-text text-darken-1">delete_forever</i></a>
                        <i class="material-icons teal-text text-lighten-1">visibility</i>
                    </div>
                    <div id="delete_book_{{book.id}}" class="modal">
                        <div class="modal-content">
                            <h6 class="pink-text text-darken-1">Deleting Book: {{book.title}}, by {{book.author}}</h6>
                            <p>This action will permanently delete this book from your Book Repository. Are you sure you
                                wish to
                                do this?</p>
                        </div>
                        <div class="modal-footer">
                            <a href="{{url_for('delete_book', book_id=book.id)}}"
                                class="modal-close btn blue darken-4"><i class="material-icons white-text right">delete_forever</i>&nbsp;Yes</a>
                            <a href="#!" class="modal-close btn blue darken-4"><i class="material-icons white-text right">pan_tool</i>&nbsp;No</a>
                        </div>
                    </div>
                </div>
                <div class="col s12">
                    <h6><a href="https://www.amazon.co.uk/s?k={{book.ISBN}}" target="_blank" rel="noopener"
                            class="tooltipped" data-position="right" data-tooltip="Link to the book at Amazon UK.">{{book.title}}</a>, by {{book.author}}</h6>
                </div>
            </div>
            <div class="collapsible-body">
                <div class="row">
                    <div class="col s12 m4 l3 center">
                        <img src="{{book.book_thumbnail}}" alt="book image"/>
                        <p>&nbsp;</p>
                    </div>

                    <div class="col s12 m8 l9">
                        {% if book.private_view == "on" %}
                        <p>HIDDEN from Public Searches.<i class="material-icons pink-text darken-1">lock</i></p>
                        {% else %}
                        <p>SEEN in Public Searches.<i class="material-icons teal-text text-lighten-1">lock_open</i></p>
                        {% endif %}
                        <p>&nbsp;</p>
                        <p>Reader: {{book.user}}</p>
                        <p>Published: {{book.year}}</p>
                        <p>ISBN: <a href="https://isbnsearch.org/isbn/{{book.ISBN}}" target="_blank" rel="noopener" class="tooltipped" data-position="right" data-tooltip="Link to the book at ISBN Search.">{{book.ISBN}}</a></p>
                        {% if book.rating > 7 %}
                        <p>Rating: {{ book.rating }} <span class="teal lighten-1 book_spine">&nbsp;&nbsp;&nbsp;</span>
                        </p>
                        {% elif book.rating > 5 %}
                        <p>Rating: {{ book.rating }} <span class="blue darken-4 book_spine">&nbsp;&nbsp;&nbsp;</span>
                        </p>
                        {% else %}
                        <p>Rating: {{ book.rating }} <span class="pink darken-1 book_spine">&nbsp;&nbsp;&nbsp;</span>
                        </p>
                        {% endif %}
                        <p>Genre: {{book.genre}}</p>
                        <p>&nbsp;</p>
                    </div>
                    <div class="col s12 m12 l12">
                        <p>Description: {{book.short_description}}</p>
                        <br>
                        <p>Comments: {{book.comments}}</p>
                    </div>
                </div>
            </div>
        </li>
        {% endfor %}
        {% endif %}
        {% else %}
        <h4 class="container">Please add books to your Book Repository by clicking this 'Book' icon: <span><a href="{{ url_for('add_book')}}" class="blue-text btn text-darken-4 white">Add Book&nbsp;<i class="material-icons blue-text text-darken-4 right">import_contacts</i><i class="material-icons blue-text text-darken-4 right">plus_one</i></a></span></h4>
        {% endif %}
    </ul>
</div>
{% endblock %}

@app.route("/add_book")
@login_required
@app.errorhandler(CSRFError)
def add_book():
    """
    Preparing for the "C" in CRUD, filling in the add book form.
    """
    app.logger.info(f"{current_user.username} is adding a book: [INFO] - (add_book.html).")
    genre = Genre.objects()
    return render_template("add_book.html", genre=genre)


@app.route("/save_book", methods=["POST"])
@login_required
@app.errorhandler(CSRFError)
def save_book():
    """
    The "C" in CRUD, save the filled in add book form. The ISBN is used to get the book's thumbnail image from the Google Books API,
    to create the book's title link to Amazon UK, and the ISBN link to ISBN Search. If no image, the default image is used.
    """
    book = Book(
        title=request.form.get("title"),
        author=request.form.get("author"),
        year=request.form.get("year"),
        ISBN=request.form.get("isbn"),
        user=current_user.username,
        short_description=request.form.get("short_description"),
        comments=request.form.get("comments"),
        rating=request.form.get("rating"),
        genre=request.form.get("genre"),
        private_view=request.form.get("private_view")
    )

    payload = {}
    isbn_key = f"isbn:{book.ISBN}"
    payload["q"] = isbn_key
    payload["key"] = os.environ.get("GOOGLE_API_KEY")

    try:
        book_request = requests.get("https://www.googleapis.com/books/v1/volumes", params=payload, headers={'User-agent': 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:61.0) Gecko/20100101 Firefox/61.0'})
        book_thumbnail_w_http = book_request.json()["items"][0]["volumeInfo"]["imageLinks"]["thumbnail"]
        book_thumbnail_w_https = book_thumbnail_w_http.replace("http://", "https://")
        book.book_thumbnail = book_thumbnail_w_https
        app.logger.info(f"{current_user.username} has successfully requested the thumbnail image {book.book_thumbnail} for the book {book.title} with the id {book.id}: [SUCCESS] - (add_book.html).")
    except Exception:
        book.book_thumbnail = "/static/images/BR_logo_no_thumbnail.png"
        app.logger.warning(f"{current_user.username} has not successfully requested the thumbnail image for the book {book.title} with the id {book.id}: [WARNING] - (add_book.html).")

    try:
        book.save()
        flash("The book was saved!", "success")
        app.logger.info(f"{current_user.username} is saving the book {book.title} with the id {book.id}: [SUCCESS] - (add_book.html).")
    except Exception:
        flash("The book was NOT saved!", "danger")
        app.logger.warning(f"{current_user.username} did not succeed in saving the {book.title}: [FAILURE] - (add_book.html).")
    return redirect(url_for("member_page"))

{% extends "flask_user_layout.html" %}
{% block content %}
<div class="container">
    <h6>
        {% if call_or_get(current_user.is_authenticated) %}
        Home
        {% else %}
        <a href="{{ url_for('home_page')}}">Home</a>
        {% endif %}
        &nbsp; > &nbsp;<a href="{{ url_for('member_page') }}">Member's Page</a>&nbsp; > &nbsp;<a href="{{ url_for('add_book')}}">Add Book</a>&nbsp;<i class="material-icons prefix tooltipped blue-text text-darken-4" data-position="bottom" role="tooltip" data-tooltip="<p class='left-align'>Please hover over the icons on the left of each field for further help on what to do.</p><br>
        <p class='left-align'>All fields, except the Book Description, Book Comments and the Private View are mandatory to fill out.</p><br>
        <p class='left-align'>Please hover over the category icon (triangle, square, circle) to view the list of genres.</p>">help</i>

        <span class="book-dropdown right">
            <span class="white-text btn waves-effect waves-light right blue darken-4"><i
                    class="material-icons white-text">import_contacts</i></span>
            <span class="book-dropdown-content">
                <span><a href="#genre_list" class="blue-text btn text-darken-4 white modal-trigger">List
                        Genres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<i
                            class="material-icons blue-text text-darken-4 right">list</i></a></span>
            </span>
        </span>
    </h6>
    <div id="genre_list" class="modal center">
        <div class="modal-content">
            <h6>Book Repository Genre List</h6>
            <table>
                <tr class="white-text blue darken-4">
                    <th>Book Genre</th>
                    <th>Genre Description</th>
                </tr>
                {% for g in genre %}
                <tr class="{{loop.cycle('white','blue-grey lighten-5')}}">
                    <td>{{g.genre}}</td>
                    <td>{{g.description}}</td>
                </tr>
                {% endfor %}
            </table>
        </div>
        <div class="modal-footer">
            <a href="#!" class="modal-close btn waves-effect waves-light blue darken-4"><i
                    class="material-icons white-text right">done</i>&nbsp;Done!</a>
        </div>
    </div>
    <div class="row">
        <form action="{{ url_for('save_book') }}" method="POST" class="col s12">
            <input type="hidden" name="csrf_token" value="{{csrf_token()}}">
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right"
                        data-tooltip="Please enter the title of the book.">title</i>
                    <input id="title" name="title" type="text" maxlength="200" required>
                    <label for="title">Book Title</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right"
                        data-tooltip="Please enter the author's name.">person</i>
                    <input id="author" name="author" type="text" maxlength="200" required>
                    <label for="author">Book Author</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right"
                        data-tooltip="Please enter the year the book was published.">event</i>
                    <input id="year" name="year" type="number" min="1455" max="2050" required>
                    <label for="year">Book Published</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right"
                        data-tooltip="Please enter the 10 or 13 digit ISBN. It is used for external book searches and front cover image.">vpn_key</i>
                    <input id="isbn" name="isbn" type="number" max="9799999999999" required>
                    <label for="isbn">Book ISBN</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right"
                        data-tooltip="Please enter a short description of the book.">description</i>
                    <textarea id="short_description" name="short_description" maxlength="1500"
                        class="materialize-textarea"></textarea>
                    <label for="short_description">Book Description</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right"
                        data-tooltip="Please enter your thoughts, ideas, and comments about the book. Add additional comments over time.">comment</i>
                    <textarea id="comments" name="comments" maxlength="3000"
                        class="materialize-textarea"></textarea>
                    <label for="comments">Book Comments</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right"
                        data-tooltip="Please rate the  book from 1 to 10 (10 being spectacular).">poll</i>
                    <input id="rating" name="rating" type="number" min="1" max="10" required>
                    <label for="rating">Book Rating</label>
                </div>
            </div>
            <div class="row container">
                <div class="input-field col s10">
                    <i class="material-icons prefix tooltipped" data-position="right" data-tooltip="Please select a suitable genre for the book.">subject</i>
                    <select id="genre" name="genre">
                        <option disabled selected>Genre</option>
                        {% for g in genre %}
                        <option value="{{g.genre}}">{{g.genre}}</option>
                        {% endfor %}
                    </select>
                    <label hidden for="genre">Genre</label>
                </div>
                <div class="switch col s2">
                    <label for="private_view">
                        <input id="private_view" name="private_view" type="checkbox">
                        <span class="lever tooltipped" data-position="right"
                            data-tooltip="Please toggle this switch if you want to keep this book hidden from public book searches."></span>
                    </label>&nbsp;&nbsp;&nbsp;Private
                </div>
            </div>
            <div class="row button_top_padding">
                <button class="btn waves-effect waves-light" type="submit" name="action">Add Book
                    <i class="material-icons right">playlist_add</i>
                </button>
            </div>
        </form>
    </div>
</div>
{% endblock %}

@app.route("/edit_book/<book_id>")
@login_required
@app.errorhandler(CSRFError)
def edit_book(book_id):
    """
    Preparing for the "U" in CRUD, updating the book form fields. It's possible to use this link to access books not belonging to the current user,
    this has been fixed, and the culprit is warned as well as the incident logged.
    """
    book = Book.objects.get(id=book_id)
    genre = Genre.objects()
    if book.user == current_user.username:
        app.logger.info(f"{current_user.username} is updating the book {book.title} with the id {book.id}: [INFO] - (edit_book.html).")
        return render_template("edit_book.html", book=book, genre=genre)
    else:
        try:
            flash("The Librarian is on to you!", "danger")
            app.logger.critical(f"{current_user.username}, please stop 'acting the maggot', trying to update a book not belonging to you! [WARNING] (edit_book.html).")
        except ReferenceError:
            pass
        return redirect(url_for("member_page"))


@app.route("/update_book/<book_id>", methods=["POST"])
@login_required
@app.errorhandler(CSRFError)
def update_book(book_id):
    """
    The "U" in CRUD, saving the changes made to the update book form fields. The ISBN is used to get the book's thumbnail image from the Google Books API,
    to create the book's title link to Amazon UK, and the ISBN link to ISBN Search. If no image, the default image is used.
    """
    book = Book.objects.get(id=book_id)
    fields = {
        "title": request.form.get("title"),
        "author": request.form.get("author"),
        "year": request.form.get("year"),
        "ISBN": request.form.get("isbn"),
        "short_description": request.form.get("short_description"),
        "comments": request.form.get("comments"),
        "rating": request.form.get("rating"),
        "genre": request.form.get("genre"),
        "private_view": request.form.get("private_view")
    }

    if fields["private_view"] != "on":
        fields["private_view"] = "off"

    payload = {}
    isbn_field = fields["ISBN"]
    isbn_key = f"isbn:{isbn_field}"
    payload["q"] = isbn_key
    payload["key"] = os.environ.get("GOOGLE_API_KEY")

    try:
        book_request = requests.get("https://www.googleapis.com/books/v1/volumes", params=payload, headers={'User-agent': 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:61.0) Gecko/20100101 Firefox/61.0'})
        book_thumbnail_w_http = book_request.json()["items"][0]["volumeInfo"]["imageLinks"]["thumbnail"]
        book_thumbnail_w_https = book_thumbnail_w_http.replace("http://", "https://")
        fields["book_thumbnail"] = book_thumbnail_w_https
        app.logger.info(f"{current_user.username} has successfully requested the thumbnail image {book.book_thumbnail} for the book {book.title} with the id {book.id}: [SUCCESS] - (add_book.html).")
    except Exception:
        fields["book_thumbnail"] = "/static/images/BR_logo_no_thumbnail.png"
        app.logger.warning(f"{current_user.username} has not successfully requested the thumbnail image for the book {book.title} with the id {book.id}: [WARNING] (add_book.html).")

    try:
        book.update(**fields)
        flash("The book is updated!", "success")
        app.logger.info(f"{current_user.username} updated the book {book.title} with the id {book.id}: [SUCCESS] (edit_book.html).")
    except Exception:
        flash("The book was NOT updated!", "danger")
        app.logger.warning(f"{current_user.username} did not update the book {book.title} with the id {book.id}: [WARNING] (edit_book.html).")
    return redirect(url_for("member_page"))

{% extends "flask_user_layout.html" %}
{% block content %}
<div class="container">
    <h6>
        {% if call_or_get(current_user.is_authenticated) %}
        Home
        {% else %}
        <a href="{{ url_for('home_page')}}">Home</a>
        {% endif %}
        &nbsp; > &nbsp;<a href="{{ url_for('member_page') }}">Member's Page</a>&nbsp; > &nbsp;<a
            href="{{ url_for('edit_book', book_id=book.id ) }}">Edit Book</a>&nbsp;<i class="material-icons prefix tooltipped blue-text text-darken-4" data-position="bottom" role="tooltip" data-tooltip="<p class='left-align'>Please hover over the icons on the left of each field for further help on what to do.</p><br>
            <p class='left-align'>All fields, except the Book Description, Book Comments and the Private View are mandatory to fill out.</p>">help</i>
    </h6>


    <div class="row">
        <form action="{{ url_for('update_book', book_id=book.id) }}" method="POST" class="col s12">
            <input type="hidden" name="csrf_token" value="{{csrf_token()}}">
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right" data-tooltip="Please enter the title of the book.">title</i>
                    <input id="title" name="title" type="text" maxlength="200" value="{{book.title}}" required>
                    <label for="title">Book Title</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right" data-tooltip="Please enter the author's name.">person</i>
                    <input id="author" name="author" type="text" maxlength="200" value="{{book.author}}" required>
                    <label for="author">Book Author</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right" data-tooltip="Please enter the year the book was published.">event</i>
                    <input id="year" name="year" type="number" min="1455" max="2050" value="{{book.year}}" required>
                    <label for="year">Book Published</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right" data-tooltip="Please enter the 10 or 13 digit ISBN. It is used for external book searches and front cover image.">vpn_key</i>
                    <input id="isbn" name="isbn" type="number" max="9799999999999" value="{{book.ISBN}}" required>
                    <label for="isbn">Book ISBN</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right" data-tooltip="Please enter a short description of the book.">description</i>
                    <textarea id="short_description" name="short_description" maxlength="1500" class="materialize-textarea">{{book.short_description}}</textarea>
                    <label for="short_description">Book Description</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right" data-tooltip="Please enter your thoughts, ideas, and comments about the book. Add additional comments over time.">comment</i>
                    <textarea id="comments" name="comments" maxlength="3000" class="materialize-textarea">{{book.comments}}</textarea>
                    <label for="comments">Book Comments</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right" data-tooltip="Please rate the  book from 1 to 10 (10 being spectacular).">poll</i>
                    <input id="rating" name="rating" type="number" min="1" max="10" value="{{book.rating}}" required>
                    <label for="rating">Book Rating</label>
                </div>
            </div>
            <div class="row container">
                <div class="input-field col s10">
                    <i class="material-icons prefix tooltipped" data-position="right"
                        data-tooltip="Please select a suitable genre for the book.">subject</i>
                    <select id="genre" name="genre">
                        <option disabled>Select Genre</option>
                        {% for g in genre %}
                        {% if g.genre == book.genre %}
                        <option value="{{g.genre}}" selected>{{g.genre}}</option>
                        {% else %}
                        <option value="{{g.genre}}">{{g.genre}}</option>
                        {% endif %}
                        {% endfor %}
                    </select>
                    <label hidden for="genre">Genre</label>
                </div>
                <div class="switch col s2">
                    <label for="private_view">
                        {% if book.private_view == "on" %}
                        <input id="private_view" name="private_view" type="checkbox" checked>
                        {% else %}
                        <input id="private_view" name="private_view" type="checkbox">
                        {% endif%}
                        <span class="lever tooltipped" data-position="right" data-tooltip="Please toggle this switch if you want to keep this book hidden from public book searches."></span>
                    </label>&nbsp;&nbsp;&nbsp;Private
                </div>
            </div>
            <div class="row button_top_padding">
                <button class="btn waves-effect waves-light" type="submit" name="action">Update Book
                    <i class="material-icons right">playlist_add</i>
                </button>
            </div>
        </form>
    </div>
</div>
{% endblock %}

@app.route("/delete_book/<book_id>")
@login_required
def delete_book(book_id):
    """
    The "D" in CRUD, deleting the book based on 'id' after delete modal confirmation. It's possible to use this link to delete books not belonging to the current user,
    this has been fixed, and the culprit is warned as well as the incident logged.
    """
    book = Book.objects.get(id=book_id)
    if book.user == current_user.username:
        try:
            book.delete()
            flash("The book is deleted!", "success")
            app.logger.info(f"{current_user.username} deleted the book {book.title} with the id {book.id}: [SUCCESS] (members.html).")
        except ReferenceError:
            pass
        except Exception:
            flash("The book was NOT deleted!", "danger")
            app.logger.warning(f"{current_user.username} did not delete the book {book.title} with the id {book.id}: [WARNING] (members.html).")
    else:
        try:
            flash("The Librarian is on to you!", "danger")
            app.logger.critical(f"{current_user.username}, please stop 'acting the maggot', trying to delete a book not belonging to you! [WARNING] (members.html).")
        except ReferenceError:
            pass
    return redirect(url_for("member_page"))

<div class="book_actions">
                        <a href="{{url_for('edit_book', book_id=book.id)}}"><i class="material-icons blue-text text-darken-4">create</i></a>
                        <a class="modal-trigger" href="#delete_book_{{book.id}}"><i class="material-icons pink-text text-darken-1">delete_forever</i></a>
                        <i class="material-icons teal-text text-lighten-1">visibility</i>
                    </div>
                    <div id="delete_book_{{book.id}}" class="modal">
                        <div class="modal-content">
                            <h6 class="pink-text text-darken-1">Deleting Book: {{book.title}}, by {{book.author}}</h6>
                            <p>This action will permanently delete this book from your Book Repository. Are you sure you
                                wish to
                                do this?</p>
                        </div>
                        <div class="modal-footer">
                            <a href="{{url_for('delete_book', book_id=book.id)}}"
                                class="modal-close btn blue darken-4"><i class="material-icons white-text right">delete_forever</i>&nbsp;Yes</a>
                            <a href="#!" class="modal-close btn blue darken-4"><i class="material-icons white-text right">pan_tool</i>&nbsp;No</a>
                        </div>
                    </div>

@app.route("/search_book")
@login_required
@app.errorhandler(CSRFError)
def search_book():
    """
    Preparing for the book search in Book Repository, filling in the search book form.
    """
    genre = Genre.objects()
    app.logger.info(f"{current_user.username} is filling out the book search form: [INFO] - (search_book.html).")
    return render_template("search_book.html", genre=genre)


@app.route("/save_search", methods=["GET", "POST"])
@login_required
@app.errorhandler(CSRFError)
def save_search():
    """
    Save the search book results in a session cookie, to use by 'search_results' repeatedly to display the paginated search results.
    """
    fields = {
        "title": request.form.get("title"),
        "author": request.form.get("author"),
        "year": request.form.get("year"),
        "ISBN": request.form.get("isbn"),
        "short_description": request.form.get("short_description"),
        "comments": request.form.get("comments"),
        "rating": request.form.get("rating"),
        "genre": request.form.get("genre"),
        "private_view": request.form.get("private_view")
    }
    session["fields"] = fields
    app.logger.info(f"{current_user.username} is searching (saving search in session cookie) for books matching {fields}: [SUCCESS] - (search_results.html).")
    return redirect(url_for("search_results"))


@app.route("/search_results", methods=["GET", "POST"])
@app.route("/search_results/<int:page>")
@login_required
@app.errorhandler(CSRFError)
def search_results(page=1):
    """
    Book search using a combination of form fields saved in the session cookie in 'save_search', and based on the values in some key fields
    decide which Book Repository BaseQuerySet to run. As all form fields are returned as strings, the integer fields must be converted to
    integers before being used. In case of errors they are caught as exceptions and set to valid values. There are 6 BaseQuerySets.
    """
    fields = session.get("fields")

    form_title = fields["title"]
    form_author = fields["author"]
    try:
        form_isbn = int(fields["ISBN"])
    except ValueError:
        form_isbn = 0
    except TypeError:
        form_isbn = 0
    try:
        form_rating = int(fields["rating"])
    except ValueError:
        form_rating = 1
    except TypeError:
        form_rating = 0
    form_genre = fields["genre"]
    form_private_view = fields["private_view"]

    genre_list = Genre.objects()

    # Query Book Repository based on the search form data
    # Private Search "form_private_view == "on"
    if form_private_view == "on":
        if form_isbn:
            book_query_results = Book.objects.filter(user=current_user.username, ISBN=form_isbn)
            app.logger.info(f"{current_user.username} found books matching {book_query_results.count()} - 1: Private & ISBN Search: [SUCCESS] - (search_results.html).")
            book_query_results = book_query_results.paginate(page=page, per_page=7)
            return render_template("search_results.html", book_query_results=book_query_results, page_prev=(page - 1), page_next=(page + 1), genre_list=genre_list)
        elif form_genre is None:
            book_query_results = Book.objects.filter(user=current_user.username, title__icontains=form_title, author__icontains=form_author, rating__gte=form_rating).order_by("+title", "+author", "-rating")
            app.logger.info(f"{current_user.username} found books matching {book_query_results.count()} - 2: Private, no Genre, no ISBN, Title, Author, and Rating Search: [SUCCESS] - (search_results.html).")
            book_query_results = book_query_results.paginate(page=page, per_page=7)
            return render_template("search_results.html", book_query_results=book_query_results, page_prev=(page - 1), page_next=(page + 1), genre_list=genre_list)
        else:
            book_query_results = Book.objects.filter(user=current_user.username, title__icontains=form_title, author__icontains=form_author, rating__gte=form_rating, genre=form_genre).order_by("+title", "+author", "-rating")
            app.logger.info(f"{current_user.username} found books matching {book_query_results.count()} - 3: Private, no ISBN, Title, Author, Rating, and Genre Search: [SUCCESS] - (search_results.html).")
            book_query_results = book_query_results.paginate(page=page, per_page=7)
            return render_template("search_results.html", book_query_results=book_query_results, page_prev=(page - 1), page_next=(page + 1), genre_list=genre_list)
    # Public Search "form_private_view == None"
    else:
        if form_isbn:
            book_query_results = Book.objects.filter(ISBN=form_isbn, private_view="off")
            app.logger.info(f"{current_user.username} found books matching {book_query_results.count()} - 4: Public & ISBN Search: [SUCCESS] - (search_results.html).")
            book_query_results = book_query_results.paginate(page=page, per_page=7)
            return render_template("search_results.html", book_query_results=book_query_results, page_prev=(page - 1), page_next=(page + 1), genre_list=genre_list)
        elif form_genre is None:
            book_query_results = Book.objects.filter(title__icontains=form_title, author__icontains=form_author, rating__gte=form_rating, private_view="off").order_by("+title", "+author", "-rating")
            app.logger.info(f"{current_user.username} found books matching {book_query_results.count()} - 5: Public, no Genre, no ISBN, Title, Author, and Rating Search: [SUCCESS] - (search_results.html).")
            book_query_results = book_query_results.paginate(page=page, per_page=7)
            return render_template("search_results.html", book_query_results=book_query_results, page_prev=(page - 1), page_next=(page + 1), genre_list=genre_list)
        else:
            book_query_results = Book.objects.filter(title__icontains=form_title, author__icontains=form_author, rating__gte=form_rating, genre=form_genre, private_view="off").order_by("+title", "+author", "-rating")
            app.logger.info(f"{current_user.username} found books matching {book_query_results.count()} - 6: Public, no ISBN, Title, Author, Rating, and Genre Search: [SUCCESS] - (search_results.html).")
            book_query_results = book_query_results.paginate(page=page, per_page=7)
            return render_template("search_results.html", book_query_results=book_query_results, page_prev=(page - 1), page_next=(page + 1), genre_list=genre_list)

{% extends "flask_user_layout.html" %}
{% block content %}
<div class="container">
    <h6>
        {% if call_or_get(current_user.is_authenticated) %}
        Home
        {% else %}
        <a href="{{ url_for('home_page')}}">Home</a>
        {% endif %}
        &nbsp; > &nbsp;<a href="{{ url_for('member_page') }}">Member's Page</a>&nbsp; > &nbsp;<a href="{{ url_for('search_book')}}">Search Books</a>&nbsp;<i class="material-icons prefix tooltipped blue-text text-darken-4" data-position="bottom" role="tooltip" data-tooltip="<p class='left-align'>To search for a book or books, please fill in the fields below. The more information you enter, the more precise the
        search.</p><br>
        <p class='left-align'>If you enter the ISBN, then that will be the only search criteria used for the search as it’s specific (ignoring all other fields).</p><br>
        <p class='left-align'>By default, the book search will include all books in the Book Repository (except those marked private by other users).</p><br>
        <p class='left-align'>If you toggle the Private selector below, you will only search your books in the Book Repository.</p><br>
        <p class='left-align'>Selecting a Genre will limit the search to books in that genre. If you want to explore all genres, leave the Genre field as it is.</p><br>
        <p class='left-align'>You can enter a full title or the full author’s name, or only pieces of the title and the first couple of letter in the author’s name.</p><br>
        <p class='left-align'>No fields are mandatory, and leaving the form empty will display all books in the Book Repository (except those marked private by other users).</p><br>
        <p class='left-align'>Please click on SEARCH BOOKS when you are done filling in the form.</p><br>
        <p class='left-align'>Please hover over the icons on the left of each field for further help on what to do, and hover over the book icon to view the list of genres and their description.</p>">help</i>

        <span class="book-dropdown right">
            <span class="white-text btn waves-effect waves-light right blue darken-4"><i
                    class="material-icons white-text">import_contacts</i></span>
            <span class="book-dropdown-content">
                <span><a href="#genre_list" class="blue-text btn text-darken-4 white modal-trigger">List
                        Genres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<i
                            class="material-icons blue-text text-darken-4 right">list</i></a></span>
            </span>
        </span>
    </h6>
    <div id="genre_list" class="modal center">
        <div class="modal-content">
            <h6>Book Repository Genre List</h6>
            <table>
                <tr class="white-text blue darken-4">
                    <th>Book Genre</th>
                    <th>Genre Description</th>
                </tr>
                {% for g in genre %}
                <tr class="{{loop.cycle('white','blue-grey lighten-5')}}">
                    <td>{{g.genre}}</td>
                    <td>{{g.description}}</td>
                </tr>
                {% endfor %}
            </table>
        </div>
        <div class="modal-footer">
            <a href="#!" class="modal-close btn waves-effect waves-light blue darken-4"><i
                    class="material-icons white-text right">done</i>&nbsp;Done!</a>
        </div>
    </div>
    <div class="row">
        <form action="{{ url_for('save_search') }}" method="POST" class="col s12">
            <input type="hidden" name="csrf_token" value="{{csrf_token()}}">
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right"
                        data-tooltip="Please enter the title of the book, or parts of a title.">title</i>
                    <input id="title" name="title" type="text" maxlength="200">
                    <label for="title">Search Title</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right"
                        data-tooltip="Please enter the author's name, or parts of a name.">person</i>
                    <input id="author" name="author" type="text" maxlength="200">
                    <label for="author">Search Author</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right"
                        data-tooltip="Please enter the 10 or 13 digit ISBN. It is used for external book searches. When filling in this field, this is the only field that will be used as the search criteria.">vpn_key</i>
                    <input id="isbn" name="isbn" type="number" max="9799999999999">
                    <label for="isbn">Search ISBN</label>
                </div>
            </div>
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="right"
                        data-tooltip="Please enter the rating (greater than or equal to), from 1 to 10. For example, 8 will only return books with a rating of 8 or greater (8, 9, 10).">poll</i>
                    <input id="rating" name="rating" type="number" min="1" max="10">
                    <label for="rating">Search Rating</label>
                </div>
            </div>
            <div class="row container">
                <div class="input-field col s10">
                    <i class="material-icons prefix tooltipped" data-position="right" data-tooltip="Please select genre to search for.">subject</i>
                    <select id="genre" name="genre">
                        <option disabled selected>Genre</option>
                        {% for g in genre %}
                        <option value="{{g.genre}}">{{g.genre}}</option>
                        {% endfor %}
                    </select>
                    <label hidden for="genre">Genre</label>
                </div>
                <div class="switch col s2">
                    <label for="private_view">
                        <input id="private_view" name="private_view" type="checkbox">
                        <span class="lever tooltipped" data-position="right"
                            data-tooltip="Please toggle this switch if you want to search your books only."></span>
                    </label>&nbsp;&nbsp;&nbsp;Private
                </div>
            </div>
            <div class="row button_top_padding">
                <button class="btn waves-effect waves-light" type="submit" name="action">Search Books
                    <i class="material-icons right">search</i>
                </button>
            </div>
        </form>
    </div>
</div>
{% endblock %}

{% extends "flask_user_layout.html" %}
{% block content %}
<div class="container">
    <h6>
        {% if call_or_get(current_user.is_authenticated) %}
        Home
        {% else %}
        <a href="{{ url_for('home_page')}}">Home</a>
        {% endif %}
        &nbsp; > &nbsp;<a href="{{ url_for('member_page') }}">Member's Page</a>&nbsp; > &nbsp;<a
            href="{{ url_for('search_book')}}">Search Books</a>&nbsp; > &nbsp;<a
            href="{{ url_for('search_results') }}">Results Page</a>&nbsp;<i
            class="material-icons prefix tooltipped blue-text text-darken-4" data-position="bottom" role="tooltip" data-tooltip="<p class='left-align'>To view a book, click on the 'book spine' or eye icon.</p><br>
        <p class='left-align'>To edit a book's details, click on the pencil icon for the book you want to edit.</p><br>
        <p class='left-align'>To delete a book, click on the rubbish bin/dust-bin icon and answer yes or no to the question.</p><br>
        <p class='left-align'>Use the page numbers to navigate to a different page.</p><br>
        <p class='left-align'>To add a book, or search for books, click on the 'Book' icon under the navigation menu. You can also view the list of genres here.</p>">help</i>

        <span class="book-dropdown right">
            <span class="white-text btn waves-effect waves-light right blue darken-4"><i
                    class="material-icons white-text">import_contacts</i></span>
            <span class="book-dropdown-content">
                <span><a href="{{ url_for('add_book')}}" class="blue-text btn text-darken-4 white">Add Book&nbsp;<i
                            class="material-icons blue-text text-darken-4 right">import_contacts</i><i
                            class="material-icons blue-text text-darken-4 right">plus_one</i></a></span>
                <span><br>&nbsp;<br></span>
                <span><a href="{{ url_for('search_book')}}" class="blue-text btn text-darken-4 white">Search
                        Books<i class="material-icons blue-text text-darken-4 right">search</i></a></span>
                <span><br>&nbsp;<br></span>
                <span><a href="#genre_list" class="blue-text btn text-darken-4 white modal-trigger">List
                        Genres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<i class="material-icons blue-text text-darken-4 right">list</i></a></span>
            </span>
        </span>
    </h6>
    <div id="genre_list" class="modal center">
        <div class="modal-content">
            <h6>Book Repository Genre List</h6>
            <table>
                <tr class="white-text blue darken-4">
                    <th>Book Genre</th>
                    <th>Genre Description</th>
                </tr>
                {% for genre in genre_list %}
                <tr class="{{loop.cycle('white','blue-grey lighten-5')}}">
                    <td>{{genre.genre}}</td>
                    <td>{{genre.description}}</td>
                </tr>
                {% endfor %}
            </table>
        </div>
        <div class="modal-footer">
            <a href="#!" class="modal-close btn waves-effect waves-light blue darken-4"><i
                    class="material-icons white-text right">done</i>&nbsp;Done!</a>
        </div>
    </div>
    {# Macro for creating navigation links #}
    {% macro render_navigation(pagination, endpoint) %}
    <div class="pagination">Page #:
        {% if page_prev == 0 %}
        &lt;&nbsp;
        {% else %}
        <a href="{{ url_for(endpoint, page=page_prev) }}">&lt;&nbsp;</a>
        {% endif %}
        {% if pagination.has_next %}
        <a href="{{ url_for(endpoint, page=page_next) }}">&gt;&nbsp;</a>
        {% else %}
        &gt;&nbsp;
        {% endif %}
        {% for page in pagination.iter_pages() %}
        {% if page %}
        {% if page != pagination.page %}
        <a href="{{ url_for(endpoint, page=page) }}">{{ page }}</a>
        {% else %}
        <span style="background-color: #0D47A1; color: white; padding: 1px 5px;">{{ page }}</span>
        {% endif %}
        {% else %}
        <span class="ellipsis">…</span>
        {% endif %}
        {% endfor %}
    </div>
    {% endmacro %}

    {{ render_navigation(book_query_results, 'search_results') }}

    {% if book_query_results.items %}

    <ul class="collapsible popout">
        {% if book_query_results %}
        {% for book in book_query_results.items %}
        <li class="row">
            <div class="collapsible-header">
                <div class="book_spine">
                    <div class="book_actions">
                        {% if book.user !=  current_user.username %}
                        <i class="material-icons grey-text">create</i>
                        <i class="material-icons grey-text">delete_forever</i>
                        <i class="material-icons teal-text text-lighten-1">visibility</i>
                        {% else %}
                        <a href="{{url_for('edit_book', book_id=book.id)}}"><i
                                class="material-icons blue-text text-darken-4">create</i></a>
                        <a class="modal-trigger" href="#delete_book_{{book.id}}"><i
                                class="material-icons pink-text text-darken-1">delete_forever</i></a>
                        <i class="material-icons teal-text text-lighten-1">visibility</i>

                        <div id="delete_book_{{book.id}}" class="modal">
                            <div class="modal-content">
                                <h6 class="pink-text text-darken-1">Deleting Book: {{book.title}}, by {{book.author}}</h6>
                                <p>This action will permanently delete this book from your Book Repository. Are you sure
                                    you
                                    wish to
                                    do this?</p>
                            </div>
                            <div class="modal-footer">
                                <a href="{{url_for('delete_book', book_id=book.id)}}"
                                    class="modal-close btn blue darken-4"><i
                                        class="material-icons white-text">delete_forever</i>&nbsp;Yes</a>
                                <a href="#!" class="modal-close btn blue darken-4"><i
                                        class="material-icons white-text">pan_tool</i>&nbsp;No</a>
                            </div>
                        </div>
                        {% endif %}
                    </div>
                </div>
                <div class="col s12">
                    <h6><a href="https://www.amazon.co.uk/s?k={{book.ISBN}}" target="_blank" rel="noopener"
                            class="tooltipped" data-position="right" data-tooltip="Link to the book at Amazon UK.">{{book.title}}</a>, by
                        {{book.author}}</h6>
                </div>
            </div>
            <div class="collapsible-body">
                <div class="row">
                    <div class="col s12 m4 l3 center">
                        <img src="{{book.book_thumbnail}}" alt="book image" />
                        <p>&nbsp;</p>
                    </div>

                    <div class="col s12 m8 l9">
                        {% if book.private_view == "on" %}
                        <p>HIDDEN from Public Searches.<i class="material-icons pink-text darken-1">lock</i></p>
                        {% else %}
                        <p>SEEN in Public Searches.<i class="material-icons teal-text text-lighten-1">lock_open</i></p>
                        {% endif %}
                        <p>&nbsp;</p>
                        <p>Reader: {{book.user}}</p>
                        <p>Published: {{book.year}}</p>
                        <p>ISBN: <a href="https://isbnsearch.org/isbn/{{book.ISBN}}" target="_blank" rel="noopener"
                                class="tooltipped" data-position="right" data-tooltip="Link to the book at ISBN Search.">{{book.ISBN}}</a></p>
                        {% if book.rating > 7 %}
                        <p>Rating: {{ book.rating }} <span class="teal lighten-1 book_spine">&nbsp;&nbsp;&nbsp;</span>
                        </p>
                        {% elif book.rating > 5 %}
                        <p>Rating: {{ book.rating }} <span class="blue darken-4 book_spine">&nbsp;&nbsp;&nbsp;</span>
                        </p>
                        {% else %}
                        <p>Rating: {{ book.rating }} <span class="pink darken-1 book_spine">&nbsp;&nbsp;&nbsp;</span>
                        </p>
                        {% endif %}
                        <p>Genre: {{book.genre}}</p>
                        <p>&nbsp;</p>
                    </div>
                    <div class="col s12 m12 l12">
                        <p>Description: {{book.short_description}}</p>
                        <br>
                        <p>Comments: {{book.comments}}</p>
                    </div>
                </div>
            </div>
        </li>
        {% endfor %}
        {% endif %}
        {% else %}
        <h4 class="container">Your search did not find any books in the Book Repository. Please try again with new
            search parameters: <span><a href="{{ url_for('search_book')}}"
                    class="blue-text btn text-darken-4 white">Search
                    Books&nbsp;<i class="material-icons blue-text text-darken-4 right">search</i></a></span></h4>
        {% endif %}
    </ul>



</div>
{% endblock %}

@app.route("/delete_user")
@login_required
@app.errorhandler(CSRFError)
def delete_user():
    """
    Delete user, user initiated, from edit_user_profile.html. "D" in CRUD. Books are deleted too, and the user is logged out.
    """
    deleted_user = current_user.username
    find_user_books = Book.objects.filter(user=current_user.username)
    find_user = User.objects.filter(username=current_user.username)

    try:
        logout_user()
        find_user_books.delete()
        find_user.delete()
        flash("We're sad to see you go!", "success")
        app.logger.info(f"{deleted_user} has left the Book Repository: [SUCCESS] - (delete_user.html).")
    except:
        flash("Your account is still alive and active!", "danger")
        app.logger.critical(f"{deleted_user} is still alive and active on the Book Repository: [FAILURE] - (delete_user.html).")
    return redirect(url_for("home_page"))

# --- // Admin Dashboard for user management and content loading (genre and book collections).
@app.route("/admin_dashboard")
@app.route("/admin_dashboard/<int:page>")
@roles_required("Admin")
def admin_dashboard(page=1):
    """
    Admin Dashboard for user management, loading genres and sample books, and display statistics.
    """
    user_details_query = User.objects().order_by("username").paginate(page=page, per_page=10)
    user_details_query_count = User.objects.count()
    book_list = Book.objects()
    book_list_count = book_list.count()
    genre_list = Genre.objects()

    genre_dict = {}
    for book in book_list:
        if book.genre in genre_dict:
            genre_dict[f"{book.genre}"] += 1
        else:
            genre_dict[f"{book.genre}"] = 1
    tuple_in_right_order = sorted(genre_dict.items(), key=lambda kv: (kv[1], kv[0]), reverse=True)
    return render_template("admin_dashboard.html", user_details_query=user_details_query, page_prev=(page - 1), page_next=(page + 1), user_details_query_count=user_details_query_count, book_list_count=book_list_count, tuple_in_right_order=tuple_in_right_order, genre_list=genre_list)

{% extends "flask_user_layout.html" %}
{% block content %}
<div class="container">
    <h6>
        {% if call_or_get(current_user.is_authenticated) %}
        Home
        {% else %}
        <a href="{{ url_for('home_page')}}">Home</a>
        {% endif %}
        &nbsp; > &nbsp;<a href="{{ url_for('admin_dashboard') }}">Admin Page</a>&nbsp;<i
            class="material-icons prefix tooltipped blue-text text-darken-4" data-position="bottom" role="tooltip"
            data-tooltip="<p class='left-align'>USER MANAGEMENT</p><br>
        <p class='left-align'>To update a user's e-mail, or inactivate/activate their account, please click on the user link in the table.</p><br>
        <p class='left-align'>In the user modal, toggle the switch to inactive (user can't sign in)/active (user can sign in) if required. The admin account has no switch as this account must always be active.</p><br>
        <p class='left-align'>Update the relevant form fields and click on Update to save the changes or Cancel to leave the modal.</p><br>
        <p class='left-align'>To PERMANENTLY delete a user and the associated books, click on the Delete button.</p><br>
        <p class='left-align'>Admin: PLEASE note the MongoDB sort order is integers first, UPPER-CASE second, and lower-case third.</p><br>
        <p>&nbsp;</p>
        <p class='left-align'>INITIAL LOAD OF GENRES AND SAMPLE BOOKS</p><br>
        <p class='left-align'>To load book genres or a sample selection of books, please hover over the category icon (triangle, square, circle) and make your selection from the drop-down menu. You can also view the list of genres here.</p><br>
        <p>&nbsp;</p>
        <p class='left-align'>BOOK REPOSITORY STATISTICS</p><br>
        <p class='left-align'>To view Book Repository statistics, please hover over the category icon (triangle, square, circle) and click on Statistics from the drop-down menu.</p>">help</i>

        <span class="book-dropdown right">
            <span class="white-text btn waves-effect waves-light right blue darken-4"><i
                    class="material-icons white-text">category</i></span>
            <span class="book-dropdown-content">
                <span><a href="{{ url_for('load_genres')}}" class="blue-text btn text-darken-4 white">Load Genres&nbsp;&nbsp;&nbsp;<i class="material-icons blue-text text-darken-4 right">subject</i></a></span>
                <span><br>&nbsp;<br></span>
                <span><a href="{{ url_for('load_books')}}" class="blue-text btn text-darken-4 white">Load Books&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<i class="material-icons blue-text text-darken-4 right">import_contacts</i></a></span>
                <span><br>&nbsp;<br></span>
                <span><a href="#genre_list" class="blue-text btn text-darken-4 white modal-trigger">List Genres&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<i class="material-icons blue-text text-darken-4 right">list</i></a></span>
                <span><br>&nbsp;<br></span>
                <span><a href="#statistics" class="blue-text btn text-darken-4 white modal-trigger">Statistics&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<i class="material-icons blue-text text-darken-4 right">insert_chart</i></a></span>
            </span>
        </span>
    </h6>
    <div id="statistics" class="modal center">
        <div class="modal-content">
            <h6>Book Repository Statistics</h6>
            <p class="left">Number of Users: {{user_details_query_count}}</p><br>
            <p class="left">Number of Books: {{book_list_count}}</p><br><br>
            <table>
                <tr class="white-text blue darken-4">
                    <th>Book Genre</th>
                    <th>Number of Books</th>
                </tr>
                {% for key, value in tuple_in_right_order %}
                <tr class="{{loop.cycle('white','blue-grey lighten-5')}}">
                    <td>{{key}}</td>
                    <td>{{value}}</td>
                </tr>
                {% endfor %}
            </table>
        </div>
        <div class="modal-footer">
            <a href="#!" class="modal-close btn waves-effect waves-light blue darken-4"><i
                    class="material-icons white-text right">done</i>&nbsp;Done!</a>
        </div>
    </div>
    <div id="genre_list" class="modal center">
        <div class="modal-content">
            <h6>Book Repository Genre List</h6>
            <table>
                <tr class="white-text blue darken-4">
                    <th>Book Genre</th>
                    <th>Genre Description</th>
                </tr>
                {% for genre in genre_list %}
                <tr class="{{loop.cycle('white','blue-grey lighten-5')}}">
                    <td>{{genre.genre}}</td>
                    <td>{{genre.description}}</td>
                </tr>
                {% endfor %}
            </table>
        </div>
        <div class="modal-footer">
            <a href="#!" class="modal-close btn waves-effect waves-light blue darken-4"><i
                    class="material-icons white-text right">done</i>&nbsp;Done!</a>
        </div>
    </div>
    {# Macro for creating navigation links #}
    {% macro render_navigation(pagination, endpoint) %}
    <div class="pagination">Page #:
        {% if page_prev == 0 %}
        &lt;&nbsp;
        {% else %}
        <a href="{{ url_for(endpoint, page=page_prev) }}">&lt;&nbsp;</a>
        {% endif %}
        {% if pagination.has_next %}
        <a href="{{ url_for(endpoint, page=page_next) }}">&gt;&nbsp;</a>
        {% else %}
        &gt;&nbsp;
        {% endif %}
        {% for page in pagination.iter_pages() %}
        {% if page %}
        {% if page != pagination.page %}
        <a href="{{ url_for(endpoint, page=page) }}">{{ page }}</a>
        {% else %}
        <span style="background-color: #0D47A1; color: white; padding: 1px 5px;">{{ page }}</span>
        {% endif %}
        {% else %}
        <span class="ellipsis">…</span>
        {% endif %}
        {% endfor %}
    </div>
</div>
{% endmacro %}

{{ render_navigation(user_details_query, 'admin_dashboard') }}

<div class="container">
    {% if user_details_query %}
    <table>
        <tr class="white-text blue darken-4">
            <th>User</th>
            <th>Full Name</th>
            <th>Active</th>
            <th>E-mail</th>
        </tr>
        {% for user in user_details_query.items %}
        <tr class="{{loop.cycle('white','blue-grey lighten-5')}}">
            <td><a class="modal-trigger" href="#edit_user_{{user.username}}">{{user.username}}</a></td>
            <td>{{user.first_name}} {{user.last_name}}</td>
            {% if user.active is true %}
            <td class="teal-text text-lighten-1 "><i class="material-icons teal-text text-lighten-1">lock_open</i></td>
            {% else %}
            <td class="pink-text text-darken-1 "><i class="material-icons pink-text darken-1">lock</i></td>
            {% endif %}
            <td>{{user.email}}</td>
        </tr>
        {% endfor %}
    </table>
    {% endif %}
    {% for user in user_details_query.items %}
    <div id="edit_user_{{user.username}}" class="modal center">
        <div class="modal-content">
            <h6>User: {{user.username}}</h6>
            <form action="{{ url_for('update_user', user_id=user.id) }}" method="POST" class="col s12">
                <input type="hidden" name="csrf_token" value="{{csrf_token()}}">
                {% if user.username != "admin" %}
                <div class="row switch">
                    <i class="material-icons pink-text darken-1">lock</i> Inactive
                    {% if user.active == true %}
                    <label for="active_{{user.username}}">
                        <input id="active_{{user.username}}" name="active" type="checkbox" checked>
                        {% else %}
                        <label for="active_{{user.username}}">
                            <input id="active_{{user.username}}" name="active" type="checkbox">
                            {% endif%}
                            <span class="lever tooltipped" data-position="bottom"
                                data-tooltip="Please toggle this switch if you want to inactivate (grey) this user account (the user will not be able to sign in to the Book Repository)."></span>
                        </label>
                        Active <i class="material-icons teal-text text-lighten-1">lock_open</i>
                </div>
                {% endif %}
                <div class="row">
                    <div class="input-field col s12">
                        <i class="material-icons prefix tooltipped" data-position="bottom"
                            data-tooltip="Please update the first name if required.">person</i>
                        <input id="first_name_{{user.username}}" name="first_name_{{user.username}}" type="text" maxlength="250"
                            value="{{user.first_name}}" required>
                        <label for="first_name_{{user.username}}">First Name</label>
                    </div>
                    <div class="input-field col s12">
                        <i class="material-icons prefix tooltipped" data-position="bottom"
                            data-tooltip="Please update the last name if required.">group</i>
                        <input id="last_name_{{user.username}}" name="last_name_{{user.username}}" type="text" maxlength="250"
                            value="{{user.last_name}}" required>
                        <label for="last_name_{{user.username}}">Last Name</label>
                    </div>
                    <div class="input-field col s12">
                        <i class="material-icons prefix tooltipped" data-position="bottom"
                            data-tooltip="Please update the password if required. The current password is hashed ($2b$...), delete it and enter your new password if required.">vpn_key</i>
                        <input id="password_{{user.username}}" name="password_{{user.username}}" type="password" maxlength="250" value="{{user.password}}" required>
                        <label for="password_{{user.username}}">Password</label>
                    </div>
                    <div class="input-field col s12">
                        <i class="material-icons prefix tooltipped" data-position="bottom"
                            data-tooltip="Please enter the new password again for confirmation.">vpn_key</i>
                        <input id="password_conf_{{user.username}}" name="password_conf_{{user.username}}" type="password" maxlength="250"
                            value="{{user.password}}" required>
                        <label for="password_conf_{{user.username}}">Password Confirmation</label>
                    </div>
                    <div class="input-field col s12">
                        <i class="material-icons prefix tooltipped" data-position="bottom"
                            data-tooltip="Please update the e-mail address if required.">email</i>
                        <input id="email_{{user.username}}" name="email_{{user.username}}" type="email" maxlength="64" value="{{user.email}}" required>
                        <label for="email_{{user.username}}">E-mail</label>
                    </div>
                </div>
                <div class="modal-footer">
                    <div class="center">
                    {% if user.username != "admin" %}
                    
                        <a href="{{ url_for('admin_delete_user', user_id=user.id) }}"
                            class="modal-close btn waves-effect waves-light pink darken-1 tooltipped" data-position="bottom"
                            data-tooltip="This will PERMANENTLY delete the user and associated books!"><i
                                class="material-icons white-text right">delete_forever</i>&nbsp;Delete</a>
                    {% endif %}
                        <button class="btn waves-effect waves-light blue darken-4" type="submit" name="action">Update<i
                                class="material-icons right">person_add</i></button>
                        <a href="#!" class="modal-close btn waves-effect waves-light blue darken-4"><i
                                class="material-icons white-text right">pan_tool</i>&nbsp;Cancel</a>
                    </div>
                </div>
            </form>
        </div>
    </div>
    {% endfor %}
</div>
{% endblock %}

@app.route("/update_user/<user_id>", methods=["POST"])
@roles_required("Admin")
@app.errorhandler(CSRFError)
def update_user(user_id):
    """
    The "U" in CRUD, saving the changes made to the update user modal form fields.
    """
    user = User.objects.get(id=user_id)
    user_form_name = user.username
    admin_user_form = {
        "active": request.form.get("active"),
        "email": request.form.get(f"email_{user_form_name}"),
        "first_name": request.form.get(f"first_name_{user_form_name}"),
        "last_name": request.form.get(f"last_name_{user_form_name}"),
        "password": request.form.get(f"password_{user_form_name}")
    }

    # Paranoia: make sure admin account can't be set to inactive, even though the form does not allow it,
    # however the URL can be created and used anyway.
    if user.username == "admin":
        admin_user_form["active"] = True
    elif admin_user_form["active"] == "on":
        admin_user_form["active"] = True
    else:
        admin_user_form["active"] = False

    # Validate the password, checking the password to confirm password fields match = no update.
    if request.form.get(f"password_{user_form_name}") != request.form.get(f"password_conf_{user_form_name}"):
        flash("Passwords did not match!", "danger")
        return redirect(url_for("admin_dashboard"))

    # Checking if the password is accidentally changed (the current hash) and the current/original/unchanged
    # hashed password ($2b$) = set to original/current password.
    if admin_user_form["password"] == user.password and admin_user_form["password"].startswith("$2b$"):
        admin_user_form["password"] == user.password
    else:
        admin_user_form["password"] = user_manager.hash_password(admin_user_form["password"])

    try:
        user.update(**admin_user_form)
        flash("User profile updated.", "success")
        app.logger.info(f"User {user.username} profile updated by {current_user.username}: [SUCCESS] - (admin_dashboard.html).")
    except Exception:
        flash("User profile NOT updated.", "danger")
        app.logger.critical(f"User {user.username} profile NOT updated by {current_user.username}: [FAILURE] - (admin_dashboard.html).")
    return redirect(url_for("admin_dashboard"))

@app.route("/admin_delete_user/<user_id>", methods=["GET"])
@roles_required("Admin")
@app.errorhandler(CSRFError)
def admin_delete_user(user_id):
    """
    The "D" in CRUD, deleting the user based on 'id' after delete modal with NO confirmation. User 'admin' can't be deleted via the application.
    """
    user = User.objects.get(id=user_id)
    user_books = Book.objects.filter(user=user.username)

    if user.username != "admin":
        deleted_username = user.username
        try:
            user_books.delete()
            user.delete()
            flash("The user is deleted!", "success")
            app.logger.info(f"{current_user.username} deleted the user {deleted_username}: [SUCCESS] - (admin_dashboard.html).")
        except Exception:
            flash("The user was NOT deleted!", "danger")
            app.logger.critical(f"{current_user.username} did not delete the user {deleted_username}: [FAILURE] - (admin_dashboard.html).")
    return redirect(url_for("admin_dashboard"))

@app.route("/load_genres")
@roles_required("Admin")
def load_genres():
    """
    Create the Genre Collection if it does not exist. Genre descriptions taken from https://bookriot.com/guide-to-book-genres/
    First validation: Genre Collection exists. Second validation: FileNotFound ('genre.json').
    Third validation: JSONDecodeError (valid JSON format). Fourth validation: correct JSON Schema = Genre Class.
    """
    if not Genre.objects():
        try:
            with open("genre.json", "r", encoding="utf-8") as f:
                genre_dict = json.load(f)
        except FileNotFoundError:
            flash("'genre.json' can't be found.", "danger")
            app.logger.critical("Genre file can't be found. The filename is 'genre.json' and contains the Book Genres: [FAILURE] - (admin_dashboard.html).")
            return redirect(url_for("admin_dashboard"))
        except json.decoder.JSONDecodeError:
            flash("'genre.json' isn't a proper JSON file.", "danger")
            app.logger.critical("Genre file isn't a proper JSON file. Please correct the issues with the file 'genre.json' and try to load it again: [FAILURE] - (admin_dashboard.html).")
            return redirect(url_for("admin_dashboard"))

        genre_schema = {
            "type": "object",
            "properties": {
                "genre": {"type": "string"},
                "description": {"type": "string"},
            },
        }

        try:
            for genre in genre_dict:
                validate(instance=genre, schema=genre_schema)
        except ValidationError:
            genre_genre = genre["genre"]
            flash("'genre.json' has JSON Schema errors.", "danger")
            app.logger.critical(f"{current_user.username} has NOT loaded the Genre Collection to the Book Repository, 'genre.json' file has JSON Schema errors. Please correct the genre '{genre_genre}': [FAILURE] - (admin_dashboard.html).")
            return redirect(url_for("admin_dashboard"))

        try:
            genre_instances = [Genre(**data) for data in genre_dict]
            Genre.objects.insert(genre_instances, load_bulk=False)
            flash("Genres Collection created.", "success")
            app.logger.info("Genres Collection created: [SUCCESS] - (index.html)")
        except Exception:
            flash(f"Genres Collection NOT created.", "danger")
            app.logger.critical("Genres Collection NOT created: [FAILURE] - (index.html)")
        finally:
            return redirect(url_for("admin_dashboard") or url_for("home_page"))
    else:
        flash(f"Genres Collection already created.", "info")
        app.logger.info("Genres Collection already created: [INFO] - (index.html)")
        return redirect(url_for("admin_dashboard"))

@app.route("/load_books")
@roles_required("Admin")
def load_books():
    """
    Create the sample Book Collection if it does not exist. First validation: Book Collection exists. Second validation: FileNotFound ('book.json').
    Third validation: JSONDecodeError (valid JSON format). Fourth validation: correct JSON Schema = Book Class.
    """
    if not Book.objects():
        try:
            with open("book.json", "r", encoding="utf-8") as f:
                book_dict = json.load(f)
        except FileNotFoundError:
            flash("'book.json' can't be found.", "danger")
            app.logger.critical("Book file can't be found. The filename is 'book.json' and contains sample Books: [FAILURE] - (admin_dashboard.html).")
        except json.decoder.JSONDecodeError:
            flash("'book.json' isn't a proper JSON file.", "danger")
            app.logger.critical("Book file isn't a proper JSON file. Please correct the issues with the file 'book.json' and try to load it again: [FAILURE] - (admin_dashboard.html).")
            return redirect(url_for("admin_dashboard"))

        book_schema = {
            "type": "object",
            "properties": {
                "title": {"type": "string"},
                "author": {"type": "string"},
                "year": {"type": "number"},
                "ISBN": {"type": "number"},
                "user": {"type": "string"},
                "short_description": {"type": "string"},
                "comments": {"type": "string"},
                "rating": {"type": "number"},
                "genre": {"type": "string"},
                "private_view": {"type": "string"},
                "book_thumbnail": {"type": "string"},
            },
        }

        try:
            for book in book_dict:
                validate(instance=book, schema=book_schema)
        except ValidationError:
            book_title = book["title"]
            flash("'book.json' has JSON Schema errors.", "danger")
            app.logger.critical(f"{current_user.username} has NOT loaded the Book Collection to the Book Repository, 'book.json' file has JSON Schema errors. Please correct the book '{book_title}': [FAILURE] - (admin_dashboard.html).")
            return redirect(url_for("admin_dashboard"))

        try:
            book_instances = [Book(**data) for data in book_dict]
            Book.objects.insert(book_instances, load_bulk=False)
            flash("Book Collection created.", "success")
            app.logger.info(f"{current_user.username} has successfully loaded the Book Collection to the Book Repository: [SUCCESS] - (admin_dashboard.html).")
        except Exception:
            flash(f"Book Collection NOT created.", "danger")
            app.logger.critical(f"{current_user.username} has NOT loaded the Book Collection to the Book Repository: [FAILURE] - (admin_dashboard.html).")
        finally:
            return redirect(url_for("admin_dashboard") or url_for("home_page"))
    else:
        flash(f"Sample Book Collection already created.", "info")
        app.logger.info("Sample Book Collection already created: [INFO] - (index.html)")
        return redirect(url_for("admin_dashboard"))

# --- // Error Handlers for 400 CSRF Error (Bad Request), 404 Page Not Found, 405 Method Not Allowed, and 500 Internal Server Error.
@app.errorhandler(CSRFError)
def handle_csrf_error(error):
    excuse = "Apologies, the Librarian Security Detail have omitted to secure this page! We're calling them back from their lunch-break to fix this. Please click on the pink pulsating buoy to go to the Home Page (registering or signing in) or Member's Page (signed in), or click on Sign Out below."
    try:
        app.logger.critical(f"{current_user.username} has encountered a 400 CSRF Error (Bad Request), {error.description}: [FAILURE].")
    except AttributeError:
        app.logger.critical(f"Unauthenticated user has encountered a 400 CSRF Error (Bad Request), {error.description}: [FAILURE].")
    finally:
        return render_template("oops.html", error=error.description, excuse=excuse, error_type="Client: 400 - Bad Request")


@app.errorhandler(404)
def not_found(error):
    excuse = "Apologies, our Librarians are lost in the Library or have lost the book you're looking for! Please click on the pink pulsating buoy to go to the Home Page (registering or signing in) or Member's Page (signed in), or click on Sign Out below."
    try:
        app.logger.critical(f"{current_user.username} has encountered a 404 Page Not Found Error, {error}: [FAILURE].")
    except AttributeError:
        app.logger.critical(f"Unauthenticated user has encountered a 404 Page Not Found Error, {error}: [FAILURE].")
    finally:
        return render_template("oops.html", error=error, excuse=excuse, error_type="Client: 404 - Page Not Found")


@app.errorhandler(405)
def not_found(error):
    excuse = "Apologies, our Librarians won't allow you to do this! Please click on the pink pulsating buoy to go to the Home Page (registering or signing in) or Member's Page (signed in), or click on Sign Out below."
    try:
        app.logger.critical(f"{current_user.username} has encountered a 405 Method Not Allowed Error, {error}: [FAILURE].")
    except AttributeError:
        app.logger.critical(f"Unauthenticated user has encountered a 405 Method Not Allowed Error, {error}: [FAILURE].")
    finally:
        return render_template("oops.html", error=error, excuse=excuse, error_type="Client: 405 - Method Not Allowed")


@app.errorhandler(500)
def internal_error(error):
    excuse = "Apologies, something serious occurred and the Librarians are working on resolving the issue! This section is cordoned off for now. Please click on the pink pulsating buoy to go to the Home Page (registering or signing in) or Member's Page (signed in), or click on Sign Out below."
    try:
        app.logger.critical(f"{current_user.username} has encountered a 500 Internal Server Error, {error}: [FAILURE].")
    except AttributeError:
        app.logger.critical(f"Unauthenticated user has encountered a 500 Internal Server Error, {error}: [FAILURE].")
    finally:
        return render_template("oops.html", error=error, excuse=excuse, error_type="Server: 500 - Internal Server Error")

{% extends "flask_user_layout.html" %}
{% block content %}
<div class="container">
    <div class="row">
        <div class="col s12 offset-m1 m10 offset-l1 l10">
            <div class="card center">
                <div class="card-image">
                    <img src="/static/images/fred-kearney-enkfvvZkKv0-unsplash.jpg" alt="burning book">
                    <a href="{{ url_for('home_page')}}" class="halfway-fab btn-floating pink pink-darken-1 pulse">
                        <i class="material-icons">support</i>
                    </a>
                </div>
                <div class="card-content">
                    <span class="card-title pink-text text-darken-1">{{error_type}}</span>
                    <p>{{excuse}}</p>
                    <p>&nbsp;</p>
                    <p>Book Repository Message - {{error}}</p>
                </div>
                <div class="card-action">
                    <a href="{{ url_for('user.logout') }}">[ Sign Out <i class="material-icons">pan_tool</i> ]</a>
                </div>
            </div>
        </div>
    </div>
</div>
{% endblock %}

class User(db.Document, UserMixin):
    # Active set to True to allow login of user
    active = db.BooleanField(default=True)

    # User authentication information
    username = db.StringField(default="")
    password = db.StringField()

    # User information
    first_name = db.StringField(default="")
    last_name = db.StringField(default="")
    email = db.StringField(default="")
    email_confirmed_at = db.DateTimeField()
    # Required for the e-mail confirmation, and subsequent login.

    # Relationships  (Roles: user or user and Admin)
    roles = db.ListField(db.StringField(), default=["user"])

    meta = {
        "auto_create_index": True,
        "index_background": True,
        "indexes": ["username"]
    }

import os
from datetime import timedelta

from dotenv import load_dotenv
from pathlib import Path
env_path = Path(".") / ".env"
load_dotenv(dotenv_path=env_path)


class ConfigClass(object):
    """ Flask application config """
    # Flask settings
    SECRET_KEY = os.environ.get("SECRET_KEY")

    # Flask-MongoEngine settings
    MONGO_DB_URL = os.environ.get("MONGO_URI_BR")
    MONGODB_SETTINGS = {
        'host': MONGO_DB_URL
    }

    # Flask-User settings
    # Shown in email templates and page footers
    USER_APP_NAME = "Book Repository"
    USER_ENABLE_EMAIL = True      # Enable email authentication
    USER_ENABLE_USERNAME = True    # Enable username authentication
    USER_ENABLE_CONFIRM_EMAIL = True  # Enable email after registration
    USER_ENABLE_FORGOT_PASSWORD = True # Enable email after forgot password
    USER_ENABLE_CHANGE_PASSWORD = True # Enable email after password change
    USER_SEND_PASSWORD_CHANGED_EMAIL = True # Enable email after password change
    USER_REQUIRE_RETYPE_PASSWORD = True
    USER_ENABLE_CHANGE_USERNAME = False

    MAIL_SERVER = os.environ.get("MAIL_SERVER")
    MAIL_PORT = os.environ.get("MAIL_PORT")
    # TLS Port: 587, SSL Port: 465 --> TLS or SSL: True/False
    MAIL_USERNAME = os.environ.get("MAIL_USERNAME")
    MAIL_PASSWORD = os.environ.get("MAIL_PASSWORD")
    MAIL_USE_TLS = True
    MAIL_USE_SSL = False
    USER_EMAIL_SENDER_EMAIL = os.environ.get("USER_EMAIL_SENDER_EMAIL")

    # Flask Session Configuration for Session Protection and "Remember Me" function
    SESSION_PROTECTION = "strong"
    REMEMBER_COOKIE_DURATION = timedelta(seconds=3600) # Logged out after 1 hour (come back in without logging in too)
    SESSION_COOKIE_SECURE = True

    # Flask User Manager Configuration
    USER_COPYRIGHT_YEAR = 2020
    USER_CORPORATION_NAME = "GaffCo Consulting"

{% extends 'flask_user/_public_base.html' %}

{% block content %}
{% from "flask_user/_macros.html" import render_field, render_submit_field %}
<h6><a href="{{ url_for('home_page')}}">Home</a>&nbsp; > &nbsp;<a
        href="{{ url_for('user.register') }}">Register</a>&nbsp;<i
        class="material-icons prefix tooltipped blue-text text-darken-4" data-position="bottom"
        data-tooltip="<p class='left-align'>Please enter your username (Username) using 250 characters or less. Letters, digits and @ . + - _ only.</p><br><p class='left-align'>Please enter your email address (Email), for example '[email protected]'.</p><br><p class='left-align'>Please enter a password (Password) longer than 8 characters, using a mixture of numbers and letters, and ideally one or more special characters.</p><br><p class='left-align'>Password confirmation: Please enter the same password (Retype Password) again for verification.</p>">help</i>
</h6>


<form method="POST" novalidate class="form">
    <div class="field_top_padding">
        {{ form.hidden_tag() }}
        {% set field = form.username if user_manager.USER_ENABLE_USERNAME else form.email %}
        <div class="form-group {% if field.errors %}has-error{% endif %}">
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="bottom"
                        data-tooltip="Please enter your username.">person</i>
                    {{ field(class_='form-control') }}
                    <label for="{{ field.id }}" class="control-label">{{ field.label.text }}</label>
                    {% if field.errors %}
                    {% for e in field.errors %}
                    <p class="help-block">{{ e }}</p>
                    {% endfor %}
                    {% endif %}
                </div>
            </div>
        </div>

        {% if user_manager.USER_ENABLE_EMAIL and user_manager.USER_ENABLE_USERNAME %}
        {{ render_field(form.email) }}
        {% endif %}

        {{ render_field(form.password) }}

        {% if user_manager.USER_REQUIRE_RETYPE_PASSWORD %}
        {{ render_field(form.retype_password) }}
        {% endif %}

        <div class="button_top_padding">
            <button class="btn waves-effect waves-light" type="submit" name="action">Register
                <i class="material-icons right">how_to_reg</i>
            </button>
        </div>
    </div>
</form>
<br>
{% if user_manager.USER_ENABLE_REGISTER %}
<p><a href="{{ url_for('user.login') }}">Already registered? Sign in.</a></p>
{% endif %}
{% endblock %}

class User(db.Document, UserMixin):
    # Active set to True to allow login of user
    active = db.BooleanField(default=True)

    # User authentication information
    username = db.StringField(default="")
    password = db.StringField()

    # User information
    first_name = db.StringField(default="")
    last_name = db.StringField(default="")
    email = db.StringField(default="")
    email_confirmed_at = db.DateTimeField()
    # Required for the e-mail confirmation, and subsequent login.

    # Relationships  (Roles: user or user and Admin)
    roles = db.ListField(db.StringField(), default=["user"])

    meta = {
        "auto_create_index": True,
        "index_background": True,
        "indexes": ["username"]
    }

import os
from datetime import timedelta

from dotenv import load_dotenv
from pathlib import Path
env_path = Path(".") / ".env"
load_dotenv(dotenv_path=env_path)


class ConfigClass(object):
    """ Flask application config """
    # Flask settings
    SECRET_KEY = os.environ.get("SECRET_KEY")

    # Flask-MongoEngine settings
    MONGO_DB_URL = os.environ.get("MONGO_URI_BR")
    MONGODB_SETTINGS = {
        'host': MONGO_DB_URL
    }

    # Flask-User settings
    # Shown in email templates and page footers
    USER_APP_NAME = "Book Repository"
    USER_ENABLE_EMAIL = True      # Enable email authentication
    USER_ENABLE_USERNAME = True    # Enable username authentication
    USER_ENABLE_CONFIRM_EMAIL = True  # Enable email after registration
    USER_ENABLE_FORGOT_PASSWORD = True # Enable email after forgot password
    USER_ENABLE_CHANGE_PASSWORD = True # Enable email after password change
    USER_SEND_PASSWORD_CHANGED_EMAIL = True # Enable email after password change
    USER_REQUIRE_RETYPE_PASSWORD = True
    USER_ENABLE_CHANGE_USERNAME = False

    MAIL_SERVER = os.environ.get("MAIL_SERVER")
    MAIL_PORT = os.environ.get("MAIL_PORT")
    # TLS Port: 587, SSL Port: 465 --> TLS or SSL: True/False
    MAIL_USERNAME = os.environ.get("MAIL_USERNAME")
    MAIL_PASSWORD = os.environ.get("MAIL_PASSWORD")
    MAIL_USE_TLS = True
    MAIL_USE_SSL = False
    USER_EMAIL_SENDER_EMAIL = os.environ.get("USER_EMAIL_SENDER_EMAIL")

    # Flask Session Configuration for Session Protection and "Remember Me" function
    SESSION_PROTECTION = "strong"
    REMEMBER_COOKIE_DURATION = timedelta(seconds=3600) # Logged out after 1 hour (come back in without logging in too)
    SESSION_COOKIE_SECURE = True

    # Flask User Manager Configuration
    USER_COPYRIGHT_YEAR = 2020
    USER_CORPORATION_NAME = "GaffCo Consulting"

{% extends 'flask_user/_public_base.html' %}

{% block content %}
{% from "flask_user/_macros.html" import render_field, render_checkbox_field, render_submit_field %}
<h6><a href="{{ url_for('home_page')}}">Home</a>&nbsp; > &nbsp;<a href="{{ url_for('user.login') }}">Sign In
        Page</a>&nbsp;<i class="material-icons prefix tooltipped blue-text text-darken-4" data-position="bottom"
        role="tooltip"
        data-tooltip="<p class='left-align'>Please enter your username or email (Username or Email), followed by your password (Password), the same ones you used when you registered.</p><br><p class='left-align'>Please click the checkbox (Remember Me) if you want to remain logged in.</p><br><p class='left-align'>Click on the SIGN IN button when done filling in the username and password fields.</p>">help</i>
</h6>
<form method="POST" class="form">
    {{ form.hidden_tag() }}

    {# Username or Email field #}
    {% set field = form.username if user_manager.USER_ENABLE_USERNAME else form.email %}
    <div class="field_top_padding">
        <div class="form-group {% if field.errors %}has-error{% endif %}">
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="bottom"
                        data-tooltip="Please enter your username or email.">person</i>
                    {{ field(class_='form-control') }}
                    <label for="{{ field.id }}" class="control-label">{{ field.label.text }}</label>
                    {% if field.errors %}
                    {% for e in field.errors %}
                    <p class="help-block">{{ e }}</p>
                    {% endfor %}
                    {% endif %}
                </div>
            </div>
        </div>
    </div>

    {# Password field #}
    {% set field = form.password %}
    <div class="field_top_padding">
        <div class="form-group {% if field.errors %}has-error{% endif %}">
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="bottom"
                        data-tooltip="Please enter your password.">vpn_key</i>
                    {{ field(class_='form-control') }}
                    <label for="{{ field.id }}" class="control-label">{{ field.label.text }}</label>
                    {% if field.errors %}
                    {% for e in field.errors %}
                    <p class="help-block">{{ e }}</p>
                    {% endfor %}
                    {% endif %}
                </div>
            </div>
        </div>
    </div>

    {# Remember me #}
    {% if user_manager.USER_ENABLE_REMEMBER_ME %}
    <div class="field_top_padding">
        <div class="row">
            <div class="col s12">
                <i class="material-icons prefix tooltipped" data-position="bottom"
                    data-tooltip="Please click the checkbox (Remember Me) if you want to remain logged in.">bookmark</i>
                <label id="remember_me_label">Remember Me&nbsp;
                    <input id="remember_me" name="remember_me" type="checkbox" /><span></span>
                </label>
            </div>
        </div>
    </div>
    {% endif %}

    <div class="button_top_padding">
        <button class="btn waves-effect waves-light" type="submit" name="action">Sign In
            <i class="material-icons right">login</i>
        </button>
    </div>
</form>
<br>
{% if user_manager.USER_ENABLE_REGISTER and not user_manager.USER_REQUIRE_INVITATION %}
<p><a href="{{ url_for('user.register') }}">New here? Register.</a></p>
{% endif %}
{% if user_manager.USER_ENABLE_FORGOT_PASSWORD %}
<p><a href="{{ url_for('user.forgot_password') }}">Forgot your Password?</a></p>
{% endif %}
{% endblock %}

class User(db.Document, UserMixin):
    # Active set to True to allow login of user
    active = db.BooleanField(default=True)

    # User authentication information
    username = db.StringField(default="")
    password = db.StringField()

    # User information
    first_name = db.StringField(default="")
    last_name = db.StringField(default="")
    email = db.StringField(default="")
    email_confirmed_at = db.DateTimeField()
    # Required for the e-mail confirmation, and subsequent login.

    # Relationships  (Roles: user or user and Admin)
    roles = db.ListField(db.StringField(), default=["user"])

    meta = {
        "auto_create_index": True,
        "index_background": True,
        "indexes": ["username"]
    }

import os
from datetime import timedelta

from dotenv import load_dotenv
from pathlib import Path
env_path = Path(".") / ".env"
load_dotenv(dotenv_path=env_path)


class ConfigClass(object):
    """ Flask application config """
    # Flask settings
    SECRET_KEY = os.environ.get("SECRET_KEY")

    # Flask-MongoEngine settings
    MONGO_DB_URL = os.environ.get("MONGO_URI_BR")
    MONGODB_SETTINGS = {
        'host': MONGO_DB_URL
    }

    # Flask-User settings
    # Shown in email templates and page footers
    USER_APP_NAME = "Book Repository"
    USER_ENABLE_EMAIL = True      # Enable email authentication
    USER_ENABLE_USERNAME = True    # Enable username authentication
    USER_ENABLE_CONFIRM_EMAIL = True  # Enable email after registration
    USER_ENABLE_FORGOT_PASSWORD = True # Enable email after forgot password
    USER_ENABLE_CHANGE_PASSWORD = True # Enable email after password change
    USER_SEND_PASSWORD_CHANGED_EMAIL = True # Enable email after password change
    USER_REQUIRE_RETYPE_PASSWORD = True
    USER_ENABLE_CHANGE_USERNAME = False

    MAIL_SERVER = os.environ.get("MAIL_SERVER")
    MAIL_PORT = os.environ.get("MAIL_PORT")
    # TLS Port: 587, SSL Port: 465 --> TLS or SSL: True/False
    MAIL_USERNAME = os.environ.get("MAIL_USERNAME")
    MAIL_PASSWORD = os.environ.get("MAIL_PASSWORD")
    MAIL_USE_TLS = True
    MAIL_USE_SSL = False
    USER_EMAIL_SENDER_EMAIL = os.environ.get("USER_EMAIL_SENDER_EMAIL")

    # Flask Session Configuration for Session Protection and "Remember Me" function
    SESSION_PROTECTION = "strong"
    REMEMBER_COOKIE_DURATION = timedelta(seconds=3600) # Logged out after 1 hour (come back in without logging in too)
    SESSION_COOKIE_SECURE = True

    # Flask User Manager Configuration
    USER_COPYRIGHT_YEAR = 2020
    USER_CORPORATION_NAME = "GaffCo Consulting"

{% extends 'flask_user/_authorized_base.html' %}

{% block content %}
{% from "flask_user/_macros.html" import render_field, render_checkbox_field, render_submit_field %}

<h6>
    {% if call_or_get(current_user.is_authenticated) %}
    Home
    {% else %}
    <a href="{{ url_for('home_page')}}">Home</a>
    {% endif %}
    &nbsp; > &nbsp;<a href="{{ url_for('member_page') }}">Member's Page</a>&nbsp; > &nbsp;<a
        href="{{ url_for('user.edit_user_profile') }}">User Profile:
        {{ current_user.username or current_user.email }}</a>&nbsp;<i
        class="material-icons prefix tooltipped blue-text text-darken-4" data-position="bottom"
        data-tooltip="<p class='left-align'>Please enter your first (First Name) and last name (Last Name) in the fields below, and then click on the UPDATE button when you are done.</p>">help</i>
</h6>

<form method="POST" class="form">
    {{ form.hidden_tag() }}
    <div class="field_top_padding">
        <div class="form-group">
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="bottom"
                        data-tooltip="Please enter your first name.">person</i>
                    <input class="form-control" id="first_name" name="first_name" required="" type="text"
                        value="{{current_user.first_name}}">
                    <label for="first_name" class="control-label active">First Name</label>
                </div>
            </div>
        </div>
    </div>
    <div class="field_top_padding">
        <div class="form-group">
            <div class="row">
                <div class="input-field col s12">
                    <i class="material-icons prefix tooltipped" data-position="bottom"
                        data-tooltip="Please enter your last name/surname.">group</i>
                    <input class="form-control" id="last_name" name="last_name" required="" type="text"
                        value="{{current_user.last_name}}">
                    <label for="last_name" class="control-label active">Last Name</label>
                </div>
            </div>
        </div>
    </div>
    <div class="button_top_padding">
        <button class="btn waves-effect waves-light" type="submit" name="action">Update
            <i class="material-icons right">person_add</i>
        </button>
    </div>
</form>
<br>

{% if not user_manager.USER_ENABLE_AUTH0 %}
{% if user_manager.USER_ENABLE_CHANGE_USERNAME %}
<p><a href="{{ url_for('user.change_username') }}">Change Username</a></p>
{% endif %}
{% if user_manager.USER_ENABLE_CHANGE_PASSWORD %}
<p><a href="{{ url_for('user.change_password') }}">Change Password</a></p>
{% endif %}
{% endif %}
{% if current_user.username != "admin" %}
<a class="modal-trigger pink-text text-darken-1" href="#delete_user">Delete User</a>
<div id="delete_user" class="modal">
    <div class="modal-content center">
        <h6 class="pink-text text-darken-1">Deleting your User account and all your Books: {{current_user.username}}
        </h6>
        <p>This action will permanently delete your User account and all your Books from the Book Repository. Are you
            sure you wish to do this?</p>
    </div>
    <div class="modal-footer">
        <a href="{{ url_for('delete_user') }}" class="modal-close btn blue darken-4"><i
                class="material-icons white-text right">delete_forever</i>&nbsp;Yes</a>
        <a href="#!" class="modal-close btn blue darken-4"><i
                class="material-icons white-text right">pan_tool</i>&nbsp;No</a>
    </div>
</div>
{% endif %}
{% endblock %}

@import url('https://fonts.googleapis.com/css?family=Raleway|&display=swap');

/* --- // Main Styling and Layout */
/* Reset values */
* {
    margin: 0;
    padding: 0;
    border: 0;
    box-sizing: border-box;
}

/* Use Raleway font throughout the site, and provide room for the scrolling under the fixed nav-bar and footer */
html,
body {
    font-family: 'Raleway', sans-serif;
    margin-top: 35px;
    margin-bottom: 50px;
}

/* Background image setting */
html {
    background: url("/static/images/sharon-mccutcheon-eMP4sYPJ9x0-unsplash.jpg") no-repeat center center fixed;
    /* Photo by <a href="https://unsplash.com/@sharonmccutcheon?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Sharon McCutcheon</a> */
    -webkit-background-size: cover;
    -moz-background-size: cover;
    -o-background-size: cover;
    background-size: cover;
}

.landing_logo {
    width: 100%;
}

.landing_page {
    background: rgba(255, 255, 255, 0.5);
    padding: 10px;
}

/* <a href... */
a {
    color: #0D47A1;
}

/* Pagination styling to suit <H6> above on the 'members.html' page */
.pagination {
    font-size: 1.15rem;
    line-height: 110%;
    margin-bottom: 1rem;
}

/* --- // Navigation Bar, Hamburger-bar, and Fixed Footer Styling and Layout */
/* Navigation Bar: fixed and MaterializeCSS styling. */
nav {
    overflow: hidden;
    position: fixed;
    top: 0;
    z-index: 10;
}

.sidenav {
    width: 230px;
}

/* Footer: fixed footer and MaterializeCSS styling. Using box-shadow (in reverse) from the MaterializeCSS navbar class. */
footer {
    position: fixed;
    left: 0;
    bottom: 0;
    width: 100%;
    background-color: #0D47A1;
    color: #FFFFFF;
    text-align: center;
}

.footer-copyright {
    -webkit-box-shadow: 0 -2px 0 rgba(0, 0, 0, 0.14), 0 -3px 1px 0 rgba(0, 0, 0, 0.12), 0 -1px 5px 0 rgba(0, 0, 0, 0.2);
    -moz-box-shadow: 0 -2px 0 rgba(0, 0, 0, 0.14), 0 -3px 1px 0 rgba(0, 0, 0, 0.12), 0 -1px 5px 0 rgba(0, 0, 0, 0.2);
    box-shadow: 0 -2px 0 rgba(0, 0, 0, 0.14), 0 -3px 1px 0 rgba(0, 0, 0, 0.12), 0 -1px 5px 0 rgba(0, 0, 0, 0.2);
}

.page-footer,
.footer-copyright {
    padding: 0px;
    z-index: 10;
}

#menu_book {
    transform: scale(1.2);
    padding: 0px 2px;
}

footer .left-align {
    padding-left: 15%;
}

footer .right-align {
    padding-right: 15%;
}

/* --- // Modal Colour Schemes to match the Book Repository UX Design */
.modal,
.modal-footer {
    font-family: 'Raleway', sans-serif;
    color: #0D47A1;
}

.page-footer,
.tabs .indicator {
    background-color: #0D47A1;
}

.tab_content_heading {
    padding: 10px 0px;
}

/* --- // Message Chips (Flask, MaterializeCSS 1.0.0, custom CSS 3, and a JS Timeout function = Flask Flash Messages) */
.message-success {
    color: #FFFFFF;
    background-color: #26A69A;
}

.message-info {
    color: #FFFFFF;
    background-color: #37474F;
}

.message-warning {
    color: #FFFFFF;
    background-color: orange;
}

.message-danger {
    color: #FFFFFF;
    background-color: #d81b60;
}

.help-block {
    color: #FFFFFF;
    background-color: #d81b60;
}

/* --- // Book Spine background-image for the Member's Page */
.collapsible-header {
    background-image: url("/static/images/christian-wiediger-GWucxGZvO-w-unsplash.jpg");
    /* Photo by <a href="https://unsplash.com/@christianw?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Christian Wiediger</a> */
    background-position: 95% 55%;
    background-size: 150%
}

.collapsible-body {
    background: rgba(255, 255, 255, 0.5);
}

.book_spine {
    text-align: center;
}

.book_actions {
    padding: 10px 0px 0px 10px;
}

/* ---// Form Fields and Buttons Styling */
/* Remember Me Label */
#remember_me_label {
    font-size: 1rem;
    color: #000000;
    margin-left: 15px;
}

label {
    color: #000000;
}

/* "Breathing space between the submit/register/login buttons, the fields and the forms */
.button_top_padding,
.field_top_padding {
    padding-top: 1rem;
}

.btn {
    background-color: #0d47a1;
}

.btn:hover,
.btn:focus {
    background-color: #0c4091;
}

/* --- // Taken from 'materialize.css' (1.0.0) to style the input fields to match the Book Repository UX Design */
/* Checkbox when selected is the same colour as the rest of the form elements */
[type="checkbox"]:checked+span:not(.lever):before {
    border-right: 2px solid #0d47a1;
    border-bottom: 2px solid #0d47a1;
}

input:not([type]):focus:not([readonly]),
input[type=text]:not(.browser-default):focus:not([readonly]),
input[type=password]:not(.browser-default):focus:not([readonly]),
input[type=email]:not(.browser-default):focus:not([readonly]),
input[type=url]:not(.browser-default):focus:not([readonly]),
input[type=time]:not(.browser-default):focus:not([readonly]),
input[type=date]:not(.browser-default):focus:not([readonly]),
input[type=datetime]:not(.browser-default):focus:not([readonly]),
input[type=datetime-local]:not(.browser-default):focus:not([readonly]),
input[type=tel]:not(.browser-default):focus:not([readonly]),
input[type=number]:not(.browser-default):focus:not([readonly]),
input[type=search]:not(.browser-default):focus:not([readonly]),
textarea.materialize-textarea:focus:not([readonly]) {
    border-bottom: 1px solid #0d47a1;
    -webkit-box-shadow: 0 1px 0 0 #0d47a1;
    box-shadow: 0 1px 0 0 #0d47a1;
}

input:not([type]):focus:not([readonly])+label,
input[type=text]:not(.browser-default):focus:not([readonly])+label,
input[type=password]:not(.browser-default):focus:not([readonly])+label,
input[type=email]:not(.browser-default):focus:not([readonly])+label,
input[type=url]:not(.browser-default):focus:not([readonly])+label,
input[type=time]:not(.browser-default):focus:not([readonly])+label,
input[type=date]:not(.browser-default):focus:not([readonly])+label,
input[type=datetime]:not(.browser-default):focus:not([readonly])+label,
input[type=datetime-local]:not(.browser-default):focus:not([readonly])+label,
input[type=tel]:not(.browser-default):focus:not([readonly])+label,
input[type=number]:not(.browser-default):focus:not([readonly])+label,
input[type=search]:not(.browser-default):focus:not([readonly])+label,
textarea.materialize-textarea:focus:not([readonly])+label {
    color: #0d47a1;
}

.input-field .prefix.active {
    color: #0d47a1;
}

.switch label input[type=checkbox]:checked+.lever {
    background-color: #0c4091;
}

.switch label input[type=checkbox]:checked+.lever:after {
    background-color: #ffffff;
}

.input-field>label {
    color: #000000;
}

.dropdown-content li>a,
.dropdown-content li>span {
    color: #0d47a1;
}

.select-wrapper input.select-dropdown:focus {
    border-bottom: 2px solid #0d47a1;
}

.select-wrapper .prefix.active {
    color: #0D47A1;
}

/* Active Label on the Register Page and Jinja render for Flask-User and error handling */
.input-field>label:not(.label-icon).active {
    color: #0D47A1;
}

/* --- // W3Schools Drop-Down Menu for the Member's, Search Results, and Admin Pages */
.book-dropdown {
    position: relative;
    display: inline-block;
    list-style-type: none;
    padding-top: 12px;
}

.book-dropdown-content {
    display: none;
    position: absolute;
    background-color: #ffffff;
    min-width: 216px;
    box-shadow: 0px 8px 16px 0px rgba(0, 0, 0, 0.2);
    padding: 12px 16px;
    z-index: 10;
    right: 0;
}

.book-dropdown:hover .book-dropdown-content {
    display: block;
}

window.cookieconsent.initialise({
    "palette": {
        "popup": {
            "background": "#ffffff",
            "text": "#0d47a1"
        },
        "button": {
            "background": "#0d47a1",
            "text": "#ffffff"
        }
    },
    "position": "bottom-right",
    "content": {
        "message": "The Book Repository uses 🍪🍪 (cookies), solely for the purpose of session management (user registration, login, and access to restricted areas), and are a requirement to use the Book Repository.<br><br>No information is shared with third parties.<br><br>All 🍪🍪 (cookies) are deleted after the browser is closed.<br><br>",
        "dismiss": "I understand and agree!",
        "link": "I want to know more!"
    }
});

document.addEventListener("DOMContentLoaded", () => {
    M.AutoInit();
});

// Timeout Chip: handles multiple Flask flash messages.
setTimeout(()=> {
    chip_message = document.getElementsByClassName("chip");

    for (let i = 0; i < chip_message.length; i++) {
        chip_message[i].style.display="none";
    }
}, 5000);

# Generated by Selenium IDE and modified by Gaff
import pytest
import time
import json
from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.common.action_chains import ActionChains
from selenium.webdriver.support import expected_conditions
from selenium.webdriver.support.wait import WebDriverWait
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.common.desired_capabilities import DesiredCapabilities

import os
from dotenv import load_dotenv
from pathlib import Path
env_path = Path(".") / ".env"
load_dotenv(dotenv_path=env_path)

class TestBookRepositoryBDDTestSuite():
  def setup_method(self, method):
    self.driver = webdriver.Chrome()
    self.vars = {}
  
  def teardown_method(self, method):
    self.driver.quit()
  
  def test_1TestUserManagementUserStory001UserReaderUseCase001001CinUserCRUDRegister(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a").click()
    self.driver.find_element(By.CSS_SELECTOR, ".control-label:nth-child(3)").click()
    self.driver.find_element(By.ID, "username").send_keys(os.environ.get("USERTESTNAME"))
    self.driver.find_element(By.ID, "email").send_keys(os.environ.get("USERTESTEMAIL"))
    self.driver.find_element(By.ID, "password").send_keys(os.environ.get("USERTESTPASS"))
    element = self.driver.find_element(By.NAME, "action")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.ID, "retype_password").send_keys(os.environ.get("USERTESTPASS"))
    self.driver.find_element(By.NAME, "action").click()
    self.driver.close()
    time.sleep(30)
  
  def test_2TestUserManagementUserStory001UserReaderUseCase001002SignIn(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.CSS_SELECTOR, ".field_top_padding:nth-child(4) .control-label").click()
    self.driver.find_element(By.ID, "username").send_keys(os.environ.get("USERTESTNAME"))
    self.driver.find_element(By.ID, "password").send_keys(os.environ.get("USERTESTPASS"))
    self.driver.find_element(By.CSS_SELECTOR, "span:nth-child(2)").click()
    self.driver.find_element(By.NAME, "action").click()
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a").click()
    self.driver.close()
  
  def test_3TestUserManagementUserStory001UserReaderUseCase001003ResetPassword(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.LINK_TEXT, "Forgot your Password?").click()
    self.driver.find_element(By.ID, "email").click()
    self.driver.find_element(By.ID, "email").send_keys("[email protected]")
    self.driver.find_element(By.NAME, "action").click()
    self.driver.close()
  
  def test_4TestUserManagementUserStory002UserReaderUseCase002001UinUserCRUDUpdateUserProfile(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.ID, "username").send_keys(os.environ.get("USERTESTNAME"))
    self.driver.find_element(By.ID, "password").send_keys(os.environ.get("USERTESTPASS"))
    self.driver.find_element(By.CSS_SELECTOR, "span:nth-child(2)").click()
    element = self.driver.find_element(By.NAME, "action")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.NAME, "action").click()
    # self.driver.find_element(By.CSS_SELECTOR, ".container > .container").click()
    element = self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.CSS_SELECTOR, ".field_top_padding:nth-child(2) .control-label").click()
    self.driver.find_element(By.ID, "first_name").send_keys("Naoise")
    element = self.driver.find_element(By.NAME, "action")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.ID, "last_name").send_keys("Gaffney")
    self.driver.find_element(By.NAME, "action").click()
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a").click()
    self.driver.close()
  
  def test_5TestUserManagementUserStory002UserReaderUseCase002002UinUserCRUDChangePassword(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.CSS_SELECTOR, ".field_top_padding:nth-child(4) .control-label").click()
    self.driver.find_element(By.ID, "username").send_keys("Naoise")
    self.driver.find_element(By.ID, "password").send_keys("S3cr3t@")
    self.driver.find_element(By.CSS_SELECTOR, "span:nth-child(2)").click()
    self.driver.find_element(By.NAME, "action").click()
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.LINK_TEXT, "Change Password").click()
    self.driver.find_element(By.CSS_SELECTOR, ".form-group:nth-child(2) .control-label").click()
    self.driver.find_element(By.ID, "old_password").send_keys(os.environ.get("USERTESTPASS"))
    self.driver.find_element(By.ID, "new_password").send_keys(os.environ.get("USERTESTPASSNEW"))
    element = self.driver.find_element(By.NAME, "action")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.ID, "retype_password").send_keys(os.environ.get("USERTESTPASSNEW"))
    self.driver.find_element(By.NAME, "action").click()
    self.driver.close()
  
  def test_6TestUserManagementUserStory002UserReaderUseCase002003DinUserCRUDDeleteUser(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.CSS_SELECTOR, ".field_top_padding:nth-child(4) .control-label").click()
    self.driver.find_element(By.ID, "username").send_keys(os.environ.get("USERTESTNAME"))
    self.driver.find_element(By.ID, "password").send_keys(os.environ.get("USERTESTPASSNEW"))
    self.driver.find_element(By.ID, "password").send_keys(Keys.ENTER)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.LINK_TEXT, "Delete User").click()
    self.driver.find_element(By.CSS_SELECTOR, ".modal-footer:nth-child(2) > .modal-close:nth-child(1)").click()
    self.driver.close()

  # Added to create the user account again for the remaining tests, as the account was just deleted in test case 6.
  def test_6X_AddUserAccountAgainForRemainingTests(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a").click()
    self.driver.find_element(By.CSS_SELECTOR, ".control-label:nth-child(3)").click()
    self.driver.find_element(By.ID, "username").send_keys(os.environ.get("USERTESTNAME"))
    self.driver.find_element(By.ID, "email").send_keys(os.environ.get("USERTESTEMAIL"))
    self.driver.find_element(By.ID, "password").send_keys(os.environ.get("USERTESTPASSNEW"))
    element = self.driver.find_element(By.NAME, "action")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.ID, "retype_password").send_keys(os.environ.get("USERTESTPASSNEW"))
    self.driver.find_element(By.NAME, "action").click()
    self.driver.close()
    time.sleep(30)

  def test_7TestBookRepositoryUserStory003UserReaderUseCase003001CinBookCRUDAddBook(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.CSS_SELECTOR, ".field_top_padding:nth-child(4) .control-label").click()
    self.driver.find_element(By.ID, "username").send_keys(os.environ.get("USERTESTNAME"))
    self.driver.find_element(By.ID, "password").send_keys(os.environ.get("USERTESTPASSNEW"))
    self.driver.find_element(By.ID, "password").send_keys(Keys.ENTER)
    self.driver.get("https://book-repository-virtual.herokuapp.com/add_book")
    self.driver.find_element(By.ID, "title").send_keys("Uganda")
    self.driver.find_element(By.ID, "author").send_keys("Philip Briggs with Andrew Roberts")
    self.driver.find_element(By.ID, "year").send_keys("2016")
    self.driver.find_element(By.ID, "isbn").send_keys("9781784770228")
    self.driver.execute_script("window.scrollTo(0,0)")
    self.driver.find_element(By.ID, "short_description").send_keys("Uganda is the most comprehensive guidebook available, with up-to-date accommodation suggestions, advice on personal safety, and tips on the best wildlife experience.")
    self.driver.find_element(By.ID, "rating").send_keys("7")
    self.driver.find_element(By.CSS_SELECTOR, ".dropdown-trigger").send_keys(Keys.DOWN)
    dropdown = self.driver.find_element(By.ID, "genre")
    dropdown.find_element(By.XPATH, "//option[. = '(NF) Reference']")
    self.driver.find_element(By.CSS_SELECTOR, ".dropdown-trigger").send_keys(Keys.TAB)
    element = self.driver.find_element(By.NAME, "action")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.NAME, "action").click()
    element = self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a").click()
    self.driver.close()

  def test_8TestBookRepositoryUserStory003UserReaderUseCase003002RinBookCRUDViewBook(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.CSS_SELECTOR, ".field_top_padding:nth-child(4) .control-label").click()
    self.driver.find_element(By.ID, "username").send_keys(os.environ.get("USERTESTNAME"))
    self.driver.find_element(By.ID, "password").send_keys(os.environ.get("USERTESTPASSNEW"))
    self.driver.find_element(By.CSS_SELECTOR, "span:nth-child(2)").click()
    element = self.driver.find_element(By.NAME, "action")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.NAME, "action").click()
    self.driver.find_element(By.CSS_SELECTOR, ".collapsible-header > .col").click()
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a").click()
    self.driver.close()

  def test_9TestBookRepositoryUserStory003UserReaderUseCase003003UinBookCRUDUpdateEditBook(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.ID, "username").send_keys(os.environ.get("USERTESTNAME"))
    self.driver.find_element(By.ID, "password").send_keys(os.environ.get("USERTESTPASSNEW"))
    self.driver.find_element(By.ID, "password").send_keys(Keys.ENTER)
    self.driver.find_element(By.CSS_SELECTOR, ".book_actions .blue-text").click()
    self.driver.find_element(By.ID, "comments").send_keys("Great book with excellent descriptions of things to do and to see.")
    element = self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a").click()
    self.driver.close()
  
  def test_11TestBookRepositoryUserStory004UserReaderUseCase004001RinBookCRUDSearchBookPrivateISBN(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.CSS_SELECTOR, ".field_top_padding:nth-child(4) .control-label").click()
    self.driver.find_element(By.ID, "username").send_keys(os.environ.get("USERTESTNAME"))
    self.driver.find_element(By.ID, "password").send_keys(os.environ.get("USERTESTPASSNEW"))
    self.driver.find_element(By.ID, "password").send_keys(Keys.ENTER)
    self.driver.get("https://book-repository-virtual.herokuapp.com/search_book")
    self.driver.find_element(By.ID, "isbn").send_keys("9781784770228")
    self.driver.find_element(By.CSS_SELECTOR, ".lever").click()
    self.driver.find_element(By.NAME, "action").click()
    element = self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a").click()
    self.driver.close()
  
  def test_12TestBookRepositoryUserStory004UserReaderUseCase004002RinBookCRUDSearchBookPrivateallfieldsexceptgenrenorISBN(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    element = self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.CSS_SELECTOR, ".field_top_padding:nth-child(4) .control-label").click()
    self.driver.find_element(By.ID, "username").send_keys(os.environ.get("USERTESTNAME"))
    self.driver.find_element(By.ID, "password").send_keys(os.environ.get("USERTESTPASSNEW"))
    self.driver.find_element(By.ID, "password").send_keys(Keys.ENTER)
    self.driver.get("https://book-repository-virtual.herokuapp.com/search_book")
    self.driver.find_element(By.ID, "title").send_keys("U")
    self.driver.find_element(By.ID, "author").send_keys("Philip")
    self.driver.find_element(By.ID, "rating").send_keys("7")
    self.driver.find_element(By.CSS_SELECTOR, ".lever").click()
    self.driver.find_element(By.NAME, "action").click()
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a").click()
    self.driver.close()
  
  def test_13TestBookRepositoryUserStory004UserReaderUseCase004003RinBookCRUDSearchBookPrivateallfieldsexceptISBN(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "li:nth-child(2) .right").click()
    self.driver.find_element(By.CSS_SELECTOR, ".field_top_padding:nth-child(4) .control-label").click()
    self.driver.find_element(By.ID, "username").send_keys(os.environ.get("USERTESTNAME"))
    self.driver.find_element(By.ID, "password").send_keys(os.environ.get("USERTESTPASSNEW"))
    self.driver.find_element(By.ID, "password").send_keys(Keys.ENTER)
    self.driver.get("https://book-repository-virtual.herokuapp.com/search_book")
    self.driver.find_element(By.CSS_SELECTOR, ".lever").click()
    self.driver.find_element(By.NAME, "action").click()
    element = self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a").click()
    self.driver.close()
  
  def test_14TestBookRepositoryUserStory004UserReaderUseCase004006RinBookCRUDSearchBookallfieldsempty(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.CSS_SELECTOR, ".field_top_padding:nth-child(4) .input-field").click()
    self.driver.find_element(By.ID, "username").click()
    self.driver.find_element(By.ID, "username").send_keys(os.environ.get("USERTESTNAME"))
    self.driver.find_element(By.ID, "password").send_keys(os.environ.get("USERTESTPASSNEW"))
    self.driver.find_element(By.ID, "password").send_keys(Keys.ENTER)
    self.driver.get("https://book-repository-virtual.herokuapp.com/search_book")
    self.driver.find_element(By.NAME, "action").click()
    self.driver.find_element(By.LINK_TEXT, ">").click()
    self.driver.find_element(By.LINK_TEXT, ">").click()
    self.driver.find_element(By.LINK_TEXT, ">").click()
    self.driver.find_element(By.LINK_TEXT, ">").click()
    element = self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(3) > a").click()
    self.driver.close()
  
  def test_17TestAdminDashboardUserStory005AdminUseCase005001RinAdminUserCRUDViewUsers(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.CSS_SELECTOR, ".field_top_padding:nth-child(4) .control-label").click()
    self.driver.find_element(By.ID, "username").send_keys("admin")
    element = self.driver.find_element(By.NAME, "action")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.ID, "password").send_keys(os.environ.get("ADMINTESTPASSWORD"))
    self.driver.find_element(By.NAME, "action").click()
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(1) > a").click()
    element = self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(4) > a")
    actions = ActionChains(self.driver)
    actions.move_to_element(element).perform()
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(4) > a").click()
    self.driver.close()
  
  def test_20TestAdminDashboardUserStory005AdminUseCase005004CinGenreCRUDLoadGenres(self):
    self.driver.get("https://book-repository-virtual.herokuapp.com/")
    self.driver.set_window_size(1680, 989)
    self.driver.find_element(By.CSS_SELECTOR, "#nav-mobile > li:nth-child(2) > a").click()
    self.driver.find_element(By.ID, "username").send_keys("admin")
    self.driver.find_element(By.ID, "password").send_keys(os.environ.get("ADMINTESTPASSWORD"))
    self.driver.find_element(By.ID, "password").send_keys(Keys.ENTER)
    self.driver.find_element(By.CSS_SELECTOR, "li:nth-child(1) > a > .right").click()
    self.driver.get("https://book-repository-virtual.herokuapp.com/load_genres")
    self.driver.close()