def test_orderby_multiple(self): """Test multiple orderby statements.""" q = Query('Environment') q.orderby('account_number', 'ASC', label='Environment') q.orderby('name', 'DESC', label='Environment') expected = ("ORDER BY environment.account_number ASC, " "environment.name DESC") self.assertTrue(expected in str(q))
def test_orderby_state_property(self): """Test orderby on a state property.""" q = Query('Host') q.orderby('kernel', 'DESC', label='Host') expected = 'ORDER BY host_state.kernel DESC' self.assertTrue(expected in str(q))
def test_orderby_invalid_property(self): """Test that orderby raises InvalidPropertyError""" q = Query('Environment') with self.assertRaises(InvalidPropertyError): q.orderby('invalidproperty', 'ASC')
def test_orderby_invalid_label(self): """Test that orderby raises InvalidLabelError""" q = Query('Environment') with self.assertRaises(InvalidLabelError): q.orderby('aproperty', 'DESC', label='invalidlabel')
def test_orderby_no_label(self): """Test a single nondefault orderby""" q = Query('Environment') q.orderby('account_number', 'DESC') expected = "ORDER BY environment.account_number DESC" self.assertTrue(expected in str(q))