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
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
// Code generated by software.amazon.smithy.rust.codegen.smithy-rs. DO NOT EDIT.
/// <p>The request parameters represent the input of a SQL statement over an array of data.</p>
#[non_exhaustive]
#[derive(::std::clone::Clone, ::std::cmp::PartialEq, ::std::fmt::Debug)]
pub struct BatchExecuteStatementInput {
/// <p>The Amazon Resource Name (ARN) of the Aurora Serverless DB cluster.</p>
pub resource_arn: ::std::option::Option<::std::string::String>,
/// <p>The ARN of the secret that enables access to the DB cluster. Enter the database user name and password for the credentials in the secret.</p>
/// <p>For information about creating the secret, see <a href="https://docs.aws.amazon.com/secretsmanager/latest/userguide/create_database_secret.html">Create a database secret</a>.</p>
pub secret_arn: ::std::option::Option<::std::string::String>,
/// <p>The SQL statement to run. Don't include a semicolon (;) at the end of the SQL statement.</p>
pub sql: ::std::option::Option<::std::string::String>,
/// <p>The name of the database.</p>
pub database: ::std::option::Option<::std::string::String>,
/// <p>The name of the database schema.</p><note>
/// <p>Currently, the <code>schema</code> parameter isn't supported.</p>
/// </note>
pub schema: ::std::option::Option<::std::string::String>,
/// <p>The parameter set for the batch operation.</p>
/// <p>The SQL statement is executed as many times as the number of parameter sets provided. To execute a SQL statement with no parameters, use one of the following options:</p>
/// <ul>
/// <li>
/// <p>Specify one or more empty parameter sets.</p></li>
/// <li>
/// <p>Use the <code>ExecuteStatement</code> operation instead of the <code>BatchExecuteStatement</code> operation.</p></li>
/// </ul><note>
/// <p>Array parameters are not supported.</p>
/// </note>
pub parameter_sets: ::std::option::Option<::std::vec::Vec<::std::vec::Vec<crate::types::SqlParameter>>>,
/// <p>The identifier of a transaction that was started by using the <code>BeginTransaction</code> operation. Specify the transaction ID of the transaction that you want to include the SQL statement in.</p>
/// <p>If the SQL statement is not part of a transaction, don't set this parameter.</p>
pub transaction_id: ::std::option::Option<::std::string::String>,
}
impl BatchExecuteStatementInput {
/// <p>The Amazon Resource Name (ARN) of the Aurora Serverless DB cluster.</p>
pub fn resource_arn(&self) -> ::std::option::Option<&str> {
self.resource_arn.as_deref()
}
/// <p>The ARN of the secret that enables access to the DB cluster. Enter the database user name and password for the credentials in the secret.</p>
/// <p>For information about creating the secret, see <a href="https://docs.aws.amazon.com/secretsmanager/latest/userguide/create_database_secret.html">Create a database secret</a>.</p>
pub fn secret_arn(&self) -> ::std::option::Option<&str> {
self.secret_arn.as_deref()
}
/// <p>The SQL statement to run. Don't include a semicolon (;) at the end of the SQL statement.</p>
pub fn sql(&self) -> ::std::option::Option<&str> {
self.sql.as_deref()
}
/// <p>The name of the database.</p>
pub fn database(&self) -> ::std::option::Option<&str> {
self.database.as_deref()
}
/// <p>The name of the database schema.</p><note>
/// <p>Currently, the <code>schema</code> parameter isn't supported.</p>
/// </note>
pub fn schema(&self) -> ::std::option::Option<&str> {
self.schema.as_deref()
}
/// <p>The parameter set for the batch operation.</p>
/// <p>The SQL statement is executed as many times as the number of parameter sets provided. To execute a SQL statement with no parameters, use one of the following options:</p>
/// <ul>
/// <li>
/// <p>Specify one or more empty parameter sets.</p></li>
/// <li>
/// <p>Use the <code>ExecuteStatement</code> operation instead of the <code>BatchExecuteStatement</code> operation.</p></li>
/// </ul><note>
/// <p>Array parameters are not supported.</p>
/// </note>
///
/// If no value was sent for this field, a default will be set. If you want to determine if no value was sent, use `.parameter_sets.is_none()`.
pub fn parameter_sets(&self) -> &[::std::vec::Vec<crate::types::SqlParameter>] {
self.parameter_sets.as_deref().unwrap_or_default()
}
/// <p>The identifier of a transaction that was started by using the <code>BeginTransaction</code> operation. Specify the transaction ID of the transaction that you want to include the SQL statement in.</p>
/// <p>If the SQL statement is not part of a transaction, don't set this parameter.</p>
pub fn transaction_id(&self) -> ::std::option::Option<&str> {
self.transaction_id.as_deref()
}
}
impl BatchExecuteStatementInput {
/// Creates a new builder-style object to manufacture [`BatchExecuteStatementInput`](crate::operation::batch_execute_statement::BatchExecuteStatementInput).
pub fn builder() -> crate::operation::batch_execute_statement::builders::BatchExecuteStatementInputBuilder {
crate::operation::batch_execute_statement::builders::BatchExecuteStatementInputBuilder::default()
}
}
/// A builder for [`BatchExecuteStatementInput`](crate::operation::batch_execute_statement::BatchExecuteStatementInput).
#[derive(::std::clone::Clone, ::std::cmp::PartialEq, ::std::default::Default, ::std::fmt::Debug)]
#[non_exhaustive]
pub struct BatchExecuteStatementInputBuilder {
pub(crate) resource_arn: ::std::option::Option<::std::string::String>,
pub(crate) secret_arn: ::std::option::Option<::std::string::String>,
pub(crate) sql: ::std::option::Option<::std::string::String>,
pub(crate) database: ::std::option::Option<::std::string::String>,
pub(crate) schema: ::std::option::Option<::std::string::String>,
pub(crate) parameter_sets: ::std::option::Option<::std::vec::Vec<::std::vec::Vec<crate::types::SqlParameter>>>,
pub(crate) transaction_id: ::std::option::Option<::std::string::String>,
}
impl BatchExecuteStatementInputBuilder {
/// <p>The Amazon Resource Name (ARN) of the Aurora Serverless DB cluster.</p>
/// This field is required.
pub fn resource_arn(mut self, input: impl ::std::convert::Into<::std::string::String>) -> Self {
self.resource_arn = ::std::option::Option::Some(input.into());
self
}
/// <p>The Amazon Resource Name (ARN) of the Aurora Serverless DB cluster.</p>
pub fn set_resource_arn(mut self, input: ::std::option::Option<::std::string::String>) -> Self {
self.resource_arn = input;
self
}
/// <p>The Amazon Resource Name (ARN) of the Aurora Serverless DB cluster.</p>
pub fn get_resource_arn(&self) -> &::std::option::Option<::std::string::String> {
&self.resource_arn
}
/// <p>The ARN of the secret that enables access to the DB cluster. Enter the database user name and password for the credentials in the secret.</p>
/// <p>For information about creating the secret, see <a href="https://docs.aws.amazon.com/secretsmanager/latest/userguide/create_database_secret.html">Create a database secret</a>.</p>
/// This field is required.
pub fn secret_arn(mut self, input: impl ::std::convert::Into<::std::string::String>) -> Self {
self.secret_arn = ::std::option::Option::Some(input.into());
self
}
/// <p>The ARN of the secret that enables access to the DB cluster. Enter the database user name and password for the credentials in the secret.</p>
/// <p>For information about creating the secret, see <a href="https://docs.aws.amazon.com/secretsmanager/latest/userguide/create_database_secret.html">Create a database secret</a>.</p>
pub fn set_secret_arn(mut self, input: ::std::option::Option<::std::string::String>) -> Self {
self.secret_arn = input;
self
}
/// <p>The ARN of the secret that enables access to the DB cluster. Enter the database user name and password for the credentials in the secret.</p>
/// <p>For information about creating the secret, see <a href="https://docs.aws.amazon.com/secretsmanager/latest/userguide/create_database_secret.html">Create a database secret</a>.</p>
pub fn get_secret_arn(&self) -> &::std::option::Option<::std::string::String> {
&self.secret_arn
}
/// <p>The SQL statement to run. Don't include a semicolon (;) at the end of the SQL statement.</p>
/// This field is required.
pub fn sql(mut self, input: impl ::std::convert::Into<::std::string::String>) -> Self {
self.sql = ::std::option::Option::Some(input.into());
self
}
/// <p>The SQL statement to run. Don't include a semicolon (;) at the end of the SQL statement.</p>
pub fn set_sql(mut self, input: ::std::option::Option<::std::string::String>) -> Self {
self.sql = input;
self
}
/// <p>The SQL statement to run. Don't include a semicolon (;) at the end of the SQL statement.</p>
pub fn get_sql(&self) -> &::std::option::Option<::std::string::String> {
&self.sql
}
/// <p>The name of the database.</p>
pub fn database(mut self, input: impl ::std::convert::Into<::std::string::String>) -> Self {
self.database = ::std::option::Option::Some(input.into());
self
}
/// <p>The name of the database.</p>
pub fn set_database(mut self, input: ::std::option::Option<::std::string::String>) -> Self {
self.database = input;
self
}
/// <p>The name of the database.</p>
pub fn get_database(&self) -> &::std::option::Option<::std::string::String> {
&self.database
}
/// <p>The name of the database schema.</p><note>
/// <p>Currently, the <code>schema</code> parameter isn't supported.</p>
/// </note>
pub fn schema(mut self, input: impl ::std::convert::Into<::std::string::String>) -> Self {
self.schema = ::std::option::Option::Some(input.into());
self
}
/// <p>The name of the database schema.</p><note>
/// <p>Currently, the <code>schema</code> parameter isn't supported.</p>
/// </note>
pub fn set_schema(mut self, input: ::std::option::Option<::std::string::String>) -> Self {
self.schema = input;
self
}
/// <p>The name of the database schema.</p><note>
/// <p>Currently, the <code>schema</code> parameter isn't supported.</p>
/// </note>
pub fn get_schema(&self) -> &::std::option::Option<::std::string::String> {
&self.schema
}
/// Appends an item to `parameter_sets`.
///
/// To override the contents of this collection use [`set_parameter_sets`](Self::set_parameter_sets).
///
/// <p>The parameter set for the batch operation.</p>
/// <p>The SQL statement is executed as many times as the number of parameter sets provided. To execute a SQL statement with no parameters, use one of the following options:</p>
/// <ul>
/// <li>
/// <p>Specify one or more empty parameter sets.</p></li>
/// <li>
/// <p>Use the <code>ExecuteStatement</code> operation instead of the <code>BatchExecuteStatement</code> operation.</p></li>
/// </ul><note>
/// <p>Array parameters are not supported.</p>
/// </note>
pub fn parameter_sets(mut self, input: ::std::vec::Vec<crate::types::SqlParameter>) -> Self {
let mut v = self.parameter_sets.unwrap_or_default();
v.push(input);
self.parameter_sets = ::std::option::Option::Some(v);
self
}
/// <p>The parameter set for the batch operation.</p>
/// <p>The SQL statement is executed as many times as the number of parameter sets provided. To execute a SQL statement with no parameters, use one of the following options:</p>
/// <ul>
/// <li>
/// <p>Specify one or more empty parameter sets.</p></li>
/// <li>
/// <p>Use the <code>ExecuteStatement</code> operation instead of the <code>BatchExecuteStatement</code> operation.</p></li>
/// </ul><note>
/// <p>Array parameters are not supported.</p>
/// </note>
pub fn set_parameter_sets(mut self, input: ::std::option::Option<::std::vec::Vec<::std::vec::Vec<crate::types::SqlParameter>>>) -> Self {
self.parameter_sets = input;
self
}
/// <p>The parameter set for the batch operation.</p>
/// <p>The SQL statement is executed as many times as the number of parameter sets provided. To execute a SQL statement with no parameters, use one of the following options:</p>
/// <ul>
/// <li>
/// <p>Specify one or more empty parameter sets.</p></li>
/// <li>
/// <p>Use the <code>ExecuteStatement</code> operation instead of the <code>BatchExecuteStatement</code> operation.</p></li>
/// </ul><note>
/// <p>Array parameters are not supported.</p>
/// </note>
pub fn get_parameter_sets(&self) -> &::std::option::Option<::std::vec::Vec<::std::vec::Vec<crate::types::SqlParameter>>> {
&self.parameter_sets
}
/// <p>The identifier of a transaction that was started by using the <code>BeginTransaction</code> operation. Specify the transaction ID of the transaction that you want to include the SQL statement in.</p>
/// <p>If the SQL statement is not part of a transaction, don't set this parameter.</p>
pub fn transaction_id(mut self, input: impl ::std::convert::Into<::std::string::String>) -> Self {
self.transaction_id = ::std::option::Option::Some(input.into());
self
}
/// <p>The identifier of a transaction that was started by using the <code>BeginTransaction</code> operation. Specify the transaction ID of the transaction that you want to include the SQL statement in.</p>
/// <p>If the SQL statement is not part of a transaction, don't set this parameter.</p>
pub fn set_transaction_id(mut self, input: ::std::option::Option<::std::string::String>) -> Self {
self.transaction_id = input;
self
}
/// <p>The identifier of a transaction that was started by using the <code>BeginTransaction</code> operation. Specify the transaction ID of the transaction that you want to include the SQL statement in.</p>
/// <p>If the SQL statement is not part of a transaction, don't set this parameter.</p>
pub fn get_transaction_id(&self) -> &::std::option::Option<::std::string::String> {
&self.transaction_id
}
/// Consumes the builder and constructs a [`BatchExecuteStatementInput`](crate::operation::batch_execute_statement::BatchExecuteStatementInput).
pub fn build(
self,
) -> ::std::result::Result<crate::operation::batch_execute_statement::BatchExecuteStatementInput, ::aws_smithy_types::error::operation::BuildError>
{
::std::result::Result::Ok(crate::operation::batch_execute_statement::BatchExecuteStatementInput {
resource_arn: self.resource_arn,
secret_arn: self.secret_arn,
sql: self.sql,
database: self.database,
schema: self.schema,
parameter_sets: self.parameter_sets,
transaction_id: self.transaction_id,
})
}
}