我有文章,存储在article表中。有些文章有一张或多张照片,存储在指定了article_id的photo表中。某些照片已“停用”(photo.active = '0'),不应检索。
我试图为主页获得文章,并为每篇文章提供一张或多张照片。如下所示:
SELECT article.id, article.date, article.title, photo.filename_small
FROM (article)
LEFT JOIN photo ON photo.article_id=article.id
WHERE photo.active = '1'
我的应用程序在添加了多张照片后崩溃了:
import SwiftUI
import PhotosUI
import CoreTransferable
struct ContentView: View {
@State var imageData: Data?
@State var selectedItems: [PhotosPickerItem] = []
var body: some View {
VStack {
if let imageData, let uiImage = UIIma