def add_client_to_clients_db(client_name): with session_scope() as session: existing_client = session.query(Client).filter_by( name=client_name).first() if not existing_client: client = Client(name=client_name, is_active=True) session.add(client) set_client_to_active(client_name)
def set_client_to_active(client_name): with session_scope() as session: query = session.query(Client) clients = query.all() current_client = query.filter_by(name=client_name).first() for client in clients: if client is current_client: client.is_active = True client.last_visit = datetime.now()
def set_client_to_inactive(): with session_scope() as session: active_client = session.query(Client).filter_by(is_active=True).first() if active_client: active_client.is_active = False
def set_client_last_visit_date(client_name): with session_scope() as session: client = session.query(Client).filter_by(name=client_name).first() client.last_visit = datetime.now()
def get_client_last_visit_date(client_name): with session_scope() as session: client = session.query(Client).filter_by(name=client_name).first() if client: return client.last_visit
def get_active_client_from_clients_db(): with session_scope(expire=False) as session: return session.query(Client).filter_by(is_active=True).first()