Struct sea_query::foreign_key::ForeignKeyCreateStatement [−][src]
pub struct ForeignKeyCreateStatement { /* fields omitted */ }
Expand description
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
[src]
impl ForeignKeyCreateStatement
[src]pub fn new() -> Self
[src]
pub fn new() -> Self
[src]Construct a new ForeignKeyCreateStatement
pub fn table<T: 'static, R: 'static>(self, table: T, ref_table: R) -> Self where
T: Iden,
R: Iden,
[src]
👎 Deprecated since 0.10.2: Please use the [ForeignKeyCreateStatement::from
] and [ForeignKeyCreateStatement::to
]
pub fn table<T: 'static, R: 'static>(self, table: T, ref_table: R) -> Self where
T: Iden,
R: Iden,
[src]Please use the [ForeignKeyCreateStatement::from
] and [ForeignKeyCreateStatement::to
]
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,
[src]
👎 Deprecated since 0.10.2: Please use the [ForeignKeyCreateStatement::from
] and [ForeignKeyCreateStatement::to
]
pub fn col<T: 'static, R: 'static>(self, column: T, ref_column: R) -> Self where
T: Iden,
R: Iden,
[src]Please use the [ForeignKeyCreateStatement::from
] and [ForeignKeyCreateStatement::to
]
Set key column and referencing column
pub fn from<T, C>(self, table: T, columns: C) -> Self where
T: IntoIden,
C: IdenList,
[src]
pub fn from<T, C>(self, table: T, columns: C) -> Self where
T: IntoIden,
C: IdenList,
[src]Set key table and columns
pub fn to<T, C>(self, table: T, columns: C) -> Self where
T: IntoIden,
C: IdenList,
[src]
pub fn to<T, C>(self, table: T, columns: C) -> Self where
T: IntoIden,
C: IdenList,
[src]Set referencing table and columns
pub fn on_delete(self, action: ForeignKeyAction) -> Self
[src]
pub fn on_delete(self, action: ForeignKeyAction) -> Self
[src]Set on delete action
pub fn on_update(self, action: ForeignKeyAction) -> Self
[src]
pub fn on_update(self, action: ForeignKeyAction) -> Self
[src]Set on update action
impl ForeignKeyCreateStatement
[src]
impl ForeignKeyCreateStatement
[src]pub fn to_string<T: SchemaBuilder>(&self, schema_builder: T) -> String
[src]
pub fn build<T: SchemaBuilder>(&self, schema_builder: T) -> String
[src]
pub fn build_any(&self, schema_builder: &dyn SchemaBuilder) -> String
[src]
Trait Implementations
impl Clone for ForeignKeyCreateStatement
[src]
impl Clone for ForeignKeyCreateStatement
[src]fn clone(&self) -> ForeignKeyCreateStatement
[src]
fn clone(&self) -> ForeignKeyCreateStatement
[src]Returns a copy of the value. Read more
fn clone_from(&mut self, source: &Self)
1.0.0[src]
fn clone_from(&mut self, source: &Self)
1.0.0[src]Performs copy-assignment from source
. Read more
impl Debug for ForeignKeyCreateStatement
[src]
impl Debug for ForeignKeyCreateStatement
[src]impl Default for ForeignKeyCreateStatement
[src]
impl Default for ForeignKeyCreateStatement
[src]impl SchemaStatementBuilder for ForeignKeyCreateStatement
[src]
impl SchemaStatementBuilder for ForeignKeyCreateStatement
[src]fn build<T: SchemaBuilder>(&self, schema_builder: T) -> String
[src]
fn build<T: SchemaBuilder>(&self, schema_builder: T) -> String
[src]Build corresponding SQL statement for certain database backend and return SQL string
fn build_any(&self, schema_builder: &dyn SchemaBuilder) -> String
[src]
fn build_any(&self, schema_builder: &dyn SchemaBuilder) -> String
[src]Build corresponding SQL statement for certain database backend and return SQL string
fn to_string<T: SchemaBuilder>(&self, schema_builder: T) -> String
[src]
fn to_string<T: SchemaBuilder>(&self, schema_builder: T) -> String
[src]Build corresponding SQL statement for certain database backend and return SQL string
Auto Trait Implementations
impl !RefUnwindSafe for ForeignKeyCreateStatement
impl !Send for ForeignKeyCreateStatement
impl !Sync for ForeignKeyCreateStatement
impl Unpin for ForeignKeyCreateStatement
impl !UnwindSafe for ForeignKeyCreateStatement
Blanket Implementations
impl<T> BorrowMut<T> for T where
T: ?Sized,
[src]
impl<T> BorrowMut<T> for T where
T: ?Sized,
[src]pub fn borrow_mut(&mut self) -> &mut T
[src]
pub fn borrow_mut(&mut self) -> &mut T
[src]Mutably borrows from an owned value. Read more
impl<T> Same<T> for T
impl<T> Same<T> for T
type Output = T
type Output = T
Should always be Self
impl<T> ToOwned for T where
T: Clone,
[src]
impl<T> ToOwned for T where
T: Clone,
[src]type Owned = T
type Owned = T
The resulting type after obtaining ownership.
pub fn to_owned(&self) -> T
[src]
pub fn to_owned(&self) -> T
[src]Creates owned data from borrowed data, usually by cloning. Read more
pub fn clone_into(&self, target: &mut T)
[src]
pub fn clone_into(&self, target: &mut T)
[src]🔬 This is a nightly-only experimental API. (toowned_clone_into
)
recently added
Uses borrowed data to replace owned data, usually by cloning. Read more
impl<V, T> VZip<V> for T where
V: MultiLane<T>,
impl<V, T> VZip<V> for T where
V: MultiLane<T>,