sqlt 0.3.2

SQL parser, translator, and linter for MySQL, MariaDB, Postgres, MSSQL, SQLite
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

//! Smoke test: every fixture under `tests/fixtures/<dialect>/*.sql` must parse
//! cleanly with its declared dialect.

use std::fs;
use std::path::Path;

use sqlt::dialect::DialectId;
use sqlt::parse;

fn fixtures_root() -> &'static Path {
    Path::new(env!("CARGO_MANIFEST_DIR"))
        .parent()
        .map(|_| Path::new(env!("CARGO_MANIFEST_DIR")))
        .unwrap()
}

fn check_dialect(dialect: DialectId, dir: &str) {
    let root = fixtures_root().join("tests/fixtures").join(dir);
    if !root.exists() {
        return;
    }
    let mut count = 0usize;
    for entry in fs::read_dir(&root).expect("read fixtures dir") {
        let entry = entry.expect("dir entry");
        let path = entry.path();
        if path.extension().and_then(|s| s.to_str()) != Some("sql") {
            continue;
        }
        let sql = fs::read_to_string(&path).expect("read fixture");
        let stmts = parse::parse(&sql, dialect)
            .unwrap_or_else(|e| panic!("failed to parse {}: {e}", path.display()));
        assert!(
            !stmts.is_empty(),
            "fixture {} parsed to empty statement list",
            path.display()
        );
        count += 1;
    }
    assert!(count > 0, "no fixtures found under {}", root.display());
}

#[test]
fn mysql_fixtures_parse() {
    check_dialect(DialectId::MySql, "mysql");
}

#[test]
fn mariadb_fixtures_parse() {
    check_dialect(DialectId::MariaDb, "mariadb");
}

#[test]
fn postgres_fixtures_parse() {
    check_dialect(DialectId::Postgres, "postgres");
}

#[test]
fn mssql_fixtures_parse() {
    check_dialect(DialectId::MsSql, "mssql");
}

#[test]
fn sqlite_fixtures_parse() {
    check_dialect(DialectId::Sqlite, "sqlite");
}