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
|
// Copyright (c) 2022 Teddy Wing
//
// This file is part of Yaqlite.
//
// Yaqlite is free software: you can redistribute it and/or modify it
// under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Yaqlite is distributed in the hope that it will be useful, but
// WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
// General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Yaqlite. If not, see <https://www.gnu.org/licenses/>.
// Copyright (c) 2022 Teddy Wing
//
// This file is part of Yaqlite.
//
// Yaqlite is free software: you can redistribute it and/or modify it
// under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Yaqlite is distributed in the hope that it will be useful, but
// WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
// General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Yaqlite. If not, see <https://www.gnu.org/licenses/>.
use rusqlite;
use std::collections::HashSet;
/// Get a list of the column names in the given table.
pub fn get_column_names(
dbconn: &rusqlite::Connection,
table_name: &str,
) -> Result<HashSet<String>, crate::Error> {
let mut column_names = HashSet::new();
let mut stmt = dbconn.prepare(
&format!(
r#"
SELECT "name"
FROM pragma_table_info("{}");
"#,
table_name,
),
)?;
let rows = stmt.query_map(
[],
|row| row.get(0),
)?;
for row_result in rows {
let row = row_result?;
column_names.insert(row);
}
Ok(column_names)
}
/// Get the name of the given table's primary key.
pub fn table_primary_key_column(
dbconn: &rusqlite::Connection,
table_name: &str,
) -> Result<String, crate::Error> {
let mut stmt = dbconn.prepare(r#"
SELECT "name"
FROM pragma_table_info(:table)
WHERE "pk" != 0;'
"#)?;
let pk_column: String = stmt.query_row(
&[(":table", table_name)],
|row| row.get(0),
)?;
Ok(pk_column)
}
#[cfg(test)]
mod tests {
use super::*;
#[test]
fn table_primary_key_column_gets_primary_key_name() {
let conn = rusqlite::Connection::open_in_memory().unwrap();
conn.execute(
r#"
CREATE TABLE "test" (
id INTEGER PRIMARY KEY,
count INTEGER
);
"#,
[]
).unwrap();
let column_name = table_primary_key_column(&conn, "test").unwrap();
assert_eq!("id", column_name);
conn.close().unwrap();
}
}
|
