Struct PhotoRepo 

pub struct PhotoRepo<'a> { /* private fields */ }

Photo repository for database operations

Implementations

impl<'a> PhotoRepo<'a>

pub fn new(conn: &'a Connection) -> Self

pub fn insert_batch_stub(&self, photos: &[PhotoInsert]) -> SqliteResult<usize>

Batch insert stub rows (streaming scanner Phase 1B).

Uses INSERT OR IGNORE so an idempotent re-scan never blows away metadata that Phase 2+ already filled in. Only sets the columns known at walk time; everything else (EXIF, thumbnail, geocoding) is updated later by the pipeline workers.

pub fn insert_batch(&self, photos: &[PhotoInsert]) -> SqliteResult<usize>

Batch insert photos within a transaction

pub fn count(&self) -> SqliteResult<i64>

Get total photo count

pub fn count_timeline_visible(&self, show_stacks: bool) -> SqliteResult<i64>

pub fn count_pending_metadata(&self) -> SqliteResult<i64>

Photos awaiting EXIF / geocoding extraction (Phase 2 of the streaming scanner). Drives the “Resume reading metadata” banner.

pub fn count_pending_thumbnails(&self) -> SqliteResult<i64>

Photos awaiting thumbnail generation (Phase 3).

pub fn get_all_by_date( &self, limit: i64, offset: i64, ) -> SqliteResult<Vec<Photo>>

Get all photos ordered by date

pub fn get_by_ids(&self, photo_ids: &[i64]) -> SqliteResult<Vec<Photo>>

Get photos by IDs ordered by date (descending).

pub fn get_by_id(&self, id: i64) -> SqliteResult<Option<Photo>>

Get a single photo by ID.

pub fn set_favorite(&self, id: i64, is_favorite: bool) -> SqliteResult<usize>

pub fn count_favorites(&self) -> SqliteResult<i64>

pub fn favorites_album_summary( &self, ) -> SqliteResult<Option<FavoriteAlbumSummary>>

impl<'a> PhotoRepo<'a>

pub fn list_after( &self, cursor: Option<(Option<DateTime<Utc>>, i64)>, limit: i64, include_trashed: bool, show_stacks: bool, ) -> SqliteResult<Vec<PhotoLite>>

Cursor-paginated timeline list. Cursor key is (date_taken, id) descending. NULL date_taken sorts last via SQLite’s IS NULL. limit is clamped by the caller; this just trusts it.

pub fn list_at_offset( &self, offset: i64, limit: i64, include_trashed: bool, show_stacks: bool, ) -> SqliteResult<Vec<PhotoLite>>

Offset-addressed timeline window. Used only for fast jumps into very large timelines; cursor paging remains the normal path.

pub fn timeline_neighbors( &self, photo_id: i64, show_stacks: bool, ) -> SqliteResult<Option<TimelineNeighbors>>

pub fn list_after_by_album( &self, album_id: i64, cursor: Option<(Option<DateTime<Utc>>, i64)>, limit: i64, ) -> SqliteResult<Vec<PhotoLite>>

Cursor-paginated photos in a specific album, ordered by date.

pub fn list_after_favorites( &self, cursor: Option<(Option<DateTime<Utc>>, i64)>, limit: i64, ) -> SqliteResult<Vec<PhotoLite>>

Cursor-paginated favorite photos. This backs the virtual Favorites album without writing synthetic rows to albums.

pub fn list_after_by_person( &self, cluster_id: i64, cursor: Option<(Option<DateTime<Utc>>, i64)>, limit: i64, ) -> SqliteResult<Vec<PhotoLite>>

Cursor-paginated photos featuring a person (face cluster).

pub fn list_after_by_date( &self, start_iso: &str, end_iso: &str, cursor: Option<(Option<DateTime<Utc>>, i64)>, limit: i64, ) -> SqliteResult<Vec<PhotoLite>>

Cursor-paginated photos in a half-open date range: [start, end).

pub fn list_after_by_place( &self, city: Option<&str>, country: Option<&str>, cursor: Option<(Option<DateTime<Utc>>, i64)>, limit: i64, ) -> SqliteResult<Vec<PhotoLite>>

Cursor-paginated photos in a place (city and/or country, both optional).

pub fn list_in_bounds( &self, north: f64, south: f64, east: f64, west: f64, cap: i64, ) -> SqliteResult<Vec<PhotoLite>>

Photos within a lat/lng bounding box that have GPS coordinates. Used by map.pins for server-side aggregation.

Bounds are inclusive on all sides. Returns a hard cap of cap rows.