Plan, apply and roll back changes to a production ontology, with a blast radius report and a proof an auditor can re-check.
Rust ai-nativedescription-logicsformal-verificationinfrastructure-as-codeisabelle-languageknowledge-graphleanlean4mcpmcp-serverontologyowlowl2reasoningrustshaclsparqltheorem-proving
#![cfg(feature = "postgres")]
use open_ontologies::schema::{TableInfo, ColumnInfo, ForeignKey, SchemaIntrospector};
#[test]
fn test_generate_turtle_single_table() {
let tables = vec![TableInfo {
name: "users".into(),
columns: vec![
ColumnInfo { name: "id".into(), data_type: "integer".into(), is_nullable: false, is_primary_key: true },
ColumnInfo { name: "name".into(), data_type: "varchar".into(), is_nullable: false, is_primary_key: false },
ColumnInfo { name: "email".into(), data_type: "varchar".into(), is_nullable: true, is_primary_key: false },
],
foreign_keys: vec![],
}];
let turtle = SchemaIntrospector::generate_turtle(&tables, "http://example.org/db/");
assert!(turtle.contains("db:Users a owl:Class"));
assert!(turtle.contains("db:users_name a owl:DatatypeProperty"));
assert!(turtle.contains("xsd:string"));
assert!(turtle.contains("owl:minCardinality")); // NOT NULL → minCard 1
assert!(turtle.contains("owl:FunctionalProperty")); // PK
}
#[test]
fn test_generate_turtle_foreign_key() {
let tables = vec![
TableInfo {
name: "users".into(),
columns: vec![
ColumnInfo { name: "id".into(), data_type: "integer".into(), is_nullable: false, is_primary_key: true },
],
foreign_keys: vec![],
},
TableInfo {
name: "orders".into(),
columns: vec![
ColumnInfo { name: "id".into(), data_type: "integer".into(), is_nullable: false, is_primary_key: true },
ColumnInfo { name: "user_id".into(), data_type: "integer".into(), is_nullable: false, is_primary_key: false },
],
foreign_keys: vec![ForeignKey {
column: "user_id".into(),
parent_table: "users".into(),
parent_column: "id".into(),
}],
},
];
let turtle = SchemaIntrospector::generate_turtle(&tables, "http://example.org/db/");
assert!(turtle.contains("db:orders_user_id a owl:ObjectProperty"));
assert!(turtle.contains("rdfs:range db:Users"));
}
#[test]
fn test_sql_type_to_xsd() {
assert_eq!(SchemaIntrospector::sql_to_xsd("integer"), "xsd:integer");
assert_eq!(SchemaIntrospector::sql_to_xsd("varchar"), "xsd:string");
assert_eq!(SchemaIntrospector::sql_to_xsd("boolean"), "xsd:boolean");
assert_eq!(SchemaIntrospector::sql_to_xsd("timestamp"), "xsd:dateTime");
assert_eq!(SchemaIntrospector::sql_to_xsd("numeric"), "xsd:decimal");
assert_eq!(SchemaIntrospector::sql_to_xsd("date"), "xsd:date");
assert_eq!(SchemaIntrospector::sql_to_xsd("bytea"), "xsd:hexBinary");
assert_eq!(SchemaIntrospector::sql_to_xsd("unknown_type"), "xsd:string");
}
/// IEEE 754 columns must not map to xsd:decimal, whose value space excludes
/// NaN and the infinities and implies an exactness binary floats do not have.
#[test]
fn test_sql_float_types_map_to_binary_xsd_types() {
// Exact decimal types keep xsd:decimal.
assert_eq!(SchemaIntrospector::sql_to_xsd("numeric"), "xsd:decimal");
assert_eq!(SchemaIntrospector::sql_to_xsd("decimal"), "xsd:decimal");
assert_eq!(SchemaIntrospector::sql_to_xsd("DECIMAL(18,2)"), "xsd:decimal");
// Single precision.
assert_eq!(SchemaIntrospector::sql_to_xsd("real"), "xsd:float");
assert_eq!(SchemaIntrospector::sql_to_xsd("float4"), "xsd:float");
// Double precision.
assert_eq!(SchemaIntrospector::sql_to_xsd("double precision"), "xsd:double");
assert_eq!(SchemaIntrospector::sql_to_xsd("double"), "xsd:double");
assert_eq!(SchemaIntrospector::sql_to_xsd("float8"), "xsd:double");
// Bare `float` is ambiguous across dialects (Postgres float8, DuckDB
// float4). It widens to xsd:double, including when parameterised.
assert_eq!(SchemaIntrospector::sql_to_xsd("float"), "xsd:double");
assert_eq!(SchemaIntrospector::sql_to_xsd("FLOAT(24)"), "xsd:double");
assert_eq!(SchemaIntrospector::sql_to_xsd("float(53)"), "xsd:double");
}
#[test]
fn test_generate_turtle_not_null_cardinality() {
let tables = vec![TableInfo {
name: "users".into(),
columns: vec![
ColumnInfo { name: "id".into(), data_type: "integer".into(), is_nullable: false, is_primary_key: true },
ColumnInfo { name: "email".into(), data_type: "varchar".into(), is_nullable: false, is_primary_key: false },
],
foreign_keys: vec![],
}];
let turtle = SchemaIntrospector::generate_turtle(&tables, "http://example.org/db/");
assert!(turtle.contains("owl:minCardinality"));
}
#[test]
fn test_table_name_to_class() {
assert_eq!(SchemaIntrospector::table_to_class("users"), "Users");
assert_eq!(SchemaIntrospector::table_to_class("order_items"), "OrderItems");
assert_eq!(SchemaIntrospector::table_to_class("product"), "Product");
}