Struct CommentStatement 

pub struct CommentStatement { /* private fields */ }

Implementations

impl CommentStatement

pub fn new(drop: bool) -> Self

pub fn schema<I>(&mut self, name: I) -> &mut Self

where I: IntoIden,

pub fn table<I>(&mut self, name: I) -> &mut Self

where I: IntoIden,

Add a table comment.

use sea_query::{extension::mssql::Comment, tests_cfg::*, *};

assert_eq!(
    Comment::add()
        .schema(Alias::new("dbo"))
        .table(Font::Table)
        .comment("The Font Collection.")
        .to_string(MsSqlQueryBuilder),
    r#"EXEC sp_addextendedproperty 'MS_Description', 'The Font Collection.', 'SCHEMA', 'dbo', 'TABLE', 'font'"#
);

pub fn column<I>(&mut self, name: I) -> &mut Self

where I: IntoIden,

Add a column comment.

use sea_query::{extension::mssql::Comment, tests_cfg::*, *};

assert_eq!(
    Comment::add()
        .schema(Alias::new("dbo"))
        .table(Font::Table)
        .column(Font::Name)
        .comment("Font's name.")
        .to_string(MsSqlQueryBuilder),
    r#"EXEC sp_addextendedproperty 'MS_Description', 'Font''s name.', 'SCHEMA', 'dbo', 'TABLE', 'font', 'COLUMN', 'name'"#
);

pub fn comment<V>(&mut self, value: V) -> &mut Self

where V: Into<String>,

pub fn take(&mut self) -> Self

impl CommentStatement

pub fn build_ref<T: CommentStatementBuilder>(&self, type_builder: &T) -> String

pub fn build_collect<T: CommentStatementBuilder>( &self, type_builder: T, sql: &mut impl SqlWriter, ) -> String

pub fn build_collect_ref<T: CommentStatementBuilder>( &self, type_builder: &T, sql: &mut impl SqlWriter, ) -> String

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

where T: CommentStatementBuilder + QueryBuilder,

Build corresponding SQL statement and return SQL string

Trait Implementations

impl Clone for CommentStatement

fn clone(&self) -> CommentStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for CommentStatement

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

Formats the value using the given formatter.