sojddlZddlTddlmZddlmZddlmZddl m Z ddl m Z GddeZ e dS) N)*) BaseModel)Crew)User)CrewJoinRequestStatusceZdZUdZeedZeezed<eedZ eezed<e e j Z e e zed<Gdd Zeded edfd Zededed edfd Zd S)CrewJoinRequestz CrewJoinRequest class crew_join_requests)backrefusercrew)defaultstatusceZdZdZdS)CrewJoinRequest.Metacrew_join_requestN)__name__ __module__ __qualname__db_table!/app/src/model/CrewJoinRequest.pyMetars&rrreturnc ttj|ktjt jt jtj z k tj S)z Get all requests of a user in the cooldown period :param user: The user object :return: The list of requests hours) r selectwherer datedatetimenow timedeltaEnv#CREW_JOIN_REQUEST_COOLDOWN_DURATIONget_intorder_byasc)r s r#get_all_requests_in_cooldown_periodz3CrewJoinRequest.get_all_requests_in_cooldown_periods  " " $ $ U$,$#''))$3+R+Z+Z+\+\]]]^^ Xo*..00 1 1 rc Nttj|ktj|ktjt jt jtj z kS)z Get all requests of a user for a given crew in the cooldown period :param user: The user object :param crew: The crew object :return: The list of requests r) r rr r r r!r"r#r$r%-CREW_JOIN_REQUEST_COOLDOWN_SAME_CREW_DURATIONr')r r s r,get_all_requests_in_cooldown_period_for_crewzr=s######))))))LLLLLL2 2 2 2 2 i2 2 2 jr