René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"could not assemble any primary key columns for mapped table","articleBody":"### Privileged issue\n\n- [x] I'm @tiangolo or he asked me directly to create an issue here.\n\n### Issue Content\n```\n File \"C:\\Users\\petzold\\PycharmProjects\\script_executor\\model\\exec_result.py\", line 9, in \u003cmodule\u003e\n    class ExecResult(SQLModel, table=True):\n    ...\u003c8 lines\u003e...\n        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)]\n  File \"C:\\Users\\petzold\\PycharmProjects\\script_executor\\.venv\\Lib\\site-packages\\sqlmodel\\main.py\", line 644, in __init__\n    DeclarativeMeta.__init__(cls, classname, bases, dict_, **kw)\n    ~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File \"C:\\Users\\petzold\\PycharmProjects\\script_executor\\.venv\\Lib\\site-packages\\sqlalchemy\\orm\\decl_api.py\", line 199, in __init__\n    _as_declarative(reg, cls, dict_)\n    ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^\n  File \"C:\\Users\\petzold\\PycharmProjects\\script_executor\\.venv\\Lib\\site-packages\\sqlalchemy\\orm\\decl_base.py\", line 245, in _as_declarative\n    return _MapperConfig.setup_mapping(registry, cls, dict_, None, {})\n           ~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File \"C:\\Users\\petzold\\PycharmProjects\\script_executor\\.venv\\Lib\\site-packages\\sqlalchemy\\orm\\decl_base.py\", line 326, in setup_mapping\n    return _ClassScanMapperConfig(\n        registry, cls_, dict_, table, mapper_kw\n    )\n  File \"C:\\Users\\petzold\\PycharmProjects\\script_executor\\.venv\\Lib\\site-packages\\sqlalchemy\\orm\\decl_base.py\", line 581, in __init__\n    self._early_mapping(mapper_kw)\n    ~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^\n  File \"C:\\Users\\petzold\\PycharmProjects\\script_executor\\.venv\\Lib\\site-packages\\sqlalchemy\\orm\\decl_base.py\", line 367, in _early_mapping\n    self.map(mapper_kw)\n    ~~~~~~~~^^^^^^^^^^^\n  File \"C:\\Users\\petzold\\PycharmProjects\\script_executor\\.venv\\Lib\\site-packages\\sqlalchemy\\orm\\decl_base.py\", line 1995, in map\n    mapper_cls(self.cls, self.local_table, **self.mapper_args),\n    ~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n  File \"\u003cstring\u003e\", line 2, in __init__\n  File \"C:\\Users\\petzold\\PycharmProjects\\script_executor\\.venv\\Lib\\site-packages\\sqlalchemy\\util\\deprecations.py\", line 281, in warned\n    return fn(*args, **kwargs)  # type: ignore[no-any-return]\n  File \"C:\\Users\\petzold\\PycharmProjects\\script_executor\\.venv\\Lib\\site-packages\\sqlalchemy\\orm\\mapper.py\", line 866, in __init__\n    self._configure_pks()\n    ~~~~~~~~~~~~~~~~~~~^^\n  File \"C:\\Users\\petzold\\PycharmProjects\\script_executor\\.venv\\Lib\\site-packages\\sqlalchemy\\orm\\mapper.py\", line 1652, in _configure_pks\n    raise sa_exc.ArgumentError(\n    ...\u003c3 lines\u003e...\n    )\nsqlalchemy.exc.ArgumentError: Mapper Mapper[ExecResult(exec_result)] could not assemble any primary key columns for mapped table 'exec_result'\n```\nmy model is \n```python\nclass ExecResult(SQLModel, table=True):\n    \"\"\"执行结果\"\"\"\n    __tablename__ = 'exec_result'\n    id: Annotated[int, Field(sa_column=Column('id', primary_key=True), description=\"id\")]\n    script_id: Annotated[int, Field(description=\"脚本id\")]\n    status: Annotated[int, Field(description=\"执行状态\")]\n    result: Annotated[str, Field(description=\"执行结果\")]\n    error: Annotated[str, Field(description=\"错误输出\")]\n    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)]\n    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)]\n```\n\nthis is also not work\n```python\nclass ExecResult(SQLModel, table=True):\n    \"\"\"执行结果\"\"\"\n    __tablename__ = 'exec_result'\n    id: Annotated[int, Field(primary_key=True, description=\"id\")]\n    script_id: Annotated[int, Field(description=\"脚本id\")]\n    status: Annotated[int, Field(description=\"执行状态\")]\n    result: Annotated[str, Field(description=\"执行结果\")]\n    error: Annotated[str, Field(description=\"错误输出\")]\n    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)]\n    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)]\n```\n","author":{"url":"https://github.com/cjdxhjj","@type":"Person","name":"cjdxhjj"},"datePublished":"2025-10-14T01:28:56.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/1606/sqlmodel/issues/1606"}