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