def execute(self, group_id=None): """Statistics on a Group. It returns how many promotions and demotions were executed within a group. Specifically, a list with the following fields are returned: group_id, number of promotions, number of demotions. :param group_id: Group one wants to retrieve information on. """ rset = ResultSet( names=('group_id', 'call_count', 'call_abort'), types=(str, long, long), ) for row in MySQLHandler.group_view(group_id): rset.append_row(row) return CommandResult(None, results=rset)
def execute(self, group_id=None): """Statistics on a Group. It returns how many promotions and demotions were executed within a group. Specifically, a list with the following fields are returned: group_id, number of promotions, number of demotions. :param group_id: Group one wants to retrieve information on. """ rset = ResultSet( names=('group_id', 'call_count', 'call_abort'), types=(str, long, long), ) for row in MySQLHandler.group_view(group_id): rset.append_row(row) return CommandResult(None, results=rset)
def test_group_view(self): # Try to retrieve non-existent group. res = MySQLHandler.group_view("non-existent") self.assertEqual(len(res), 0) # Retrieve information on a group and check demote and promote. _LOGGER.debug("Master is being promoted.", extra={ 'subject' : 'group_id_1', 'category' : MySQLHandler.GROUP, 'type' : MySQLHandler.PROMOTE, 'reporter' : 'test_handler' } ) _LOGGER.debug("Master is being demoted.", extra={ 'subject' : 'group_id_1', 'category' : MySQLHandler.GROUP, 'type' : MySQLHandler.DEMOTE, 'reporter' : 'test_handler' } ) _LOGGER.debug("Master is being promoted.", extra={ 'subject' : 'group_id_1', 'category' : MySQLHandler.GROUP, 'type' : MySQLHandler.PROMOTE, 'reporter' : 'test_handler' } ) res = MySQLHandler.group_view("group_id_1") self.assertEqual(len(res), 1) self.assertEqual(res[0][1], 2) self.assertEqual(res[0][2], 1) # Retrieve information on groups with similar name patterns. _LOGGER.debug("Master is being promoted.", extra={ 'subject' : 'group_id_2', 'category' : MySQLHandler.GROUP, 'type' : MySQLHandler.PROMOTE, 'reporter' : 'test_handler' } ) res = MySQLHandler.group_view("group_id_2") self.assertEqual(len(res), 1) self.assertEqual(res[0][1], 1) self.assertEqual(res[0][2], 0) res = MySQLHandler.group_view("group_id") self.assertEqual(len(res), 2) # Retrieve information on groups with different name patterns, # i.e. all groups. _LOGGER.debug("Master is being promoted.", extra={ 'subject' : 'abc_group', 'category' : MySQLHandler.GROUP, 'type' : MySQLHandler.PROMOTE, 'reporter' : 'test_handler' } ) res = MySQLHandler.group_view() self.assertEqual(len(res), 3)