Search SeasonDir table.

    Find the season directory for a given show id and season combination.

    Parameters
    ----------
      showID : int
        Show id for given show.

      seasonNum : int
        Season number.

    Returns
    ----------
      string or None
        If no match is found this returns None, if a single match is found
        then the season directory name value is returned. If multiple matches
        are found a fatal error is raised.

def SearchSeasonDirTable(self, showID, seasonNum):
    """
    Search SeasonDir table.

    Find the season directory for a given show id and season combination.

    Parameters
    ----------
      showID : int
        Show id for given show.

      seasonNum : int
        Season number.

    Returns
    ----------
      string or None
        If no match is found this returns None, if a single match is found
        then the season directory name value is returned. If multiple matches
        are found a fatal error is raised.
    """
    goodlogging.Log.Info("DB", "Looking up directory for ShowID={0} Season={1} in database".format(showID, seasonNum), verbosity=self.logVerbosity)

    queryString = "SELECT SeasonDir FROM SeasonDir WHERE ShowID=? AND Season=?"
    queryTuple = (showID, seasonNum)

    result = self._ActionDatabase(queryString, queryTuple, error = False)

    if result is None:
      goodlogging.Log.Info("DB", "No match found in database", verbosity=self.logVerbosity)
      return None
    elif len(result) == 0:
      return None
    elif len(result) == 1:
      goodlogging.Log.Info("DB", "Found database match: {0}".format(result), verbosity=self.logVerbosity)
      return result[0][0]
    elif len(result) > 1:
      goodlogging.Log.Fatal("DB", "Database corrupted - multiple matches found in database table for: {0}".format(result))