Struct 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 duplicate of the value.

const 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