我在下面的代码中遇到了困难，我试图为u128创建一个自定义类型U128，Diesel默认情况下没有实现。我的目标是将u128原语存储在Postgresql数据库中，无论是文本格式还是数字格式（最好是数字格式）。

use std::io::Write;
use diesel::{AsExpression, deserialize, FromSqlRow, serialize};
use diesel::deserialize::{FromSql};
use diesel::pg::{Pg};
use diesel::serialize::{IsNull, Output, ToSql};
use diesel::sql_types::{Text};

#[derive(AsExpression, FromSqlRow, Debug, Clone, Copy)]
#[diesel(sql_type = Text)]
pub struct U128(pub u128);

impl ToSql<Text, Pg> for U128 {
    fn to_sql<'b>(&self, out: &mut Output<'b, '_, Pg>) -> serialize::Result {
        write!(out, "{}", self.0.to_string())?;
        Ok(IsNull::No)
    }
}

impl FromSql<Text, Pg> for U128 {
    fn from_sql(bytes: Option<&[u8]>) -> deserialize::Result<Self> {
        let s = String::from_utf8_lossy(bytes.as_bytes());
        Ok(U128(s.parse()?))
    }
}

字符串
这是我创建的柴油结构。

#[derive(Queryable, Selectable)]
#[diesel(table_name = crate::schema::balance)]
#[diesel(check_for_backend(diesel::pg::Pg))]
pub struct Balance {
    pub id: i32,
    pub account_name: String,
    pub balance: u128,
}

型
这是我尝试在diesel结构中使用u128时遇到的编译错误。

error[E0277]: the trait bound `u128: diesel::Queryable<diesel::sql_types::Text, Pg>` is not satisfied
   --> src\models.rs:117:27
    |
117 |     pub balance: u128,
    |                  ^^^^ the trait `diesel::Queryable<diesel::sql_types::Text, Pg>` is not implemented for `u128`
    |
    = help: the following other types implement trait `diesel::Queryable<ST, DB>`:
              i8
              i16
              i32
              i64
              u8
              u16
              u32
              u64
            and 2 others
    = note: required for `u128` to implement `FromSqlRow<diesel::sql_types::Text, Pg>`
    = help: see issue #48214

型