geographdb-core 0.3.1

//! Storage manager - coordinates node and edge stores with memory-mapped files
//!
//! # File Format
//!
//! ```text
//! +----------------------+
//! | Header (8 bytes)     | <- Node count
//! +----------------------+
//! | Node 0 (72 bytes)    |
//! +----------------------+
//! | ...                  |
//! +----------------------+
//! | Node N (72 bytes)    |
//! +----------------------+
//! | Edge Count (8B)      |
//! +----------------------+
//! | Edge 0 (48 bytes)    |
//! +----------------------+
//! | ...                  |
//! +----------------------+
//! | Edge M (48 bytes)    |
//! +----------------------+
//! | Metadata Count (8B)  |
//! +----------------------+
//! | Metadata 0 (256B)    |
//! +----------------------+
//! | ...                  |
//! +----------------------+
//! | Metadata K (256B)    |
//! +----------------------+
//! ```

use anyhow::{Context, Result};
use memmap2::MmapMut;
use std::fs::{File, OpenOptions};
use std::io::{Read, Seek, SeekFrom, Write};
use std::path::Path;

use super::dual_octree::OctreePageStore;
use super::spatial_page::{build_spatial_pages, BoundingBox, DEFAULT_MAX_NODES_PER_PAGE};
use crate::storage::data_structures::{EdgeRec, MetadataRec, NodeRec};

#[cfg(feature = "telemetry")]
use crate::telemetry::LoopGuard;

/// Storage manager for geometric graph database
/// Uses memory-mapped files for persistent storage
pub struct StorageManager {
    file: File,
    mmap: Option<MmapMut>,
    node_count: usize,
    edge_count: usize,
    metadata_count: usize,
    edge_offset: usize,     // Byte offset where edge section starts
    metadata_offset: usize, // Byte offset where metadata section starts
    #[allow(dead_code)]
    path: std::path::PathBuf,
    /// LSTS: Maps logical node ID -> Vec of physical storage IDs (versions)
    /// This enables time-travel queries by tracking all versions of a node
    version_index: std::collections::HashMap<u64, Vec<u64>>,
    /// Dual-octree spatial page store (lazy-rebuilt on first spatial query)
    spatial_page_store: Option<OctreePageStore>,
}

impl StorageManager {
    /// Create a new storage manager with a new database file
    pub fn create(path: &Path) -> Result<Self> {
        let mut file = OpenOptions::new()
            .read(true)
            .write(true)
            .create(true)
            .truncate(true)
            .open(path)
            .context("Failed to create database file")?;

        let initial_count: u64 = 0;
        file.write_all(&initial_count.to_le_bytes())
            .context("Failed to write header")?;
        file.sync_all().context("Failed to sync file")?;

        let mmap = unsafe { MmapMut::map_mut(&file).context("Failed to memory-map file")? };

        Ok(Self {
            file,
            mmap: Some(mmap),
            node_count: 0,
            edge_count: 0,
            metadata_count: 0,
            edge_offset: 8,
            metadata_offset: 8,
            path: path.to_path_buf(),
            version_index: std::collections::HashMap::new(),
            spatial_page_store: None,
        })
    }

    /// Open an existing database file
    pub fn open(path: &Path) -> Result<Self> {
        let mut file = OpenOptions::new()
            .read(true)
            .write(true)
            .open(path)
            .context("Failed to open database file")?;

        let mut header = [0u8; 8];
        file.read_exact(&mut header)
            .context("Failed to read header")?;
        let node_count = u64::from_le_bytes(header) as usize;

        let edge_offset = 8 + node_count * std::mem::size_of::<NodeRec>();
        file.seek(SeekFrom::Start(edge_offset as u64))
            .context("Failed to seek to edge section")?;

        let mut edge_header = [0u8; 8];
        let edge_count = if file.read_exact(&mut edge_header).is_ok() {
            u64::from_le_bytes(edge_header) as usize
        } else {
            0
        };

        // Calculate metadata offset and read metadata count
        let metadata_offset = edge_offset + 8 + edge_count * std::mem::size_of::<EdgeRec>();
        file.seek(SeekFrom::Start(metadata_offset as u64))
            .context("Failed to seek to metadata section")?;

        let mut metadata_header = [0u8; 8];
        let metadata_count = if file.read_exact(&mut metadata_header).is_ok() {
            u64::from_le_bytes(metadata_header) as usize
        } else {
            0
        };

        let mmap = unsafe { MmapMut::map_mut(&file).context("Failed to memory-map file")? };

        Ok(Self {
            file,
            mmap: Some(mmap),
            node_count,
            edge_count,
            metadata_count,
            edge_offset,
            metadata_offset,
            path: path.to_path_buf(),
            version_index: std::collections::HashMap::new(),
            spatial_page_store: None,
        })
    }

