Struct SqlSession 

pub struct SqlSession {
    pub file_count: usize,
    pub tag_count: usize,
    pub link_count: usize,
    /* private fields */
}

A pre-built SQL session with files, tags, and links tables.

Created via FrontmatterSqlEngine::session. Reuse for multiple queries to avoid rebuilding the in-memory tables each time.

Fields

file_count: usize

Rows in the files table.

tag_count: usize

Rows in the tags table.

link_count: usize

Rows in the links table.

Implementations

impl SqlSession

pub async fn query(&mut self, sql: &str) -> Result<Value>

Execute a SQL query against the pre-built tables.

Only SELECT (and SHOW COLUMNS) statements run: the tool that calls this is read-only, and the tables are a view of the vault, not somewhere to keep data. The query runs on a blocking thread for at most QUERY_TIMEOUT, and each result keeps its first MAX_RESULT_ROWS rows.