nestrs-sea-orm

[dependencies]
nestrs = { version = "1.5.0", features = ["sea-orm-authz", "sea-orm-expose", "openapi"] }
# or the adapter directly:
nestrs-sea-orm = { version = "1.5.0", features = ["expose"] }

use nestrs::prelude::*;
use nestrs_sea_orm::{Repo, SeaOrmModule};
use sea_orm::DatabaseConnection;
use std::sync::Arc;

#[injectable]
struct PostsService {
    db: Arc<DatabaseConnection>,
}

impl PostsService {
    fn repo(&self) -> Repo<post::Entity> {
        Repo::new(self.db.clone())
    }
}

use axum::middleware::from_fn_with_state;
use nestrs_sea_orm::install_sea_orm_transactional_middleware;

let router = router.layer(from_fn_with_state(
    db.clone(),
    install_sea_orm_transactional_middleware,
));

use axum::extract::{Path, State};
use axum::Json;
use nestrs::current_ability_authz;
use nestrs_sea_orm::{bind_read, BindError, Repo};
use sea_orm::DatabaseConnection;
use std::sync::Arc;

#[get("/posts/:id")]
#[use_guards(AuthnGuard, PoliciesGuard)]
async fn show(
    State(db): State<Arc<DatabaseConnection>>,
    Path(id): Path<i32>,
) -> Result<Json<post::Model>, BindError> {
    let repo = Repo::<post::Entity>::new(db);
    let authz = current_ability_authz().ok_or(BindError::MissingAuthz)?;
    let model = bind_read(&repo, &authz, "Post", id).await?;
    Ok(Json(model))
}

use axum::middleware::from_fn;
use nestrs::attach_row_authz_middleware;

// Last `.layer` is outermost — policies should wrap attach.
router
    .layer(from_fn(attach_row_authz_middleware))
    .layer(policies_layer);

use nestrs_openapi::OpenApiOptions;
use nestrs_sea_orm::expose_schema;

let opts = OpenApiOptions::default()
    .with_schemas([expose_schema::<post::Model>("Post")])
    .with_posture_security(true); // lock icons for #[use_guards] routes

use nestrs::current_ability_authz;

let authz = current_ability_authz().expect("policies middleware");
let row = repo
    .find_by_id_authorized(&authz, "Post", id)
    .await?;

#[get("/health")]
#[public]
async fn health() -> &'static str { "ok" }

#[get("/posts/:id")]
#[use_guards(AuthnGuard, PoliciesGuard)]
async fn show(...) { ... }

NestFactory::create::<AppModule>()
    .require_route_posture()
    .listen_graceful(3000)
    .await;

use nestrs_graphql::data_loader;
// inside batch_load: one SELECT ... WHERE id IN (...) via Repo / SeaORM QueryFilter