    pub fn node_count(&self) -> usize {
        self.node_count
    }

    pub fn edge_count(&self) -> usize {
        self.edge_count
    }

    pub fn metadata_count(&self) -> usize {
        self.metadata_count
    }

    /// Insert a metadata record at a specific ID (matches node ID)
    /// This ensures metadata[N] always corresponds to node[N]
    pub fn insert_metadata_at(&mut self, id: u64, metadata: MetadataRec) -> Result<()> {
        // Ensure we have enough space for this metadata ID
        let required_id = id as usize + 1;
        if required_id > self.metadata_count {
            self.metadata_count = required_id;
        }

        let node_section_size = self.node_count * std::mem::size_of::<NodeRec>();
        let edge_header_size = 8;
        let edge_section_size = self.edge_count * std::mem::size_of::<EdgeRec>();
        let metadata_header_size = 8;
        let metadata_section_size = self.metadata_count * std::mem::size_of::<MetadataRec>();
        let required_size = 8
            + node_section_size
            + edge_header_size
            + edge_section_size
            + metadata_header_size
            + metadata_section_size;

        self.file
            .set_len(required_size as u64)
            .context("Failed to grow file for metadata")?;

        if let Some(ref mut mmap) = self.mmap {
            if mmap.len() < required_size {
                mmap.flush().ok();
                *mmap = unsafe { MmapMut::map_mut(&self.file).context("Failed to re-map file")? };
            }
        }

        if let Some(ref mut mmap) = self.mmap {
            let metadata_data_offset = self.metadata_offset + 8;
            let offset = metadata_data_offset + id as usize * std::mem::size_of::<MetadataRec>();
            let metadata_bytes = bytemuck::bytes_of(&metadata);
            mmap[offset..offset + std::mem::size_of::<MetadataRec>()]
                .copy_from_slice(metadata_bytes);

            // Update metadata count header
            let metadata_header_offset = self.metadata_offset;
            mmap[metadata_header_offset..metadata_header_offset + 8]
                .copy_from_slice(&(self.metadata_count as u64).to_le_bytes());
            mmap.flush().context("Failed to flush mmap")?;
        }

        Ok(())
    }

    /// Get a metadata record by ID
    pub fn get_metadata(&self, id: u64) -> Option<&MetadataRec> {
        if id as usize >= self.metadata_count {
            return None;
        }

        self.mmap.as_ref().and_then(|mmap| {
            let metadata_data_offset = self.metadata_offset + 8;
            let offset = metadata_data_offset + id as usize * std::mem::size_of::<MetadataRec>();
            let bytes = &mmap[offset..offset + std::mem::size_of::<MetadataRec>()];
            bytemuck::try_from_bytes::<MetadataRec>(bytes).ok()
        })
    }

