ormarModel

ormarModel refers to the model classes used by the Ormar ORM to represent and manipulate database tables in Python applications. An ormarModel is defined by creating a class that inherits from ormar.Model and declaring a Meta inner class that specifies the database connection, SQLAlchemy metadata, and the table name. Each attribute of the class corresponds to a database column and is defined with Ormar field types such as ormar.String, ormar.Integer, ormar.DateTime, which also carry validation rules via Pydantic.

Instances of an ormarModel map to rows in the table. They support asynchronous CRUD operations through an objects query manager (for example Item.objects) and instance methods such as save(), update(), and delete(). Queries are built with fluent filter syntax and can return single objects or lists; there are helper methods like get_or_none(), exists(), and all().

ormarModel supports relationships: ForeignKey, ManyToMany, and OneToMany, enabling joined queries and nested retrievals. Validation is provided by Pydantic, so input data is validated when creating or updating records and can be serialized to dict or JSON.

Ormar models rely on SQLAlchemy for metadata and can be used with the databases library for async database access. Migrations are typically handled with standard SQLAlchemy/Alembic tooling. Ormar supports several relational databases such as SQLite, PostgreSQL, and MySQL, over asynchronous connections.

In practice, ormarModel is commonly used in asynchronous web frameworks like FastAPI and Starlette, where models are defined once and reused across routes for data persistence.