use super::{Conjunction, Error, KeyIn, ScalarComparison, TextComparison};
use crate::{
At, ComplexComparison, FieldName, ScalarFilter, TextFilter,
comparison::{
TryFromFilter,
sql::{
SqlKeyIn, SqlScalarComparison, SqlTextComparison,
tests::{render, threaded},
},
},
};
struct Track {
bitrate: ScalarComparison<i64>,
codec: TextComparison<String>,
}
impl ComplexComparison<sqlx::Sqlite> for Track {
fn conjuncts(&self) -> usize {
self.bitrate.conjuncts() + self.codec.conjuncts()
}
fn apply<'q>(&'q self, at: At<'_>, builder: Conjunction<'q>) -> Result<Conjunction<'q>, Error> {
let bitrate = at.frame(FieldName::new("bitrate"));
let builder = self.bitrate.apply(bitrate.at(), builder)?;
let codec = at.frame(FieldName::new("codec"));
self.codec.apply(codec.at(), builder)
}
}
fn track() -> Track {
Track {
bitrate: SqlScalarComparison::try_from_filter(ScalarFilter::<i64>::new().with_gte(1_000i64))
.unwrap(),
codec: SqlTextComparison::try_from_filter(
TextFilter::<String>::new().with_contains("av1".to_owned()),
)
.unwrap(),
}
}
#[test]
fn the_two_spellings_are_one_type() {
let track = track();
let bitrate: SqlScalarComparison<i64, sqlx::Sqlite> = track.bitrate.clone();
let codec: SqlTextComparison<String, sqlx::Sqlite> = track.codec.clone();
assert_eq!(bitrate.gte(), Some(&1_000));
assert_eq!(codec.contains().map(String::as_str), Some("av1"));
assert_eq!(bitrate, track.bitrate);
assert_eq!(codec, track.codec);
let _: ScalarComparison<i64> = bitrate;
let _: TextComparison<String> = codec;
}
#[test]
fn the_aliased_impl_lowers_what_the_full_form_lowers() {
let track = track();
let bitrate: SqlScalarComparison<i64, sqlx::Sqlite> = track.bitrate.clone();
let codec: SqlTextComparison<String, sqlx::Sqlite> = track.codec.clone();
assert_eq!(
render::<sqlx::Sqlite, _>("track_bitrate", &bitrate),
("\"track_bitrate\" >= ?".to_owned(), 1)
);
assert_eq!(
render::<sqlx::Sqlite, _>("track_codec", &codec),
("instr(\"track_codec\", ?) > 0".to_owned(), 1)
);
assert_eq!(track.conjuncts(), 2);
assert_eq!(
threaded::<sqlx::Sqlite, _>("track", &track),
"SELECT \"id\" FROM \"t\" WHERE \"track_bitrate\" >= ? AND instr(\"track_codec\", ?) > 0"
);
}
#[test]
fn the_key_set_alias_keeps_the_width_the_module_does_not_fix() {
let full = SqlKeyIn::<i64, sqlx::Sqlite, 2>::new(["media", "segment"], [[1i64, 10], [2, 20]]);
let aliased: KeyIn<i64, 2> = full;
assert_eq!(aliased.parts(), &["media", "segment"]);
assert_eq!(aliased.keys(), [[1, 10], [2, 20]]);
assert_eq!(
render::<sqlx::Sqlite, _>("k", &aliased),
(
"(\"k_media\", \"k_segment\") IN ((?, ?), (?, ?))".to_owned(),
4
)
);
}