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()
