Struct SqlName

pub struct SqlName { /* private fields */ }

Create safe name of identifier

Examples

#[macro_use] extern crate sql_builder;
use sql_builder::{SqlBuilder, SqlName};

let sql = SqlBuilder::select_from(SqlName::new("public").add("BOOKS").alias("b").baquoted())
    .field(SqlName::new("b").add("title").baquoted())
    .field(SqlName::new("s").add("total").baquoted())
    .left()
    .join(SqlName::new("shops").alias("s").baquoted())
    .on_eq(SqlName::new("b").add("id").baquoted(), SqlName::new("s").add("book").baquoted())
    .sql()?;

assert_eq!("SELECT `b`.`title`, `s`.`total` FROM `public`.`BOOKS` AS b LEFT JOIN `shops` AS s ON `b`.`id` = `s`.`book`;", &sql);

#[macro_use] extern crate sql_builder;
use sql_builder::{SqlBuilder, SqlName};

let sql = SqlBuilder::select_from(baname!("public", "BOOKS"; "b"))
    .field(baname!("b", "title"))
    .field(baname!("s", "total"))
    .left()
    .join(baname!("shops"; "s"))
    .on_eq(baname!("b", "id"), baname!("s", "book"))
    .sql()?;

assert_eq!("SELECT `b`.`title`, `s`.`total` FROM `public`.`BOOKS` AS b LEFT JOIN `shops` AS s ON `b`.`id` = `s`.`book`;", &sql);

Implementations

impl SqlName

pub fn new<S: ToString>(name: S) -> Self

Name of identifier

pub fn add<S: ToString>(&mut self, name: S) -> &mut Self

Add additional part of identifier

pub fn alias<S: ToString>(&mut self, alias: S) -> &mut Self

Set an alias for identifier

pub fn safe(&self) -> String

Make safe identifier

pub fn quoted(&self) -> String

Make quoted identifier

pub fn baquoted(&self) -> String

Make backquoted identifier

pub fn brquoted(&self) -> String

Make bracket-quoted identifier

pub fn dquoted(&self) -> String

Make double quoted identifier

Trait Implementations

impl Clone for SqlName

fn clone(&self) -> SqlName

Returns a copy of the value.

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

Performs copy-assignment from source.