def test_add_columns(database):
"""Test that all keys can be added also for row withous keys."""
pytest.importorskip('flask')
session = Session('name')
project = {
'default_columns': ['bar'],
'handle_query_function': handle_query
}
session.update('query', '', {'query': 'id=2'}, project)
table = session.create_table(database, 'id', ['foo'])
assert table.columns == ['bar'] # selected row doesn't have a foo key
assert 'foo' in table.addcolumns # ... but we can add it
def test_paging(database):
"""Test paging."""
pytest.importorskip('flask')
session = Session('name')
project = {
'default_columns': ['bar'],
'handle_query_function': handle_query
}
session.update('query', '', {'query': ''}, project)
table = session.create_table(database, 'id', ['foo'])
assert len(table.rows) == 2
session.update('limit', '1', {}, project)
session.update('page', '1', {}, project)
table = session.create_table(database, 'id', ['foo'])
assert len(table.rows) == 1
# We are now on page 2 and select something on page 1:
session.update('query', '', {'query': 'id=1'}, project)
table = session.create_table(database, 'id', ['foo'])
assert len(table.rows) == 1
