use rusqlite::{params, Connection};
use uqa_storage::{
mvcc::{CommitSequence, PreparedRecordCommit},
read_control::StorageReadControl,
};
use super::{invalid, NativeRecordFamily as Family, NativeRecordIdentity, NativeRecordOwner};
use crate::{
mvcc::{read, PhysicalResult},
read_control::{prefix_upper_bound, reserve_bindings},
};
pub(super) fn validate_source(connection: &Connection) -> PhysicalResult<()> {
if connection.query_row(
"SELECT EXISTS(SELECT 1 FROM _sequences GROUP BY object_id HAVING count(*) > 1)",
[],
|row| row.get::<_, bool>(0),
)? {
return Err(invalid("native sequences share an object identity").into());
}
Ok(())
}
pub(super) fn validate_prepared(
connection: &Connection,
prepared: &PreparedRecordCommit,
control: &StorageReadControl,
) -> PhysicalResult<()> {
for record in prepared.records() {
let identity = NativeRecordIdentity::decode(record.key())?;
if identity.family() != Family::Sequences || record.value().is_none() {
continue;
}
let NativeRecordOwner::Object { identity, .. } = identity.owner() else {
unreachable!("sequence definitions are object-owned")
};
let prefix = NativeRecordIdentity::object_prefix(Family::Sequences, identity, control)?;
let upper = prefix_upper_bound(&prefix, control)?.expect("native prefix has a successor");
let _bindings = reserve_bindings(control, &[&prefix, &upper, record.key()])?;
let mut collision: bool = connection.query_row(
"SELECT count(*) > 1 FROM _uqa_mvcc_native_expected WHERE new_key >= ?1 AND new_key < ?2",
params![&prefix[..], &upper[..]],
|row| row.get(0),
)?;
if !collision {
read::keys(connection, &prefix, None, usize::MAX, control, &mut |key| {
if key == record.key()
|| read::info(connection, key, CommitSequence::from_u64(u64::MAX))?
.is_none_or(|info| info.length.is_none())
{
return Ok(Some(true));
}
collision = !connection.query_row("SELECT EXISTS(SELECT 1 FROM _uqa_mvcc_native_expected WHERE old_key = ?1 AND new_key IS NOT ?1)", [key], |row| row.get::<_, bool>(0))?;
Ok(Some(!collision))
})?;
}
if collision {
return Err(invalid("native sequence incarnation has competing definitions").into());
}
}
Ok(())
}