Struct sea_query::foreign_key::ForeignKeyCreateStatement

pub struct ForeignKeyCreateStatement { /* fields omitted */ }

Create a foreign key constraint for an existing table

Examples

use sea_query::{*, tests_cfg::*};
 
let foreign_key = ForeignKey::create()
    .name("FK_character_font")
    .table(Char::Table, Font::Table)
    .col(Char::FontId, Font::Id)
    .on_delete(ForeignKeyAction::Cascade)
    .on_update(ForeignKeyAction::Cascade)
    .to_owned();
 
assert_eq!(
    foreign_key.to_string(MysqlQueryBuilder),
    vec![
        r#"ALTER TABLE `character`"#,
        r#"ADD CONSTRAINT `FK_character_font`"#,
        r#"FOREIGN KEY `FK_character_font` (`font_id`) REFERENCES `font` (`id`)"#,
        r#"ON DELETE CASCADE ON UPDATE CASCADE"#,
    ].join(" ")
);
assert_eq!(
    foreign_key.to_string(PostgresQueryBuilder),
    vec![
        r#"ALTER TABLE "character" ADD CONSTRAINT "FK_character_font""#,
        r#"FOREIGN KEY ("font_id") REFERENCES "font" ("id")"#,
        r#"ON DELETE CASCADE ON UPDATE CASCADE"#,
    ].join(" ")
);
// Sqlite does not support modification of foreign key constraints to existing tables

Implementations

impl ForeignKeyCreateStatement

pub fn new() -> Self

Construct a new ForeignKeyCreateStatement

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

Set foreign key name

pub fn table<T: 'static, R: 'static>(self, table: T, ref_table: R) -> Self where
    T: Iden,
    R: Iden, 

Set key table and referencing table

pub fn col<T: 'static, R: 'static>(self, column: T, ref_column: R) -> Self where
    T: Iden,
    R: Iden, 

Set key column and referencing column

pub fn on_delete(self, action: ForeignKeyAction) -> Self

Set on delete action

pub fn on_update(self, action: ForeignKeyAction) -> Self

Set on update action

pub fn build<T: ForeignKeyBuilder>(&self, foreign_key_builder: T) -> String

Build corresponding SQL statement for certain database backend and return SQL string

pub fn build_any(&self, foreign_key_builder: &dyn ForeignKeyBuilder) -> String

Build corresponding SQL statement for certain database backend and return SQL string

pub fn to_string<T: ForeignKeyBuilder>(&self, foreign_key_builder: T) -> String

Build corresponding SQL statement for certain database backend and return SQL string

Trait Implementations

impl Clone for ForeignKeyCreateStatement

fn clone(&self) -> ForeignKeyCreateStatement

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for ForeignKeyCreateStatement

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

Formats the value using the given formatter.

impl Default for ForeignKeyCreateStatement

fn default() -> Self

Returns the “default value” for a type.