    pub fn insert_node(&mut self, node: NodeRec) -> Result<u64> {
        let node_id = self.node_count as u64;

        let node_section_size = (self.node_count + 1) * std::mem::size_of::<NodeRec>();
        let edge_header_size = 8;
        let edge_section_size = self.edge_count * std::mem::size_of::<EdgeRec>();
        let metadata_header_size = 8;
        let metadata_section_size = self.metadata_count * std::mem::size_of::<MetadataRec>();
        let required_size = 8
            + node_section_size
            + edge_header_size
            + edge_section_size
            + metadata_header_size
            + metadata_section_size;

        self.file
            .set_len(required_size as u64)
            .context("Failed to grow file")?;

        if let Some(ref mut mmap) = self.mmap {
            if mmap.len() < required_size {
                mmap.flush().ok();
                *mmap = unsafe { MmapMut::map_mut(&self.file).context("Failed to re-map file")? };
            }
        }

        if self.edge_count > 0 || self.metadata_count > 0 {
            self.move_data_sections(node_section_size)?;
        }

        if let Some(ref mut mmap) = self.mmap {
            let offset = 8 + self.node_count * std::mem::size_of::<NodeRec>();
            let node_bytes = bytemuck::bytes_of(&node);
            mmap[offset..offset + std::mem::size_of::<NodeRec>()].copy_from_slice(node_bytes);
        }

        self.node_count += 1;
        self.edge_offset = 8 + self.node_count * std::mem::size_of::<NodeRec>();
        // Update metadata_offset after node section size change
        self.metadata_offset =
            self.edge_offset + 8 + self.edge_count * std::mem::size_of::<EdgeRec>();

        if let Some(ref mut mmap) = self.mmap {
            mmap[0..8].copy_from_slice(&(self.node_count as u64).to_le_bytes());
            let edge_header_offset = self.edge_offset;
            mmap[edge_header_offset..edge_header_offset + 8]
                .copy_from_slice(&(self.edge_count as u64).to_le_bytes());
            let metadata_header_offset = self.metadata_offset;
            mmap[metadata_header_offset..metadata_header_offset + 8]
                .copy_from_slice(&(self.metadata_count as u64).to_le_bytes());
            mmap.flush().context("Failed to flush mmap")?;
        }

        // LSTS: Track this as the first version of this logical node
        self.version_index.entry(node.id).or_default().push(node_id);

        Ok(node_id)
    }

    pub fn insert_edge(&mut self, edge: EdgeRec) -> Result<u64> {
        let edge_id = self.edge_count as u64;

        let node_section_size = self.node_count * std::mem::size_of::<NodeRec>();
        let edge_header_size = 8;
        let edge_section_size = (self.edge_count + 1) * std::mem::size_of::<EdgeRec>();
        let metadata_header_size = 8;
        let metadata_section_size = self.metadata_count * std::mem::size_of::<MetadataRec>();
        let required_size = 8
            + node_section_size
            + edge_header_size
            + edge_section_size
            + metadata_header_size
            + metadata_section_size;

        // Grow file first to make room for the new edge
        self.file
            .set_len(required_size as u64)
            .context("Failed to grow file")?;

        if let Some(ref mut mmap) = self.mmap {
            if mmap.len() < required_size {
                mmap.flush().ok();
                *mmap = unsafe { MmapMut::map_mut(&self.file).context("Failed to re-map file")? };
            }
        }

        // If metadata exists, we need to move it to make room for the new edge
        if self.metadata_count > 0 {
            self.move_metadata_section()?;
        }

        if let Some(ref mut mmap) = self.mmap {
            let edge_header_offset = self.edge_offset;
            let edge_data_offset = edge_header_offset + 8;
            let offset = edge_data_offset + self.edge_count * std::mem::size_of::<EdgeRec>();
            let edge_bytes = bytemuck::bytes_of(&edge);
            mmap[offset..offset + std::mem::size_of::<EdgeRec>()].copy_from_slice(edge_bytes);

            self.edge_count += 1;
            mmap[edge_header_offset..edge_header_offset + 8]
                .copy_from_slice(&(self.edge_count as u64).to_le_bytes());
            // Update metadata_offset after edge section growth (already updated by move_metadata_section if needed)
            // If no metadata exists, update it here
            if self.metadata_count == 0 {
                self.metadata_offset =
                    self.edge_offset + 8 + self.edge_count * std::mem::size_of::<EdgeRec>();
            }
            mmap.flush().context("Failed to flush mmap")?;
        }

        Ok(edge_id)
    }

