Exemplo n.º 1
0
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
Exemplo n.º 2
0
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
Exemplo n.º 3
0
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
Exemplo n.º 4
0
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
Exemplo n.º 5
0
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
Exemplo n.º 6
0
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