"""Endpoints for publications"""
import json

from gn_libs.mysqldb import database_connection
from flask import Blueprint, render_template, current_app as app

from uploader.authorisation import require_login

from .models import fetch_publications

from gn_libs.debug import __pk__

pubbp = Blueprint("publications", __name__)


@pubbp.route("/", methods=["GET"])
@require_login
def index():
    """Index page for publications."""
    with database_connection(app.config["SQL_URI"]) as conn:
        return render_template("publications/index.html")


@pubbp.route("/list", methods=["GET"])
@require_login
def list_publications():
    with database_connection(app.config["SQL_URI"]) as conn:
        return json.dumps({
            "publications": tuple({
                **row, "index": idx
            } for idx,row in enumerate(
                fetch_publications(conn), start=1)),
            "status": "success"
        })