pyramid_tut.views

Complexity

Total Complexity

10

Size/Duplication

Total Lines	121
Duplicated Lines	35.54 %

Importance

Changes

0

9 Functions

Rating	Name	Duplication	Size	Complexity
A	dt_110x_advanced_column_search()	0	6	1
A	dt_110x_basic_column_search()	0	6	1
A	home()	0	13	2
A	dt_110x()	0	4	1
A	data_advanced()	17	17	1
A	data()	0	17	1
A	data_yadcf()	21	17	1
A	dt_110x_custom_column()	0	6	1
A	dt_110x_yadcf()	0	5	1

from pyramid.response import Response
from pyramid.view import view_config
from sqlalchemy import func
from sqlalchemy.exc import DBAPIError

from datatables import ColumnDT, DataTables

from .models import Address, DBSession, User


@view_config(route_name="home", renderer="templates/home.html")
def home(request):
    """Try to connect to database, and list available examples."""
    try:
        DBSession.query(User).first()
    except DBAPIError:
        return Response(
            conn_err_msg,
            content_type="text/plain",
            status_int=500,
        )

    return {"project": "pyramid_tut"}


@view_config(route_name="dt_110x", renderer="templates/dt_110x.html")
def dt_110x(request):
    """List users with DataTables >= 1.10.x."""
    return {"project": "dt_110x"}


@view_config(
    route_name="dt_110x_custom_column",
    renderer="templates/dt_110x_custom_column.html")
def dt_110x_custom_column(request):
    """Show a CRUD custom column."""
    return {"project": "dt_110x_custom_column"}


@view_config(
    route_name="dt_110x_basic_column_search",
    renderer="templates/dt_110x_basic_column_search.html")
def dt_110x_basic_column_search(request):
    """Text based per column search."""
    return {"project": "dt_110x_basic_column_search"}


@view_config(
    route_name="dt_110x_advanced_column_search",
    renderer="templates/dt_110x_advanced_column_search.html")
def dt_110x_advanced_column_search(request):
    """Advanced per column search."""
    return {"project": "dt_110x_advanced_column_search"}


@view_config(
    route_name="dt_110x_yadcf", renderer="templates/dt_110x_yadcf.html")
def dt_110x_yadcf(request):
    """Search with yadcf."""
    return {"project": "dt_110x_yadcf"}


@view_config(route_name="data", renderer="json")
def data(request):
    """Return server side data."""
    columns = [
        ColumnDT(User.id),
        ColumnDT(User.name),
        ColumnDT(Address.description),
        ColumnDT(func.strftime("%d-%m-%Y", User.birthday)),
        ColumnDT(User.age)
    ]

    query = DBSession.query().select_from(User).join(Address).filter(
        Address.id > 4)

    rowTable = DataTables(request.GET, query, columns)

    return rowTable.output_result()


@view_config(route_name="data_advanced", renderer="json_with_dates")

This code seems to be duplicated in your project.

def data_advanced(request):
    """Return server side data."""
    columns = [
        ColumnDT(User.id, search_method="numeric"),
        ColumnDT(User.name),
        ColumnDT(Address.description),
        ColumnDT(User.birthday, search_method="date"),
        ColumnDT(User.age, search_method="numeric")
    ]

    query = DBSession.query().select_from(User).join(Address).filter(
        Address.id > 4)

    rowTable = DataTables(request.GET, query, columns)

    return rowTable.output_result()


@view_config(route_name="data_yadcf", renderer="json_with_dates")

This code seems to be duplicated in your project.

def data_yadcf(request):
    """Return server side data."""
    columns = [
        ColumnDT(User.id, search_method="yadcf_range_number"),
        ColumnDT(User.name, search_method="yadcf_multi_select"),
        ColumnDT(Address.description, search_method="yadcf_autocomplete"),
        ColumnDT(User.birthday, search_method="yadcf_range_date"),
        ColumnDT(User.age, search_method="yadcf_range_number_slider")
    ]

    query = DBSession.query().select_from(User).join(Address).filter(
        Address.id > 4)

    rowTable = DataTables(request.GET, query, columns)

    return rowTable.output_result()


conn_err_msg = '''\
Pyramid is having a problem using your SQL database.  The problem
might be caused by one of the following things:

1.  You may need to run the "initialize_pyramid_tut_db" script
    to initialize your database tables.  Check your virtual
    environment's "bin" directory for this script and try to run it.

2.  Your database server may not be running.  Check that the
    database server referred to by the "sqlalchemy.url" setting in
    your "development.ini" file is running.

After you fix the problem, please restart the Pyramid application to
try it again.
'''