use std::path::PathBuf;
use datacraft_core::command::Command;
use datacraft_core::core::Core;
use datacraft_core::port::MockPort;
use datacraft_core::present::status_line;
use datacraft_core::schema::{FieldDef, FieldKind, TableDef};
fn open_core(path: &str) -> Core {
let mut core = Core::new(Box::new(MockPort::new()));
core.dispatch(Command::OpenDatabase {
path: PathBuf::from(path),
password: None,
source: None,
});
core
}
fn add_table(core: &mut Core, name: &str) {
core.dispatch(Command::CreateTable {
definition: TableDef::new(name, vec![FieldDef::new("id", FieldKind::Currency)]),
});
}
#[test]
fn closed_core_reports_no_database() {
let snapshot = Core::new(Box::new(MockPort::new())).inspect();
assert_eq!(status_line(&snapshot, None), "No database open");
}
#[test]
fn status_context_prefers_the_active_object_over_the_table_count() {
let mut core = open_core("shop.mdb");
let snapshot = core.inspect();
assert_eq!(status_line(&snapshot, None), "shop (Jet4) โ 0 tables");
add_table(&mut core, "Customers");
let snapshot = core.inspect();
assert_eq!(status_line(&snapshot, None), "shop (Jet4) โ 1 table");
core.dispatch(Command::OpenObject(datacraft_core::ObjectId::new(
datacraft_core::ObjectKind::Table,
"Customers",
)));
let snapshot = core.inspect();
let active = snapshot
.active_tab
.and_then(|id| snapshot.tabs.iter().find(|t| t.id == id))
.map(|t| (t.object_kind.clone(), t.object_name.clone()));
assert_eq!(
status_line(
&snapshot,
active.as_ref().map(|(k, n)| (k.as_str(), n.as_str()))
),
"shop (Jet4) โ Customers"
);
assert_eq!(
status_line(&snapshot, Some(("report", "Weekly"))),
"shop (Jet4) โ Weekly"
);
add_table(&mut core, "Orders");
assert_eq!(status_line(&core.inspect(), None), "shop (Jet4) โ 2 tables");
}
#[test]
fn format_names_are_human_readable() {
assert_eq!(
datacraft_core::port::DatabaseFormat::Jet3.to_string(),
"Jet3"
);
assert_eq!(
datacraft_core::port::DatabaseFormat::Jet4.to_string(),
"Jet4"
);
assert_eq!(datacraft_core::port::DatabaseFormat::Ace.to_string(), "ACE");
assert_eq!(
datacraft_core::port::DatabaseFormat::Sqlite.to_string(),
"SQLite"
);
}
#[test]
fn sqlite_format_serializes_as_lower_case_slug() {
let json = serde_json::to_string(&datacraft_core::port::DatabaseFormat::Sqlite)
.expect("format serializes");
assert_eq!(json, "\"sqlite\"");
}
#[test]
fn display_values_are_user_renderable() {
use datacraft_core::present::display_value;
use datacraft_core::schema::FieldValue;
assert_eq!(display_value(&FieldValue::Null), "");
assert_eq!(display_value(&FieldValue::Boolean(true)), "Yes");
assert_eq!(display_value(&FieldValue::Boolean(false)), "No");
assert_eq!(display_value(&FieldValue::Integer(-42)), "-42");
assert_eq!(display_value(&FieldValue::Float(1.5)), "1.5");
assert_eq!(display_value(&FieldValue::Currency(123_456)), "12.3456");
assert_eq!(display_value(&FieldValue::Currency(-10_000)), "-1");
assert_eq!(
display_value(&FieldValue::DateTime(45_657.5)),
"2024-12-31 12:00"
);
assert_eq!(display_value(&FieldValue::Decimal(-9)), "-9");
assert_eq!(display_value(&FieldValue::Text("hi โ".into())), "hi โ");
assert_eq!(
display_value(&FieldValue::Binary(vec![1, 2, 3])),
"<binary: 3 bytes>"
);
assert_eq!(
display_value(&FieldValue::Guid([0u8; 16])),
"00000000-0000-0000-0000-000000000000"
);
}
#[test]
fn field_kinds_display_access_ui_names() {
use datacraft_core::present::field_kind_display;
use datacraft_core::schema::{AutoKind, BinaryKind, FieldKind, NumericKind};
assert_eq!(
field_kind_display(&FieldKind::Text { max_len: 255 }),
"Short Text"
);
assert_eq!(field_kind_display(&FieldKind::Memo), "Long Text");
assert_eq!(
field_kind_display(&FieldKind::Number(NumericKind::Byte)),
"Byte"
);
assert_eq!(
field_kind_display(&FieldKind::Number(NumericKind::Integer)),
"Integer"
);
assert_eq!(
field_kind_display(&FieldKind::Number(NumericKind::LongInteger)),
"Long Integer"
);
assert_eq!(
field_kind_display(&FieldKind::Number(NumericKind::Single)),
"Single"
);
assert_eq!(
field_kind_display(&FieldKind::Number(NumericKind::Double)),
"Double"
);
assert_eq!(
field_kind_display(&FieldKind::Number(NumericKind::Decimal {
precision: 18,
scale: 2
})),
"Decimal (18, 2)"
);
assert_eq!(field_kind_display(&FieldKind::DateTime), "Date/Time");
assert_eq!(field_kind_display(&FieldKind::Currency), "Currency");
assert_eq!(
field_kind_display(&FieldKind::AutoNumber(AutoKind::LongInteger)),
"AutoNumber"
);
assert_eq!(
field_kind_display(&FieldKind::AutoNumber(AutoKind::ReplicationId)),
"AutoNumber (Replication ID)"
);
assert_eq!(
field_kind_display(&FieldKind::Boolean { tri_state: true }),
"Yes/No"
);
assert_eq!(
field_kind_display(&FieldKind::Binary(BinaryKind::OleObject)),
"OLE Object"
);
assert_eq!(
field_kind_display(&FieldKind::Binary(BinaryKind::Attachment)),
"Attachment"
);
assert_eq!(field_kind_display(&FieldKind::Guid), "GUID");
}
#[test]
fn the_status_line_names_the_ace_format() {
use datacraft_core::present::status_line;
let mut state = datacraft_core::state::AppState::new();
state.database = Some(datacraft_core::state::DatabaseState {
table_views: std::collections::BTreeMap::new(),
path: "shop.accdb".into(),
source: None,
name: "shop".into(),
format: datacraft_core::port::DatabaseFormat::Ace,
driver: datacraft_core::port::DriverId::new("jet"),
capabilities: datacraft_core::port::DriverCapabilities::full(),
tables: Vec::new(),
relationships: Vec::new(),
queries: Vec::new(),
forms: Vec::new(),
reports: Vec::new(),
views: Vec::new(),
native_views: Vec::new(),
indexes: Vec::new(),
triggers: Vec::new(),
source_facts: Default::default(),
native_objects: Vec::new(),
native_queries: Vec::new(),
native_queries_error: None,
macros: Vec::new(),
macros_error: None,
vba_project: None,
vba_error: None,
sidecar_error: None,
lock_file: None,
undo: Vec::new(),
redo: Vec::new(),
});
let snapshot = datacraft_core::snapshot::UiStateSnapshot::of(&state);
assert_eq!(status_line(&snapshot, None), "shop (ACE) โ 0 tables");
}
#[test]
fn every_format_renders_through_the_single_display_path() {
use datacraft_core::port::DatabaseFormat;
assert_eq!(DatabaseFormat::Jet3.to_string(), "Jet3");
assert_eq!(DatabaseFormat::Jet4.to_string(), "Jet4");
assert_eq!(DatabaseFormat::Ace.to_string(), "ACE");
assert_eq!(DatabaseFormat::Sqlite.to_string(), "SQLite");
assert_eq!(DatabaseFormat::Csv.to_string(), "CSV");
}