SQLModel support

[aminalaee]

Discussed in #56

^{Originally posted by JonasKs February 16, 2022}
Hi! This looks awesome, I’m definitely going to test it out!

Since this support SQLAlchemy, will it also support SQLModel? 😊

As suggested by @JonasKs, I did test SQLAdmin with SQLModel but it needs a few tweaks to make it work.
I'll get to it after we have the minimum functionality like #24 done.

[aminalaee]

Thanks a lot for the suggestion 👍

[JonasKs]

Thank you! Looking forward to it!

[ischaojie]

Awesome! SQLModel use pydantic for type annotation, that is better for model convert to forms, for example,

name: str = Field(max_length=12)
age: int = Field(ge=0, le=100)

We can auto-add validators( like validators.Length()) for name and age fields in wtforms Forms.

If needed, I wish to provide some contribution to it.

[aminalaee]

Honestly I haven't taken a deep look into it, but yeah maybe something like that will do it.

What I suggest is to split that into multiple PRs, so my first attempt would be to just make it work with SQLModel because right now the field conversion fails.
Then we. can work on it and improve the validations.
Even in that, if any PR will be big we can split it into parts.

If needed, I wish to provide some contribution to it.

That would be more than welcome, feel free to go for it 👍

[EZhivaikin]

Hi! Do you want to add fully support of sqlmodel? I just have done some "tweaks" to make it work in my current project, and can make a PR. By the way, if there is some requirements, I would try to help

[aminalaee]

Hey @EZhivaikin ,
Yes ideally I think SQLAdmin should work with SQLModel, but as far as I saw we only need to defined the converters for creating wtform field validators in SQLModel.

And yes, all sorts of contributions are welcome, please do create a PR for it 👍

As for other improvements, my initial goal is to support the flask-admin features, there are still some of them missing here. So what I suggest is that if you want/can help with anything first let's create an issue and then do the PRs. How does that sound?

[EZhivaikin]

Sounds great, I'll try to do this all asap 😃

[aminalaee]

I've created a PR to add SQLModel support in SQLAdmin. It would be appreciated if anyone could take a look.