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)