def print_bots_in_bot_group(cls): print_names_and_count( set([ item[0] for item in db.execute(cls.BOTS_WITHOUT_BOT_FLAG_IN_BOT_GROUP_QUERY) ]), 'unique bots which belong to the group bot and do not have a bot flag' )
def print_bots_with_bot_flag_and_in_bot_group(cls): print_names_and_count( set([ item[0] for item in db.execute(cls.BOTS_WITH_BOT_FLAG_AND_IN_BOT_GROUP_QUERY) ]), 'unique bots with a bot flag and which belong to the group bot' )
def print_bots_without_request(cls): print_names_and_count( set([ item[0] for item in db.execute(cls.BOTS_WITHOUT_REQUEST_QUERY) ]), 'bots without a request for permission' )
def print_unique_bots(cls): print_names_and_count( set([ item[0] for item in db.execute(cls.UNIQUE_BOTS_QUERY) ]), 'unique bots' )
def print_request_for_permission_without_editor_count(cls): print_names_and_count( [ item[0] for item in db.execute(cls.REQUEST_WITHOUT_EDITOR_COUNT_QUERY) ], 'requests for permissions without editor_count', "\n" )
def print_request_for_permission_without_closed_at(cls): print_names_and_count( [ item[0] for item in db.execute(cls.REQUEST_WITHOUT_CLOSED_AT_QUERY) ], 'requests for permissions without closed_at', "\n" )
def print_bots_without_request_without_groups(cls): print_names_and_count( set([ item[0] for item in db.execute(cls.GROUPS_OF_BOTS_WITHOUT_REQUEST_QUERY) if item[1] is None ]), 'bots without a request and without groups' )
def print_bots_with_request_without_groups(cls): bots_with_red_link = [] bots_without_red_link = [] for item in db.execute(cls.GROUPS_OF_BOTS_WITH_REQUEST_QUERY): if item[1] is None: if item[2] == 1: bots_with_red_link.append(item[0]) else: bots_without_red_link.append(item[0]) print_names_and_count(bots_with_red_link, 'bots with a request, without groups and a red link') print_names_and_count(bots_without_red_link, 'bots with a request, without groups and without a red link')
def print_bots_with_request_without_rights(cls): bots_with_red_link = [] # bots_with_right_and_redlink = [] bots_without_red_link = [] for item in db.execute(cls.RIGHTS_OF_BOTS_WITH_REQUEST_QUERY): if item[1] is None: if item[2] == 1: bots_with_red_link.append(item[0]) else: bots_without_red_link.append(item[0]) # else: # if item[2] == 1: # bots_with_right_and_redlink.append(item[0]) #print( # "#################### Names of all bots with a request, with rights and a red link: ####################\n", # ', '.join(bots_with_right_and_redlink), "\n") print_names_and_count(bots_with_red_link, 'bots with a request, without rights and a red link') print_names_and_count(bots_without_red_link, 'bots with a request, without rights and without a red link')