這是我的作業環境：
- 生銹 - 1.57.0
- 貨物 - 1.57.0
- 柴油 - 1.4.8 具有 mysql 功能
這是專案的結構：
- src
- lib.rs
quant
- mod.rs
common
- mod.rs
persistence
- mod.rs
- database.rs
- model.rs
- schema.rs
Cargo.toml
diesel.toml
這是lib.rs：
#[macro_use]
extern crate diesel;
pub mod quant;
這是model.rs：
use diesel::Queryable;
#[derive(Queryable)]
pub struct NetWorthModel {
pub fund_code: String,
pub date: String,
pub create_time: i64,
pub update_time: i64,
pub payload: String,
}
這是schema.rs：
use diesel::table;
table! {
tb_net_worth(fund_code) {
fund_code -> VarChar,
date -> Date,
create_time -> BigInt,
update_time -> BigInt,
payload -> Text,
}
}
這是database.rs：
use crate::quant::common::persistence::model::NetWorthModel;
use diesel::mysql::MysqlConnection;
use diesel::sql_types;
use diesel::Connection;
use chrono;
type YaDate = chrono::prelude::Date<chrono::prelude::Local>;
pub struct Database {
connection: MysqlConnection,
}
impl Database {
const ASC: &'static str = "ASC";
const DESC: &'static str = "DESC";
pub fn get() -> Database {
Database::new()
}
pub fn shutdown() {}
fn new() -> Database {
use crate::quant::config;
let engine = "mysql";
let username = "root";
let password = "123456";
let host = "localhost";
let port = 3306;
let db = "test";
let url = format!(
"{}://{}:{}@{}:{}/{}",
engine, username, password, host, port, db
);
let connection = MysqlConnection::establish(&url)
.expect(&format!("Failed to connect database:{}-{}", engine, db));
Database { connection }
}
pub fn paged_query_net_worth(
&mut self,
fund_code: &str,
order_by: &str,
start_date: YaDate,
end_date: YaDate,
page_index: i32,
page_size: i32,
) -> Vec<NetWorthModel> {
use super::schema::tb_net_worth::dsl;
let query = dsl::tb_net_worth
.filter(dsl::fund_code.eq(fund_code))
.filter(dsl::date.ge(start_date))
.filter(dsl::date.lt(end_date));
let query = if order_by == Database::ASC {
query.order(dsl::date)
} else {
query.order(dsl::date.desc())
};
query
.limit(page_size)
.offset(page_index * page_size)
.load::<NetWorthModel>(&self.connection)
.unwrap()
}
}
這是編譯錯誤：
error[E0599]: the method `filter` exists for struct `table`, but its trait bounds were not satisfied
--> src/quant/common/persistence/database.rs:74:14
|
74 | .filter(dsl::fund_code.eq(fund_code))
| ^^^^^^ method cannot be called on `table` due to unsatisfied trait bounds
|
::: src/quant/common/persistence/schema.rs:5:1
|
5 | / table! {
6 | | tb_net_worth(fund_code) {
7 | | fund_code -> VarChar,
8 | | date -> Date,
... |
12 | | }
13 | | }
| | -
| | |
| |_method `filter` not found for this
| doesn't satisfy `table: Iterator`
|
= note: the following trait bounds were not satisfied:
`table: Iterator`
which is required by `&mut table: Iterator`
note: the following trait must be implemented
--> /Users/rolin/.rustup/toolchains/stable-x86_64-apple-darwin/lib/rustlib/src/rust/library/core/src/iter/traits/iterator.rs:55:1
|
55 | / pub trait Iterator {
56 | | /// The type of the elements being iterated over.
57 | | #[stable(feature = "rust1", since = "1.0.0")]
58 | | type Item;
... |
3457 | | }
3458 | | }
| |_^
= help: items from traits can only be used if the trait is in scope
help: the following traits are implemented but not in scope; perhaps add a `use` for one of them:
|
3 | use std::iter::Iterator;
|
3 | use crate::diesel::query_dsl::filter_dsl::FilterDsl;
|
3 | use crate::diesel::QueryDsl;
|
3 | use log4rs::filter::Filter;
|
error[E0599]: the method `eq` exists for struct `columns::fund_code`, but its trait bounds were not satisfied
--> src/quant/common/persistence/database.rs:74:36
|
74 | .filter(dsl::fund_code.eq(fund_code))
| ^^ method cannot be called on `columns::fund_code` due to unsatisfied trait bounds
|
::: src/quant/common/persistence/schema.rs:5:1
|
5 | / table! {
6 | | tb_net_worth(fund_code) {
7 | | fund_code -> VarChar,
8 | | date -> Date,
... |
12 | | }
13 | | }
| | -
| | |
| |_method `eq` not found for this
| doesn't satisfy `columns::fund_code: Iterator`
|
= note: the following trait bounds were not satisfied:
`columns::fund_code: Iterator`
which is required by `&mut columns::fund_code: Iterator`
note: the following trait must be implemented
--> /Users/rolin/.rustup/toolchains/stable-x86_64-apple-darwin/lib/rustlib/src/rust/library/core/src/iter/traits/iterator.rs:55:1
|
55 | / pub trait Iterator {
56 | | /// The type of the elements being iterated over.
57 | | #[stable(feature = "rust1", since = "1.0.0")]
58 | | type Item;
... |
3457 | | }
3458 | | }
| |_^
= help: items from traits can only be used if the trait is in scope
help: the following trait is implemented but not in scope; perhaps add a `use` for it:
|
3 | use crate::diesel::ExpressionMethods;
|
error[E0599]: the method `ge` exists for struct `columns::date`, but its trait bounds were not satisfied
--> src/quant/common/persistence/database.rs:75:31
|
75 | .filter(dsl::date.ge(start_date))
| ^^ method cannot be called on `columns::date` due to unsatisfied trait bounds
|
::: src/quant/common/persistence/schema.rs:5:1
|
5 | / table! {
6 | | tb_net_worth(fund_code) {
7 | | fund_code -> VarChar,
8 | | date -> Date,
... |
12 | | }
13 | | }
| | -
| | |
| |_method `ge` not found for this
| doesn't satisfy `columns::date: Iterator`
|
= note: the following trait bounds were not satisfied:
`columns::date: Iterator`
which is required by `&mut columns::date: Iterator`
note: the following trait must be implemented
--> /Users/rolin/.rustup/toolchains/stable-x86_64-apple-darwin/lib/rustlib/src/rust/library/core/src/iter/traits/iterator.rs:55:1
|
55 | / pub trait Iterator {
56 | | /// The type of the elements being iterated over.
57 | | #[stable(feature = "rust1", since = "1.0.0")]
58 | | type Item;
... |
3457 | | }
3458 | | }
| |_^
= help: items from traits can only be used if the trait is in scope
help: the following trait is implemented but not in scope; perhaps add a `use` for it:
|
3 | use crate::diesel::ExpressionMethods;
|
error[E0599]: the method `lt` exists for struct `columns::date`, but its trait bounds were not satisfied
--> src/quant/common/persistence/database.rs:76:31
|
76 | .filter(dsl::date.lt(end_date));
| ^^ method cannot be called on `columns::date` due to unsatisfied trait bounds
|
::: src/quant/common/persistence/schema.rs:5:1
|
5 | / table! {
6 | | tb_net_worth(fund_code) {
7 | | fund_code -> VarChar,
8 | | date -> Date,
... |
12 | | }
13 | | }
| | -
| | |
| |_method `lt` not found for this
| doesn't satisfy `columns::date: Iterator`
|
= note: the following trait bounds were not satisfied:
`columns::date: Iterator`
which is required by `&mut columns::date: Iterator`
note: the following trait must be implemented
--> /Users/rolin/.rustup/toolchains/stable-x86_64-apple-darwin/lib/rustlib/src/rust/library/core/src/iter/traits/iterator.rs:55:1
|
55 | / pub trait Iterator {
56 | | /// The type of the elements being iterated over.
57 | | #[stable(feature = "rust1", since = "1.0.0")]
58 | | type Item;
... |
3457 | | }
3458 | | }
| |_^
= help: items from traits can only be used if the trait is in scope
help: the following trait is implemented but not in scope; perhaps add a `use` for it:
|
3 | use crate::diesel::ExpressionMethods;
|
error[E0599]: no method named `desc` found for struct `columns::date` in the current scope
--> src/quant/common/persistence/database.rs:80:35
|
80 | query.order(dsl::date.desc())
| ^^^^ method not found in `columns::date`
|
::: /Users/rolin/.cargo/registry/src/github.com-1ecc6299db9ec823/diesel-1.4.8/src/expression_methods/global_expression_methods.rs:397:8
|
397 | fn desc(self) -> Desc<Self> {
| ---- the method is available for `columns::date` here
|
::: src/quant/common/persistence/schema.rs:5:1
|
5 | / table! {
6 | | tb_net_worth(fund_code) {
7 | | fund_code -> VarChar,
8 | | date -> Date,
... |
12 | | }
13 | | }
| |_- method `desc` not found for this
|
= help: items from traits can only be used if the trait is in scope
help: the following trait is implemented but not in scope; perhaps add a `use` for it:
|
3 | use crate::diesel::ExpressionMethods;
|
For more information about this error, try `rustc --explain E0599`.
你能幫我嗎？
uj5u.com熱心網友回復：
錯誤訊息具有幫助注釋，可以將您推向正確的方向：
以下特征已實作但不在范圍內
柴油機提供的功能filter, eq, ge, lt, 和desc是通過 trait 實作的。并且必須將特征納入使用范圍。您需要幾個最常見的柴油特性：QueryDsl和ExpressionMethods。
因此，將這些添加到您的匯入中：
use diesel::expression_methods::ExpressionMethods;
use diesel::query_dsl::QueryDsl;
或者，如果您的檔案非常重柴油，請考慮使用通配符匯入許多最常見型別的柴油的前奏：
use diesel::prelude::*;
提到的錯誤Iterator是一個紅鯡魚。Iterator默認情況下，該特征始終在范圍內，它具有具有匹配名稱的函式，并且在&mut T給定T的Iterator.
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/383430.html