Hi Rajeswari
one way can be passing the details which you wan to percolate from shows page to seasons page and seasons page to episodes page.
For eg. you wont be crawling to all urls on the shows page, you would be crawling url of a certain type only.For this you will be yielding new requests for seasons pages from shows page.
if rows has all the urls for seasons then
you can do something like
for row in rows:
yield Request(url=row[0],meta={'show':row[2]},callback=self.parse)
def parse(self, response):
print(response.meta['show']) # prints the shows name
in this way you will be passing the name of the show while calling request for each season url. Similarly you can do while crawling episodes on seasons page.
I hope this helps.
in this way all the seasons