python - 无效输入导致 psycopg2.errors.InvalidTextRepresentation

Question

我不断收到错误，我不确定是什么触发了它。在我的终端中，我收到 Error 500 get /artists/none" 它说的另一行

sqlalchemy.exc.DataError: (psycopg2.errors.InvalidTextRepresentation) 整数类型的无效输入语法：“无”第 3 行：WHERE artist.id = 'None'

@app.route('/artists/<artist_id>')
def show_artist(artist_id):
  selectedArtist = Artist.query.filter_by(id=artist_id).first()
  related_shows = Shows.query.filter_by(related_artist=artist_id).all()
  upcoming_shows = []
  upcoming_shows_count = 0
  past_shows = []
  past_shows_count = 0
  for show in related_shows:
    if show.start_time > datetime.now():
      upcoming_shows_count += 1
      upcoming_shows.append({
        'venue_id': show.venue.id,
        'venue_name': show.venue.name,
        'venue_image_link':show.venue.image_link,
        'start_time': format_datetime(str(show.start_time))
      })
    elif show.start_time < datetime.now():
      past_shows_count += 1
      past_shows.append({
        'venue_id': show.venue.id,
        'venue_name': show.venue.name,
        'venue_image_link':show.venue.image_link,
        'start_time': format_datetime(str(show.start_time))
      })
  data = {
    'id': selectedArtist.id,
    'name':selectedArtist.name,
    'city': selectedArtist.city,
    'state': selectedArtist.state,
    'phone': selectedArtist.phone,
    'website': selectedArtist.website,
    'facebook_link': selectedArtist.facebook_link,
    'image_link': selectedArtist.image_link,
    'upcoming_shows': upcoming_shows,
    'upcoming_shows_count':upcoming_shows_count,
    'past_shows_count': past_shows_count,
    'past_shows': past_shows
  }
  return render_template('pages/show_artist.html', artist=data)

它返回艺术家模板，但我在 shell 中收到此错误，最终应用程序超时，艺术家部分中没有任何内容。一旦我重新启动本地服务器，它就会再次工作。我似乎无法找出触发它的原因。有什么线索吗？

标签： pythonflasksqlalchemy