Struct sea_orm_migration::prelude::ForeignKeyCreateStatement

pub struct ForeignKeyCreateStatement { /* private fields */ }

Create a foreign key constraint for an existing table. Unsupported by Sqlite

Examples

use sea_query::{tests_cfg::*, *};

let foreign_key = ForeignKey::create()
    .name("FK_character_font")
    .from(Char::Table, Char::FontId)
    .to(Font::Table, 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 (`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(" ")
);

Composite key

use sea_query::{tests_cfg::*, *};

let foreign_key = ForeignKey::create()
    .name("FK_character_glyph")
    .from(Char::Table, (Char::FontId, Char::Id))
    .to(Glyph::Table, (Char::FontId, Glyph::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_glyph`"#,
        r#"FOREIGN KEY (`font_id`, `id`) REFERENCES `glyph` (`font_id`, `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_glyph""#,
        r#"FOREIGN KEY ("font_id", "id") REFERENCES "glyph" ("font_id", "id")"#,
        r#"ON DELETE CASCADE ON UPDATE CASCADE"#,
    ]
    .join(" ")
);

Implementations

impl ForeignKeyCreateStatement

pub fn new() -> ForeignKeyCreateStatement

Construct a new ForeignKeyCreateStatement

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

Set foreign key name

pub fn table<T, R>(
    &mut self,
    table: T,
    ref_table: R
) -> &mut ForeignKeyCreateStatement where
    T: 'static + Iden,
    R: 'static + Iden, 

👎 Deprecated since 0.10.2:

Please use the [ForeignKeyCreateStatement::from] and [ForeignKeyCreateStatement::to]

Set key table and referencing table

pub fn col<T, R>(
    &mut self,
    column: T,
    ref_column: R
) -> &mut ForeignKeyCreateStatement where
    T: 'static + Iden,
    R: 'static + Iden, 

👎 Deprecated since 0.10.2:

Please use the [ForeignKeyCreateStatement::from] and [ForeignKeyCreateStatement::to]

Set key column and referencing column

pub fn from<T, C>(
    &mut self,
    table: T,
    columns: C
) -> &mut ForeignKeyCreateStatement where
    T: IntoIden,
    C: IdenList, 

Set key table and columns

pub fn to<T, C>(
    &mut self,
    table: T,
    columns: C
) -> &mut ForeignKeyCreateStatement where
    T: IntoIden,
    C: IdenList, 

Set referencing table and columns

pub fn from_tbl<T>(&mut self, table: T) -> &mut ForeignKeyCreateStatement where
    T: IntoIden, 

Set key table

pub fn to_tbl<R>(&mut self, ref_table: R) -> &mut ForeignKeyCreateStatement where
    R: IntoIden, 

Set referencing table

pub fn from_col<T>(&mut self, column: T) -> &mut ForeignKeyCreateStatement where
    T: IntoIden, 

Add key column

pub fn to_col<R>(&mut self, ref_column: R) -> &mut ForeignKeyCreateStatement where
    R: IntoIden, 

Add referencing column

pub fn on_delete(
    &mut self,
    action: ForeignKeyAction
) -> &mut ForeignKeyCreateStatement

Set on delete action

pub fn on_update(
    &mut self,
    action: ForeignKeyAction
) -> &mut ForeignKeyCreateStatement

Set on update action

pub fn get_foreign_key(&self) -> &TableForeignKey

pub fn take(&mut self) -> ForeignKeyCreateStatement

impl ForeignKeyCreateStatement

pub fn to_string<T>(&self, schema_builder: T) -> String where
    T: SchemaBuilder, 

pub fn build<T>(&self, schema_builder: T) -> String where
    T: SchemaBuilder, 

pub fn build_any(&self, schema_builder: &dyn SchemaBuilder) -> String

Trait Implementations

impl Clone for ForeignKeyCreateStatement

fn clone(&self) -> ForeignKeyCreateStatement

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for ForeignKeyCreateStatement

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

Formats the value using the given formatter.

impl Default for ForeignKeyCreateStatement

fn default() -> ForeignKeyCreateStatement

Returns the “default value” for a type.

impl SchemaStatementBuilder for ForeignKeyCreateStatement

fn build<T>(&self, schema_builder: T) -> String where
    T: SchemaBuilder, 

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

fn build_any(&self, schema_builder: &dyn SchemaBuilder) -> String

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

fn to_string<T>(&self, schema_builder: T) -> String where
    T: SchemaBuilder, 

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

impl StatementBuilder for ForeignKeyCreateStatement

fn build(&self, db_backend: &DatabaseBackend) -> Statement

Method to call in order to build a Statement