mutation InsertProductOxelaWithImage(
  $handle: String!
  $title: String!
  $description: String
  $availableForSale: Boolean!
  $productType: String
  $imageUrl: String!
  $imageAltText: String
  $imageWidth: Int!
  $imageHeight: Int!
  $featured: Boolean!
  $displayPosition: Int!
) @auth(level: PUBLIC) @transaction {
  # Étape 0 : s'assurer que le handle n'existe pas déjà
  query
    @check(
      expr: "response.query.products.size() == 0"
      message: "A product with this handle already exists"
    )
    @redact {
    products(where: { handle: { eq: $handle } }) {
      id
    }
  }

  # Étape 1 : création du produit
  product: product_insert(
    data: {
      handle: $handle
      title: $title
      description: $description
      productType: $productType
      availableForSale: $availableForSale
    }
  ) @check(expr: "this != null", message: "Product creation failed")

  # Étape 2 : création de l'image
  productImage_insert(
    data: {
      productId_expr: "response.product.id"
      url: $imageUrl
      altText: $imageAltText
      width: $imageWidth
      height: $imageHeight
      featured: $featured
      displayPosition: $displayPosition
    }
  ) @check(expr: "this != null", message: "Image creation failed")

  # # Étape 3 : mise à jour du produit avec l'image en vedette
  product_update(
    key: { id_expr: "response.product.id" }
    data: { featuredImageId_expr: "response.productImage_insert.id" }
  ) @check(expr: "this != null", message: "Failed to link featured image")
}

type SEO @table {
  id: UUID! @default(expr: "uuidV4()")
  title: String!
  description: String!
  keywords: String!
}

type ProductImage @table {
  id: UUID! @default(expr: "uuidV4()")
  product: Product! @unique

  url: String! @col(name: "url", dataType: "text")
  altText: String @col(name: "alt_text", dataType: "text")
  width: Int! @col(name: "width", dataType: "int")
  height: Int! @col(name: "height", dataType: "int")

  featured: Boolean! @col(name: "featured", dataType: "boolean")
  displayPosition: Int! @col(name: "display_position", dataType: "int")
}

# Product
type Product @table {
  id: UUID! @default(expr: "uuidV4()")
  featuredImage: ProductImage
  seo: SEO

  handle: String! @col(name: "handle", dataType: "varchar(100)") @unique
  title: String! @col(name: "title", dataType: "varchar(100)")
  description: String @col(name: "description", dataType: "text")
  # price ? NOPE
  productType: String @col(name: "product_type", dataType: "varchar(100)")
  availableForSale: Boolean!
    @col(name: "available_for_sale", dataType: "boolean")

  createdAt: Date! @default(expr: "request.time")
  updatedAt: Date! @default(expr: "request.time")
}