Struct oracle::SqlValue

pub struct SqlValue<'a> { /* private fields */ }

A type containing an Oracle value

When this is a column value in a select statement, the Oracle type is determined by the column type.

When this is a bind value in a SQL statement, the Oracle type is determined by ToSql::oratype.

Implementations

impl SqlValue<'_>

pub fn get<T>(&self) -> Result<T>

where T: FromSql,

Gets the Oracle value. It internally does the followings:

1. Checks whether the conversion from the Oracle type to the target rust type is allowed. It returns Err(Error::InvalidTypeConversion(...)) when it isn’t allowed.
2. Checks whether the Oracle value is null. When it is null and the return type is Option<FromSql>, it returns Ok(None). When it is null and it isn’t Option<FromSql>, it returns Err(Error::NullValue).
3. Converts the Oracle value to the rust value. The data type is converted implicitly if required. For example string is converted to i64 by str::parse if get::<i64>() is called for VARCHAR2 columns. If the conversion fails, various errors are returned.

pub fn set(&mut self, val: &dyn ToSql) -> Result<()>

Sets a rust value to the Oracle value. It internally does the followings:

1. Checks whether the conversion from the rust type to the target Oracle type is allowed. It returns Err(Error::InvalidTypeConversion(...)) when it isn’t allowed.
2. When the argument type is None::<ToSql>, null is set.
3. Otherwise, converts the rust value to the Oracle value. The data type is converted implicitly if required. For example i64 is converted to string by to_string() if set(100i64) is called for VARCHAR2 columns. When the argument is None::<ToSql> If the conversion fails, various errors are returned.

pub fn is_null(&self) -> Result<bool>

Returns Ok(true) when the SQL value is null. Ok(false) when it isn’t null.

pub fn set_null(&mut self) -> Result<()>

Sets null to the SQL value.

pub fn oracle_type(&self) -> Result<&OracleType>

Gets the Oracle type of the SQL value.

Trait Implementations

impl Debug for SqlValue<'_>

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

Formats the value using the given formatter.

impl Display for SqlValue<'_>

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

Formats any SQL value to string using the given formatter. Note that both a null value and a string NULL are formatted as NULL.