rust - 将 Option 与 Diesel 的 Insertable 特性结合使用

Question

我有以下模型:

use diesel::prelude::*;

use crate::schema::category;

#[derive(Debug, Identifiable, Queryable)]
#[table_name = "category"]
pub struct Category {
    pub id: i64,
    pub name: String,
    pub description: String,
    pub parent_id: Option<i64>,
}

#[derive(Debug, Insertable)]
#[table_name = "category"]
pub struct NewCategory<'a> {
    pub name: &'a str,
    pub description: &'a str,
    pub parent_id: &'a Option<i64>,
}

和 schema.rs:

table! {
    category (id) {
        id -> Integer,
        name -> Text,
        description -> Text,
        parent_id -> Nullable<Integer>,
    }
}

但是，当我尝试编译这段代码时，出现以下错误:

error[E0277]: the trait bound `std::option::Option<i64>: diesel::Expression` is not satisfied
  --> src/models/categories.rs:15:17
   |
15 | #[derive(Debug, Insertable)]
   |                 ^^^^^^^^^^ the trait `diesel::Expression` is not implemented for `std::option::Option<i64>`
   |
   = note: required because of the requirements on the impl of `diesel::Expression` for `&std::option::Option<i64>`

error[E0277]: the trait bound `std::option::Option<i64>: diesel::Expression` is not satisfied
  --> src/models/categories.rs:15:17
   |
15 | #[derive(Debug, Insertable)]
   |                 ^^^^^^^^^^ the trait `diesel::Expression` is not implemented for `std::option::Option<i64>`
   |
   = note: required because of the requirements on the impl of `diesel::Expression` for `&'a std::option::Option<i64>`

我需要什么才能让它工作？我环顾四周，但我发现的唯一类似问题是有人在他们的表格中有超过 16 列，而这里不是这种情况。

Answer 1

修改pub parent_id: &'a Option<i64>放置 &'a选项内部:pub parent_id: Option<&'a i64> .