Struct sea_query::index::IndexCreateStatement

pub struct IndexCreateStatement { /* fields omitted */ }

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

pub fn new() -> Self

Construct a new IndexCreateStatement

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

Set index name

pub fn table<T: 'static>(self, table: T) -> Self where
    T: Iden, 

Set target table

pub fn col<C: 'static>(self, col: C) -> Self where
    C: IntoIndexColumn, 

Add index column

pub fn primary(self) -> Self

Set index as primary

pub fn unique(self) -> Self

Set index as unique

pub fn full_text(self) -> Self

Set index as full text. On MySQL, this is FULLTEXT. On PgSQL, this is GIN.

pub fn index_type(self, index_type: IndexType) -> Self

Set index type. Not available on Sqlite.

pub fn build<T: IndexBuilder>(&self, index_builder: T) -> String

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

pub fn build_any(&self, index_builder: &dyn IndexBuilder) -> String

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

pub fn to_string<T: IndexBuilder>(&self, index_builder: T) -> String

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

Trait Implementations

impl Clone for IndexCreateStatement

fn clone(&self) -> IndexCreateStatement

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for IndexCreateStatement

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

Formats the value using the given formatter.

impl Default for IndexCreateStatement

fn default() -> Self

Returns the “default value” for a type.