#![cfg(feature = "sqlite")]
use super::{OrderSubjects, SubjectShape, SubjectSlot, TermColumns};
use crate::{
FieldName, OrderDirection, OrderTerm, TermName, TermSubject,
comparison::{At, sql::tests::ROW},
};
const COMPANION: &FieldName = FieldName::new("__ig_tags_sort__");
fn shadow() -> OrderTerm {
OrderTerm::shadow(TermName::new("tags"), COMPANION, OrderDirection::Asc)
}
fn written(terms: &[OrderTerm], shape: SubjectShape) -> String {
let mut qb = sqlx::QueryBuilder::<sqlx::Sqlite>::default();
TermColumns.push_subject(SubjectSlot::new(&mut qb, shape), At::new(&ROW), terms, 0);
qb.into_string()
}
#[test]
fn the_shape_is_read_off_the_terms_own_subject() {
let value = OrderTerm::new(
TermName::new("title"),
FieldName::new("title"),
OrderDirection::Asc,
);
let array = OrderTerm::array(
TermName::new("tags"),
FieldName::new("tags"),
OrderDirection::Asc,
);
let edge = OrderTerm::edge(
TermName::new("tags"),
FieldName::new("tags"),
OrderDirection::Asc,
);
assert_eq!(
OrderSubjects::<sqlx::Sqlite>::shape(&TermColumns, &[shadow()], 0),
SubjectShape::Companion,
"the one subject whose value is not on the row and whose subject is a name"
);
for term in [value, array, edge] {
assert_eq!(
OrderSubjects::<sqlx::Sqlite>::shape(&TermColumns, &[term], 0),
SubjectShape::Column
);
}
}
#[test]
fn a_companion_takes_the_column_wrapping_and_a_sub_select_takes_its_own() {
let terms = [shadow()];
let bare = written(&terms, SubjectShape::Companion);
assert_eq!(bare, r#""__ig_tags_sort__""#);
assert_eq!(
bare,
written(&terms, SubjectShape::Column),
"nothing about the wrapping distinguishes the two"
);
assert_eq!(
written(&terms, SubjectShape::SubSelect),
r#"("__ig_tags_sort__")"#,
"the parentheses are the SUB-SELECT's alone, and the slot is where they are spelled"
);
}
#[test]
fn the_subject_renders_the_companion_under_the_fields_identity() {
let term = shadow();
assert_eq!(term.subject(), TermSubject::Shadow);
assert_eq!(term.identity(), TermName::new("tags"));
assert_eq!(term.column(), COMPANION);
assert_eq!(
term.width(),
1,
"a companion is ONE column whatever it holds"
);
}