Struct sea_query::table::TableCreateStatement [−][src]
Create a table
Examples
use sea_query::{*, tests_cfg::*}; let table = Table::create() .table(Char::Table) .create_if_not_exists() .col(ColumnDef::new(Char::Id).integer().not_null().auto_increment().primary_key()) .col(ColumnDef::new(Char::FontSize).integer().not_null()) .col(ColumnDef::new(Char::Character).string().not_null()) .col(ColumnDef::new(Char::SizeW).integer().not_null()) .col(ColumnDef::new(Char::SizeH).integer().not_null()) .col(ColumnDef::new(Char::FontId).integer().default(Value::Null)) .foreign_key( ForeignKey::create() .name("FK_2e303c3a712662f1fc2a4d0aad6") .table(Char::Table, Font::Table) .col(Char::FontId, Font::Id) .on_delete(ForeignKeyAction::Cascade) .on_update(ForeignKeyAction::Cascade) ) .to_owned(); assert_eq!( table.to_string(MysqlQueryBuilder), vec![ r#"CREATE TABLE IF NOT EXISTS `character` ("#, r#"`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,"#, r#"`font_size` int NOT NULL,"#, r#"`character` varchar(255) NOT NULL,"#, r#"`size_w` int NOT NULL,"#, r#"`size_h` int NOT NULL,"#, r#"`font_id` int DEFAULT NULL,"#, r#"CONSTRAINT `FK_2e303c3a712662f1fc2a4d0aad6`"#, r#"FOREIGN KEY `FK_2e303c3a712662f1fc2a4d0aad6` (`font_id`) REFERENCES `font` (`id`)"#, r#"ON DELETE CASCADE ON UPDATE CASCADE"#, r#")"#, ].join(" ") ); assert_eq!( table.to_string(PostgresQueryBuilder), vec![ r#"CREATE TABLE IF NOT EXISTS "character" ("#, r#""id" serial NOT NULL PRIMARY KEY,"#, r#""font_size" integer NOT NULL,"#, r#""character" varchar NOT NULL,"#, r#""size_w" integer NOT NULL,"#, r#""size_h" integer NOT NULL,"#, r#""font_id" integer DEFAULT NULL,"#, r#"CONSTRAINT "FK_2e303c3a712662f1fc2a4d0aad6""#, r#"FOREIGN KEY ("font_id") REFERENCES "font" ("id")"#, r#"ON DELETE CASCADE ON UPDATE CASCADE"#, r#")"#, ].join(" ") ); assert_eq!( table.to_string(SqliteQueryBuilder), vec![ r#"CREATE TABLE IF NOT EXISTS `character` ("#, r#"`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT,"#, r#"`font_size` integer NOT NULL,"#, r#"`character` text NOT NULL,"#, r#"`size_w` integer NOT NULL,"#, r#"`size_h` integer NOT NULL,"#, r#"`font_id` integer DEFAULT NULL,"#, r#"FOREIGN KEY (`font_id`) REFERENCES `font` (`id`) ON DELETE CASCADE ON UPDATE CASCADE"#, r#")"#, ].join(" ") );
Implementations
impl TableCreateStatement
[src]
pub fn new() -> Self
[src]
Construct create table statement
pub fn create_if_not_exists(&mut self) -> &mut Self
[src]
Create table if table not exists
pub fn table<T: 'static>(&mut self, table: T) -> &mut Self where
T: Iden,
[src]
T: Iden,
Set table name
pub fn col(&mut self, column: ColumnDef) -> &mut Self
[src]
Add a new table column
pub fn foreign_key(
&mut self,
foreign_key: ForeignKeyCreateStatement
) -> &mut Self
[src]
&mut self,
foreign_key: ForeignKeyCreateStatement
) -> &mut Self
Add a foreign key
pub fn engine(&mut self, string: &str) -> &mut Self
[src]
Set database engine (for MySQL only)
pub fn collate(&mut self, string: &str) -> &mut Self
[src]
Set database collate (for MySQL only)
pub fn character_set(&mut self, string: &str) -> &mut Self
[src]
Set database character set (for MySQL only)
pub fn build<T: TableBuilder>(&self, table_builder: T) -> String
[src]
Build corresponding SQL statement for certain database backend and return SQL string
pub fn build_any(&self, table_builder: &dyn TableBuilder) -> String
[src]
Build corresponding SQL statement for certain database backend and return SQL string
pub fn to_string<T: TableBuilder>(&self, table_builder: T) -> String
[src]
Build corresponding SQL statement for certain database backend and return SQL string
Trait Implementations
impl Clone for TableCreateStatement
[src]
fn clone(&self) -> TableCreateStatement
[src]
pub fn clone_from(&mut self, source: &Self)
1.0.0[src]
impl Debug for TableCreateStatement
[src]
impl Default for TableCreateStatement
[src]
Auto Trait Implementations
impl !RefUnwindSafe for TableCreateStatement
impl !Send for TableCreateStatement
impl !Sync for TableCreateStatement
impl Unpin for TableCreateStatement
impl !UnwindSafe for TableCreateStatement
Blanket Implementations
impl<T> Any for T where
T: 'static + ?Sized,
[src]
T: 'static + ?Sized,
impl<T> Borrow<T> for T where
T: ?Sized,
[src]
T: ?Sized,
impl<T> BorrowMut<T> for T where
T: ?Sized,
[src]
T: ?Sized,
pub fn borrow_mut(&mut self) -> &mut T
[src]
impl<T> From<T> for T
[src]
impl<T, U> Into<U> for T where
U: From<T>,
[src]
U: From<T>,
impl<T> Same<T> for T
type Output = T
Should always be Self
impl<T> ToOwned for T where
T: Clone,
[src]
T: Clone,
type Owned = T
The resulting type after obtaining ownership.
pub fn to_owned(&self) -> T
[src]
pub fn clone_into(&self, target: &mut T)
[src]
impl<T, U> TryFrom<U> for T where
U: Into<T>,
[src]
U: Into<T>,
type Error = Infallible
The type returned in the event of a conversion error.
pub fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>
[src]
impl<T, U> TryInto<U> for T where
U: TryFrom<T>,
[src]
U: TryFrom<T>,
type Error = <U as TryFrom<T>>::Error
The type returned in the event of a conversion error.
pub fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>
[src]
impl<V, T> VZip<V> for T where
V: MultiLane<T>,
V: MultiLane<T>,