def new_token(self) -> str:
from session import SessionInfo
token = b64encode(urandom(128)).decode("utf-8")
session_info = SessionInfo(user_id=self.id, token=token)
self.session_info.append(session_info)
with session_manager() as session:
session_info.write(session)
return token
def new_friend(self, friend_id: int):
from friend import Friend
friend = Friend(user_id=self.id, friend_id=friend_id)
with session_manager() as session:
if Friend.query_both(user_id=self.id, friend_id=friend_id, session=session):
return
self.friends.append(friend)
friend.write(session)
def find(cls, token: str) -> "Optional[_DBUser]":
with session_manager() as session:
session_info = cls.query(token, session)
if not session_info:
return
return User.from_db(session_info.user)
def find(cls, id: str) -> "Optional[List[Friend]]":
with session_manager() as session:
return cls.query(id, session)
def write(self):
with session_manager() as session:
user = _DBUser.from_user(self)
user.write(session)
def find(cls, session=None, **kwargs) -> "Optional[User]":
with session_manager() as session:
db_user = _DBUser.query_unique(session, kwargs)
if not db_user:
return
return cls.from_db(db_user)
from models import *
from database import dbSession, session_manager
import datetime
# from itsdangerous import URLSafeSerializer
# ts=URLSafeSerializer("key")
with session_manager() as session:
# data=session.query(User,Fellow).join(Fellow, Fellow.id==User.id).filter(Fellow.id==2).first()
# #data=session.query(User,Fellow).join(Fellow, User.id==Fellow.id).all()
# #data=session.query(User,Fellow).join(Fellow, 2==Fellow.id).first()
#
# completed=session.query(evaluandocourses_table).filter_by(evaluation_status=True,user_id=3).all()
# keys=[ c.curso_id for c in completed]
#
# ## Hago un query de todos los cursos que no he evaluado
# data=session.query(Curso).filter(Curso.id.in_(keys)).all()
# # print(data[0].name)
# score=session.query(EvaluationCourses.overallQualification).filter(EvaluationCourses.curso_id.in_(keys),\
# EvaluationCourses.evaluator_id==3).all()
# print(score[0][0])
# x=ts.dumps("1")
# print(type(x))