sql-ddl-to-json-schema 0.2.1

Parse MySQL and MariaDB DDL into a compact table model and JSON Schema draft-07 documents
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

//! Compact formatter. Replays DDL statements into a table model.

mod column;
mod database;
mod keys;
mod models;
mod table;
mod table_options;
mod util;

use serde_json::Value;

use database::Database;

/// Format a `MAIN` parse tree into an array of compact table objects.
///
/// Returns an error if the tree root is not `{ id: "MAIN", ... }`.
pub fn format(json: &Value) -> Result<Vec<Value>, String> {
    if json.get("id").and_then(Value::as_str) != Some("MAIN") {
        return Err(
            "Invalid JSON format provided for CompactFormatter. Please provide JSON from root element, containing { id: MAIN }."
                .to_string(),
        );
    }
    let dds = json
        .get("def")
        .and_then(Value::as_array)
        .cloned()
        .unwrap_or_default();
    let mut database = Database::new();
    database.parse_dds_collection(&dds);
    Ok(database.tables.iter().map(table::Table::to_json).collect())
}