    /// Move metadata section when edge section grows
    fn move_metadata_section(&mut self) -> Result<()> {
        let old_metadata_offset = self.metadata_offset;
        let old_edge_section_size = self.edge_count * std::mem::size_of::<EdgeRec>();
        let new_edge_section_size = old_edge_section_size + std::mem::size_of::<EdgeRec>();
        let new_metadata_offset = self.edge_offset + 8 + new_edge_section_size;

        let metadata_rec_size = std::mem::size_of::<MetadataRec>();
        let metadata_header_size = 8;
        let metadata_section_size = self.metadata_count * metadata_rec_size;
        let total_metadata_size = metadata_header_size + metadata_section_size;

        if let Some(ref mut mmap) = self.mmap {
            if total_metadata_size > 0 && old_metadata_offset != new_metadata_offset {
                // Move metadata section to make room for new edge
                let mut data = vec![0u8; total_metadata_size];
                data.copy_from_slice(
                    &mmap[old_metadata_offset..old_metadata_offset + total_metadata_size],
                );
                mmap[new_metadata_offset..new_metadata_offset + total_metadata_size]
                    .copy_from_slice(&data);
            }
        }

        self.metadata_offset = new_metadata_offset;
        Ok(())
    }

    pub fn get_node(&self, id: u64) -> Option<&NodeRec> {
        if id as usize >= self.node_count {
            return None;
        }

        self.mmap.as_ref().and_then(|mmap| {
            let offset = 8 + id as usize * std::mem::size_of::<NodeRec>();
            let bytes = &mmap[offset..offset + std::mem::size_of::<NodeRec>()];
            bytemuck::try_from_bytes::<NodeRec>(bytes).ok()
        })
    }

    pub fn get_edge(&self, id: u64) -> Option<&EdgeRec> {
        if id as usize >= self.edge_count {
            return None;
        }

        self.mmap.as_ref().and_then(|mmap| {
            let edge_data_offset = self.edge_offset + 8;
            let offset = edge_data_offset + id as usize * std::mem::size_of::<EdgeRec>();
            let bytes = &mmap[offset..offset + std::mem::size_of::<EdgeRec>()];
            bytemuck::try_from_bytes::<EdgeRec>(bytes).ok()
        })
    }

    pub fn get_edges_for_node(&self, _node_id: u64) -> Vec<&EdgeRec> {
        Vec::new()
    }

    /// LSTS (Linearly Versioned Timestamp) query
    ///
    /// Returns the node version that was visible at the given timestamp.
    /// A version is visible if:
    /// - begin_ts <= query_timestamp
    /// - end_ts == 0 OR end_ts > query_timestamp
    /// - visibility == VERSION_COMMITTED (1)
    ///
    /// Get the version history for a logical node
    pub fn get_version_history(&self, logical_id: u64) -> Option<&Vec<u64>> {
        self.version_index.get(&logical_id)
    }

    pub fn get_node_at_timestamp(&self, logical_id: u64, timestamp: u64) -> Option<&NodeRec> {
        // Telemetry: Loop guard to prevent infinite scanning
        #[cfg(feature = "telemetry")]
        let loop_guard = LoopGuard::new("get_node_at_timestamp", 1000);

        // Get all versions of this logical node
        let versions = self.version_index.get(&logical_id)?;

        // Scan all versions to find the one visible at the given timestamp
        for &version_id in versions {
            #[cfg(feature = "telemetry")]
            loop_guard.check().ok()?;

            if let Some(node) = self.get_node(version_id) {
                if node.visibility != 1 {
                    // VERSION_COMMITTED
                    continue;
                }

                // Check if this version was visible at the given timestamp
                if node.begin_ts <= timestamp && (node.end_ts == 0 || node.end_ts > timestamp) {
                    return Some(node);
                }
            }
        }

        None
    }

