Struct SoftDeleteBuilder 

pub struct SoftDeleteBuilder { /* private fields */ }

Builder for constructing soft delete queries

This builder helps construct safe, parameterized soft delete queries.

Implementations

impl SoftDeleteBuilder

pub fn new(table: &str) -> Self

Create a new soft delete builder

Examples

let builder = SoftDeleteBuilder::new("workflows");

pub fn where_clause(self, clause: &str) -> Self

Set the WHERE clause for the soft delete

Examples

let builder = SoftDeleteBuilder::new("workflows")
    .where_clause("id = $1");

pub fn deleted_at_column(self, column: &str) -> Self

Set custom column name for deleted_at timestamp

pub fn with_deleted_by_column(self, column: &str) -> Self

Enable tracking of who deleted the record

pub fn with_deletion_reason_column(self, column: &str) -> Self

Enable tracking of deletion reason

pub fn with_metadata(self, metadata: SoftDeleteMetadata) -> Self

Set metadata for the soft delete operation

pub fn soft_delete_query(&self) -> Result<String>

Get the SQL query for soft delete

Use this to execute the soft delete with your own parameters.

Examples

let builder = SoftDeleteBuilder::new("workflows").where_clause("id = $1");
let query = builder.soft_delete_query()?;
let result = sqlx::query(&query)
    .bind(workflow_id)
    .execute(pool)
    .await?;