How to forbid fields/attributes that are not defined in the model?

[drorata]

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 datetime import datetime
from typing import Optional
from sqlmodel import Field, SQLModel
from pydantic import Extra

class Transaction(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    isin: str
    ts: datetime

    class Config:
        extra = Extra.forbid


t = Transaction(isin="789xyz", ts=datetime(2022, 2, 20), some_foo="bar")

Description

• I define a model which should reject instantiations that contain undefined attributes.
• In this case, I expect the instantiation to fail, because the field some_foo is provided while it is not included in the definition of the model.

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.8

Python Version

3.11

Additional Context

I'm trying to include also validation that depends on an IntEnum. Consider:

class TransactionTypes(IntEnum):
    buy = 1
    sell = 2
    dividend = 3

class Transaction(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    isin: str
    ts: datetime
    kind: TransactionTypes = TransactionTypes.dividend

    class Config:
        extra = Extra.forbid

This Transaction(isin="789xyz", ts=datetime(2022, 2, 20), some_foo="bar", kind=1) works as expected., while Transaction(isin="789xyz", ts=datetime(2022, 2, 20), some_foo="bar", kind=10) simply ignores the invalid kind.

[drorata]

I believe that the problem is due to table=True. See #52 for example.