    /// Update a node with LSTS versioning
    ///
    /// This implements the core LSTS update semantics:
    /// 1. Find the current version of the node (where end_ts == 0)
    /// 2. Set end_ts = new_begin_ts on the current version (mark as superseded)
    /// 3. Insert a new version with begin_ts = new_begin_ts, end_ts = 0
    ///
    /// Returns the ID of the new version
    pub fn update_node(
        &mut self,
        logical_id: u64,
        new_node: NodeRec,
        new_begin_ts: u64,
    ) -> Result<u64> {
        // Get the version history for this logical node
        let versions = self
            .version_index
            .get(&logical_id)
            .ok_or_else(|| anyhow::anyhow!("Logical node {} not found", logical_id))?;

        if versions.is_empty() {
            return Err(anyhow::anyhow!(
                "No versions found for logical node {}",
                logical_id
            ));
        }

        // Get the latest version (last in the list)
        let latest_version_id = *versions.last().unwrap();

        // Step 1: "Close" the current version by setting its end_ts
        if let Some(ref mut mmap) = self.mmap {
            let offset = 8 + latest_version_id as usize * std::mem::size_of::<NodeRec>();
            let bytes = &mut mmap[offset..offset + std::mem::size_of::<NodeRec>()];
            if let Ok(node) = bytemuck::try_from_bytes_mut::<NodeRec>(bytes) {
                node.end_ts = new_begin_ts; // Mark as superseded at this timestamp
            }
        }

        // Step 2: Insert the new version
        let new_version_id = self.insert_node(new_node)?;

        // Update the version index to include the new version
        self.version_index
            .entry(logical_id)
            .or_default()
            .push(new_version_id);

        Ok(new_version_id)
    }

    /// Move edge and metadata sections when node section grows
    fn move_data_sections(&mut self, new_node_section_size: usize) -> Result<()> {
        let old_edge_offset = self.edge_offset;
        let new_edge_offset = 8 + new_node_section_size;

        if let Some(ref mut mmap) = self.mmap {
            // Calculate total data size to move
            // This includes: edge count header + edge section + metadata count header + metadata section
            let edge_count_header_size = 8;
            let edge_section_size = self.edge_count * std::mem::size_of::<EdgeRec>();
            let metadata_count_header_size = 8;
            let metadata_section_size = self.metadata_count * std::mem::size_of::<MetadataRec>();
            let total_data_size = edge_count_header_size
                + edge_section_size
                + metadata_count_header_size
                + metadata_section_size;

            if total_data_size > 0 {
                let mut data = vec![0u8; total_data_size];
                data.copy_from_slice(&mmap[old_edge_offset..old_edge_offset + total_data_size]);
                mmap[new_edge_offset..new_edge_offset + total_data_size].copy_from_slice(&data);
            }
        }

        self.edge_offset = new_edge_offset;
        // Update metadata_offset after moving edge section
        self.metadata_offset =
            self.edge_offset + 8 + self.edge_count * std::mem::size_of::<EdgeRec>();
        Ok(())
    }

    pub fn flush(&mut self) -> Result<()> {
        if let Some(ref mut mmap) = self.mmap {
            mmap.flush().context("Failed to flush mmap")?;
        }
        self.file.sync_all().context("Failed to sync file")?;
        self.maybe_save_spatial_store()?;
        Ok(())
    }

    /// Rebuild the spatial page store from all current nodes + edges.
    /// Call this explicitly after bulk insertions.
    pub fn rebuild_spatial_index(&mut self) -> Result<()> {
        let nodes = self.all_nodes();
        let edges = self.all_edges();
        let edge_refs: Vec<(u64, u64, f32, u32)> =
            edges.iter().map(|e| (e.src, e.dst, e.w, e.flags)).collect();
        let properties = self.all_node_properties();

        let pages = build_spatial_pages(nodes, &properties, &edge_refs, DEFAULT_MAX_NODES_PER_PAGE);
        self.spatial_page_store = Some(OctreePageStore::new(pages, 4, 1));
        Ok(())
    }

    /// Range query via dual-octree page store. Returns node IDs in matching pages.
    /// Rebuilds the index lazily on first call if not explicitly built.
    pub fn spatial_range_query(&mut self, query: &BoundingBox) -> Vec<u64> {
        if self.spatial_page_store.is_none() {
            if let Err(e) = self.rebuild_spatial_index() {
                eprintln!(
                    "spatial_range_query: failed to rebuild spatial index: {}",
                    e
                );
                return vec![];
            }
        }
        let store = self.spatial_page_store.as_ref().unwrap();
        let page_indices = store.range_query(query);
        let mut node_ids = Vec::new();
        let mut seen = std::collections::HashSet::new();
        for &idx in &page_indices {
            if let Some(page) = store.get_page(idx) {
                for node in &page.nodes {
                    if seen.insert(node.id) {
                        node_ids.push(node.id);
                    }
                }
            }
        }
        node_ids
    }

