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