Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
def _load_from_db(self):
logger.log(str(self.indexerid) + u': Loading show info from database', logger.DEBUG)
main_db_con = db.DBConnection()
sql_results = main_db_con.select(b'SELECT * FROM tv_shows WHERE indexer_id = ?', [self.indexerid])
if len(sql_results) > 1:
raise MultipleShowsInDatabaseException()
elif not sql_results:
logger.log(u'{0}: Unable to find the show in the database'.format(self.indexerid))
return
else:
self.indexer = int(sql_results[0][b'indexer'] or 0)
if not self.name:
self.name = sql_results[0][b'show_name']
if not self.network:
self.network = sql_results[0][b'network']
if not self.genre:
self.genre = sql_results[0][b'genre']
if not self.classification:
self.classification = sql_results[0][b'classification']
self.runtime = sql_results[0][b'runtime']