Struct Database 

pub struct Database { /* private fields */ }

Struct holding a sqlite database connection, with methods to interact with this connection.

Implementations

impl Database

pub fn new(path: &Path) -> Result<Database>

Creates a new connection to the database (and creates database if it does not already exist).

Errors

• if creating / opening the database fails
• if migration fails

pub fn insert_podcast(&self, podcast: &PodcastNoId) -> Result<u64>

Inserts a new podcast and list of podcast episodes into the database.

pub fn insert_episode( conn: &Connection, podcast_id: PodcastDBId, episode: &EpisodeNoId, ) -> Result<PodcastDBId>

Inserts a podcast episode into the database.

pub fn insert_file(&self, episode_id: PodcastDBId, path: &Path) -> Result<()>

Inserts a filepath to a downloaded episode.

pub fn remove_file(&self, episode_id: PodcastDBId) -> Result<()>

Removes a file listing for an episode from the database when the user has chosen to delete the file.

pub fn remove_files(&self, episode_ids: &[PodcastDBId]) -> Result<()>

Removes all file listings for the selected episode ids.

pub fn remove_podcast(&self, podcast_id: PodcastDBId) -> Result<()>

Removes a podcast, all episodes, and files from the database.

pub fn update_podcast( &self, pod_id: PodcastDBId, podcast: &PodcastNoId, ) -> Result<SyncResult>

Updates an existing podcast in the database, where metadata is changed if necessary, and episodes are updated (modified episodes are updated, new episodes are inserted).

pub fn set_played_status( &self, episode_id: PodcastDBId, played: bool, ) -> Result<()>

Updates an episode to mark it as played or unplayed.

pub fn set_all_played_status( &self, episode_id_vec: &[PodcastDBId], played: bool, ) -> Result<()>

Updates an episode to mark it as played or unplayed.

pub fn hide_episode(&self, episode_id: PodcastDBId, hide: bool) -> Result<()>

Updates an episode to “remove” it by hiding it. “Removed” episodes need to stay in the database so that they don’t get re-added when the podcast is synced again.

pub fn get_podcasts(&self) -> Result<Vec<Podcast>>

Generates list of all podcasts in database. TODO: This should probably use a JOIN statement instead.

pub fn get_episodes( &self, pod_id: PodcastDBId, include_hidden: bool, ) -> Result<Vec<Episode>>

Generates list of episodes for a given podcast.

pub fn get_episode_by_url(&self, ep_uri: &str) -> Result<Episode>

Find a single Episode by its Url.

pub fn clear_db(&self) -> Result<()>

Deletes all rows in all tables

pub fn get_last_position(&mut self, track: &Track) -> Result<Duration>

pub fn set_last_position( &self, track: &Track, last_position: Duration, ) -> Result<()>

Errors

• if the connection is unavailable
• if the query fails

Trait Implementations

impl Debug for Database

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.