Trait tiberius::ToSql

pub trait ToSql: Send + Sync {
    // Required method
    fn to_sql(&self) -> ColumnData<'_>;
}

A conversion trait to a TDS type.

A ToSql implementation for a Rust type is needed for using it as a parameter in the Client#query or Client#execute methods. The following Rust types are already implemented to match the given server types:

Rust type	Server type
u8	tinyint
i16	smallint
i32	int
i64	bigint
f32	float(24)
f64	float(53)
bool	bit
String/&str (< 4000 characters)	nvarchar(4000)
String/&str	nvarchar(max)
Vec<u8>/&[u8] (< 8000 bytes)	varbinary(8000)
Vec<u8>/&[u8]	varbinary(max)
Uuid	uniqueidentifier
Numeric	numeric/decimal
Decimal (with feature flag rust_decimal)	numeric/decimal
BigDecimal (with feature flag bigdecimal)	numeric/decimal
XmlData	xml
NaiveDate (with chrono feature, TDS 7.3 >)	date
NaiveTime (with chrono feature, TDS 7.3 >)	time
DateTime (with chrono feature, TDS 7.3 >)	datetimeoffset
NaiveDateTime (with chrono feature, TDS 7.3 >)	datetime2
NaiveDateTime (with chrono feature, TDS 7.2)	datetime

It is possible to use some of the types to write into columns that are not of the same type. For example on systems following the TDS 7.3 standard (SQL Server 2008 and later), the chrono type NaiveDateTime can also be used to write to datetime, datetime2 and smalldatetime columns. All string types can also be used with ntext, text, varchar, nchar and char columns. All binary types can also be used with binary and image columns.

See the time module for more information about the date and time structs.

Required Methods

fn to_sql(&self) -> ColumnData<'_>

Convert to a value understood by the SQL Server. Conversion by-reference.

Implementations on Foreign Types

impl ToSql for Option<OffsetDateTime>

Available on crate feature time only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<Decimal>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for bool

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<i16>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<Uuid>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<OffsetDateTime>

Available on crate feature time only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<PrimitiveDateTime>

Available on crate feature time only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<Numeric>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<String>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<&[u8]>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<DateTime<FixedOffset>>

Available on crate feature chrono only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<Uuid>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &str

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<bool>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<Cow<'_, [u8]>>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<BigDecimal>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for f32

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Cow<'_, [u8]>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<i16>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<&str>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<i32>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<Date>

Available on crate feature time only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<XmlData>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<String>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<u8>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<f64>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<i64>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<f32>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<Decimal>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<DateTime<FixedOffset>>

Available on crate feature chrono only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for i32

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<NaiveDateTime>

Available on crate feature chrono only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<Cow<'_, str>>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for u8

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<f64>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<Numeric>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<XmlData>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for i64

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<NaiveDate>

Available on crate feature chrono only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<DateTime<Utc>>

Available on crate feature chrono only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<Time>

Available on crate feature time only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for f64

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<NaiveTime>

Available on crate feature chrono only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &[u8]

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<&[u8]>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<DateTime<Utc>>

Available on crate feature chrono only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<NaiveDateTime>

Available on crate feature chrono only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<NaiveDate>

Available on crate feature chrono only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<u8>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<Time>

Available on crate feature time only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<&str>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<PrimitiveDateTime>

Available on crate feature time only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<Cow<'_, str>>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<i64>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<Cow<'_, [u8]>>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<BigDecimal>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Cow<'_, str>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<Vec<u8>>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<bool>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<i32>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<f32>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for i16

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<NaiveTime>

Available on crate feature chrono only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for &Option<Date>

Available on crate feature time only.

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for String

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Vec<u8>

fn to_sql(&self) -> ColumnData<'_>

impl ToSql for Option<Vec<u8>>

fn to_sql(&self) -> ColumnData<'_>

Implementors

impl ToSql for BigDecimal

impl ToSql for Decimal

impl ToSql for Numeric

impl ToSql for Uuid

impl ToSql for DateTime<FixedOffset>

Available on crate feature chrono only.

impl ToSql for DateTime<Utc>

Available on crate feature chrono only.

impl ToSql for NaiveDate

Available on crate feature chrono only.

impl ToSql for NaiveDateTime

Available on crate feature chrono only.

impl ToSql for NaiveTime

Available on crate feature chrono only.

impl ToSql for Date

Available on crate feature time only.

impl ToSql for OffsetDateTime

Available on crate feature time only.

impl ToSql for PrimitiveDateTime

Available on crate feature time only.

impl ToSql for Time

Available on crate feature time only.

impl ToSql for XmlData