Pydantic field validation and direct initialization

[gvwilson]

I'm currently using SQLModel for a project, but would like to move to something lighter-weight. ORMagic looks like a good fit, but I can't tell if it supports Pydantic-style field validation (e.g., the "name" field must be a string of length greater than zero, etc.). I'd also be grateful if you could tell me whether there's an (undocumented?) way to initialize the database connection directly, without using an environment variable - in particular, I'd like to use :memory: for testing. Thanks - @gvwilson

[SpaceShaman]

Hi @gvwilson,

Thanks for your interest in ORMagic!

ORMagic was built on top of Pydantic precisely to support Pydantic-style field validation, so things like enforcing non-empty strings, type constraints, etc. work the same way you’d expect from Pydantic models.

As for initializing the database connection: at the moment, the only supported way is via an environment variable. There isn’t an (even undocumented) option to initialize the connection directly in code, so using something like :memory: for tests isn’t currently possible without setting the env var.

If this kind of functionality is important to you, I’d definitely encourage you to consider becoming a contributor to the project. To be transparent, I haven’t actively worked on ORMagic for about a year, mainly because there wasn’t much interest around it—but I’d be more than happy to get back to developing it if someone wanted to work on it together.

Thanks again for checking it out, and feel free to follow up if you have more questions.