Skip to main content

Database

Struct Database 

Source
pub struct Database { /* private fields */ }

Implementations§

Source§

impl Database

Source

pub async fn connect(url: &str, max_connections: u32) -> DbResult<Self>

Source

pub async fn ping(&self) -> DbResult<()>

Source

pub fn pool(&self) -> &SqlitePool

Source

pub async fn create_user(&self, api_key: &str) -> DbResult<String>

Source

pub async fn get_user_by_api_key( &self, api_key: &str, ) -> DbResult<Option<String>>

Source

pub async fn create_library( &self, user_id: &str, name: &str, ) -> DbResult<String>

Source

pub async fn list_libraries( &self, user_id: &str, limit: i32, offset: i32, ) -> DbResult<(Vec<Library>, i32)>

Source

pub async fn delete_library( &self, user_id: &str, library_id: &str, ) -> DbResult<()>

Source

pub async fn get_default_library(&self, user_id: &str) -> DbResult<String>

Source

pub async fn verify_library_ownership( &self, user_id: &str, library_id: &str, ) -> DbResult<bool>

Source

pub async fn get_snippets( &self, user_id: &str, library_id: &str, since: i64, limit: i32, offset: i32, include_deleted: bool, ) -> DbResult<(Vec<Snippet>, i32)>

Source

pub async fn get_snippets_page( &self, user_id: &str, library_id: &str, cursor: DeltaCursor, limit: i32, offset: i32, include_deleted: bool, ) -> DbResult<SnippetPage>

Fetch one page of snippets together with the paging facts derived from it.

The page is read with LIMIT limit + 1, so has_more comes from the rows themselves instead of a second COUNT(*) scan over the same range. The exact total is taken from the page whenever the page is the last one (the range then holds exactly offset + rows rows); when the range continues past the page — or the requested offset is past the end of the range — the range is still counted so total keeps its exact meaning.

Source

pub async fn upsert_snippet_in_tx( &self, tx: &mut Transaction<'_, Sqlite>, snippet: &Snippet, user_id: &str, library_id: &str, ) -> DbResult<UpsertOutcome>

Source

pub async fn get_latest_timestamp( &self, user_id: &str, library_id: &str, ) -> DbResult<i64>

Source

pub async fn get_latest_sequence( &self, user_id: &str, library_id: &str, ) -> DbResult<i64>

The library’s write-sequence watermark.

This is the cursor the server hands back to a client that syncs on the sequence path. It is the highest sequence any row of the library holds, so it never moves backwards and never skips a row.

Source

pub async fn migrate_snippet_sequence(&self) -> DbResult<bool>

Add the write-sequence cursor: its column, its per-library counter, and the unique index that turns a counter race into a loud failure.

The backfill gives every row a sequence that preserves the pre-migration updated_at ordering (ranked inside the row’s library, ties broken by the row id), so a migrated database selects the same rows as an unmigrated one for the first sync and every client’s stored cursor stays valid. The counter is then seeded from the highest sequence of each library, so the next write can never collide with a backfilled row.

Idempotent: it is safe to run on every start.

Source

pub async fn migrate_snippet_visible_at(&self) -> DbResult<bool>

Add the visible_at cursor column to an existing database.

The column carries the delta cursor position of a row; updated_at keeps the client’s logical modification time. Existing rows are backfilled with their current updated_at, so a migrated database selects exactly the same rows as before the migration and every client’s stored cursor stays valid.

Source

pub async fn migrate_plaintext_api_keys(&self) -> DbResult<usize>

Trait Implementations§

Source§

impl Clone for Database

Source§

fn clone(&self) -> Self

Returns a duplicate of the value. Read more
1.0.0 (const: unstable) · Source§

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source. Read more

Auto Trait Implementations§

Blanket Implementations§

Source§

impl<T> Any for T
where T: 'static + ?Sized,

Source§

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more
Source§

impl<T> Borrow<T> for T
where T: ?Sized,

Source§

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more
Source§

impl<T> BorrowMut<T> for T
where T: ?Sized,

Source§

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more
Source§

impl<T> CloneToUninit for T
where T: Clone,

Source§

unsafe fn clone_to_uninit(&self, dest: *mut u8)

🔬This is a nightly-only experimental API. (clone_to_uninit)
Performs copy-assignment from self to dest. Read more
Source§

impl<T> From<T> for T

Source§

fn from(t: T) -> T

Returns the argument unchanged.

Source§

impl<T> FromRef<T> for T
where T: Clone,

Source§

fn from_ref(input: &T) -> T

Converts to this type from a reference to the input type.
Source§

impl<T> Instrument for T

Source§

fn instrument(self, span: Span) -> Instrumented<Self> ⓘ

Instruments this type with the provided Span, returning an Instrumented wrapper. Read more
Source§

fn in_current_span(self) -> Instrumented<Self> ⓘ

Instruments this type with the current Span, returning an Instrumented wrapper. Read more
Source§

impl<T, U> Into<U> for T
where U: From<T>,

Source§

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

Source§

impl<T> IntoEither for T

Source§

fn into_either(self, into_left: bool) -> Either<Self, Self> ⓘ

Converts self into a Left variant of Either<Self, Self> if into_left is true. Converts self into a Right variant of Either<Self, Self> otherwise. Read more
Source§

fn into_either_with<F>(self, into_left: F) -> Either<Self, Self> ⓘ
where F: FnOnce(&Self) -> bool,

Converts self into a Left variant of Either<Self, Self> if into_left(&self) returns true. Converts self into a Right variant of Either<Self, Self> otherwise. Read more
Source§

impl<T> IntoRequest<T> for T

Source§

fn into_request(self) -> Request<T>

Wrap the input message T in a tonic::Request
Source§

impl<L> LayerExt<L> for L

Source§

fn named_layer<S>(&self, service: S) -> Layered<<L as Layer<S>>::Service, S>
where L: Layer<S>,

Applies the layer to a service and wraps it in Layered.
Source§

impl<T> Same for T

Source§

type Output = T

Should always be Self
Source§

impl<T> ToOwned for T
where T: Clone,

Source§

type Owned = T

The resulting type after obtaining ownership.
Source§

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more
Source§

fn clone_into(&self, target: &mut T)

Uses borrowed data to replace owned data, usually by cloning. Read more
Source§

impl<T, U> TryFrom<U> for T
where U: Into<T>,

Source§

type Error = !

The type returned in the event of a conversion error.
Source§

fn try_from(value: U) -> Result<T, !>

Performs the conversion.
Source§

impl<T, U> TryInto<U> for T
where U: TryFrom<T>,

Source§

type Error = <U as TryFrom<T>>::Error

The type returned in the event of a conversion error.
Source§

fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

Performs the conversion.
Source§

impl<T> WithSubscriber for T

Source§

fn with_subscriber<S>(self, subscriber: S) -> WithDispatch<Self> ⓘ
where S: Into<Dispatch>,

Attaches the provided Subscriber to this type, returning a WithDispatch wrapper. Read more
Source§

fn with_current_subscriber(self) -> WithDispatch<Self> ⓘ

Attaches the current default Subscriber to this type, returning a WithDispatch wrapper. Read more