cli/data/
sql.rs

1// Copyright 2023 Greptime Team
2//
3// Licensed under the Apache License, Version 2.0 (the "License");
4// you may not use this file except in compliance with the License.
5// You may obtain a copy of the License at
6//
7//     http://www.apache.org/licenses/LICENSE-2.0
8//
9// Unless required by applicable law or agreed to in writing, software
10// distributed under the License is distributed on an "AS IS" BASIS,
11// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
12// See the License for the specific language governing permissions and
13// limitations under the License.
14
15//! Shared SQL escaping helpers for CLI-generated statements.
16
17pub(crate) fn escape_sql_literal(value: &str) -> String {
18    value.replace('\'', "''")
19}
20
21pub(crate) fn escape_sql_identifier(value: &str) -> String {
22    value.replace('"', "\"\"")
23}
24
25#[cfg(test)]
26mod tests {
27    use super::*;
28
29    #[test]
30    fn test_escape_sql_literal_escapes_single_quotes() {
31        assert_eq!(escape_sql_literal("test_db"), "test_db");
32        assert_eq!(escape_sql_literal("te'st"), "te''st");
33    }
34
35    #[test]
36    fn test_escape_sql_identifier_escapes_double_quotes() {
37        assert_eq!(escape_sql_identifier("test_db"), "test_db");
38        assert_eq!(escape_sql_identifier(r#"te"st"#), r#"te""st"#);
39    }
40}
cli/data/sql.rs

cli/data/
sql.rs
