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')