def get_from_db(self):
ret = {}
sess = DBSession()
for task in sess.query(Task).filter(Task.enabled.is_(True)):
sess.expunge(task.schedule)
sess.expunge(task)
lastrun = None
if self._schedule and task.name in self._schedule:
lastrun = self._schedule[task.name].last_run_at
ret[task.name] = self.Entry(self.app, task, last_run_at=lastrun)
transaction.commit()
return ret
def _get_db_session(self, uid, login, sname):
from netprofile_core import (NPSession, User)
db = DBSession()
try:
npsess = db.query(NPSession).filter(
NPSession.session_name == sname, NPSession.user_id == uid,
NPSession.login == login).one()
except NoResultFound:
transaction.abort()
return None
npuser = npsess.user
privs = npuser.flat_privileges
db.expunge(npuser)
db.expunge(npsess)
# TODO: compute next session timeout check
transaction.abort()
return (npsess, npuser, privs)
def _get_db_session(self, uid, login, sname):
from netprofile_core.models import NPSession
db = DBSession()
try:
npsess = db.query(NPSession).filter(
NPSession.session_name == sname,
NPSession.user_id == uid,
NPSession.login == login).one()
except NoResultFound:
transaction.abort()
return None
npuser = npsess.user
privs = npuser.flat_privileges
db.expunge(npuser)
db.expunge(npsess)
# TODO: compute next session timeout check
transaction.abort()
return (npsess, npuser, privs)
