fraiseql-db 2.3.0

Database abstraction layer for FraiseQL v2
Documentation 
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

use super::*;

#[test]
fn test_postgres_simple_identifier() {
    assert_eq!(quote_postgres_identifier("v_user"), "\"v_user\"");
}

#[test]
fn test_postgres_schema_qualified() {
    assert_eq!(quote_postgres_identifier("benchmark.v_user"), "\"benchmark\".\"v_user\"");
}

#[test]
fn test_postgres_three_part_name() {
    assert_eq!(
        quote_postgres_identifier("catalog.schema.table"),
        "\"catalog\".\"schema\".\"table\""
    );
}

#[test]
fn test_mysql_simple_identifier() {
    assert_eq!(quote_mysql_identifier("v_user"), "`v_user`");
}

#[test]
fn test_mysql_schema_qualified() {
    assert_eq!(quote_mysql_identifier("mydb.v_user"), "`mydb`.`v_user`");
}

#[test]
fn test_mysql_three_part_name() {
    assert_eq!(quote_mysql_identifier("catalog.schema.table"), "`catalog`.`schema`.`table`");
}

#[test]
fn test_sqlite_simple_identifier() {
    assert_eq!(quote_sqlite_identifier("v_user"), "\"v_user\"");
}

#[test]
fn test_sqlite_schema_qualified() {
    assert_eq!(quote_sqlite_identifier("main.v_user"), "\"main\".\"v_user\"");
}

#[test]
fn test_sqlite_three_part_name() {
    assert_eq!(
        quote_sqlite_identifier("catalog.schema.table"),
        "\"catalog\".\"schema\".\"table\""
    );
}

#[test]
fn test_sqlserver_simple_identifier() {
    assert_eq!(quote_sqlserver_identifier("v_user"), "[v_user]");
}

#[test]
fn test_sqlserver_schema_qualified() {
    assert_eq!(quote_sqlserver_identifier("dbo.v_user"), "[dbo].[v_user]");
}

#[test]
fn test_sqlserver_three_part_name() {
    assert_eq!(quote_sqlserver_identifier("catalog.schema.table"), "[catalog].[schema].[table]");
}

// Delimiter-escape tests — the delimiter character must be doubled inside the quoted name.

#[test]
fn test_postgres_escapes_embedded_double_quote() {
    // A double-quote inside a PostgreSQL quoted identifier must be doubled ("").
    assert_eq!(quote_postgres_identifier("evil\"inject"), "\"evil\"\"inject\"");
}

#[test]
fn test_sqlite_escapes_embedded_double_quote() {
    assert_eq!(quote_sqlite_identifier("evil\"inject"), "\"evil\"\"inject\"");
}

#[test]
fn test_mysql_escapes_embedded_backtick() {
    // A backtick inside a MySQL quoted identifier must be doubled (``).
    assert_eq!(quote_mysql_identifier("evil`inject"), "`evil``inject`");
}

#[test]
fn test_sqlserver_escapes_embedded_bracket() {
    // A closing bracket ']' inside a SQL Server quoted identifier must be doubled ']]'.
    // Single identifier component containing ']':
    assert_eq!(quote_sqlserver_identifier("evil]inject"), "[evil]]inject]");
    // Schema-qualified name where each part escapes its own ']':
    assert_eq!(quote_sqlserver_identifier("dbo.evil]inject"), "[dbo].[evil]]inject]");
}