Evilitself提出的问题

Evilitself

Asked: 2024-12-18 21:17:37 +0000 UTC

sqlalchemy.orm.exc.DetachedInstanceError：删除用户时实例未绑定到会话

不断给出错误“sqlalchemy.orm.exc.DetachedInstanceError：实例 <User at 0x2d790022f70> 未绑定到会话；属性刷新操作无法继续（此错误的背景位于：https://sqlalche.me/e/20/ bhk3）”。我不知道如何摆脱它，但用户并没有从数据库中删除。我附上了一些代码，可能会帮助您解决这个问题。

@router1.message(Form.waiting_for_deletion_number)
async def process_delete_input(message: types.Message, state: FSMContext):
if message.text == 'Назад':
    await back(message, state)
    return
phone_number = message.text.strip()

if not is_valid_phone_number(phone_number):
    await message.answer("Номер телефона должен начинаться с '+'.")
    return

user = await rq.get_user_by_number(phone_number)
if user:
    tg_id = user.tg_id  
    fio = user.fio     
    user_deleted = await rq.delete_user_by_number(phone_number, tg_id, fio)
if user_deleted:
    await message.answer(f"Сотрудник с номером {phone_number} успешно удален.")
else:
    await message.answer(f"Сотрудник с номером {phone_number} не найден.")

await state.clear()  # Завершаем состояние после удаления

我使用此代码作为管理处理程序。要从数据库中删除，编写以下代码：

async def get_user_by_number(number: str):
    async with async_session() as session:  
        async with session.begin(): 
            result = await session.execute(select(User).filter(User.number == number))
            return result.scalar_one_or_none() 

async def delete_user_by_number(number: str, tg_id: int, fio: str):
    async with async_session() as session:
        async with session.begin():
        # Извлекаем пользователя из базы данных
            user_to_delete = await session.scalar(
                select(User).where(User.tg_id == tg_id, User.number == number, User.fio == fio)
        )

        if user_to_delete:
            # Обновляем экземпляр (если он был отсоединен)
            await session.refresh(user_to_delete)
            await session.delete(user_to_delete)
            await session.commit()
            return True
        
        return False

应该是找到的号码的行在数据库中被完全删除（即有关用户的所有数据）

DetachedInstanceError: Instance <User at 0x2d790022f70> is not bound to a Session; attribute refresh operation cannot proceed (Background on this error at: https://sqlalche.me/e/20/bhk3)
Traceback (most recent call last):
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\dispatcher.py", line 309, in _process_update
    response = await self.feed_update(bot, update, **kwargs)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\dispatcher.py", line 158, in feed_update
    response = await self.update.wrap_outer_middleware(
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\middlewares\error.py", line 25, in __call__
    return await handler(event, data)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\middlewares\user_context.py", line 56, in __call__
    return await handler(event, data)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\fsm\middleware.py", line 42, in __call__
    return await handler(event, data)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\event\telegram.py", line 121, in trigger
    return await wrapped_inner(event, kwargs)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\event\handler.py", line 43, in call
    return await wrapped()
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\dispatcher.py", line 276, in _listen_update
    return await self.propagate_event(update_type=update_type, event=event, **kwargs)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\router.py", line 146, in propagate_event
    return await observer.wrap_outer_middleware(_wrapped, event=event, data=kwargs)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\router.py", line 141, in _wrapped
    return await self._propagate_event(
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\router.py", line 174, in _propagate_event
    response = await router.propagate_event(update_type=update_type, event=event, **kwargs)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\router.py", line 146, in propagate_event
    return await observer.wrap_outer_middleware(_wrapped, event=event, data=kwargs)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\router.py", line 141, in _wrapped
    return await self._propagate_event(
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\router.py", line 166, in _propagate_event
    response = await observer.trigger(event, **kwargs)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\event\telegram.py", line 121, in trigger
    return await wrapped_inner(event, kwargs)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\aiogram\dispatcher\event\handler.py", line 43, in call
    return await wrapped()
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\app\handler_admin.py", line 92, in process_delete_input
    tg_id = user.tg_id
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\sqlalchemy\orm\attributes.py", line 566, in __get__
    return self.impl.get(state, dict_)  # type: ignore[no-any-return]
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\sqlalchemy\orm\attributes.py", line 1086, in get
    value = self._fire_loader_callables(state, key, passive)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\sqlalchemy\orm\attributes.py", line 1116, in _fire_loader_callables
    return state._load_expired(state, passive)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\sqlalchemy\orm\state.py", line 803, in _load_expired
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\sqlalchemy\orm\attributes.py", line 1116, in _fire_loader_callables
    return state._load_expired(state, passive)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\sqlalchemy\orm\attributes.py", line 1116, in _fire_loader_callables
    return state._load_expired(state, passive)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\sqlalchemy\orm\state.py", line 803, in _load_expired
    self.manager.expired_attribute_loader(self, toload, passive)
  File "C:\Users\Evilitself\OneDrive\Рабочий стол\Тг бот\.venv\lib\site-packages\sqlalchemy\orm\loading.py", line 1603, in load_scalar_attributes
    raise orm_exc.DetachedInstanceError(
sqlalchemy.orm.exc.DetachedInstanceError: Instance <User at 0x2d790022f70> is not bound to a Session; attribute refresh operation cannot proceed (Background on this error at: https://sqlalche.me/e/20/bhk3)

Evilitself

Asked: 2024-10-03 19:25:53 +0000 UTC

如何将输入的字符与列表进行比较？

给出了介绍性符号和列表。

"e", ['a', 'e', 'i', 'o', 'u']

我们需要比较这个符号是否在列表中，如果是，则显示 True

我的代码：

def is_member(value,lst):
    for i in value:
        if i[0] == value:
            return True
        else:
            return False

sqlalchemy.orm.exc.DetachedInstanceError：删除用户时实例未绑定到会话

如何将输入的字符与列表进行比较？

我看不懂措辞

请求的模块“del”不提供名为“default”的导出

"!+tab" 在 HTML 的 vs 代码中不起作用

我正在尝试解决“猜词”的问题。Python

可以使用哪些命令将当前指针移动到指定的提交而不更改工作目录中的文件？

Python解析野莓

问题：“警告：检查最新版本的 pip 时出错。”

帮助编写一个用值填充变量的循环。解决这个问题

尽管依赖数组为空，但在渲染上调用了 2 次 useEffect

数据不通过 Telegram.WebApp.sendData 发送

Evilitself's questions