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
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
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