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
pub fn bulk_insert_sql(
table: impl Into<String>,
columns: Vec<impl Into<String>>,
values: Vec<impl Into<String>>,
item_count: usize,
) -> String {
let table = table.into();
let columns = columns
.into_iter()
.map(|a| a.into())
.collect::<Vec<String>>();
let values = values
.into_iter()
.map(|s| s.into())
.collect::<Vec<String>>();
let column_sql: String = columns.join(", ");
let mut sql = format!("INSERT INTO {} ({}) VALUES ", table, column_sql);
for i in 0..item_count {
let value_sql: String = values.clone().join(", ");
sql.push_str(format!("({})", value_sql).as_str());
if i < item_count - 1 {
sql.push_str(", ");
}
}
sql
}