fga-gpp-mds/2017.2-QueroCultura

from .api_connections import RequestLibraryRawData
from quero_cultura.views import ParserYAML
from quero_cultura.views import get_metabase_url
from project_indicators.views import clean_url
from .models import LibraryArea
from .models import LibraryData
from .models import LibraryTags
from .models import LastUpdateLibraryDate
from datetime import datetime
from django.shortcuts import render
from celery.decorators import task


DEFAULT_INITIAL_DATE = "2012-01-01 15:47:38.337553"

# Get graphics urls from metabase
# To add new graphis, just add in the metabase_graphics variable
view_type = "question"
metabase_graphics = [{'id': 1, 'url': get_metabase_url(view_type, 25, "true")},
                     {'id': 2, 'url': get_metabase_url(view_type, 26, "true")},
                     {'id': 3, 'url': get_metabase_url(view_type, 27, "true")},
                     {'id': 4, 'url': get_metabase_url(view_type, 28, "true")},
                     {'id': 5, 'url': get_metabase_url(view_type, 29, "true")}]


detailed_data = [{'id': 1, 'url': get_metabase_url("dashboard", 8, "false")}]


page_type = "Bibliotecas"
graphic_type = 'library_graphic_detail'
page_descripition = "Biblioteca é todo espaço, seja ele concreto ou virtual "\
                    + "que reúne coleção de informações de qualquer tipo,"\
                    + "sejam livros, enciclopédias, dicionário, monografias,"\
                    + " revista, entre outros. Os gráficos abaixo representam"\
                    + " indicadores culturais extraidos das Bibliotecas"\
                    + " cadastradas na plataforma"


def index(request):
    return render(request, 'quero_cultura/indicators_page.html',
                  {'metabase_graphics': metabase_graphics,
                   'detailed_data': detailed_data,
                   'page_type': page_type,
                   'graphic_type': graphic_type,
                   'page_descripition': page_descripition})


def graphic_detail(request, graphic_id):
    try:
        graphic = metabase_graphics[int(graphic_id) - 1]
    except IndexError:
        return render(request, 'quero_cultura/not_found.html')
    return render(request, 'quero_cultura/graphic_detail.html', {'graphic': graphic})


@task(name="load_libraries")
def populate_library_data():
    if len(LastUpdateLibraryDate.objects) == 0:
        LastUpdateLibraryDate(DEFAULT_INITIAL_DATE).save()

    size = LastUpdateLibraryDate.objects.count()
    last_update = LastUpdateLibraryDate.objects[size - 1].create_date
    LastUpdateLibraryDate(str(datetime.now())).save()

    parser_yaml = ParserYAML()
    urls = parser_yaml.get_multi_instances_urls

    for url in urls:
        request = RequestLibraryRawData(last_update, url).data
        new_url = clean_url(url)
        for library in request:
            date = library["createTimestamp"]['date']

            accessibility = str(library["acessibilidade"]).capitalize()
            if accessibility == '' or accessibility == 'None':
                accessibility = 'Não definido'

            LibraryData(new_url,
                        library["type"]['name'],
                        accessibility,
                        date).save()

            for area in library["terms"]["area"]:
                LibraryArea(new_url, str(area).title()).save()

            for tag in library["terms"]["tag"]:
                LibraryTags(new_url, str(tag).title()).save()