Python Query._format_select Examples

Example #1

File: test_query.py Project: puhrez/pyinfluxql

def test_format_select():
    q = Query().from_('test_measurement')
    q._select_expressions = ['hello']
    assert q._format_select() == 'SELECT hello'
    q._select_expressions = ['hello', 'goodbye']
    assert q._format_select() == 'SELECT hello, goodbye'
    q = Query().from_('test_measurement')
    q._select_expressions = [Sum('hello')]
    assert q._format_select() == 'SELECT SUM(hello)'
    q._select_expressions = [Sum('hello'), Min('bye')]
    assert q._format_select() == 'SELECT SUM(hello), MIN(bye)'
    q = Query().from_('1').select(Max(Min('hello')))
    assert q._format_select() == 'SELECT MAX(MIN(hello))'

Example #2

File: test_query.py Project: jjmalina/pyinfluxql

def test_format_select():
    q = Query().from_('test_measurement')
    q._select_expressions = ['hello']
    assert q._format_select() == 'SELECT hello'
    q._select_expressions = ['hello', 'goodbye']
    assert q._format_select() == 'SELECT hello, goodbye'
    q = Query().from_('test_measurement')
    q._select_expressions = [Sum('hello')]
    assert q._format_select() == 'SELECT SUM(hello)'
    q._select_expressions = [Sum('hello'), Min('bye')]
    assert q._format_select() == 'SELECT SUM(hello), MIN(bye)'
    q = Query().from_('1').select(Max(Min('hello')))
    assert q._format_select() == 'SELECT MAX(MIN(hello))'