sqlx_core_oldapi/mssql/
arguments.rs

1use crate::arguments::Arguments;
2use crate::encode::Encode;
3use crate::mssql::database::Mssql;
4use crate::mssql::io::MssqlBufMutExt;
5use crate::mssql::protocol::rpc::StatusFlags;
6use crate::types::Type;
7use std::fmt::{self, Write};
8
9#[derive(Default, Clone)]
10pub struct MssqlArguments {
11    // next ordinal to be used when formatting a positional parameter name
12    pub(crate) ordinal: usize,
13    // temporary string buffer used to format parameter names
14    name: String,
15    pub(crate) data: Vec<u8>,
16    pub(crate) declarations: String,
17}
18
19impl MssqlArguments {
20    pub(crate) fn add_named<'q, T: Encode<'q, Mssql> + Type<Mssql>>(
21        &mut self,
22        name: &str,
23        value: T,
24    ) {
25        let ty = value.produces().unwrap_or_else(T::type_info);
26
27        let mut ty_name = String::new();
28        ty.0.fmt(&mut ty_name);
29
30        self.data.put_b_varchar(name); // [ParamName]
31        self.data.push(0); // [StatusFlags]
32
33        ty.0.put(&mut self.data); // [TYPE_INFO]
34        ty.0.put_value(&mut self.data, value); // [ParamLenData]
35    }
36
37    pub(crate) fn add_unnamed<'q, T: Encode<'q, Mssql> + Type<Mssql>>(&mut self, value: T) {
38        self.add_named("", value);
39    }
40
41    pub(crate) fn declare<'q, T: Encode<'q, Mssql> + Type<Mssql>>(
42        &mut self,
43        name: &str,
44        initial_value: T,
45    ) {
46        let ty = initial_value.produces().unwrap_or_else(T::type_info);
47
48        let mut ty_name = String::new();
49        ty.0.fmt(&mut ty_name);
50
51        self.data.put_b_varchar(name); // [ParamName]
52        self.data.push(StatusFlags::BY_REF_VALUE.bits()); // [StatusFlags]
53
54        ty.0.put(&mut self.data); // [TYPE_INFO]
55        ty.0.put_value(&mut self.data, initial_value); // [ParamLenData]
56    }
57
58    pub(crate) fn append(&mut self, arguments: &mut MssqlArguments) {
59        self.ordinal += arguments.ordinal;
60        self.data.append(&mut arguments.data);
61    }
62
63    pub(crate) fn add<'q, T>(&mut self, value: T)
64    where
65        T: Encode<'q, Mssql> + Type<Mssql>,
66    {
67        let ty = value.produces().unwrap_or_else(T::type_info);
68
69        // produce an ordinal parameter name
70        //  @p1, @p2, ... @pN
71
72        self.name.clear();
73        self.name.push_str("@p");
74
75        self.ordinal += 1;
76        self.name.push_str(itoa::Buffer::new().format(self.ordinal));
77
78        let MssqlArguments {
79            ref name,
80            ref mut declarations,
81            ref mut data,
82            ..
83        } = self;
84
85        // add this to our variable declaration list
86        //  @p1 int, @p2 nvarchar(10), ...
87
88        if !declarations.is_empty() {
89            declarations.push_str(",");
90        }
91
92        declarations.push_str(name);
93        declarations.push(' ');
94        ty.0.fmt(declarations);
95
96        // write out the parameter
97
98        data.put_b_varchar(name); // [ParamName]
99        data.push(0); // [StatusFlags]
100
101        ty.0.put(data); // [TYPE_INFO]
102        ty.0.put_value(data, value); // [ParamLenData]
103    }
104}
105
106impl<'q> Arguments<'q> for MssqlArguments {
107    type Database = Mssql;
108
109    fn reserve(&mut self, _additional: usize, size: usize) {
110        self.data.reserve(size + 10); // est. 4 chars for name, 1 for status, 1 for TYPE_INFO
111    }
112
113    fn add<T>(&mut self, value: T)
114    where
115        T: 'q + Encode<'q, Self::Database> + Type<Mssql>,
116    {
117        self.add(value)
118    }
119
120    fn format_placeholder<W: Write>(&self, writer: &mut W) -> fmt::Result {
121        // self.ordinal is incremented by the `MssqlArguments::add` method (the inherent one)
122        // *before* this `format_placeholder` method is called by QueryBuilder.
123        // So, `self.ordinal` correctly represents the number of the current parameter (e.g., 1 for @p1).
124        writer.write_str("@p")?;
125        writer.write_str(itoa::Buffer::new().format(self.ordinal))
126    }
127}
128
129#[cfg(test)]
130mod tests {
131    use super::*;
132    use crate::query_builder::QueryBuilder;
133
134    #[test]
135    fn test_format_placeholder_method() {
136        let mut args = MssqlArguments::default(); // ordinal = 0 initially
137        let mut buffer = String::new();
138
139        // Simulate first bind operation sequence as done by QueryBuilder:
140        // 1. QueryBuilder calls MssqlArguments::add (via trait)
141        // 2. QueryBuilder calls MssqlArguments::format_placeholder (via trait)
142
143        // First bind:
144        args.add(123i32); // This calls the inherent `MssqlArguments::add`, which increments ordinal to 1.
145        args.format_placeholder(&mut buffer).unwrap(); // This should now use ordinal = 1.
146        assert_eq!(buffer, "@p1");
147
148        buffer.clear();
149
150        // Second bind:
151        args.add("test_val".to_string()); // Inherent `add` increments ordinal to 2.
152        args.format_placeholder(&mut buffer).unwrap(); // This should use ordinal = 2.
153        assert_eq!(buffer, "@p2");
154    }
155
156    #[test]
157    fn test_query_builder_with_mssql_placeholders() {
158        // This test replicates the scenario from GitHub issue #11
159        let id = 100;
160        let mut builder = QueryBuilder::<Mssql>::new("SELECT * FROM table ");
161        builder
162            .push("WHERE id=")
163            .push_bind(id)
164            .push(" AND name=")
165            .push_bind("test");
166        let sql = builder.sql(); // Get the generated SQL string
167
168        assert_eq!(sql, "SELECT * FROM table WHERE id=@p1 AND name=@p2");
169    }
170}
sqlx_core_oldapi/mssql/arguments.rs

sqlx_core_oldapi/mssql/
arguments.rs
