sibyl 0.7.0

An OCI-based (synchronous or asynchronous) interface between Rust applications and Oracle databases
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99

use crate::types::OracleDataType;
/// Implementation of traits that allow Timestamps to be used as SQL parameters

use crate::{oci::*, ToSql, Result, stmt::Params};
use super::DateTime;
use std::mem::size_of;

macro_rules! impl_ts_to_sql {
    ($($ts:ty),+) => {
        $(
            impl ToSql for DateTime<'_, $ts> {
                fn bind_to(&mut self, pos: usize, params: &mut Params, stmt: &OCIStmt, err: &OCIError) -> Result<usize> {
                    let next_pos = self.datetime.bind_to(pos, params, stmt, err)?;
                    let (year, _, _) = self.date()?;
                    if year == 0 {
                        params.mark_as_null(pos);
                    }
                    Ok(next_pos)
                }
            }
            impl ToSql for &DateTime<'_, $ts> {
                fn bind_to(&mut self, pos: usize, params: &mut Params, stmt: &OCIStmt, err: &OCIError) -> Result<usize> {
                    let len = size_of::<*mut <$ts as DescriptorType>::OCIType>();
                    params.bind(pos, <$ts>::sql_type(), self.datetime.as_ptr() as _, len, len, stmt, err)?;
                    Ok(pos + 1)
                }
            }
            impl ToSql for &mut DateTime<'_, $ts> {
                fn bind_to(&mut self, pos: usize, params: &mut Params, stmt: &OCIStmt, err: &OCIError) -> Result<usize> {
                    (*self).bind_to(pos, params, stmt, err)
                }
            }
            impl ToSql for &[DateTime<'_, $ts>] {
                fn bind_to(&mut self, mut pos: usize, params: &mut Params, stmt: &OCIStmt, err: &OCIError) -> Result<usize> {
                    let len = size_of::<*mut <$ts as DescriptorType>::OCIType>();
                    for item in self.iter() {
                        params.bind(pos, <$ts>::sql_type(), item.datetime.as_ptr() as _, len, len, stmt, err)?;
                        pos += 1;
                    }
                    Ok(pos)
                }
                fn update_from_bind(&mut self, pos: usize, _params: &Params) -> Result<usize> {
                    Ok(pos + self.len())
                }
            }
            impl ToSql for &[&DateTime<'_, $ts>] {
                fn bind_to(&mut self, mut pos: usize, params: &mut Params, stmt: &OCIStmt, err: &OCIError) -> Result<usize> {
                    let len = size_of::<*mut <$ts as DescriptorType>::OCIType>();
                    for &item in self.iter() {
                        params.bind(pos, <$ts>::sql_type(), item.datetime.as_ptr() as _, len, len, stmt, err)?;
                        pos += 1;
                    }
                    Ok(pos)
                }
                fn update_from_bind(&mut self, pos: usize, _params: &Params) -> Result<usize> {
                    Ok(pos + self.len())
                }
            }
            impl ToSql for &mut [&mut DateTime<'_, $ts>] {
                fn bind_to(&mut self, mut pos: usize, params: &mut Params, stmt: &OCIStmt, err: &OCIError) -> Result<usize> {
                    for item in self.iter_mut() {
                        pos = (*item).bind_to(pos, params, stmt, err)?;
                    }
                    Ok(pos)
                }
                fn update_from_bind(&mut self, pos: usize, _params: &Params) -> Result<usize> {
                    Ok(pos + self.len())
                }
            }
            impl SqlType for DateTime<'_, $ts> {
                fn sql_type() -> u16 {
                    <$ts>::sql_type()
                }
            }
            impl SqlType for &DateTime<'_, $ts> {
                fn sql_type() -> u16 {
                    <$ts>::sql_type()
                }
            }
            impl SqlType for &mut DateTime<'_, $ts> {
                fn sql_type() -> u16 {
                    <$ts>::sql_type()
                }
            }
        )+
    };
}

impl_ts_to_sql!{ OCITimestamp, OCITimestampTZ, OCITimestampLTZ }

impl OracleDataType for DateTime<'_, OCITimestamp> {}
impl OracleDataType for &DateTime<'_, OCITimestamp> {}
impl OracleDataType for &mut DateTime<'_, OCITimestamp> {}
impl OracleDataType for DateTime<'_, OCITimestampTZ> {}
impl OracleDataType for &DateTime<'_, OCITimestampTZ> {}
impl OracleDataType for &mut DateTime<'_, OCITimestampTZ> {}
impl OracleDataType for DateTime<'_, OCITimestampLTZ> {}
impl OracleDataType for &DateTime<'_, OCITimestampLTZ> {}
impl OracleDataType for &mut DateTime<'_, OCITimestampLTZ> {}