Struct sea_query::extension::postgres::TypeDropStatement

pub struct TypeDropStatement { /* private fields */ }

Available on crate feature backend-postgres only.

Implementations

impl TypeDropStatement

pub fn new() -> Self

pub fn name<T>(&mut self, name: T) -> &mut Selfwhere T: IntoTypeRef,

Drop a type

use sea_query::{extension::postgres::Type, *};

struct FontFamily;

impl Iden for FontFamily {
    fn unquoted(&self, s: &mut dyn Write) {
        write!(s, "{}", "font_family").unwrap();
    }
}

assert_eq!(
    Type::drop()
        .if_exists()
        .name(FontFamily)
        .restrict()
        .to_string(PostgresQueryBuilder),
    r#"DROP TYPE IF EXISTS "font_family" RESTRICT"#
);

pub fn names<T, I>(&mut self, names: I) -> &mut Selfwhere T: IntoTypeRef, I: IntoIterator<Item = T>,

Drop multiple types

use sea_query::{extension::postgres::Type, *};

#[derive(Iden)]
enum KycStatus {
    #[iden = "kyc_status"]
    Type,
    Pending,
    Approved,
}

#[derive(Iden)]
enum FontFamily {
    #[iden = "font_family"]
    Type,
    Aerial,
    Forte,
}

assert_eq!(
    Type::drop()
        .if_exists()
        .names([
            SeaRc::new(KycStatus::Type) as DynIden,
            SeaRc::new(FontFamily::Type) as DynIden,
        ])
        .cascade()
        .to_string(PostgresQueryBuilder),
    r#"DROP TYPE IF EXISTS "kyc_status", "font_family" CASCADE"#
);

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

Set IF EXISTS

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

Set CASCADE

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

Set RESTRICT

impl TypeDropStatement

pub fn build_ref<T: TypeBuilder>(&self, type_builder: &T) -> String

pub fn build_collect<T: TypeBuilder>( &self, type_builder: T, sql: &mut dyn SqlWriter ) -> String

pub fn build_collect_ref<T: TypeBuilder>( &self, type_builder: &T, sql: &mut dyn SqlWriter ) -> String

pub fn to_string<T>(&self, type_builder: T) -> Stringwhere T: TypeBuilder + QueryBuilder,

Build corresponding SQL statement and return SQL string

Trait Implementations

impl Clone for TypeDropStatement

fn clone(&self) -> TypeDropStatement

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for TypeDropStatement

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

Formats the value using the given formatter.

impl Default for TypeDropStatement

fn default() -> TypeDropStatement

Returns the “default value” for a type.