mysql bigint id is defined using sqlmodel and cannot be inherited

[Leewinner1]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

from sqlalchemy import BigInteger, Column
from sqlmodel import SQLModel, Field
from datetime import datetime

# parent class
class BaseMixinModel(SQLModel):
    id :int = Field(description='id', title="id",sa_column=Column(BigInteger,primary_key=True))
    create_time: datetime | None = Field(default_factory=get_current_time)
    update_time: datetime | None = Field(
        default_factory=get_current_time,
        sa_column_kwargs={
        'onupdate': get_current_time}, )
    is_delete: bool = Field(default=False, )  

class Admin(BaseMixinModel,table = True): 
    __tablename__ = 'tb_admin'
    
    username :str = Field()
    password :str = Field()
    is_super :bool | None= Field()
    last_login :datetime |None= Field(default=None)

Description

File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/decl_base.py", line 578, in init
2024-05-12 22:22:25 self._setup_table(table)
2024-05-12 22:22:25 File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/decl_base.py", line 1729, in _setup_table
2024-05-12 22:22:25 table_cls(
2024-05-12 22:22:25 File "", line 2, in new
2024-05-12 22:22:25 File "/usr/local/lib/python3.11/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
2024-05-12 22:22:25 return fn(*args, **kwargs) # type: ignore[no-any-return]
2024-05-12 22:22:25 ^^^^^^^^^^^^^^^^^^^
2024-05-12 22:22:25 File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/schema.py", line 436, in new
2024-05-12 22:22:25 return cls._new(*args, **kw)
2024-05-12 22:22:25 ^^^^^^^^^^^^^^^^^^^^^
2024-05-12 22:22:25 File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/schema.py", line 490, in _new
2024-05-12 22:22:25 with util.safe_reraise():
2024-05-12 22:22:25 File "/usr/local/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 146, in exit
2024-05-12 22:22:25 raise exc_value.with_traceback(exc_tb)
2024-05-12 22:22:25 File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/schema.py", line 486, in _new
2024-05-12 22:22:25 table.init(name, metadata, *args, _no_init=False, **kw)
2024-05-12 22:22:25 File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/schema.py", line 878, in init
2024-05-12 22:22:25 self._init_items(
2024-05-12 22:22:25 File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/schema.py", line 231, in _init_items
2024-05-12 22:22:25 spwd(self, **kw)
2024-05-12 22:22:25 File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/base.py", line 1337, in _set_parent_with_dispatch
2024-05-12 22:22:25 self._set_parent(parent, **kw)
2024-05-12 22:22:25 File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/schema.py", line 2317, in _set_parent
2024-05-12 22:22:25 raise exc.ArgumentError(
2024-05-12 22:22:25 sqlalchemy.exc.ArgumentError: Column object 'id' already assigned to Table 'tb_admin

I'm using sa_column=Column(BigInteger,primary_key=True) so I'm going to throw an error whenever my subclass inherits

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.14

Python Version

3.11

Additional Context

[joachimhuet]

you can't use Column in a parent class that is used by several tables because it will instantiate the column and the instance of a column cannot be used multiple times.

So replace that line:

id :int = Field(description='id', title="id",sa_column=Column(BigInteger,primary_key=True))

with this:

id: int = Field(description='id', title="id", sa_type=BigInteger, primary_key=True)

Using sa_type (or sa_column_args or sa_column_kwargs) won't instantiate the column right away and so the problem won't occur.