setter and getter can not work in sqlmodel , but it works in sqlalchenmy

[1219295581]

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 typing import Optional
from sqlmodel import SQLModel, Field
from sqlalchemy.orm import declarative_base
from sqlalchemy import Column, Integer, String

SqlalchemyBase = declarative_base()

def fakehash(data):
    return "fake" + str(data)


class UserSqlalchemy(SqlalchemyBase):
    __tablename__ = "user_orm"

    id = Column(Integer, primary_key=True)
    hashed_password = Column("password", String(255))  # I want hash password auto complete, so we add password setter and getter.

    @property
    def password(self):
        return self.hashed_password

    @password.setter
    def password(self, value):
        self.hashed_password = fakehash(value)


class User(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    hashed_password: str

    @property
    def password(self):
        return self.hashed_password

    @password.setter
    def password(self, value):
        self.hashed_password = fakehash(value)  # "fake"+value

    class Config:
        arbitrary_types_allowed = True


sqlalchemy_user = UserSqlalchemy()
sqlalchemy_user.password = "123"
# setter works
print(sqlalchemy_user.hashed_password)
# fake123
print(sqlalchemy_user.password)
# fake123, getter works

user = User()
user.password = "123"
# ValueError: "User" object has no field "password"

Description

for auto conservate password from plain string to hashed str, in Sqlalchemy model , it is very common to use setter and getter .
It works in sqlalchemy. but it can not work in sqlmodel.

Operating System

Windows

Operating System Details

No response

SQLModel Version

0.0.8

Python Version

3.11.0

Additional Context

No response

[YuriiMotov]

Works well in current version (0.0.24):

from typing import Optional

from sqlalchemy.orm import declarative_base
from sqlmodel import Field, SQLModel

SqlalchemyBase = declarative_base()

def fakehash(data):
    return "fake" + str(data)

class User(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    hashed_password: str

    @property
    def password(self):
        return self.hashed_password

    @password.setter
    def password(self, value):
        self.hashed_password = fakehash(value)  # "fake"+value

    class Config:
        arbitrary_types_allowed = True


user = User()
user.password = "123"
print(user.hashed_password)
print(user.password)

Output:

fake123
fake123