神奇的option, uuid

 

business_model_id, transaction_type_id 这2个字段在数据库都是not null,

 

 

pub async fn get_model_relation_transaction_types() -> Result<Vec<(Uuid, Uuid)>, sqlx::Error> {let pool = db::pool();let relations = sqlx::query!(r#"SELECT business_model_id as "business_model_id!",transaction_type_id as "transaction_type_id!"FROM biz_mdoel_relate_transaction_typeWHERE deleted = false"#).fetch_all(pool).await?.into_iter().map(|r| (r.business_model_id, r.transaction_type_id)).collect();Ok(relations)
}

　　

 

这样写, 错误.

pub async fn get_model_relation_transaction_types() -> Result<Vec<(Uuid, Uuid)>, sqlx::Error> {let pool = db::pool();let relations = sqlx::query!(r#"SELECT business_model_id, transaction_type_idFROM biz_mdoel_relate_transaction_typeWHERE deleted = false"#).fetch_all(pool).await?.into_iter().map(|r| (r.business_model_id, r.transaction_type_id)).collect();Ok(relations)
}

　　

这样写也错误.

pub async fn get_model_relation_transaction_types() -> Result<Vec<(Uuid, Uuid)>, sqlx::Error> {let pool = db::pool();let relations = sqlx::query!(r#"SELECT business_model_id, transaction_type_idFROM biz_mdoel_relate_transaction_typeWHERE deleted = false"#).fetch_all(pool).await?.into_iter().map(|r| (r.business_model_id.expect("business_model_id should not be NULL"),r.transaction_type_id.expect("transaction_type_id should not be NULL"))).collect();Ok(relations)
}