    /// Point query via dual-octree page store.
    pub fn spatial_point_query(&mut self, x: f32, y: f32, z: f32) -> Vec<u64> {
        if self.spatial_page_store.is_none() {
            if let Err(e) = self.rebuild_spatial_index() {
                eprintln!(
                    "spatial_point_query: failed to rebuild spatial index: {}",
                    e
                );
                return vec![];
            }
        }
        let store = self.spatial_page_store.as_ref().unwrap();
        let page_indices = store.point_query(x, y, z);
        let mut node_ids = Vec::new();
        let mut seen = std::collections::HashSet::new();
        for &idx in &page_indices {
            if let Some(page) = store.get_page(idx) {
                for node in &page.nodes {
                    if seen.insert(node.id) {
                        node_ids.push(node.id);
                    }
                }
            }
        }
        node_ids
    }

    fn all_nodes(&self) -> Vec<NodeRec> {
        let mut nodes = Vec::with_capacity(self.node_count);
        for i in 0..self.node_count {
            if let Some(node) = self.get_node(i as u64) {
                nodes.push(*node);
            }
        }
        nodes
    }

    fn all_edges(&self) -> Vec<EdgeRec> {
        let mut edges = Vec::with_capacity(self.edge_count);
        for i in 0..self.edge_count {
            if let Some(edge) = self.get_edge(i as u64) {
                edges.push(*edge);
            }
        }
        edges
    }

    fn all_node_properties(
        &self,
    ) -> std::collections::HashMap<u64, std::collections::HashMap<String, String>> {
        // Node properties not persisted in the mmap format yet.
        std::collections::HashMap::new()
    }

    /// Save the spatial page store to disk alongside the main db file.
    fn maybe_save_spatial_store(&self) -> Result<()> {
        if let Some(ref store) = self.spatial_page_store {
            let spatial_path = self.path.with_extension("spatial");
            store.save(&spatial_path)?;
        }
        Ok(())
    }

    /// Try to load a persisted spatial page store from the sidecar file.
    pub fn maybe_load_spatial_store(&mut self) -> Result<()> {
        let spatial_path = self.path.with_extension("spatial");
        if spatial_path.exists() {
            let store = OctreePageStore::open(&spatial_path, 4, 1)?;
            self.spatial_page_store = Some(store);
        }
        Ok(())
    }
}

impl Drop for StorageManager {
    fn drop(&mut self) {
        if let Some(ref mut mmap) = self.mmap {
            let _ = mmap.flush();
        }
        let _ = self.file.sync_all();
    }
}

#[cfg(test)]
mod tests {
    use super::*;
    use tempfile::tempdir;

    #[test]
    fn test_storage_manager_create() {
        let temp_dir = tempdir().unwrap();
        let db_path = temp_dir.path().join("test.db");
        let result = StorageManager::create(&db_path);
        assert!(result.is_ok());
    }

