could not assemble any primary key columns for mapped table

[cjdxhjj]

Privileged issue

• I'm @tiangolo or he asked me directly to create an issue here.

Issue Content

 File "C:\Users\petzold\PycharmProjects\script_executor\model\exec_result.py", line 9, in <module>
 class ExecResult(SQLModel, table=True):
 ...<8 lines>...
 update_time: Annotated[datetime, Field(sa_column=Column('update_time', DateTime, default=func.now(), onupdate=func.now()), description='更新时间'), PlainSerializer(lambda x: x.strftime('%Y-%m-%d %H:%M:%S'), return_type=str)]
 File "C:\Users\petzold\PycharmProjects\script_executor\.venv\Lib\site-packages\sqlmodel\main.py", line 644, in __init__
 DeclarativeMeta.__init__(cls, classname, bases, dict_, **kw)
 ~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 File "C:\Users\petzold\PycharmProjects\script_executor\.venv\Lib\site-packages\sqlalchemy\orm\decl_api.py", line 199, in __init__
 _as_declarative(reg, cls, dict_)
 ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^
 File "C:\Users\petzold\PycharmProjects\script_executor\.venv\Lib\site-packages\sqlalchemy\orm\decl_base.py", line 245, in _as_declarative
 return _MapperConfig.setup_mapping(registry, cls, dict_, None, {})
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 File "C:\Users\petzold\PycharmProjects\script_executor\.venv\Lib\site-packages\sqlalchemy\orm\decl_base.py", line 326, in setup_mapping
 return _ClassScanMapperConfig(
 registry, cls_, dict_, table, mapper_kw
 )
 File "C:\Users\petzold\PycharmProjects\script_executor\.venv\Lib\site-packages\sqlalchemy\orm\decl_base.py", line 581, in __init__
 self._early_mapping(mapper_kw)
 ~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^
 File "C:\Users\petzold\PycharmProjects\script_executor\.venv\Lib\site-packages\sqlalchemy\orm\decl_base.py", line 367, in _early_mapping
 self.map(mapper_kw)
 ~~~~~~~~^^^^^^^^^^^
 File "C:\Users\petzold\PycharmProjects\script_executor\.venv\Lib\site-packages\sqlalchemy\orm\decl_base.py", line 1995, in map
 mapper_cls(self.cls, self.local_table, **self.mapper_args),
 ~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 File "<string>", line 2, in __init__
 File "C:\Users\petzold\PycharmProjects\script_executor\.venv\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in warned
 return fn(*args, **kwargs) # type: ignore[no-any-return]
 File "C:\Users\petzold\PycharmProjects\script_executor\.venv\Lib\site-packages\sqlalchemy\orm\mapper.py", line 866, in __init__
 self._configure_pks()
 ~~~~~~~~~~~~~~~~~~~^^
 File "C:\Users\petzold\PycharmProjects\script_executor\.venv\Lib\site-packages\sqlalchemy\orm\mapper.py", line 1652, in _configure_pks
 raise sa_exc.ArgumentError(
 ...<3 lines>...
 )
sqlalchemy.exc.ArgumentError: Mapper Mapper[ExecResult(exec_result)] could not assemble any primary key columns for mapped table 'exec_result'

my model is

class ExecResult(SQLModel, table=True):
 """执行结果"""
 __tablename__ = 'exec_result'
 id: Annotated[int, Field(sa_column=Column('id', primary_key=True), description="id")]
 script_id: Annotated[int, Field(description="脚本id")]
 status: Annotated[int, Field(description="执行状态")]
 result: Annotated[str, Field(description="执行结果")]
 error: Annotated[str, Field(description="错误输出")]
 create_time: Annotated[datetime, Field(sa_column=Column('create_time', DateTime, default=func.now()), description='创建时间'), PlainSerializer(lambda x: x.strftime('%Y-%m-%d %H:%M:%S'), return_type=str)]
 update_time: Annotated[datetime, Field(sa_column=Column('update_time', DateTime, default=func.now(), onupdate=func.now()), description='更新时间'), PlainSerializer(lambda x: x.strftime('%Y-%m-%d %H:%M:%S'), return_type=str)]

this is also not work

class ExecResult(SQLModel, table=True):
 """执行结果"""
 __tablename__ = 'exec_result'
 id: Annotated[int, Field(primary_key=True, description="id")]
 script_id: Annotated[int, Field(description="脚本id")]
 status: Annotated[int, Field(description="执行状态")]
 result: Annotated[str, Field(description="执行结果")]
 error: Annotated[str, Field(description="错误输出")]
 create_time: Annotated[datetime, Field(sa_column=Column('create_time', DateTime, default=func.now()), description='创建时间'), PlainSerializer(lambda x: x.strftime('%Y-%m-%d %H:%M:%S'), return_type=str)]
 update_time: Annotated[datetime, Field(sa_column=Column('update_time', DateTime, default=func.now(), onupdate=func.now()), description='更新时间'), PlainSerializer(lambda x: x.strftime('%Y-%m-%d %H:%M:%S'), return_type=str)]

[cjdxhjj]

python 3.14, asyncmy>=0.2.10

[cjdxhjj]

[YuriiMotov]

Related discussion: #1597
Related PRs:

• 🐛 Fix composite primary with AfterValidator/Annotated #1602
• 🐛 Fix support for Annotated fields with Pydantic 2.12+ #1603

[vimota]

One more related PR: https://github.com/fastapi/sqlmodel/pull/1607/files

[YuriiMotov]

Close in favor of more descriptive: #1623