Struct SqliteDatabase 

pub struct SqliteDatabase { /* private fields */ }

SQLite-backed database implementation.

Implementations

impl SqliteDatabase

pub fn open<P: AsRef<Path>>(path: P) -> Result<Self, Error>

Open a database at the given path and run any pending migrations.

pub fn open_in_memory() -> Result<Self, Error>

Open an in-memory database and run migrations.

Trait Implementations

impl Database for SqliteDatabase

fn add_note<'life0, 'async_trait>( &'life0 self, note: CreateNote, ) -> Pin<Box<dyn Future<Output = Result<i64, Error>> + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Add a new note and return its ID.

fn get_note<'life0, 'async_trait>( &'life0 self, id: i64, ) -> Pin<Box<dyn Future<Output = Result<Option<Note>, Error>> + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Get a note by ID.

fn list_notes<'life0, 'async_trait>( &'life0 self, query: NoteQuery, ) -> Pin<Box<dyn Future<Output = Result<Vec<Note>, Error>> + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

List notes matching the query.

fn count_notes<'life0, 'async_trait>( &'life0 self, query: NoteQuery, ) -> Pin<Box<dyn Future<Output = Result<i64, Error>> + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Count notes matching the query (ignores limit).

fn update_note<'life0, 'async_trait>( &'life0 self, id: i64, update: UpdateNote, ) -> Pin<Box<dyn Future<Output = Result<bool, Error>> + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Update an existing note.

fn delete_note<'life0, 'async_trait>( &'life0 self, id: i64, ) -> Pin<Box<dyn Future<Output = Result<bool, Error>> + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Delete a note by ID. Returns true if deleted, false if not found.

fn list_tags<'life0, 'async_trait>( &'life0 self, ) -> Pin<Box<dyn Future<Output = Result<Vec<TagCount>, Error>> + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

List all tags with their note counts.

fn grep<'life0, 'life1, 'life2, 'async_trait>( &'life0 self, pattern: &'life1 str, tags: Option<&'life2 [String]>, case_sensitive: bool, ) -> Pin<Box<dyn Future<Output = Result<Vec<Note>, Error>> + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait, 'life2: 'async_trait,

Search notes by pattern (regex) in title and body.