tests.test_fields

Complexity

Total Complexity

29

Size/Duplication

Total Lines	194
Duplicated Lines	9.79 %

Importance

Changes

0

9 Functions

Rating	Name	Duplication	Size	Complexity
A	test_fields_search_filters()	0	22	2
A	test_column_not_searchable()	0	20	4
B	test_fields_mdata()	0	25	6
A	fixtures_fields_global_search_filtering_with_regex()	0	14	1
B	test_fields_global_search_filtering_with_regex()	0	26	7
A	test_calculating_age_on_the_fly()	0	17	2
A	fixtures_column_not_searchable()	0	11	1
A	test_fields_filtering()	19	19	5
A	fixtures_filed_filtering()	0	14	1

import pytest

This module should have a docstring.

Unable to import 'pytest'

from sqlalchemy import func

from datatables import ColumnDT, DataTables

from .helpers import create_dt_params
from .models import Address, User


def test_fields_mdata(session):
    """Test if the result's data have mData set."""
    columns = [
        ColumnDT(User.id, mData='ID'),
        ColumnDT(User.name, mData='Username'),
        ColumnDT(Address.description, mData='Address'),
        ColumnDT(User.created_at, mData='Created at')
    ]

    query = session.query().select_from(User).join(Address)

    params = create_dt_params(columns)
    rowTable = DataTables(params, query, columns)

The name rowTable does not conform to the variable naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

    res = rowTable.output_result()

    if not len(res['data']) == 3:
        raise AssertionError()
    if 'ID' not in res['data'][0]:
        raise AssertionError()
    if 'Username' not in res['data'][0]:
        raise AssertionError()
    if 'Address' not in res['data'][0]:
        raise AssertionError()
    if 'Created at' not in res['data'][0]:
        raise AssertionError()


def test_fields_search_filters(session):
    """Test if the result's data are filtered after search."""
    query = session.query()

    columns = [
        ColumnDT(User.id, search_method='numeric'),
        ColumnDT(User.name, search_method='string_contains'),
        ColumnDT(User.birthday, search_method='date')
    ]

    user = session.query(User).filter(User.id == 4).one()

    params = create_dt_params(columns)
    params['columns[0][search][value]'] = '=4'
    params['columns[1][search][value]'] = user.name
    params['columns[2][search][value]'] = '>1965-02-02'
    params['columns[2][search][value]'] = '<=99'
    rowTable = DataTables(params, query, columns)

The name rowTable does not conform to the variable naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

    res = rowTable.output_result()

    if not len(res['data']) == 1:
        raise AssertionError()


def test_calculating_age_on_the_fly(session):
    """Test if the result's have a custom field."""
    query = session.query().filter(User.id > 5)

    columns = [
        ColumnDT(User.id, search_method='numeric'),
        ColumnDT(User.name, search_method='string_contains'),
        ColumnDT(User.birthday, search_method='date'),
        ColumnDT(func.datetime('now') - User.birthday, search_method='numeric')
    ]

    params = create_dt_params(columns)
    rowTable = DataTables(params, query, columns)

The name rowTable does not conform to the variable naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

    res = rowTable.output_result()

    if not len(res['data']) == 10:
        raise AssertionError()


@pytest.fixture(scope="function")
def fixtures_filed_filtering(session):

This function should have a docstring.

    user51 = User(name='User 51')
    user52 = User(name='User 52')

    session.add(user51)
    session.add(user52)
    session.commit()

    yield

    session.delete(user51)
    session.delete(user52)
    session.commit()


@pytest.mark.usefixtures("fixtures_filed_filtering")

This code seems to be duplicated in your project.

def test_fields_filtering(session):
    """Test if result's are filtered from global search field."""
    columns = [ColumnDT(User.id, ), ColumnDT(User.name)]

    query = session.query().select_from(User)

    params = create_dt_params(columns, search='51')
    rowTable = DataTables(params, query, columns)

The name rowTable does not conform to the variable naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

    res = rowTable.output_result()

    if not len(res['data']) == 1:
        raise AssertionError()
    if not res['recordsTotal'] == '52':
        raise AssertionError()
    if not res['recordsFiltered'] == '1':
        raise AssertionError()
    if not res['data'][0]['1'] == 'User 51':
        raise AssertionError()


@pytest.fixture(scope="function")
def fixtures_fields_global_search_filtering_with_regex(session):

The name fixtures_fields_global_search_filtering_with_regex does not conform to the function naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

This function should have a docstring.

    user51 = User(name='Run To')
    user52 = User(name='Feeeeear Of')

    session.add(user51)
    session.add(user52)
    session.commit()

    yield

    session.delete(user51)
    session.delete(user52)
    session.commit()


@pytest.mark.usefixtures("fixtures_fields_global_search_filtering_with_regex")
def test_fields_global_search_filtering_with_regex(session):

The name test_fields_global_search_filtering_with_regex does not conform to the function naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

    """Test if result's are filtered from global search field."""
    columns = [ColumnDT(User.id, ), ColumnDT(User.name)]

    query = session.query().select_from(User)

    params = create_dt_params(columns, search='Fe*ar')
    params['search[regex]'] = 'true'

    rowTable = DataTables(params, query, columns, allow_regex_searches=True)

The name rowTable does not conform to the variable naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

    res = rowTable.output_result()

    if 'error' in res:
        # unfortunately sqlite doesn't support regexp out of the box'
        if 'no such function: REGEXP' not in res['error']:
            raise AssertionError()
    else:
        if not len(res['data']) == 1:
            raise AssertionError()
        if not res['recordsTotal'] == '1':
            raise AssertionError()
        if not res['recordsFiltered'] == '1':
            raise AssertionError()
        if not res['data'][0]['1'] == 'Feeeeear Of':
            raise AssertionError()


@pytest.fixture(scope="function")
def fixtures_column_not_searchable(session):

This function should have a docstring.

    user51 = User(name='User 51')

    session.add(user51)
    session.commit()

    yield

    session.delete(user51)
    session.commit()


@pytest.mark.usefixtures("fixtures_column_not_searchable")
def test_column_not_searchable(session):
    """Test if result's are filtered from global search field."""
    columns = [
        ColumnDT(User.id, mData='ID'),
        ColumnDT(User.name, mData='Username', global_search=False)
    ]

    query = session.query().select_from(User)

    params = create_dt_params(columns, search='User 51')
    rowTable = DataTables(params, query, columns)

The name rowTable does not conform to the variable naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

    res = rowTable.output_result()

    if not len(res['data']) == 0:

Do not use len(SEQUENCE) as condition value

        raise AssertionError()
    if not res['recordsTotal'] == '51':
        raise AssertionError()
    if not res['recordsFiltered'] == '0':
        raise AssertionError()