async def get_contests(self,
tag=None,
organization=None) -> List[Contest_DB]:
a = API()
page = 1
await a.get_contests(tag=tag, organization=organization, page=page)
q = session.query(Contest_DB).\
filter(self.parse(Contest_DB.tags, tag)).\
filter(self.parse(Contest_DB.organizations, organization))
if a.data.total_objects == q.count():
return q.all()
for contest in a.data.objects:
qq = session.query(Contest_DB).\
filter(Contest_DB.key == contest.key)
if qq.count() == 0:
session.add(Contest_DB(contest))
while a.data.has_more:
page += 1
await a.get_contests(tag=tag, organization=organization, page=page)
for contest in a.data.objects:
qq = session.query(Contest_DB).\
filter(Contest_DB.key == contest.key)
if qq.count() == 0:
session.add(Contest_DB(contest))
session.commit()
return q.all()
async def get_problems(self,
partial=None,
group=None,
_type=None,
organization=None,
search=None,
cached=False) -> List[Problem_DB]:
q = session.query(Problem_DB).\
filter(self.parse(Problem_DB.partial, partial)).\
filter(self.parse(Problem_DB.group, group)).\
filter(self.parse(Problem_DB.types, _type)).\
filter(self.parse(Problem_DB.organizations, organization))
if cached:
return q.all()
a = API()
if search is not None:
# Can't bother to implement something with db
# maybe future me can do this
await a.get_problems(partial=partial,
group=group,
_type=_type,
organization=organization,
search=search)
return list(map(Problem_DB, a.data.objects))
page = 1
await a.get_problems(partial=partial,
group=group,
_type=_type,
organization=organization,
search=search,
page=page)
if a.data.total_objects == q.count():
return q.all()
for problem in a.data.objects:
qq = session.query(Problem_DB).\
filter(Problem_DB.code == problem.code)
if qq.count() == 0:
session.add(Problem_DB(problem))
while a.data.has_more:
page += 1
await a.get_problems(partial=partial,
group=group,
_type=_type,
organization=organization,
search=search,
page=page)
for problem in a.data.objects:
qq = session.query(Problem_DB).\
filter(Problem_DB.code == problem.code)
if qq.count() == 0:
session.add(Problem_DB(problem))
session.commit()
return q.all()
async def get_users(self, organization=None) -> List[User_DB]:
a = API()
page = 1
await a.get_users(organization=organization, page=page)
q = session.query(User_DB).\
filter(self.parse(User_DB.organizations, organization))
if a.data.total_objects == q.count():
return q.all()
for user in a.data.objects:
qq = session.query(User_DB).\
filter(User_DB.id == user.id)
if qq.count() == 0:
session.add(User_DB(user))
while a.data.has_more:
page += 1
await a.get_users(organization=organization, page=page)
for user in a.data.objects:
qq = session.query(User_DB).\
filter(User_DB.id == user.id)
if qq.count() == 0:
session.add(User_DB(user))
session.commit()
return q.all()
async def get_languages(self, common_name=None) -> [Language_DB]:
q = session.query(Language_DB).\
filter(self.parse(Language_DB.common_name, common_name))
if q.count():
return q.all()
a = API()
await a.get_languages(common_name=common_name)
languages = list(map(Language_DB, a.data.objects))
for language in languages:
session.add(language)
session.commit()
return languages
async def check(self, ctx):
"""Check if the bot has been rate limited"""
api = API()
try:
await api.get_judges()
user = api.data.objects
if user is None:
await ctx.send('There is something wrong with the api, '
'please contact an admin')
else:
await ctx.send('Api is all good, move along.')
except Exception as e:
await ctx.send('Seems like I\'m getting cloud flared, rip. ' +
str(e))
async def get_contest(self, key) -> Contest_DB:
q = session.query(Contest_DB).\
filter(Contest_DB.key == key)
if q.count():
# is_rated checks if it has detailed rows
if q.first().is_rated is not None:
return q.first()
a = API()
await a.get_contest(key)
if q.count():
q.delete()
session.add(Contest_DB(a.data.object))
session.commit()
return q.first()
async def check(self, ctx):
'''Check if the bot has been rate limited'''
api = API()
try:
await api.get_user('JoshuaL')
user = api.data.object
if user is None:
await ctx.send('There is something wrong with the api, '
'please contact an admin')
else:
await ctx.send('Api is all good, move along')
except Exception as e:
await ctx.send(
'Seems like I\'m getting cloud flared, rip. Error: ' + str(e))
async def get_problem(self, code) -> Problem_DB:
q = session.query(Problem_DB).\
filter(Problem_DB.code == code)
if q.count():
# has_rating check if it has a detailed row
if q.first().short_circuit is not None:
return q.first()
a = API()
await a.get_problem(code)
if q.count():
q.delete()
session.add(Problem_DB(a.data.object))
session.commit()
return q.first()
async def get_user(self, username) -> User_DB:
q = session.query(User_DB).\
filter(func.lower(User_DB.username) == func.lower(username))
# if q.count():
# # solved_problems checks if it has detailed rows
# if len(q.first().solved_problems) != 0:
# return q.first()
a = API()
await a.get_user(username)
if q.count():
# Needs to be fetch, the default (evaluate) is not able to eval
# the query
q.delete(synchronize_session='fetch')
session.add(User_DB(a.data.object))
session.commit()
return q.first()
async def get_contest(self, key: str) -> Contest_DB:
q = session.query(Contest_DB).\
filter(Contest_DB.key == key)
if q.count():
# is_rated checks if it has detailed rows
if q.first().is_rated is not None:
return q.first()
a = API()
await a.get_contest(key)
# Requery the key to prevent path traversal from killing db
q = session.query(Contest_DB).\
filter(Contest_DB.key == a.data.object.key)
if q.count():
q.delete()
session.add(Contest_DB(a.data.object))
session.commit()
return q.first()
import random
import re
from utils import conf
from utils.api import API
parser = argparse.ArgumentParser(
description=__doc__, formatter_class=argparse.RawDescriptionHelpFormatter)
parser.add_argument(
'--address',
help='hostname or ip address of target appliance', default=conf.env.get("base_url", None))
args = parser.parse_args()
api = API(
"{}/api".format(
args.address if not args.address.endswith("/") else re.sub(r"/+$", "", args.address)),
("admin", "smartvm"))
print("Appliance IP: {}".format(args.address))
for collection in api.collections.all:
print("=" * (2 + len(collection.name)))
print("* {}".format(collection.name))
actions = collection.action.all
if actions:
print(" Collection actions:")
for action in actions:
print(" * {}".format(action))
if len(collection) > 0:
entity = random.choice(collection)
actions = entity.action.all
if actions:
def setUp(self):
self.api = API()
async def get_placement(self, username) -> int:
a = API()
return await a.get_placement(username)
async def get_latest_submissions(self, user, num) -> List[Submission_DB]:
a = API()
ret = await a.get_latest_submission(user, num)
return ret
async def get_submissions(self,
user=None,
problem=None,
language=None,
result=None) -> List[Submission_DB]:
# This function is the only one which might take a while to run and
# has data that is added reguarly. asyncio.gather can apply to all
# functions but this one is the only one which really needs it
a = API()
page = 1
import time
start = time.time()
await a.get_submissions(user=user,
problem=problem,
language=language,
result=result,
page=page)
print("Done Api Call", time.time() - start)
start = time.time()
q = session.query(Submission_DB)
q = q.filter(Submission_DB._user == user)
cond_user = self.parse(func.lower(User_DB.username), func.lower(user))
if not cond_user:
q = q.join(User_DB, cond_user, aliased=True)
cond_problem = self.parse(Problem_DB.code, problem)
if not cond_problem:
q = q.join(Problem_DB, cond_problem, aliased=True)
cond_lang = self.parse(Language_DB.key, language)
if not cond_lang:
q = q.join(Language_DB, cond_lang, aliased=True)
q = q.filter(self.parse(Submission_DB.result, result))
if a.data.total_objects == q.count():
return q.all()
def get_id(submission):
return submission.id
submission_ids = list(map(get_id, a.data.objects))
qq = session.query(Submission_DB.id).\
filter(Submission_DB.id.in_(submission_ids)).all()
qq = list(map(itemgetter(0), qq))
for submission in a.data.objects:
if submission.id not in qq:
session.add(Submission_DB(submission))
total_pages = a.data.total_pages
apis = []
to_gather = []
async def get_submission(api, user, problem, language, result, page):
try:
api.get_submissions(user=user,
problem=problem,
language=language,
result=result,
page=page)
except:
# Sometimes when caching a user with many pages one might not return correctly
# this will silently return nothing
# Perhaps I should implement some sort of error catching in the cogs
pass
for _ in range(2, total_pages + 1):
page += 1
api = API()
to_await = api.get_submissions(user=user,
problem=problem,
language=language,
result=result,
page=page)
apis.append(api)
to_gather.append(to_await)
await asyncio.gather(*to_gather)
for api in apis:
if api.data.objects is None:
continue
submission_ids = list(map(get_id, api.data.objects))
qq = session.query(Submission_DB.id).\
filter(Submission_DB.id.in_(submission_ids)).all()
qq = list(map(itemgetter(0), qq))
for submission in api.data.objects:
if submission.id not in qq:
session.add(Submission_DB(submission))
session.commit()
return q.all()
async def get_participations(
self,
contest=None,
user=None,
is_disqualified=None,
virtual_participation_number=None) -> List[Participation_DB]:
a = API()
page = 1
await a.get_participations(
contest=contest,
user=user,
is_disqualified=is_disqualified,
virtual_participation_number=virtual_participation_number,
page=page)
# why the hell are these names so long?
cond_contest = self.parse(Contest_DB.key, contest)
if not cond_contest:
cond_contest = Participation_DB.contest.any(cond_contest)
cond_user = self.parse(func.lower(User_DB.username), func.lower(user))
if not cond_user:
cond_user = Participation_DB.user.any(cond_user)
q = session.query(Participation_DB).\
filter(cond_contest).\
filter(cond_user).\
filter(self.parse(Participation_DB.is_disqualified,
is_disqualified)).\
filter(self.parse(Participation_DB.virtual_participation_number,
virtual_participation_number))
if a.data.total_objects == q.count():
return q.all()
def get_id(participation):
return participation.id
participation_id = list(map(get_id, a.data.objects))
qq = session.query(Submission_DB.id).\
filter(Submission_DB.id.in_(participation_id)).all()
qq = list(map(itemgetter(0), qq))
for submission in a.data.objects:
if submission.id not in qq:
session.add(Submission_DB(submission))
total_pages = a.data.total_pages
for participation in a.data.objects:
if participation.id not in participation_id:
session.add(Participation_DB(participation))
apis = []
to_gather = []
for _ in range(2, total_pages + 1):
page += 1
api = API()
to_await = await a.get_participations(
contest=contest,
user=user,
is_disqualified=is_disqualified,
virtual_participation_number=virtual_participation_number,
page=page)
apis.append(api)
to_gather.append(to_await)
await asyncio.gather(*to_gather)
for api in apis:
participation_id = list(map(get_id, api.data.objects))
qq = session.query(Submission_DB.id).\
filter(Submission_DB.id.in_(participation_id)).all()
qq = list(map(itemgetter(0), qq))
for submission in api.data.objects:
if submission.id not in qq:
session.add(Submission_DB(submission))
total_pages = api.data.total_pages
for participation in api.data.objects:
if participation.id not in participation_id:
session.add(Participation_DB(participation))
session.commit()
return q.all()
import threading
import time
import traceback
from utils.api import API
from utils.prompt import create_attendee_record, clear_console
clear_console()
print('[MAIN] Initializing, please wait')
api = API()
def checkin_main():
while True:
try:
checkin_data = create_attendee_record(api)
if checkin_data:
threading.Thread(target=threaded_create_record, args=[checkin_data]).start()
print('Checked attendee in\n')
time.sleep(3.5)
else:
print('Attendee not checked in, please retry')
time.sleep(1.5)
except Exception as e:
api.write_to_log(str(traceback.format_exc()))
print('[MAIN] Exception logged')
time.sleep(1.5)
def threaded_create_record(info):
user_hash, marked_sunday_school = info
api.create_attendee_record(user_hash, marked_sunday_school)
print('Color recommendation: ' + api.get_color_recommendation(user_hash) + '\n')
async def get_submissions(self,
user: str = None,
problem: str = None,
language: str = None,
result: str = None) -> List[Submission_DB]:
# This function is the only one which might take a while to run and
# has data that is added reguarly. asyncio.gather can apply to all
# functions but this one is the only one which really needs it
a = API()
page = 1
import time
start = time.time()
await a.get_submissions(user=user,
problem=problem,
language=language,
result=result,
page=page)
logger.info("Got submissions for %s, time elasped %s", user,
time.time() - start)
start = time.time()
q = session.query(Submission_DB)
q = q.filter(Submission_DB._user == user)
cond_user = self.parse(func.lower(User_DB.username), func.lower(user))
if not cond_user:
q = q.join(User_DB, cond_user, aliased=True)
cond_problem = self.parse(Problem_DB.code, problem)
if not cond_problem:
q = q.join(Problem_DB, cond_problem, aliased=True)
cond_lang = self.parse(Language_DB.key, language)
if not cond_lang:
q = q.join(Language_DB, cond_lang, aliased=True)
q = q.filter(self.parse(Submission_DB.result, result))
if a.data.total_objects == q.count():
return q.all()
submission_ids = list(map(attrgetter('id'), a.data.objects))
qq = session.query(Submission_DB.id).\
filter(Submission_DB.id.in_(submission_ids)).all()
qq = list(map(itemgetter(0), qq))
for submission in a.data.objects:
if submission.id not in qq:
session.add(Submission_DB(submission))
total_pages = a.data.total_pages
apis = []
to_gather = []
for _ in range(2, total_pages + 1):
page += 1
api = API()
to_await = api.get_submissions(user=user,
problem=problem,
language=language,
result=result,
page=page)
apis.append(api)
to_gather.append(to_await)
await asyncio.gather(*to_gather)
for api in apis:
if api.data.objects is None:
continue
submission_ids = list(map(attrgetter('id'), api.data.objects))
qq = session.query(Submission_DB.id).\
filter(Submission_DB.id.in_(submission_ids)).all()
qq = list(map(itemgetter(0), qq))
for submission in api.data.objects:
if submission.id not in qq:
session.add(Submission_DB(submission))
session.commit()
return q.all()
async def get_judges(self) -> List[Judge_DB]:
# If this ever has more than 1 page, I'll eat a rock
a = API()
await a.get_judges()
return list(map(Judge_DB, a.data.objects))