Method update_last_used_time

RoverSign/utils/database/models.py:209–254

更新最后使用时间，如果创建时间为空则同时设置创建时间 会更新所有具有相同 uid 和 cookie 的记录

(
        cls,
        session: AsyncSession,
        uid: str,
        user_id: str,
        bot_id: str,
        game_id: Optional[int] = None,
    )

    @with_lock
    @with_session
    async def update_last_used_time(
        cls,
        session: AsyncSession,
        uid: str,
        user_id: str,
        bot_id: str,
        game_id: Optional[int] = None,
    ):
        """更新最后使用时间，如果创建时间为空则同时设置创建时间

        会更新所有具有相同 uid 和 cookie 的记录
        """
        import time

        current_time = int(time.time())

        # 先查询当前用户获取 cookie
        filters = [
            cls.user_id == user_id,
            cls.uid == uid,
            cls.bot_id == bot_id,
        ]
        if game_id is not None:
            filters.append(cls.game_id == game_id)

        result = await session.execute(select(cls).where(*filters))
        user = result.scalars().first()

        if user and user.cookie:
            # 更新所有具有相同 user_id 和 cookie 的记录
            all_users_result = await session.execute(
                select(cls).where(
                    cls.user_id == user_id,
                    cls.cookie == user.cookie,
                )
            )
            all_users = all_users_result.scalars().all()

            # 批量更新
            for u in all_users:
                u.last_used_time = current_time
                if u.created_time is None:
                    u.created_time = current_time

            return True
        return False


class RoverSignData(PydanticBaseModel):