sea_orm/lib.rs
1#![cfg_attr(docsrs, feature(doc_cfg))]
2#![warn(missing_docs)]
3#![deny(
4 missing_debug_implementations,
5 clippy::missing_panics_doc,
6 clippy::unwrap_used,
7 clippy::print_stderr,
8 clippy::print_stdout
9)]
10
11//! <div align="center">
12//!
13//! <img alt="SeaORM" src="https://www.sea-ql.org/blog/img/SeaORM 2.0 Banner.png"/>
14//!
15//! <h1></h1>
16//! <h3>SeaORM is a powerful ORM for building web services in Rust</h3>
17//!
18//! [](https://crates.io/crates/sea-orm)
19//! [](https://github.com/SeaQL/sea-orm/actions/workflows/rust.yml)
20//! [](https://github.com/SeaQL/sea-orm/stargazers/)
21//! <br>Support us with a β !
22//!
23//! </div>
24//!
25//! # π SeaORM
26//!
27//! [δΈζζζ‘£](https://github.com/SeaQL/sea-orm/blob/master/README-zh.md)
28//!
29//! ### Advanced Relations
30//!
31//! Model complex relationships 1-1, 1-N, M-N, and even self-referential in a high-level, conceptual way.
32//!
33//! ### Familiar Concepts
34//!
35//! Inspired by popular ORMs in the Ruby, Python, and Node.js ecosystem, SeaORM offers a developer experience that feels instantly recognizable.
36//!
37//! ### Feature Rich
38//!
39//! SeaORM is a batteries-included ORM with filters, pagination, and nested queries to accelerate building REST, GraphQL, and gRPC APIs.
40//!
41//! ### Production Ready
42//!
43//! With 250k+ weekly downloads, SeaORM is production-ready, trusted by startups and enterprises worldwide.
44//!
45//! ## Getting Started
46//!
47//! [](https://discord.com/invite/uCPdDXzbdv)
48//! Join our Discord server to chat with others!
49//!
50//! + [Documentation](https://www.sea-ql.org/SeaORM)
51//!
52//! Integration examples:
53//!
54//! + [Actix Example](https://github.com/SeaQL/sea-orm/tree/master/examples/actix_example)
55//! + [Axum Example](https://github.com/SeaQL/sea-orm/tree/master/examples/axum_example)
56//! + [GraphQL Example](https://github.com/SeaQL/sea-orm/tree/master/examples/graphql_example)
57//! + [jsonrpsee Example](https://github.com/SeaQL/sea-orm/tree/master/examples/jsonrpsee_example)
58//! + [Loco Example](https://github.com/SeaQL/sea-orm/tree/master/examples/loco_example) / [Loco REST Starter](https://github.com/SeaQL/sea-orm/tree/master/examples/loco_starter)
59//! + [Poem Example](https://github.com/SeaQL/sea-orm/tree/master/examples/poem_example)
60//! + [Rocket Example](https://github.com/SeaQL/sea-orm/tree/master/examples/rocket_example) / [Rocket OpenAPI Example](https://github.com/SeaQL/sea-orm/tree/master/examples/rocket_okapi_example)
61//! + [Salvo Example](https://github.com/SeaQL/sea-orm/tree/master/examples/salvo_example)
62//! + [Tonic Example](https://github.com/SeaQL/sea-orm/tree/master/examples/tonic_example)
63//! + [Seaography Example (Bakery)](https://github.com/SeaQL/sea-orm/tree/master/examples/seaography_example) / [Seaography Example (Sakila)](https://github.com/SeaQL/seaography/tree/main/examples/sqlite)
64//!
65//! If you want a simple, clean example that fits in a single file that demonstrates the best of SeaORM, you can try:
66//! + [Quickstart](https://github.com/SeaQL/sea-orm/blob/master/examples/quickstart/src/main.rs)
67//!
68//! Let's have a quick walk through of the unique features of SeaORM.
69//!
70//! ## Expressive Entity format
71//! You don't have to write this by hand! Entity files can be generated from an existing database using `sea-orm-cli`,
72//! following is generated with `--entity-format dense` *(new in 2.0)*.
73//! ```
74//! # #[cfg(feature = "macros")]
75//! # mod entities {
76//! # mod profile {
77//! # use sea_orm::entity::prelude::*;
78//! # #[sea_orm::model]
79//! # #[derive(Clone, Debug, PartialEq, Eq, DeriveEntityModel)]
80//! # #[sea_orm(table_name = "profile")]
81//! # pub struct Model {
82//! # #[sea_orm(primary_key)]
83//! # pub id: i32,
84//! # pub picture: String,
85//! # #[sea_orm(unique)]
86//! # pub user_id: i32,
87//! # #[sea_orm(belongs_to, from = "user_id", to = "id")]
88//! # pub user: HasOne<super::user::Entity>,
89//! # }
90//! # impl ActiveModelBehavior for ActiveModel {}
91//! # }
92//! # mod tag {
93//! # use sea_orm::entity::prelude::*;
94//! # #[sea_orm::model]
95//! # #[derive(Clone, Debug, PartialEq, Eq, DeriveEntityModel)]
96//! # #[sea_orm(table_name = "post")]
97//! # pub struct Model {
98//! # #[sea_orm(primary_key)]
99//! # pub id: i32,
100//! # #[sea_orm(has_many, via = "post_tag")]
101//! # pub tags: HasMany<super::tag::Entity>,
102//! # }
103//! # impl ActiveModelBehavior for ActiveModel {}
104//! # }
105//! # mod post_tag {
106//! # use sea_orm::entity::prelude::*;
107//! # #[sea_orm::model]
108//! # #[derive(Clone, Debug, PartialEq, DeriveEntityModel, Eq)]
109//! # #[sea_orm(table_name = "post_tag")]
110//! # pub struct Model {
111//! # #[sea_orm(primary_key, auto_increment = false)]
112//! # pub post_id: i32,
113//! # #[sea_orm(primary_key, auto_increment = false)]
114//! # pub tag_id: i32,
115//! # #[sea_orm(belongs_to, from = "post_id", to = "id")]
116//! # pub post: Option<super::post::Entity>,
117//! # #[sea_orm(belongs_to, from = "tag_id", to = "id")]
118//! # pub tag: Option<super::tag::Entity>,
119//! # }
120//! # impl ActiveModelBehavior for ActiveModel {}
121//! # }
122//! mod user {
123//! use sea_orm::entity::prelude::*;
124//!
125//! #[sea_orm::model]
126//! #[derive(Clone, Debug, PartialEq, Eq, DeriveEntityModel)]
127//! #[sea_orm(table_name = "user")]
128//! pub struct Model {
129//! #[sea_orm(primary_key)]
130//! pub id: i32,
131//! pub name: String,
132//! #[sea_orm(unique)]
133//! pub email: String,
134//! #[sea_orm(has_one)]
135//! pub profile: HasOne<super::profile::Entity>,
136//! #[sea_orm(has_many)]
137//! pub posts: HasMany<super::post::Entity>,
138//! }
139//! # impl ActiveModelBehavior for ActiveModel {}
140//! }
141//! mod post {
142//! use sea_orm::entity::prelude::*;
143//!
144//! #[sea_orm::model]
145//! #[derive(Clone, Debug, PartialEq, Eq, DeriveEntityModel)]
146//! #[sea_orm(table_name = "post")]
147//! pub struct Model {
148//! #[sea_orm(primary_key)]
149//! pub id: i32,
150//! pub user_id: i32,
151//! pub title: String,
152//! #[sea_orm(belongs_to, from = "user_id", to = "id")]
153//! pub author: HasOne<super::user::Entity>,
154//! #[sea_orm(has_many, via = "post_tag")] // M-N relation with junction
155//! pub tags: HasMany<super::tag::Entity>,
156//! }
157//! # impl ActiveModelBehavior for ActiveModel {}
158//! }
159//! # }
160//! ```
161//!
162//! ## Smart Entity Loader
163//! The Entity Loader intelligently uses join for 1-1 and data loader for 1-N relations,
164//! eliminating the N+1 problem even when performing nested queries.
165//! ```
166//! # use sea_orm::{DbConn, DbErr, prelude::*, entity::*, query::*, tests_cfg::*};
167//! # fn function(db: &DbConn) -> Result<(), DbErr> {
168//! // join paths:
169//! // user -> profile
170//! // user -> post
171//! // post -> post_tag -> tag
172//! let smart_user = user::Entity::load()
173//! .filter_by_id(42) // shorthand for .filter(user::COLUMN.id.eq(42))
174//! .with(profile::Entity) // 1-1 uses join
175//! .with((post::Entity, tag::Entity)) // 1-N uses data loader
176//! .one(db)
177//! ?
178//! .unwrap();
179//!
180//! // 3 queries are executed under the hood:
181//! // 1. SELECT FROM user JOIN profile WHERE id = $
182//! // 2. SELECT FROM post WHERE user_id IN (..)
183//! // 3. SELECT FROM tag JOIN post_tag WHERE post_id IN (..)
184//!
185//! smart_user
186//! == user::ModelEx {
187//! id: 42,
188//! name: "Bob".into(),
189//! email: "bob@sea-ql.org".into(),
190//! profile: HasOne::Loaded(
191//! profile::ModelEx {
192//! # id: 1,
193//! picture: "image.jpg".into(),
194//! # user_id: 1,
195//! # user: HasOne::Unloaded,
196//! }
197//! .into(),
198//! ),
199//! posts: HasMany::Loaded(vec![post::ModelEx {
200//! # id: 2,
201//! # user_id: 1,
202//! title: "Nice weather".into(),
203//! # author: HasOne::Unloaded,
204//! # comments: HasMany::Unloaded,
205//! tags: HasMany::Loaded(vec![tag::ModelEx {
206//! # id: 3,
207//! tag: "sunny".into(),
208//! # posts: HasMany::Unloaded,
209//! }]),
210//! }]),
211//! };
212//! # Ok(())
213//! # }
214//! ```
215//!
216//! ## ActiveModel: nested persistence made simple
217//! Persist an entire object graph: user, profile (1-1), posts (1-N), and tags (M-N)
218//! in a single operation using a fluent builder API. SeaORM automatically determines
219//! the dependencies and inserts or deletes objects in the correct order.
220//!
221//! ```
222//! # use sea_orm::{DbConn, DbErr, entity::*, query::*, tests_cfg::*};
223//! # fn function(db: &DbConn) -> Result<(), DbErr> {
224//! // this creates the nested object as shown above:
225//! let user = user::ActiveModel::builder()
226//! .set_name("Bob")
227//! .set_email("bob@sea-ql.org")
228//! .set_profile(profile::ActiveModel::builder().set_picture("image.jpg"))
229//! .add_post(
230//! post::ActiveModel::builder()
231//! .set_title("Nice weather")
232//! .add_tag(tag::ActiveModel::builder().set_tag("sunny")),
233//! )
234//! .save(db)
235//! ?;
236//! # Ok(())
237//! # }
238//! ```
239//!
240//! ## Schema first or Entity first? Your choice
241//!
242//! SeaORM provides a powerful migration system that lets you create tables, modify schemas, and seed data with ease.
243//!
244//! With SeaORM 2.0, you also get a first-class [Entity First Workflow](https://www.sea-ql.org/blog/2025-10-30-sea-orm-2.0/):
245//! simply define new entities or add columns to existing ones,
246//! and SeaORM will automatically detect the changes and create the new tables, columns, unique keys, and foreign keys.
247//!
248//! ```ignore
249//! // SeaORM resolves foreign key dependencies and creates the tables in topological order.
250//! // Requires the `entity-registry` and `schema-sync` feature flags.
251//! db.get_schema_registry("my_crate::entity::*").sync(db);
252//! ```
253//!
254//! ## Ergonomic Raw SQL
255//!
256//! Let SeaORM handle 95% of your transactional queries.
257//! For the remaining cases that are too complex to express,
258//! SeaORM still offers convenient support for writing raw SQL.
259//! ```
260//! # use sea_orm::{DbErr, DbConn};
261//! # fn function(db: &DbConn) -> Result<(), DbErr> {
262//! # use sea_orm::{entity::*, query::*, tests_cfg::*, raw_sql};
263//! # struct Item<'a> { name: &'a str }
264//! let user = Item { name: "Bob" }; // nested parameter access
265//! let ids = [2, 3, 4]; // expanded by the `..` operator
266//!
267//! let user: Option<user::Model> = user::Entity::find()
268//! .from_raw_sql(raw_sql!(
269//! Sqlite,
270//! r#"SELECT "id", "name" FROM "user"
271//! WHERE "name" LIKE {user.name}
272//! AND "id" in ({..ids})
273//! "#
274//! ))
275//! .one(db)
276//! ?;
277//! # Ok(())
278//! # }
279//! ```
280//!
281//! ## Basics
282//!
283//! ### Select
284//! SeaORM models 1-N and M-N relationships at the Entity level,
285//! letting you traverse many-to-many links through a junction table in a single call.
286//! ```
287//! # use sea_orm::{DbConn, DbErr, entity::*, query::*, tests_cfg::*};
288//! # fn function(db: &DbConn) -> Result<(), DbErr> {
289//! // find all models
290//! let cakes: Vec<cake::Model> = Cake::find().all(db)?;
291//!
292//! // find and filter
293//! let chocolate: Vec<cake::Model> = Cake::find()
294//! .filter(Cake::COLUMN.name.contains("chocolate"))
295//! .all(db)
296//! ?;
297//!
298//! // find one model
299//! let cheese: Option<cake::Model> = Cake::find_by_id(1).one(db)?;
300//! let cheese: cake::Model = cheese.unwrap();
301//!
302//! // find related models (lazy)
303//! let fruit: Option<fruit::Model> = cheese.find_related(Fruit).one(db)?;
304//!
305//! // find related models (eager): for 1-1 relations
306//! let cake_with_fruit: Vec<(cake::Model, Option<fruit::Model>)> =
307//! Cake::find().find_also_related(Fruit).all(db)?;
308//!
309//! // find related models (eager): works for both 1-N and M-N relations
310//! let cake_with_fillings: Vec<(cake::Model, Vec<filling::Model>)> = Cake::find()
311//! .find_with_related(Filling) // for M-N relations, two joins are performed
312//! .all(db) // rows are automatically consolidated by left entity
313//! ?;
314//! # Ok(())
315//! # }
316//! ```
317//! ### Nested Select
318//!
319//! Partial models prevent overfetching by letting you querying only the fields
320//! you need; it also makes writing deeply nested relational queries simple.
321//! ```
322//! # use sea_orm::{DbConn, DbErr, entity::*, query::*, tests_cfg::*};
323//! # fn function(db: &DbConn) -> Result<(), DbErr> {
324//! use sea_orm::DerivePartialModel;
325//!
326//! #[derive(DerivePartialModel)]
327//! #[sea_orm(entity = "cake::Entity")]
328//! struct CakeWithFruit {
329//! id: i32,
330//! name: String,
331//! #[sea_orm(nested)]
332//! fruit: Option<fruit::Model>, // this can be a regular or another partial model
333//! }
334//!
335//! let cakes: Vec<CakeWithFruit> = Cake::find()
336//! .left_join(fruit::Entity) // no need to specify join condition
337//! .into_partial_model() // only the columns in the partial model will be selected
338//! .all(db)
339//! ?;
340//! # Ok(())
341//! # }
342//! ```
343//!
344//! ### Insert
345//! SeaORM's ActiveModel lets you work directly with Rust data structures and
346//! persist them through a simple API.
347//! It's easy to insert large batches of rows from different data sources.
348//! ```
349//! # use sea_orm::{DbConn, DbErr, entity::*, query::*, tests_cfg::*};
350//! # fn function(db: &DbConn) -> Result<(), DbErr> {
351//! let apple = fruit::ActiveModel {
352//! name: Set("Apple".to_owned()),
353//! ..Default::default() // no need to set primary key
354//! };
355//!
356//! let pear = fruit::ActiveModel {
357//! name: Set("Pear".to_owned()),
358//! ..Default::default()
359//! };
360//!
361//! // insert one: Active Record style
362//! let apple = apple.insert(db)?;
363//! apple.id == 1;
364//! # let apple = fruit::ActiveModel {
365//! # name: Set("Apple".to_owned()),
366//! # ..Default::default() // no need to set primary key
367//! # };
368//!
369//! // insert one: repository style
370//! let result = Fruit::insert(apple).exec(db)?;
371//! result.last_insert_id == 1;
372//! # let apple = fruit::ActiveModel {
373//! # name: Set("Apple".to_owned()),
374//! # ..Default::default() // no need to set primary key
375//! # };
376//!
377//! // insert many returning last insert id
378//! let result = Fruit::insert_many([apple, pear]).exec(db)?;
379//! result.last_insert_id == Some(2);
380//! # Ok(())
381//! # }
382//! ```
383//!
384//! ### Insert (advanced)
385//! You can take advantage of database specific features to perform upsert and idempotent insert.
386//! ```
387//! # use sea_orm::{DbConn, TryInsertResult, DbErr, entity::*, query::*, tests_cfg::*};
388//! # fn function_1(db: &DbConn) -> Result<(), DbErr> {
389//! # let apple = fruit::ActiveModel {
390//! # name: Set("Apple".to_owned()),
391//! # ..Default::default() // no need to set primary key
392//! # };
393//! # let pear = fruit::ActiveModel {
394//! # name: Set("Pear".to_owned()),
395//! # ..Default::default()
396//! # };
397//! // insert many with returning (if supported by database)
398//! let models: Vec<fruit::Model> = Fruit::insert_many([apple, pear])
399//! .exec_with_returning(db)
400//! ?;
401//! models[0]
402//! == fruit::Model {
403//! id: 1, // database assigned value
404//! name: "Apple".to_owned(),
405//! cake_id: None,
406//! };
407//! # Ok(())
408//! # }
409//!
410//! # fn function_2(db: &DbConn) -> Result<(), DbErr> {
411//! # let apple = fruit::ActiveModel {
412//! # name: Set("Apple".to_owned()),
413//! # ..Default::default() // no need to set primary key
414//! # };
415//! # let pear = fruit::ActiveModel {
416//! # name: Set("Pear".to_owned()),
417//! # ..Default::default()
418//! # };
419//! // insert with ON CONFLICT on primary key do nothing, with MySQL specific polyfill
420//! let result = Fruit::insert_many([apple, pear])
421//! .on_conflict_do_nothing()
422//! .exec(db)
423//! ?;
424//!
425//! matches!(result, TryInsertResult::Conflicted);
426//! # Ok(())
427//! # }
428//! ```
429//!
430//! ### Update
431//! ActiveModel avoids race conditions by updating only the fields you've changed,
432//! never overwriting untouched columns.
433//! You can also craft complex bulk update queries with a fluent query building API.
434//! ```
435//! # use sea_orm::{DbConn, DbErr, entity::*, query::*, tests_cfg::*};
436//! use sea_orm::sea_query::{Expr, Value};
437//!
438//! # fn function(db: &DbConn) -> Result<(), DbErr> {
439//! let pear: Option<fruit::Model> = Fruit::find_by_id(1).one(db)?;
440//! let mut pear: fruit::ActiveModel = pear.unwrap().into();
441//!
442//! pear.name = Set("Sweet pear".to_owned()); // update value of a single field
443//!
444//! // update one: only changed columns will be updated
445//! let pear: fruit::Model = pear.update(db)?;
446//!
447//! // update many: UPDATE "fruit" SET "cake_id" = "cake_id" + 2
448//! // WHERE "fruit"."name" LIKE '%Apple%'
449//! Fruit::update_many()
450//! .col_expr(fruit::COLUMN.cake_id, fruit::COLUMN.cake_id.add(2))
451//! .filter(fruit::COLUMN.name.contains("Apple"))
452//! .exec(db)
453//! ?;
454//! # Ok(())
455//! # }
456//! ```
457//! ### Save
458//! You can perform "insert or update" operation with ActiveModel, making it easy to compose transactional operations.
459//! ```
460//! # use sea_orm::{DbConn, DbErr, entity::*, query::*, tests_cfg::*};
461//! # fn function(db: &DbConn) -> Result<(), DbErr> {
462//! let banana = fruit::ActiveModel {
463//! id: NotSet,
464//! name: Set("Banana".to_owned()),
465//! ..Default::default()
466//! };
467//!
468//! // create, because primary key `id` is `NotSet`
469//! let mut banana = banana.save(db)?;
470//!
471//! banana.id == Unchanged(2);
472//! banana.name = Set("Banana Mongo".to_owned());
473//!
474//! // update, because primary key `id` is present
475//! let banana = banana.save(db)?;
476//! # Ok(())
477//! # }
478//! ```
479//! ### Delete
480//! The same ActiveModel API consistent with insert and update.
481//! ```
482//! # use sea_orm::{DbConn, DbErr, entity::*, query::*, tests_cfg::*};
483//! # fn function(db: &DbConn) -> Result<(), DbErr> {
484//! // delete one: Active Record style
485//! let orange: Option<fruit::Model> = Fruit::find_by_id(1).one(db)?;
486//! let orange: fruit::Model = orange.unwrap();
487//! orange.delete(db)?;
488//!
489//! // delete one: repository style
490//! let orange = fruit::ActiveModel {
491//! id: Set(2),
492//! ..Default::default()
493//! };
494//! fruit::Entity::delete(orange).exec(db)?;
495//!
496//! // delete many: DELETE FROM "fruit" WHERE "fruit"."name" LIKE '%Orange%'
497//! fruit::Entity::delete_many()
498//! .filter(fruit::COLUMN.name.contains("Orange"))
499//! .exec(db)
500//! ?;
501//!
502//! # Ok(())
503//! # }
504//! ```
505//! ### Raw SQL Query
506//! The `raw_sql!` macro is like the `format!` macro but without the risk of SQL injection.
507//! It supports nested parameter interpolation, array and tuple expansion, and even repeating group,
508//! offering great flexibility in crafting complex queries.
509//!
510//! ```
511//! # use sea_orm::{DbErr, DbConn};
512//! # fn functio(db: &DbConn) -> Result<(), DbErr> {
513//! # use sea_orm::{query::*, FromQueryResult, raw_sql};
514//! #[derive(FromQueryResult)]
515//! struct CakeWithBakery {
516//! name: String,
517//! #[sea_orm(nested)]
518//! bakery: Option<Bakery>,
519//! }
520//!
521//! #[derive(FromQueryResult)]
522//! struct Bakery {
523//! #[sea_orm(alias = "bakery_name")]
524//! name: String,
525//! }
526//!
527//! let cake_ids = [2, 3, 4]; // expanded by the `..` operator
528//!
529//! // can use many APIs with raw SQL, including nested select
530//! let cake: Option<CakeWithBakery> = CakeWithBakery::find_by_statement(raw_sql!(
531//! Sqlite,
532//! r#"SELECT "cake"."name", "bakery"."name" AS "bakery_name"
533//! FROM "cake"
534//! LEFT JOIN "bakery" ON "cake"."bakery_id" = "bakery"."id"
535//! WHERE "cake"."id" IN ({..cake_ids})"#
536//! ))
537//! .one(db)
538//! ?;
539//! # Ok(())
540//! # }
541//! ```
542//!
543//! ## π§ Seaography: instant GraphQL API
544//!
545//! [Seaography](https://github.com/SeaQL/seaography) is a GraphQL framework built for SeaORM.
546//! Seaography allows you to build GraphQL resolvers quickly.
547//! With just a few commands, you can launch a fullly-featured GraphQL server from SeaORM entities,
548//! complete with filter, pagination, relational queries and mutations!
549//!
550//! Look at the [Seaography Example](https://github.com/SeaQL/sea-orm/tree/master/examples/seaography_example) to learn more.
551//!
552//! <img src="https://raw.githubusercontent.com/SeaQL/sea-orm/master/examples/seaography_example/Seaography%20example.png"/>
553//!
554//! ## π₯οΈ SeaORM Pro: Professional Admin Panel
555//!
556//! [SeaORM Pro](https://github.com/SeaQL/sea-orm-pro/) is an admin panel solution allowing you to quickly and easily launch an admin panel for your application - frontend development skills not required, but certainly nice to have!
557//!
558//! SeaORM Pro has been updated to support the latest features in SeaORM 2.0.
559//!
560//! Features:
561//!
562//! + Full CRUD
563//! + Built on React + GraphQL
564//! + Built-in GraphQL resolver
565//! + Customize the UI with TOML config
566//! + Role Based Access Control *(new in 2.0)*
567//!
568//! Read the [Getting Started](https://www.sea-ql.org/sea-orm-pro/docs/install-and-config/getting-started/) guide to learn more.
569//!
570//! 
571//! 
572//!
573//! ## SQL Server Support
574//!
575//! [SQL Server for SeaORM](https://www.sea-ql.org/SeaORM-X/) offers the same SeaORM API for MSSQL. We ported all test cases and examples, complemented by MSSQL specific documentation. If you are building enterprise software, you can [request commercial access](https://forms.office.com/r/1MuRPJmYBR). It is currently based on SeaORM 1.0, but we will offer free upgrade to existing users when SeaORM 2.0 is finalized.
576//!
577//! ## Releases
578//!
579//! SeaORM 2.0 has reached its release candidate phase. We'd love for you to try it out and help shape the final release by [sharing your feedback](https://github.com/SeaQL/sea-orm/discussions/).
580//!
581//! + [Change Log](https://github.com/SeaQL/sea-orm/tree/master/CHANGELOG.md)
582//!
583//! SeaORM 2.0 is shaping up to be our most significant release yet - with a few breaking changes, plenty of enhancements, and a clear focus on developer experience.
584//!
585//! + [A Sneak Peek at SeaORM 2.0](https://www.sea-ql.org/blog/2025-09-16-sea-orm-2.0/)
586//! + [SeaORM 2.0: A closer look](https://www.sea-ql.org/blog/2025-09-24-sea-orm-2.0/)
587//! + [Role Based Access Control in SeaORM 2.0](https://www.sea-ql.org/blog/2025-09-30-sea-orm-rbac/)
588//! + [Seaography 2.0: A Powerful and Extensible GraphQL Framework](https://www.sea-ql.org/blog/2025-10-08-seaography/)
589//! + [SeaORM 2.0: New Entity Format](https://www.sea-ql.org/blog/2025-10-20-sea-orm-2.0/)
590//! + [SeaORM 2.0: Entity First Workflow](https://www.sea-ql.org/blog/2025-10-30-sea-orm-2.0/)
591//! + [SeaORM 2.0: Strongly-Typed Column](https://www.sea-ql.org/blog/2025-11-11-sea-orm-2.0/)
592//! + [What's new in SeaORM Pro 2.0](https://www.sea-ql.org/blog/2025-11-21-whats-new-in-seaormpro-2.0/)
593//! + [SeaORM 2.0: Nested ActiveModel](https://www.sea-ql.org/blog/2025-11-25-sea-orm-2.0/)
594//!
595//! If you make extensive use of SeaQuery, we recommend checking out our blog post on SeaQuery 1.0 release:
596//!
597//! + [The road to SeaQuery 1.0](https://www.sea-ql.org/blog/2025-08-30-sea-query-1.0/)
598//!
599//! ## License
600//!
601//! Licensed under either of
602//!
603//! - Apache License, Version 2.0
604//! ([LICENSE-APACHE](LICENSE-APACHE) or <http://www.apache.org/licenses/LICENSE-2.0>)
605//! - MIT license
606//! ([LICENSE-MIT](LICENSE-MIT) or <http://opensource.org/licenses/MIT>)
607//!
608//! at your option.
609//!
610//! ## Contribution
611//!
612//! Unless you explicitly state otherwise, any contribution intentionally submitted
613//! for inclusion in the work by you, as defined in the Apache-2.0 license, shall be
614//! dual licensed as above, without any additional terms or conditions.
615//!
616//! We invite you to participate, contribute and together help build Rust's future.
617//!
618//! A big shout out to our contributors!
619//!
620//! [](https://github.com/SeaQL/sea-orm/graphs/contributors)
621//!
622//! ## Who's using SeaORM?
623//!
624//! Here is a short list of awesome open source software built with SeaORM. Feel free to [submit yours](https://github.com/SeaQL/sea-orm/blob/master/COMMUNITY.md#built-with-seaorm)!
625//!
626//! | Project | GitHub | Tagline |
627//! |---------|--------|---------|
628//! | [Zed](https://github.com/zed-industries/zed) |  | A high-performance, multiplayer code editor |
629//! | [OpenObserve](https://github.com/openobserve/openobserve) |  | Open-source observability platform |
630//! | [RisingWave](https://github.com/risingwavelabs/risingwave) |  | Stream processing and management platform |
631//! | [LLDAP](https://github.com/nitnelave/lldap) |  | A light LDAP server for user management |
632//! | [Warpgate](https://github.com/warp-tech/warpgate) |  | Smart SSH bastion that works with any SSH client |
633//! | [Svix](https://github.com/svix/svix-webhooks) |  | The enterprise ready webhooks service |
634//! | [Ryot](https://github.com/IgnisDa/ryot) |  | The only self hosted tracker you will ever need |
635//! | [Lapdev](https://github.com/lapce/lapdev) |  | Self-hosted remote development enviroment |
636//! | [System Initiative](https://github.com/systeminit/si) |  | DevOps Automation Platform |
637//! | [OctoBase](https://github.com/toeverything/OctoBase) |  | A light-weight, scalable, offline collaborative data backend |
638//!
639//! ## Sponsorship
640//!
641//! [SeaQL.org](https://www.sea-ql.org/) is an independent open-source organization run by passionate developers.
642//! If you feel generous, a small donation via [GitHub Sponsor](https://github.com/sponsors/SeaQL) will be greatly appreciated, and goes a long way towards sustaining the organization.
643//!
644//! ### Gold Sponsors
645//!
646//! <table><tr>
647//! <td><a href="https://qdx.co/">
648//! <img src="https://www.sea-ql.org/static/sponsors/QDX.svg" width="138"/>
649//! </a></td>
650//! </tr></table>
651//!
652//! [QDX](https://qdx.co/) pioneers quantum dynamics-powered drug discovery, leveraging AI and supercomputing to accelerate molecular modeling.
653//! We're immensely grateful to QDX for sponsoring the development of SeaORM, the SQL toolkit that powers their data intensive applications.
654//!
655//! ### Silver Sponsors
656//!
657//! We're grateful to our silver sponsors: Digital Ocean, for sponsoring our servers. And JetBrains, for sponsoring our IDE.
658//!
659//! <table><tr>
660//! <td><a href="https://www.digitalocean.com/">
661//! <img src="https://www.sea-ql.org/static/sponsors/DigitalOcean.svg" width="125">
662//! </a></td>
663//!
664//! <td><a href="https://www.jetbrains.com/">
665//! <img src="https://www.sea-ql.org/static/sponsors/JetBrains.svg" width="125">
666//! </a></td>
667//! </tr></table>
668//!
669//! ## Mascot
670//!
671//! A friend of Ferris, Terres the hermit crab is the official mascot of SeaORM. His hobby is collecting shells.
672//!
673//! <img alt="Terres" src="https://www.sea-ql.org/SeaORM/img/Terres.png" width="400"/>
674//!
675//! ## π¦ Rustacean Sticker Pack
676//! The Rustacean Sticker Pack is the perfect way to express your passion for Rust. Our stickers are made with a premium water-resistant vinyl with a unique matte finish.
677//!
678//! Sticker Pack Contents:
679//!
680//! + Logo of SeaQL projects: SeaQL, SeaORM, SeaQuery, Seaography
681//! + Mascots: Ferris the Crab x 3, Terres the Hermit Crab
682//! + The Rustacean wordmark
683//!
684//! [Support SeaQL and get a Sticker Pack!](https://www.sea-ql.org/sticker-pack/) All proceeds contributes directly to the ongoing development of SeaQL projects.
685//!
686//! <a href="https://www.sea-ql.org/sticker-pack/"><img alt="Rustacean Sticker Pack by SeaQL" src="https://www.sea-ql.org/static/sticker-pack-1s.jpg" width="600"/></a>
687#![doc(
688 html_logo_url = "https://raw.githubusercontent.com/SeaQL/sea-query/master/docs/SeaQL icon dark.png"
689)]
690
691mod database;
692mod docs;
693mod driver;
694pub mod dynamic;
695/// Module for the Entity type and operations
696pub mod entity;
697/// Error types for all database operations
698pub mod error;
699/// This module performs execution of queries on a Model or ActiveModel
700mod executor;
701/// Types and methods to perform metric collection
702pub mod metric;
703/// Types and methods to perform queries
704pub mod query;
705#[cfg(feature = "rbac")]
706#[cfg_attr(docsrs, doc(cfg(feature = "rbac")))]
707pub mod rbac;
708/// Types that defines the schemas of an Entity
709pub mod schema;
710/// Helpers for working with Value
711pub mod value;
712
713#[doc(hidden)]
714#[cfg(all(feature = "macros", feature = "tests-cfg"))]
715pub mod tests_cfg;
716mod util;
717
718pub use database::*;
719#[allow(unused_imports)]
720pub use driver::*;
721pub use entity::*;
722pub use error::*;
723pub use executor::*;
724pub use query::*;
725pub use schema::*;
726
727#[cfg(feature = "macros")]
728pub use sea_orm_macros::{
729 DeriveActiveEnum, DeriveActiveModel, DeriveActiveModelBehavior, DeriveActiveModelEx,
730 DeriveColumn, DeriveDisplay, DeriveEntity, DeriveEntityModel, DeriveIden,
731 DeriveIntoActiveModel, DeriveMigrationName, DeriveModel, DeriveModelEx, DerivePartialModel,
732 DerivePrimaryKey, DeriveRelatedEntity, DeriveRelation, DeriveValueType, FromJsonQueryResult,
733 FromQueryResult, raw_sql, sea_orm_compact_model as compact_model, sea_orm_model as model,
734};
735
736pub use sea_query;
737pub use sea_query::Iden;
738
739pub use sea_orm_macros::EnumIter;
740pub use strum;
741
742#[cfg(feature = "sqlx-dep")]
743pub use sqlx;