如何搜索作为属性的int数组？如何通过episodes属性检索Show对象？

Hey there! Let's break down your two questions step by step— I’ve tangled with similar issues before, so I’ll walk you through practical examples that should work for most common setups.

First, I’m assuming your Show class has an episodes attribute that links to related Episode objects (like a one-to-many relationship in an ORM). Here’s how to pull back the parent Show from that relationship:

If you have a specific Episode instance #

If you’re starting with an individual Episode object, you can usually access its associated Show directly through a reverse relationship (most ORMs set this up automatically when you define the foreign key):

# Example with SQLAlchemy
target_episode = Episode.query.get(123)
related_show = target_episode.show  # This gives you the linked Show object

# Example with Django
target_episode = Episode.objects.get(id=123)
related_show = target_episode.show

If you want to find Shows linked to a set of Episodes #

If you need to fetch all Show objects that are associated with a list of Episode IDs, you can use a join and filter:

# SQLAlchemy example: Get all Shows with Episodes 1, 2, or 3
matching_shows = Show.query.join(Episode).filter(Episode.id.in_([1, 2, 3])).distinct().all()

# Django example
matching_shows = Show.objects.filter(episodes__id__in=[1,2,3]).distinct()

Next, for searching an int array that’s a property of your Show object— this depends on whether the array is stored in a database or exists as an in-memory list:

If the int array is a database field (e.g., PostgreSQL int[]) #

Most databases have specific operators for array searches. For PostgreSQL, here are common use cases:

# SQLAlchemy: Find Shows where the int array contains the value 5
matching_shows = Show.query.filter(Show.int_array_property.any(5)).all()

# SQLAlchemy: Find Shows where the array overlaps with [3,5,7] (shares any value)
matching_shows = Show.query.filter(Show.int_array_property.overlap([3,5,7])).all()

# Django (with django-postgres extensions):
from django.contrib.postgres.fields import ArrayField
# Find Shows where the array includes 5
matching_shows = Show.objects.filter(int_array_property__contains=[5])
# Find Shows where the array overlaps with [3,5,7]
matching_shows = Show.objects.filter(int_array_property__overlap=[3,5,7])

If the int array is an in-memory list (Python attribute) #

If you’re working with a list of Show objects already loaded into memory, use list comprehensions or filter() to narrow them down:

# List comprehension: Get Shows where the int array contains 5
all_shows = Show.query.all()  # Or your existing list of Show objects
matching_shows = [show for show in all_shows if 5 in show.int_array_property]

# Using filter()
matching_shows = list(filter(lambda show: 5 in show.int_array_property, all_shows))

Quick Notes #

• Double-check your ORM model relationships/field definitions— misconfigurations here are the most common reason these methods fail!
• If you’re using a database that doesn’t natively support arrays (like MySQL), you might be storing the array as a comma-separated string— in that case, use your database’s string search functions (e.g., FIND_IN_SET in MySQL), but I’d recommend switching to a proper array type if your database supports it.

内容的提问来源于stack exchange，提问作者Dadge