def test_condition(self):
selection = Columns('first', 'last')
condition = eq('name', 'foo')
op = (Select(
self.column_family).columns(*selection.args).where(condition))
cql, args = op.statement()
self.assertEquals(cql, self.get_query(selection, condition))
self.assertEquals(args, selection.values + condition.values)
def test_limit(self):
selection = Columns('first', 'last')
limit = Limit(5)
op = (Select(self.column_family).columns(*selection.args).limit(
limit.value))
cql, args = op.statement()
self.assertEquals(cql, '{} {}'.format(self.get_query(selection),
limit.cql))
self.assertEquals(args, selection.values + limit.values)
def select_from(column_family, keyspace=None):
return Select(column_family, keyspace)
def test_selection(self):
selection = Columns('first', 'last')
op = (Select(self.column_family).columns(*selection.args))
cql, args = op.statement()
self.assertEquals(cql, self.get_query(selection))
self.assertEquals(args, selection.values)
def test_no_selection(self):
op = Select(self.column_family)
self.assertRaises(ValidationError, op.statement)
