Source code for seriesmarker.persistence.model.episode

#==============================================================================
# -*- coding: utf-8 -*-
#
# Copyright (C) 2013 - 2016 Tobias Röttger <toroettg@gmail.com>
#
# This file is part of SeriesMarker.
#
# SeriesMarker is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License version 3 as
# published by the Free Software Foundation.
#
# SeriesMarker is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with SeriesMarker.  If not, see <http://www.gnu.org/licenses/>.
#==============================================================================

from seriesmarker.persistence.database import Base
from sqlalchemy.orm import relationship
from sqlalchemy.schema import Column, ForeignKey
from sqlalchemy.types import Integer, String, Float, Date

[docs]class Episode(Base): """This class stores information about an episode.""" __tablename__ = "episode" id = Column(Integer, primary_key=True) season_id = Column(Integer, ForeignKey('season.id')) episode_name = Column('EpisodeName', String) episode_number = Column('EpisodeNumber', Integer) # season_number = Column('SeasonNumber', Integer) shifted to Season # series_id = Column(Integer, ForeignKey('series.id')) shifted to Season combined_episode_number = Column('Combined_episodenumber', Float) combined_season = Column('Combined_season', Integer) language = Column('Language', String) overview = Column('Overview', String) imdb_id = Column('IMDB_ID', String) airs_before_season = Column('airsbefore_season', Integer) airs_before_episode = Column('airsbefore_episode', Integer) airs_after_season = Column('airsafter_season', Integer) DVD_season = Column('DVD_season', Integer) DVD_chapter = Column('DVD_chapter', Integer) DVD_episode_number = Column('DVD_episodenumber', Float) DVD_disc_id = Column('DVD_discid', Integer) ep_img_flag = Column('EpImgFlag', Integer) production_code = Column('ProductionCode', String) last_updated = Column('lastupdated', Integer) filename = Column('filename', String) first_aired = Column('FirstAired', Date) absolute_number = Column('absolute_number', Integer) rating = Column('Rating', Float) rating_count = Column('RatingCount', Integer) guests = relationship('Guest') writers = relationship('Writer') directors = relationship('Director') extra = relationship("EpisodeExtra", uselist=False)
[docs] def __repr__(self): return "<Episode('%s','%s')>" % (self.id, self.episode_name)