Python Query.date_range Exemples

Exemple #1

Fichier : test_query.py Projet : puhrez/pyinfluxql

def test_unicode():
    q = Query('blah').from_('series')
    q._is_delete = True
    assert six.u(str(q)) == u'DELETE FROM series;'

    q.date_range(start=20, end=40)
    q._is_delete = False
    expected = u'SELECT blah FROM series WHERE time > 20 AND time < 40;'
    assert six.u(str(q)) == expected

Exemple #2

Fichier : test_query.py Projet : jjmalina/pyinfluxql

def test_unicode():
    q = Query('blah').from_('series')
    q._is_delete = True
    assert six.u(str(q)) == u'DELETE FROM series;'

    q.date_range(start=20, end=40)
    q._is_delete = False
    expected = u'SELECT blah FROM series WHERE time > 20 AND time < 40;'
    assert six.u(str(q)) == expected

Exemple #3

Fichier : test_query.py Projet : puhrez/pyinfluxql

def test_format():
    q = Query('blah').from_('series')
    q._is_delete = True
    assert q._format() == 'DELETE FROM series;'

    q.date_range(start=20, end=40)
    q._is_delete = False
    expected = 'SELECT blah FROM series WHERE time > 20 AND time < 40;'
    assert q._format() == expected

Exemple #4

Fichier : test_query.py Projet : jjmalina/pyinfluxql

def test_format():
    q = Query('blah').from_('series')
    q._is_delete = True
    assert q._format() == 'DELETE FROM series;'

    q.date_range(start=20, end=40)
    q._is_delete = False
    expected = 'SELECT blah FROM series WHERE time > 20 AND time < 40;'
    assert q._format() == expected

Exemple #5

Fichier : test_query.py Projet : puhrez/pyinfluxql

def test_format_delete_query():
    q = Query().from_('series')
    q._is_delete = True
    assert q._format_delete_query() == 'DELETE FROM series;'

    q.date_range(start=20, end=40)
    expected = 'DELETE FROM series WHERE time > 20 AND time < 40;'
    assert q._format_delete_query() == expected

    q = Query().from_('series')
    q.date_range(end=40)
    expected = 'DELETE FROM series WHERE time < 40;'
    assert q._format_delete_query() == expected

Exemple #6

Fichier : test_query.py Projet : jjmalina/pyinfluxql

def test_format_delete_query():
    q = Query().from_('series')
    q._is_delete = True
    assert q._format_delete_query() == 'DELETE FROM series;'

    q.date_range(start=20, end=40)
    expected = 'DELETE FROM series WHERE time > 20 AND time < 40;'
    assert q._format_delete_query() == expected

    q = Query().from_('series')
    q.date_range(end=40)
    expected = 'DELETE FROM series WHERE time < 40;'
    assert q._format_delete_query() == expected

Exemple #7

Fichier : test_query.py Projet : puhrez/pyinfluxql

def test_date_range():
    q = Query()
    start = datetime.utcnow() - timedelta(hours=1)
    end = datetime.utcnow() - timedelta(minutes=1)
    q.date_range(start)
    assert q._where['time__gt'] == start

    q = Query()
    q.date_range(start, end)
    assert q._where['time__gt'] == start
    assert q._where['time__lt'] == end

    q = Query()
    q.date_range(start=start, end=end)
    assert q._where['time__gt'] == start
    assert q._where['time__lt'] == end

    q = Query()
    q.date_range(start=10, end=100)
    assert q._where['time__gt'] == 10
    assert q._where['time__lt'] == 100

    with pytest.raises(ValueError):
        Query().date_range(end, start)
    with pytest.raises(ValueError):
        Query().date_range()

Exemple #8

Fichier : test_query.py Projet : jjmalina/pyinfluxql

def test_date_range():
    q = Query()
    start = datetime.utcnow() - timedelta(hours=1)
    end = datetime.utcnow() - timedelta(minutes=1)
    q.date_range(start)
    assert q._where['time__gt'] == start

    q = Query()
    q.date_range(start, end)
    assert q._where['time__gt'] == start
    assert q._where['time__lt'] == end

    q = Query()
    q.date_range(start=start, end=end)
    assert q._where['time__gt'] == start
    assert q._where['time__lt'] == end

    q = Query()
    q.date_range(start=10, end=100)
    assert q._where['time__gt'] == 10
    assert q._where['time__lt'] == 100

    with pytest.raises(ValueError):
        Query().date_range(end, start)
    with pytest.raises(ValueError):
        Query().date_range()