Struct dim_database::episode::Episode

pub struct Episode {
    pub id: i64,
    pub seasonid: i64,
    pub episode: i64,
    pub media: Media,
}

Episode struct encapsulates a media entry representing a episode

Fields

id: i64

seasonid: i64

Season id foreign_key

episode: i64

episode number

media: Media

Regerence to a media object which represents this epsiode. We are essnetially aliasing and wrapping around Media transparently, behind the scene in the db episode inherits all fields from media.

Implementations

impl Episode

pub async fn get_first_for_season(
    conn: &mut Transaction<'_>,
    season_id: i64
) -> Result<Self, DatabaseError>

pub async fn get_first_for_show(
    conn: &mut Transaction<'_>,
    tv_id: i64
) -> Result<Self, DatabaseError>

pub async fn get_all_of_tv(
    conn: &mut Transaction<'_>,
    tv_show_id: i64
) -> Result<Vec<Self>, DatabaseError>

Method returns all of the episodes belonging to a tv show.

Arguments

• conn - a mutable reference to a sqlx transaction.
• media - reference to a media object which should be a tv show.

pub async fn get_all_of_season(
    conn: &mut Transaction<'_>,
    season_id: i64
) -> Result<Vec<Episode>, DatabaseError>

Method returns all of the episodes belonging to a season.

Arguments

• conn - mutable reference to a sqlx transaction.
• media - reference to a season object/entry.

pub async fn get(
    conn: &mut Transaction<'_>,
    tv_id: i64,
    season_num: i64,
    ep_num: i64
) -> Result<Episode, DatabaseError>

Method returns a episodes discriminated by episode number, season number and tv show id

Arguments

• conn - mutable reference to a sqlx transaction.
• id - The id of a tv show we target
• season_num - The season we are targetting
• ep_num - Episode we are targetting

pub async fn get_by_id(
    conn: &mut Transaction<'_>,
    episode_id: i64
) -> Result<Episode, DatabaseError>

pub async fn get_season_episode_by_id(
    conn: &mut Transaction<'_>,
    episode_id: i64
) -> Result<(i64, i64), DatabaseError>

pub async fn get_season_number(
    &self,
    conn: &mut Transaction<'_>
) -> Result<i64, DatabaseError>

pub async fn get_next_episode(
    &self,
    conn: &mut Transaction<'_>
) -> Result<Episode, DatabaseError>

Function will query for the episode after the episode passed in.

pub async fn get_prev_episode(
    &self,
    conn: &mut Transaction<'_>
) -> Result<Episode, DatabaseError>

Function will query for the episode after the episode passed in.

pub async fn get_last_watched_episode(
    conn: &mut Transaction<'_>,
    tvid: i64,
    uid: UserID
) -> Result<Option<Episode>, DatabaseError>

Function will query the last episode that was watched for a show.

pub async fn get_seasonid(
    tx: &mut Transaction<'_>,
    episodeid: i64
) -> Result<i64, DatabaseError>

pub async fn delete(
    conn: &mut Transaction<'_>,
    episode_id: i64
) -> Result<usize, DatabaseError>

Method deletes a episode based on the tv show id, season number, and episode number

Arguments

• id - The id of a tv show we target
• season_num - The season we are targetting
• ep_num - Episode we are targetting

Trait Implementations

impl Clone for Episode

fn clone(&self) -> Episode

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for Episode

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

Formats the value using the given formatter.

impl Serialize for Episode

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>where
    __S: Serializer,

Serialize this value into the given Serde serializer.