Creating an entity gives "__init__() missing 1 required positional argument" error

[toinbis]

My table is:

class WebsiteDbModel(Base):

    name: Mapped[str] = mapped_column(String(length=50), nullable=False)
    id: Mapped[UUID] = mapped_column(SQLAUUID, primary_key=True, default=uuid4())

My Modelview class is:

from sqladmin import ModelView

from modules.collaboration.infrastructure.website.tables import WebsiteDbModel

class WebsiteAdmin(ModelView, model=WebsiteDbModel):
    pass

When I had only id field - I was able to create model instance in SQLAdmin UI.
But when I add name or more fields, I get such error whilst trying to submit the form:

__init__() missing 1 required positional argument: 'name'

Here is the screenshot ^!

Any ideas what I am doing wrong?

Thanks

[lukeclimen]

Try adding the property column_list with an array of the class properties that you want to include.

from sqladmin import ModelView

from modules.collaboration.infrastructure.website.tables import WebsiteDbModel

class WebsiteAdmin(ModelView, model=WebsiteDbModel):
    column_list = [WebsiteDbModel.id, WebsiteDbModel.name]

[truongduchainguyen]

I did try your suggestion but it didn't work for my case. Here is my setup.

from sqladmin import ModelView
from wtforms import PasswordField

from src import User
from src.modules.auth.security import hash_password


class UserView(ModelView, model=User):
    def __init__(self):
        super().__init__()

    can_delete = False
    can_create = True
    can_edit = True

    icon = "fa-solid fa-user"
    page_size = 20

    # Listing Page
    column_list = [
        User.id,
        User.email,
        User.is_active,
        User.created_at,
        User.updated_at,
    ]

    column_searchable_list = [
        User.id,
        User.email,
    ]

    column_sortable_list = [
        User.id,
        User.is_active,
        User.created_at,
        User.updated_at,
    ]

    column_default_sort = [
        (User.is_active, True),
        (User.id, False),
    ]

    # Details Page
    column_details_list = [
        User.id,
        User.email,
        User.is_active,
        User.created_at,
        User.updated_at,
    ]

    # Create & Edit
    form_columns = [User.email, User.password]
    form_args = dict(email=dict(label="Email"), password=dict(label="Password"))
    form_overrides = {
        "password": PasswordField
    }
    form_create_rules = ["email", "password"]
    form_edit_rules = ["email", "password"]

    async def insert_model(self, request, data):
        data["password"] = hash_password(data["password"])
        return await super().insert_model(request, data)

[lukeclimen]

Can you provide a minimum reproducible example and the stack trace? It's difficult to tell what's going wrong just from looking at your code.