    /// Layer 1 Test: 4D Temporal - Time-travel query support
    ///
    /// This test demonstrates the need for LSTS (Linearly Versioned Timestamp) support.
    /// Currently begin_ts/end_ts fields exist but are NOT used for version tracking.
    ///
    /// EXPECTED TO FAIL until LSTS is implemented.
    #[test]
    fn test_temporal_versioning_lsts_basic() {
        let temp_dir = tempdir().unwrap();
        let db_path = temp_dir.path().join("test_temporal.db");
        let mut manager = StorageManager::create(&db_path).unwrap();

        // Layer 1: Insert a node at timestamp 100
        let node_v1 = NodeRec {
            id: 1,
            morton_code: 0,
            x: 10.0,
            y: 20.0,
            z: 30.0,
            edge_off: 0,
            edge_len: 0,
            flags: 0,
            begin_ts: 100, // Version starts at timestamp 100
            end_ts: 0,     // 0 means "current" version
            tx_id: 1,
            visibility: 1, // VERSION_COMMITTED
            _padding: [0; 7],
        };

        let storage_id_v1 = manager.insert_node(node_v1).unwrap();
        assert_eq!(
            storage_id_v1, 0,
            "Layer 1: First node should have storage ID 0"
        );

        // Use the logical node ID (node.id) for LSTS operations
        let logical_id = 1u64;

        // Layer 2: Update the node at timestamp 200 (create new version)
        // In LSTS, this should:
        // 1. Set end_ts=200 on the old version
        // 2. Insert a new version with begin_ts=200, end_ts=0
        let node_v2 = NodeRec {
            id: 1,
            morton_code: 0,
            x: 15.0,
            y: 25.0,
            z: 35.0, // Changed coordinates
            edge_off: 0,
            edge_len: 0,
            flags: 0,
            begin_ts: 200, // New version starts at timestamp 200
            end_ts: 0,     // Current version
            tx_id: 2,
            visibility: 1,
            _padding: [0; 7],
        };

        let storage_id_v2 = manager.update_node(logical_id, node_v2, 200).unwrap();
        assert_eq!(
            storage_id_v2, 1,
            "Layer 2: Second version should have storage ID 1"
        );

        // Layer 3: Time-travel query - get node state at timestamp 150
        // At timestamp 150, we should see version 1 (begin_ts=100, end_ts=200)
        let node_at_150 = manager.get_node_at_timestamp(logical_id, 150);

        // This assertion will FAIL because get_node_at_timestamp doesn't exist yet
        assert!(
            node_at_150.is_some(),
            "Layer 3: Time-travel query should return version 1 at timestamp 150"
        );

        let node = node_at_150.unwrap();
        assert_eq!(
            node.x, 10.0,
            "Layer 3: At timestamp 150, should see v1 coordinates"
        );
        assert_eq!(node.begin_ts, 100, "Layer 3: Should be version 1");

        // Layer 4: Query current version (timestamp 250)
        let node_current = manager.get_node_at_timestamp(logical_id, 250);
        assert!(
            node_current.is_some(),
            "Layer 4: Should return current version at timestamp 250"
        );

        let current = node_current.unwrap();
        assert_eq!(
            current.x, 15.0,
            "Layer 4: Current version should have v2 coordinates"
        );
        assert_eq!(
            current.begin_ts, 200,
            "Layer 4: Current version should be v2"
        );
    }

    /// Layer 4 Test: Telemetry - Loop detection in LSTS operations
    ///
    /// Verifies that loop guards prevent infinite iteration when scanning versions.
    /// This test runs with telemetry enabled to validate loop detection.
    #[test]
    #[cfg(feature = "telemetry")]
    fn test_lsts_telemetry_loop_detection() {
        use crate::telemetry::LoopGuard;

        let temp_dir = tempdir().unwrap();
        let db_path = temp_dir.path().join("test_telemetry.db");
        let mut manager = StorageManager::create(&db_path).unwrap();

        // Insert a node
        let node = NodeRec {
            id: 1,
            morton_code: 0,
            x: 10.0,
            y: 20.0,
            z: 30.0,
            edge_off: 0,
            edge_len: 0,
            flags: 0,
            begin_ts: 100,
            end_ts: 0,
            tx_id: 1,
            visibility: 1,
            _padding: [0; 7],
        };

        manager.insert_node(node).unwrap();

        // Test that loop guard works
        let guard = LoopGuard::new("test_loop", 5);
        // Should succeed for first 5 iterations (0–4)
        for i in 0..5 {
            assert!(guard.check().is_ok(), "Should allow iteration {}", i);
        }
        // Should fail on 6th iteration (count becomes 5, 5 >= 5)
        assert!(guard.check().is_err(), "Should fail at iteration 5");
    }

    /// Layer 4 Test: Telemetry - Operation tracing
    ///
    /// Verifies that operation tracing tracks method calls.
    #[test]
    #[cfg(feature = "telemetry")]
    fn test_lsts_telemetry_op_tracing() {
        use crate::telemetry::OpTracer;

        let tracer = OpTracer::new();

        // Trace some operations
        tracer.trace("insert_node", file!(), line!());
        tracer.trace("get_node", file!(), line!());
        tracer.trace("update_node", file!(), line!());

        // Tracer should not panic and should track calls — this is a smoke-only test,
        // so there is no deterministic assertion against call_counts.
    }

