I have this function that I have written, that gets passed a row of data from a mysql function. The function then uses a try-except block to get some a list of values depending on a value within the row of data.
It then loops through this data and completes another try-except block within the first try-except block's
In fact, a lot of my code is styled this way. Some blocks go on for so long, or other blocks start once one has finished. Is this good practice of writing code? Or should I refactor my code and move the second try-except block into another separate function?
def select_uploaded_series(row): try: select_series_name = """SELECT track_ser_series FROM track_series WHERE track_ser_id = %s""" dbDets.execute(select_series_name,(row['track_id']),) series_names = dbDets.fetchall() except Exception as e: raise(e) else: names =  for series in series_names: try: select_series_name_query = """SELECT title FROM series WHERE categoryId = %s""" dbDets.execute( select_series_name_query, (series['track_ser_series']),) track_series_names = dbDets.fetchall() except Exception as e: raise(e) else: for t_names in track_series_names: names.append(t_names['title']) return(names)