Method get_active_waves_user

RoverSign/utils/database/models.py:174–204

获取活跃用户（在指定天数内有使用记录） Args: active_days: 活跃认定天数 Returns: 活跃用户列表

(
        cls: Type[T_WavesUser],
        session: AsyncSession,
        active_days: int,
    )

    @classmethod
    @with_session
    async def get_active_waves_user(
        cls: Type[T_WavesUser],
        session: AsyncSession,
        active_days: int,
    ) -> List[T_WavesUser]:
        """
        获取活跃用户（在指定天数内有使用记录）

        Args:
            active_days: 活跃认定天数

        Returns:
            活跃用户列表
        """
        import time

        current_time = int(time.time())
        threshold_time = current_time - (active_days * 24 * 60 * 60)

        sql = (
            select(cls)
            .where(cls.cookie != null())
            .where(cls.cookie != "")
            .where(cls.user_id != null())
            .where(cls.user_id != "")
            .where(cls.last_used_time != null())
            .where(cls.last_used_time >= threshold_time)
        )
        result = await session.execute(sql)
        data = result.scalars().all()
        return list(data)

    @classmethod
    @with_lock