Struct sea_query::index::IndexCreateStatement [−][src]
pub struct IndexCreateStatement { /* fields omitted */ }
Expand description
Create an index for an existing table
Examples
use sea_query::{*, tests_cfg::*}; let index = Index::create() .name("idx-glyph-aspect") .table(Glyph::Table) .col(Glyph::Aspect) .to_owned(); assert_eq!( index.to_string(MysqlQueryBuilder), r#"CREATE INDEX `idx-glyph-aspect` ON `glyph` (`aspect`)"# ); assert_eq!( index.to_string(PostgresQueryBuilder), r#"CREATE INDEX "idx-glyph-aspect" ON "glyph" ("aspect")"# ); assert_eq!( index.to_string(SqliteQueryBuilder), r#"CREATE INDEX `idx-glyph-aspect` ON `glyph` (`aspect`)"# );
Index with prefix
use sea_query::{*, tests_cfg::*}; let index = Index::create() .name("idx-glyph-aspect") .table(Glyph::Table) .col((Glyph::Aspect, 128)) .to_owned(); assert_eq!( index.to_string(MysqlQueryBuilder), r#"CREATE INDEX `idx-glyph-aspect` ON `glyph` (`aspect` (128))"# ); assert_eq!( index.to_string(PostgresQueryBuilder), r#"CREATE INDEX "idx-glyph-aspect" ON "glyph" ("aspect" (128))"# ); assert_eq!( index.to_string(SqliteQueryBuilder), r#"CREATE INDEX `idx-glyph-aspect` ON `glyph` (`aspect`)"# );
Index with order
use sea_query::{*, tests_cfg::*}; let index = Index::create() .name("idx-glyph-aspect") .table(Glyph::Table) .col((Glyph::Aspect, IndexOrder::Desc)) .to_owned(); assert_eq!( index.to_string(MysqlQueryBuilder), r#"CREATE INDEX `idx-glyph-aspect` ON `glyph` (`aspect` DESC)"# ); assert_eq!( index.to_string(PostgresQueryBuilder), r#"CREATE INDEX "idx-glyph-aspect" ON "glyph" ("aspect" DESC)"# ); assert_eq!( index.to_string(SqliteQueryBuilder), r#"CREATE INDEX `idx-glyph-aspect` ON `glyph` (`aspect` DESC)"# );
Index with prefix and order
use sea_query::{*, tests_cfg::*}; let index = Index::create() .name("idx-glyph-aspect") .table(Glyph::Table) .col((Glyph::Aspect, 64, IndexOrder::Asc)) .to_owned(); assert_eq!( index.to_string(MysqlQueryBuilder), r#"CREATE INDEX `idx-glyph-aspect` ON `glyph` (`aspect` (64) ASC)"# ); assert_eq!( index.to_string(PostgresQueryBuilder), r#"CREATE INDEX "idx-glyph-aspect" ON "glyph" ("aspect" (64) ASC)"# ); assert_eq!( index.to_string(SqliteQueryBuilder), r#"CREATE INDEX `idx-glyph-aspect` ON `glyph` (`aspect` ASC)"# );
Implementations
impl IndexCreateStatement
[src]
impl IndexCreateStatement
[src]pub fn new() -> Self
[src]
pub fn new() -> Self
[src]Construct a new IndexCreateStatement
pub fn col<C: 'static>(self, col: C) -> Self where
C: IntoIndexColumn,
[src]
pub fn col<C: 'static>(self, col: C) -> Self where
C: IntoIndexColumn,
[src]Add index column
pub fn full_text(self) -> Self
[src]
pub fn full_text(self) -> Self
[src]Set index as full text.
On MySQL, this is FULLTEXT
.
On PgSQL, this is GIN
.
pub fn index_type(self, index_type: IndexType) -> Self
[src]
pub fn index_type(self, index_type: IndexType) -> Self
[src]Set index type. Not available on Sqlite.
impl IndexCreateStatement
[src]
impl IndexCreateStatement
[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 IndexCreateStatement
[src]
impl Clone for IndexCreateStatement
[src]fn clone(&self) -> IndexCreateStatement
[src]
fn clone(&self) -> IndexCreateStatement
[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 IndexCreateStatement
[src]
impl Debug for IndexCreateStatement
[src]impl Default for IndexCreateStatement
[src]
impl Default for IndexCreateStatement
[src]impl SchemaStatementBuilder for IndexCreateStatement
[src]
impl SchemaStatementBuilder for IndexCreateStatement
[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 IndexCreateStatement
impl !Send for IndexCreateStatement
impl !Sync for IndexCreateStatement
impl Unpin for IndexCreateStatement
impl !UnwindSafe for IndexCreateStatement
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>,