schema-parser 0.6.21

A set of tools to manage relational database schemas
Documentation
use schema_parser::parse_database_xml;
use std::fs;

#[test]
fn test_parser() {
    let xml =
        fs::read_to_string("tests/resources/schema-parser-test-schema.xml").expect("resource present");
    let database = parse_database_xml(xml.as_str()).expect("parse ok");
    let schemas = database.schemas();

    assert_eq!(schemas.len(), 2);
    assert_eq!(schemas[0].tables().len(), 9);
    assert_eq!(schemas[0].get_table("ParentTable").name(), "ParentTable");
    assert_eq!(schemas[0].get_table("ChildTable").name(), "ChildTable");
    assert_eq!(schemas[0].get_table("ColumnTesterTable").name(), "ColumnTesterTable");
    assert_eq!(
        schemas[0].get_table("LongSequenceTesterTable").name(),
        "LongSequenceTesterTable"
    );
    assert_eq!(schemas[0].get_table("Property").name(), "Property");
    assert_eq!(schemas[0].get_table("Region").name(), "Region");
    assert_eq!(schemas[0].get_table("KBI").name(), "KBI");
    assert_eq!(schemas[0].get_table("MasterKBICode").name(), "MasterKBICode");
    assert_eq!(schemas[1].schema_name().unwrap(), "test");
    assert_eq!(schemas[1].tables().len(), 1);
    assert_eq!(schemas[1].get_table("Unit").name(), "Unit");

    let assignment = schemas[0].get_table("Assignment");
    assert_eq!(assignment.name(), "Assignment");
    let composite_relation = assignment
        .relations()
        .iter()
        .find(|r| r.is_composite())
        .expect("Assignment has a composite relation");
    assert_eq!(composite_relation.to_table_name(), "Assignment");
    assert_eq!(
        composite_relation.column_pairs(),
        &[
            ("ParentAssignmentID".to_string(), "ID".to_string()),
            ("PropertyID".to_string(), "PropertyID".to_string()),
        ]
    );
}