def test3():
"""Franchised, Series, Seasoned, with 1 OTO"""
p = Producer(name='BBC Productions')
p.save()
d = Distributor(name='PBS Distribution')
d.save()
ep1 = SeriesEpisode(name="Scandal in Belgravia")
ep1.save()
se = Season(name="Season 2", ordinal="2")
se.save()
s = Series(name='Sherlock')
s.orgs = [p, d]
s.save()
sa = SeasonAssociation(season=se)
sa.series = s
sa.episode = ep1
sa.season = se
sa.save()
# get the previous
f = session.query(Franchise).filter(Franchise.name=="Masterpiece").all()[0]
f.serieses.append(s)
f.save()
def test6():
"""Series with OTO"""
p = Producer(name='WGBH Productions')
p.save()
d = Distributor(name='PBS Distribution')
d.save()
se = Season(name='38', ordinal=38)
se.save()
e1 = OneTimeOnlyEpisode(name="Surviving Ebola")
e1.seasons = [se,]
e1.save()
# get the previous
s = session.query(Series).filter(Series.name=="NOVA").all()[0]
s.seasons = [se,]
s.episodes = [e1,]
s.save()
sa = SeasonAssociation(season=se)
sa.series = s
sa.episode = e1
sa.save()
def test_get():
titles = [ "Wolf Hall", "Wolf Hall Subseries", "Downton Abbey", "Sherlock", "The National Parks",
"NOVA", "Antiques Roadshow", "PBS NewsHour", "A Capitol Fourth", "Curious George"]
for series in titles:
s = session.query(Series).filter(Series.name==series).all()
if s:
unfurl(s[0])
def test2():
"""Franchised, Series, NO Season, 1 OTO"""
p = Producer(name='BBC Productions')
p.save()
d = Distributor(name='PBS Distribution')
d.save()
ep1 = OneTimeOnlyEpisode(name="Downton Abbey 2014 X-mas Special")
ep1.save()
s = Series(name='Downton Abbey')
s.onetimeonlys = [ep1]
s.orgs = [p, d]
s.save()
# get the previous
f = session.query(Franchise).filter(Franchise.name=="Masterpiece").all()[0]
f.serieses.append(s)
f.save()
def test9():
"""WEIRD ONE: Series and Subseries of different seasons sharing the same Ep"""
p = Producer(name='WETA Productions')
p.save()
d = Distributor(name='PBS Distribution')
d.save()
se = Season(name='41', ordinal=41)
se.save()
se2 = Season(name='2012', ordinal=2012)
se2.save()
e1 = SeriesEpisode(name="Democratic National Convention September 5, 2015 Part 1")
e1.save()
ss1 = SubSeries(name="Elections")
#ss1.episodes = [e1,]
ss1.seasons = [se2]
ss1.save()
s = session.query(Series).filter(Series.name=="PBS NewsHour").all()[0]
#s = Series(name="PBS NewsHour")
s.subseries = [ss1]
s.seasons = [se,]
s.save()
sa = SeasonAssociation(season=se)
sa.series = s
sa.episode = e1
sa.save()
sa2 = SeasonAssociation(season=se2)
sa2.series = ss1
sa2.episode = e1
sa2.save()
