rowstile for Rust
Preview. This crate may change in any release; it is not part of what 1.0 keeps stable.
rowstile for Rust apps on sqlx or tokio-postgres: every transaction signs in as whoever the request acts for, the database filters what it reads and refuses what it may not write, and the crate turns a refusal into Error::Refused (a 403 with the reason) and a hidden row into Error::NotFound (a 404). It holds no rowstile logic: it calls the authz.* functions the policy made, and reads their answers.
sh
cargo add rowstile --git https://github.com/rowstile/rowstile --features sqlx,axum # not on crates.io yetrust
let mut tx = rowstile::sqlx::begin(&pool, &rowstile::Principal::user("42")).await?;
let changed = sqlx::query("UPDATE app.notes SET body = $1 WHERE id = $2")
.bind(body)
.bind(id)
.execute(&mut *tx)
.await? // a refused write: Error::Refused
.rows_affected();
rowstile::sqlx::expect(&mut tx, changed, "app.notes", "update", id).await?; // none changed: NotFound or Refused
tx.commit().await?;sqlx::begin,pg::begin: a transaction signed in (authz.act_as), on a sqlx pool or a tokio-postgres client. The sign-in lasts the transaction alone, so pools and PgBouncer in transaction mode are safe. A transaction is one principal's, and neither begins inside another:sqlx::begintakes a connection of its own from the pool (on a pool of one, it waits for the open transaction to end, up to the pool's timeout), andpg::begintakes the client, which its open transaction holds until it ends.expect: an UPDATE or DELETE that changed no row, asked about:Error::NotFoundorError::Refused, with the reason.Error:Refused,NotFound,Call(the codes a call can meet, each with its status),NotSignedIn,Connection,Database,Other(the driver's and the pool's: a closed pool, a pool's timeout);code()is rowstile's code (rowstile help AZ709),problem()the problem body.check: at start-up, refuse a connection that skips row-level security.can,perms_of,list: take only the policy's names, whichrowstile client rustwrites.axum(featureaxum):Tx, an extractor that begins each request's transaction signed in as whoever the app's state says it is (SignIn, whoseprincipalis async);SignedIn, who the request acts for with no connection yet, for a handler that reads a body (begin()once it is read); andErroras a response,application/problem+json.testing(featuretesting): a copy of the migrated test database for each test binary, andrefusedandnot_foundassertions.
Features: tokio-postgres (the default), sqlx, axum, testing. The guide: Axum.