def rendertemplate( templatename, **args ):
if not args.has_key('menus'):
args['menus'] = menu.getmenus()
args['springgridwebsite'] = confighelper.getValue('springgridwebsite')
env = jinja2.Environment( loader=jinja2.PackageLoader('jinjaapplication', 'templates'))
template = env.get_template(templatename)
print template.render( **args )
def purgeExpiredSessions():
botrunners = Session.query(BotRunner)
for botrunner in botrunners:
for session in botrunner.sessions:
if session.lastpingtime != None:
secondssincelastping = dates.timedifftototalseconds(datetime.datetime.now() - session.lastpingtime)
if secondssincelastping > confighelper.getValue("expiresessionminutes") * 60:
expireBotRunnerSession(botrunner, session)
def archiveoldrequests():
matchrequests = sqlalchemysetup.session.query(MatchRequest).filter(MatchRequest.matchresult == None).filter(MatchRequest.matchrequestinprogress != None )
for matchrequest in matchrequests:
lastpingtime = dates.dateStringToDateTime( matchrequest.matchrequestinprogress.botrunnersession.lastpingtime )
secondssincelastping = dates.timedifftototalseconds( datetime.datetime.now() - lastpingtime )
if secondssincelastping > confighelper.getValue('expiresessionminutes') * 60:
sqlalchemysetup.session.delete( matchrequest.matchrequestinprogress.botrunnersession )
sqlalchemysetup.session.delete( matchrequest.matchrequestinprogress )
sqlalchemysetup.session.commit()
def purgeExpiredSessions():
botrunners = sqlalchemysetup.session.query(BotRunner)
for botrunner in botrunners:
for session in botrunner.sessions:
lastpingtime = session.lastpingtime
if lastpingtime != None:
lastpingtimedate = dates.dateStringToDateTime( lastpingtime )
secondssincelastping = dates.timedifftototalseconds( datetime.datetime.now() - lastpingtimedate )
if secondssincelastping > confighelper.getValue('expiresessionminutes') * 60:
expireBotRunnerSession( botrunner, session )
def archiveoldrequests():
matchrequests = sqlalchemysetup.session.query(MatchRequest).filter(
MatchRequest.matchresult == None).filter(
MatchRequest.matchrequestinprogress != None)
for matchrequest in matchrequests:
lastpingtime = dates.dateStringToDateTime(
matchrequest.matchrequestinprogress.botrunnersession.lastpingtime)
secondssincelastping = dates.timedifftototalseconds(
datetime.datetime.now() - lastpingtime)
if secondssincelastping > confighelper.getValue(
'expiresessionminutes') * 60:
sqlalchemysetup.session.delete(
matchrequest.matchrequestinprogress.botrunnersession)
sqlalchemysetup.session.delete(matchrequest.matchrequestinprogress)
sqlalchemysetup.session.commit()
def getproxy():
return xmlrpclib.ServerProxy( uri = confighelper.getValue('springgridwebsite') + "/api_webservice.py" )
