Change Details

We create a function in `upload-fetchers` to query the database for uploads given a specific threadID. The `filename NOT LIKE 'thumb%'` is used to filter out scenarios where when a video is uploaded, so is a thumbnail, and we don't want to pull a static thumbnail for the video. https://linear.app/comm/issue/ENG-2873/create-a-function-to-query-for-all-uploads-from-a-provided-thread The `any` types on the function are resolved in the immediate next diff as I introduce the appropriate types in that diff (D6531). Depends on D6482

We create a function in `upload-fetchers` to query the database for uploads given a specific threadID. The query uses a UNION to join two select statements, one for the photos and one for the videos. We get the necessary information for both media, and for the `thumbnail` data for videos, the photos are defaulted to `NULL`. https://linear.app/comm/issue/ENG-2873/create-a-function-to-query-for-all-uploads-from-a-provided-thread Depends on D6482

We create a function in `upload-fetchers` to query the database for uploads given a specific threadID. The `filename NOT LIKE 'thumb%'` is used to filter out scenarios where when a video is uploadedquery uses a UNION to join two select statements, one for the photos and one for the videos. We get the necessary information for both media, so is a and for the `thumbnail` data for videos, and we don't want to pull a static thumbnail for the videothe photos are defaulted to `NULL`. https://linear.app/comm/issue/ENG-2873/create-a-function-to-query-for-all-uploads-from-a-provided-thread The `any` types on the function are resolved in the immediate next diff as I introduce the appropriate types in that diff (D6531). Depends on D6482