Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
def findPropers(self, search_date=datetime.datetime.today()):
results = []
myDB = db.DBConnection()
sqlResults = myDB.select(
'SELECT s.show_name, e.showid, e.season, e.episode, e.status, e.airdate FROM tv_episodes AS e' +
' INNER JOIN tv_shows AS s ON (e.showid = s.indexer_id)' +
' WHERE e.airdate >= ' + str(search_date.toordinal()) +
' AND e.status IN (' + ','.join([str(x) for x in Quality.DOWNLOADED + Quality.SNATCHED + Quality.SNATCHED_BEST]) + ')'
)
for sqlshow in sqlResults or []:
show = Show.find(sickbeard.showList, int(sqlshow["showid"]))
if show:
curEp = show.getEpisode(int(sqlshow["season"]), int(sqlshow["episode"]))
for term in self.proper_strings:
searchString = self._get_episode_search_strings(curEp, add_string=term)
for item in self._doSearch(searchString[0]):
title, url = self._get_title_and_url(item)
results.append(classes.Proper(title, url, datetime.datetime.today(), show))
return results
self.dvdorder = 0
self.lang = lang
self.last_update_indexer = 1
self.sports = 0
self.anime = 0
self.scene = 0
self.rls_ignore_words = ''
self.rls_require_words = ''
self.default_ep_status = SKIPPED
self._location = ''
self.episodes = {}
self.nextaired = ''
self.release_groups = None
self.exceptions = []
other_show = Show.find(sickbeard.showList, self.indexerid)
if other_show is not None:
raise MultipleShowObjectsException("Can't create a show if it already exists")
self._load_from_db()