Struct DropTriggerStatement 

pub struct DropTriggerStatement { /* private fields */ }

Available on native and crate feature database only.

DROP TRIGGER statement builder

This struct provides a fluent API for constructing DROP TRIGGER queries.

Backend Support

• PostgreSQL: Full support (IF EXISTS, CASCADE/RESTRICT, ON table optional)
• MySQL: Basic support (IF EXISTS, ON table required)
• SQLite: Basic support (IF EXISTS, no CASCADE/RESTRICT)

Examples

use reinhardt_query::prelude::*;

// Basic DROP TRIGGER
let query = Query::drop_trigger()
    .name("audit_insert")
    .on_table("users");

// With IF EXISTS
let query = Query::drop_trigger()
    .name("audit_insert")
    .if_exists()
    .on_table("users");

// PostgreSQL with CASCADE
let query = Query::drop_trigger()
    .name("audit_insert")
    .on_table("users")
    .cascade();

Implementations

impl DropTriggerStatement

pub fn new() -> DropTriggerStatement

Create a new DROP TRIGGER statement

pub fn take(&mut self) -> DropTriggerStatement

Take the ownership of data in the current DropTriggerStatement

pub fn name<N>(&mut self, name: N) -> &mut DropTriggerStatement

where N: IntoIden,

Set the trigger name to drop

Examples

use reinhardt_query::prelude::*;

let query = Query::drop_trigger()
    .name("audit_insert");

pub fn on_table<T>(&mut self, table: T) -> &mut DropTriggerStatement

where T: IntoTableRef,

Set the table on which the trigger is defined

Required for MySQL, optional for PostgreSQL and SQLite.

Examples

use reinhardt_query::prelude::*;

let query = Query::drop_trigger()
    .name("audit_insert")
    .on_table("users");

pub fn if_exists(&mut self) -> &mut DropTriggerStatement

Add IF EXISTS clause

Examples

use reinhardt_query::prelude::*;

let query = Query::drop_trigger()
    .name("audit_insert")
    .if_exists();

pub fn cascade(&mut self) -> &mut DropTriggerStatement

Add CASCADE clause (PostgreSQL only)

Automatically drop dependent objects.

Examples

use reinhardt_query::prelude::*;

let query = Query::drop_trigger()
    .name("audit_insert")
    .on_table("users")
    .cascade();

pub fn restrict(&mut self) -> &mut DropTriggerStatement

Add RESTRICT clause (PostgreSQL only)

Refuse to drop if there are dependent objects (default behavior).

Examples

use reinhardt_query::prelude::*;

let query = Query::drop_trigger()
    .name("audit_insert")
    .on_table("users")
    .restrict();

Trait Implementations

impl Clone for DropTriggerStatement

fn clone(&self) -> DropTriggerStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for DropTriggerStatement

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

Formats the value using the given formatter.

impl Default for DropTriggerStatement

fn default() -> DropTriggerStatement

Returns the “default value” for a type.

impl QueryStatementBuilder for DropTriggerStatement

fn build_any( &self, query_builder: &(dyn QueryBuilderTrait + 'static), ) -> (String, Values)

Build SQL statement for a database backend and collect query parameters

fn to_string<T>(&self, query_builder: T) -> String

where T: QueryBuilderTrait,

Build SQL statement for a database backend and return SQL string with values inlined as SQL literals.

fn build<T>(&self, query_builder: T) -> (String, Values)

where T: QueryBuilderTrait,

Build SQL statement with parameter collection

impl QueryStatementWriter for DropTriggerStatement