    #[test]
    fn test_storage_manager_insert_edge() {
        let temp_dir = tempdir().unwrap();
        let db_path = temp_dir.path().join("test.db");
        let mut storage = StorageManager::create(&db_path).unwrap();

        let edge = EdgeRec {
            src: 0,
            dst: 1,
            w: 1.0,
            flags: 0,
            begin_ts: 0,
            end_ts: 0,
            tx_id: 0,
            visibility: 1,
            _padding: [0; 7],
        };
        let edge_id = storage.insert_edge(edge).unwrap();
        assert_eq!(edge_id, 0);
        assert_eq!(storage.edge_count(), 1);

        let retrieved = storage.get_edge(0).unwrap();
        assert_eq!(retrieved.dst, 1);
    }

    // ───────────────────────────────────────────────────────────────────────────
    // Dual-octree spatial integration tests
    // ───────────────────────────────────────────────────────────────────────────

    #[test]
    fn test_spatial_range_query_lazily_builds() {
        let temp_dir = tempdir().unwrap();
        let db_path = temp_dir.path().join("spatial.db");
        let mut storage = StorageManager::create(&db_path).unwrap();

        for i in 0..10 {
            let node = NodeRec {
                id: i as u64,
                morton_code: i as u64, // simple morton for sorting
                x: i as f32 * 1.0,
                y: 0.0,
                z: 0.0,
                edge_off: 0,
                edge_len: 0,
                flags: 0,
                begin_ts: 0,
                end_ts: 0,
                tx_id: 0,
                visibility: 1,
                _padding: [0; 7],
            };
            storage.insert_node(node).unwrap();
        }

        // Query box covering nodes 3.0..7.0 on X axis
        let query = BoundingBox::new(2.5, 7.5, -1.0, 1.0, -1.0, 1.0);
        let ids = storage.spatial_range_query(&query);

        // Should get some subset of nodes (page-based query returns
        // whole pages that intersect the query; precise IDs depend
        // on how the builder split the 10 nodes into pages).
        assert!(!ids.is_empty());
        assert!(ids.contains(&3));
        assert!(ids.contains(&6));
    }

    #[test]
    fn test_spatial_save_and_load() {
        let temp_dir = tempdir().unwrap();
        let db_path = temp_dir.path().join("spatial_persist.db");
        let mut storage = StorageManager::create(&db_path).unwrap();

        for i in 0..5 {
            let node = NodeRec {
                id: i as u64,
                morton_code: i as u64,
                x: i as f32 * 1.0,
                y: 0.0,
                z: 0.0,
                edge_off: 0,
                edge_len: 0,
                flags: 0,
                begin_ts: 0,
                end_ts: 0,
                tx_id: 0,
                visibility: 1,
                _padding: [0; 7],
            };
            storage.insert_node(node).unwrap();
        }

        // Trigger first spatial query to build the index
        let query = BoundingBox::new(0.0, 3.0, -1.0, 1.0, -1.0, 1.0);
        let before_ids = storage.spatial_range_query(&query);
        assert!(!before_ids.is_empty());

        // Flush (saves spatial sidecar)
        storage.flush().unwrap();

        // Re-open via StorageManager::open
        let mut storage2 = StorageManager::open(&db_path).unwrap();
        storage2.maybe_load_spatial_store().unwrap();

        // Query again
        let after_ids = storage2.spatial_range_query(&query);
        assert_eq!(before_ids, after_ids);
    }

    #[test]
    fn test_spatial_point_query() {
        let temp_dir = tempdir().unwrap();
        let db_path = temp_dir.path().join("spatial_point.db");
        let mut storage = StorageManager::create(&db_path).unwrap();

        let node = NodeRec {
            id: 42,
            morton_code: 0,
            x: 1.0,
            y: 2.0,
            z: 3.0,
            edge_off: 0,
            edge_len: 0,
            flags: 0,
            begin_ts: 0,
            end_ts: 0,
            tx_id: 0,
            visibility: 1,
            _padding: [0; 7],
        };
        storage.insert_node(node).unwrap();

        let ids = storage.spatial_point_query(1.0, 2.0, 3.0);
        assert!(ids.contains(&42));

        let ids_outside = storage.spatial_point_query(100.0, 100.0, 100.0);
        assert!(!ids_outside.contains(&42));
    }
}