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()),
]
);
}
fn schema_with_keys(keys: &str) -> String {
format!(
r#"<database xmlns="http://stano.com/database">
<table name="t">
<columns>
<column name="id" type="int" required="true"/>
<column name="a" type="int"/>
</columns>
<keys>{keys}</keys>
</table>
</database>"#
)
}
const PRIMARY: &str = r#"<primary><column name="id"/></primary>"#;
const UNIQUE: &str = r#"<unique><column name="a"/></unique>"#;
const INDEX: &str = r#"<index><column name="a"/></index>"#;
#[test]
fn keys_in_xsd_order_parse() {
let xml = schema_with_keys(&format!("{PRIMARY}{UNIQUE}{UNIQUE}{INDEX}{INDEX}"));
parse_database_xml(&xml).expect("ordered keys parse");
}
#[test]
fn keys_out_of_order_are_rejected() {
for keys in [
format!("{PRIMARY}{INDEX}{UNIQUE}"),
format!("{UNIQUE}{PRIMARY}"),
format!("{INDEX}{PRIMARY}"),
format!("{PRIMARY}{PRIMARY}"),
] {
assert!(
parse_database_xml(&schema_with_keys(&keys)).is_err(),
"{keys}"
);
}
}