Struct RlsPolicy 

pub struct RlsPolicy {
    pub name: String,
    pub table: String,
    pub command: PolicyCommand,
    pub role: Option<String>,
    pub using_expr: Option<String>,
    pub with_check_expr: Option<String>,
    pub permissive: bool,
}

Represents a custom RLS policy.

Fields

name: String

Policy name.

table: String

Table the policy applies to.

command: PolicyCommand

Command the policy applies to (ALL, SELECT, INSERT, UPDATE, DELETE).

role: Option<String>

Role the policy applies to.

using_expr: Option<String>

USING expression (for SELECT, UPDATE, DELETE).

with_check_expr: Option<String>

WITH CHECK expression (for INSERT, UPDATE).

permissive: bool

Whether this is a permissive or restrictive policy.

Implementations

impl RlsPolicy

pub fn new(name: impl Into<String>, table: impl Into<String>) -> Self

Create a new policy.

pub fn command(self, cmd: PolicyCommand) -> Self

Set the command.

pub fn role(self, role: impl Into<String>) -> Self

Set the role.

pub fn using(self, expr: impl Into<String>) -> Self

Set the USING expression.

pub fn with_check(self, expr: impl Into<String>) -> Self

Set the WITH CHECK expression.

pub fn restrictive(self) -> Self

Make this a restrictive policy.

pub fn to_sql(&self) -> String

Generate the CREATE POLICY SQL.

Trait Implementations

impl Clone for RlsPolicy

fn clone(&self) -> RlsPolicy

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for RlsPolicy

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.