Struct sqlx_model::Select
source · pub struct Select<DB>where
DB: Database,{
pub table_name: TableName,
pub table_field: TableFields,
pub table_pk: TableFields,
/* private fields */
}
Expand description
查询操作
Fields§
§table_name: TableName
§table_field: TableFields
§table_pk: TableFields
Implementations§
source§impl<DB> Select<DB>where
DB: Database,
impl<DB> Select<DB>where
DB: Database,
pub fn new(
table_name: TableName,
table_field: TableFields,
table_pk: TableFields
) -> Self
pub fn type_new<T>() -> Selfwhere
T: ModelTableField<DB> + ModelTableName,
sourcepub async fn fetch_one_by_scalar_pk<'c, M, PT, E>(
&self,
pk_scalar: PT,
executor: E
) -> Result<M, Error>where
for<'q> PT: 'q + Send + Encode<'q, DB> + Type<DB>,
for<'r> M: FromRow<'r, DB::Row> + Send + Unpin + ModelTableField<DB>,
for<'n> <DB as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, DB>,
E: Executor<'c, Database = DB>,
pub async fn fetch_one_by_scalar_pk<'c, M, PT, E>(
&self,
pk_scalar: PT,
executor: E
) -> Result<M, Error>where
for<'q> PT: 'q + Send + Encode<'q, DB> + Type<DB>,
for<'r> M: FromRow<'r, DB::Row> + Send + Unpin + ModelTableField<DB>,
for<'n> <DB as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, DB>,
E: Executor<'c, Database = DB>,
非联合主键的表通过主键值查找某记录 @field_name 需要获取的字段名 @pk_scalar 主键值 @executor Executor M 为 Model 类型
sourcepub async fn fetch_one_scalar_by_scalar_pk<'c, M, PT, E>(
&self,
field_name: &str,
pk_scalar: PT,
executor: E
) -> Result<M, Error>where
for<'q> PT: 'q + Send + Encode<'q, DB> + Type<DB>,
(M,): for<'r> FromRow<'r, DB::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <DB as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, DB>,
E: Executor<'c, Database = DB>,
pub async fn fetch_one_scalar_by_scalar_pk<'c, M, PT, E>(
&self,
field_name: &str,
pk_scalar: PT,
executor: E
) -> Result<M, Error>where
for<'q> PT: 'q + Send + Encode<'q, DB> + Type<DB>,
(M,): for<'r> FromRow<'r, DB::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <DB as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, DB>,
E: Executor<'c, Database = DB>,
非联合主键的表通过主键值查找某字段值 @field_name 需要获取的字段名 @pk_scalar 主键值 @executor Executor M 为 @field_name 字段类型
sourcepub async fn reload<'c, M, E>(&self, val: &M, executor: E) -> Result<M, Error>where
M: for<'r> FromRow<'r, DB::Row> + Send + Unpin + ModelTableField<DB>,
for<'n> <DB as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, DB>,
E: Executor<'c, Database = DB>,
pub async fn reload<'c, M, E>(&self, val: &M, executor: E) -> Result<M, Error>where
M: for<'r> FromRow<'r, DB::Row> + Send + Unpin + ModelTableField<DB>,
for<'n> <DB as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, DB>,
E: Executor<'c, Database = DB>,
从DB中重新加载Model里值 @val Model 变量 @executor Executor
source§impl Select<MySql>
impl Select<MySql>
sourcepub async fn fetch_all_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
for<'r> M: FromRow<'r, <MySql as Database>::Row> + Send + Unpin + ModelTableField<MySql>,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
pub async fn fetch_all_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
for<'r> M: FromRow<'r, <MySql as Database>::Row> + Send + Unpin + ModelTableField<MySql>,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
M 为 Model 类型
source§impl Select<MySql>
impl Select<MySql>
sourcepub async fn fetch_one_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
for<'r> M: FromRow<'r, <MySql as Database>::Row> + Send + Unpin + ModelTableField<MySql>,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
pub async fn fetch_one_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
for<'r> M: FromRow<'r, <MySql as Database>::Row> + Send + Unpin + ModelTableField<MySql>,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
M 为 Model 类型
source§impl Select<Sqlite>
impl Select<Sqlite>
sourcepub async fn fetch_all_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
for<'r> M: FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin + ModelTableField<Sqlite>,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
pub async fn fetch_all_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
for<'r> M: FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin + ModelTableField<Sqlite>,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
M 为 Model 类型
source§impl Select<Sqlite>
impl Select<Sqlite>
sourcepub async fn fetch_one_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
for<'r> M: FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin + ModelTableField<Sqlite>,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
pub async fn fetch_one_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
for<'r> M: FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin + ModelTableField<Sqlite>,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
M 为 Model 类型
source§impl Select<Postgres>
impl Select<Postgres>
sourcepub async fn fetch_all_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
for<'r> M: FromRow<'r, <Postgres as Database>::Row> + Send + Unpin + ModelTableField<Postgres>,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
pub async fn fetch_all_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
for<'r> M: FromRow<'r, <Postgres as Database>::Row> + Send + Unpin + ModelTableField<Postgres>,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
M 为 Model 类型
source§impl Select<Postgres>
impl Select<Postgres>
sourcepub async fn fetch_one_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
for<'r> M: FromRow<'r, <Postgres as Database>::Row> + Send + Unpin + ModelTableField<Postgres>,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
pub async fn fetch_one_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
for<'r> M: FromRow<'r, <Postgres as Database>::Row> + Send + Unpin + ModelTableField<Postgres>,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
M 为 Model 类型
source§impl Select<Mssql>
impl Select<Mssql>
sourcepub async fn fetch_all_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
for<'r> M: FromRow<'r, <Mssql as Database>::Row> + Send + Unpin + ModelTableField<Mssql>,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
pub async fn fetch_all_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
for<'r> M: FromRow<'r, <Mssql as Database>::Row> + Send + Unpin + ModelTableField<Mssql>,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
M 为 Model 类型
source§impl Select<Mssql>
impl Select<Mssql>
sourcepub async fn fetch_one_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
for<'r> M: FromRow<'r, <Mssql as Database>::Row> + Send + Unpin + ModelTableField<Mssql>,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
pub async fn fetch_one_by_where<'c, M, E>(
&self,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
for<'r> M: FromRow<'r, <Mssql as Database>::Row> + Send + Unpin + ModelTableField<Mssql>,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
M 为 Model 类型
source§impl Select<MySql>
impl Select<MySql>
sourcepub async fn fetch_all_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryAs<'t, MySql, M, <MySql as HasArguments<'_>>::Arguments>, &'t Select<MySql>) -> QueryAs<'t, MySql, M, <MySql as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <MySql as Database>::Row> + Send + Unpin + ModelTableField<MySql>,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
pub async fn fetch_all_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryAs<'t, MySql, M, <MySql as HasArguments<'_>>::Arguments>, &'t Select<MySql>) -> QueryAs<'t, MySql, M, <MySql as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <MySql as Database>::Row> + Send + Unpin + ModelTableField<MySql>,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
M 为 Model 类型
source§impl Select<MySql>
impl Select<MySql>
sourcepub async fn fetch_one_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryAs<'t, MySql, M, <MySql as HasArguments<'_>>::Arguments>, &'t Select<MySql>) -> QueryAs<'t, MySql, M, <MySql as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <MySql as Database>::Row> + Send + Unpin + ModelTableField<MySql>,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
pub async fn fetch_one_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryAs<'t, MySql, M, <MySql as HasArguments<'_>>::Arguments>, &'t Select<MySql>) -> QueryAs<'t, MySql, M, <MySql as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <MySql as Database>::Row> + Send + Unpin + ModelTableField<MySql>,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
M 为 Model 类型
source§impl Select<Sqlite>
impl Select<Sqlite>
sourcepub async fn fetch_all_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryAs<'t, Sqlite, M, <Sqlite as HasArguments<'_>>::Arguments>, &'t Select<Sqlite>) -> QueryAs<'t, Sqlite, M, <Sqlite as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin + ModelTableField<Sqlite>,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
pub async fn fetch_all_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryAs<'t, Sqlite, M, <Sqlite as HasArguments<'_>>::Arguments>, &'t Select<Sqlite>) -> QueryAs<'t, Sqlite, M, <Sqlite as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin + ModelTableField<Sqlite>,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
M 为 Model 类型
source§impl Select<Sqlite>
impl Select<Sqlite>
sourcepub async fn fetch_one_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryAs<'t, Sqlite, M, <Sqlite as HasArguments<'_>>::Arguments>, &'t Select<Sqlite>) -> QueryAs<'t, Sqlite, M, <Sqlite as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin + ModelTableField<Sqlite>,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
pub async fn fetch_one_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryAs<'t, Sqlite, M, <Sqlite as HasArguments<'_>>::Arguments>, &'t Select<Sqlite>) -> QueryAs<'t, Sqlite, M, <Sqlite as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin + ModelTableField<Sqlite>,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
M 为 Model 类型
source§impl Select<Postgres>
impl Select<Postgres>
sourcepub async fn fetch_all_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryAs<'t, Postgres, M, <Postgres as HasArguments<'_>>::Arguments>, &'t Select<Postgres>) -> QueryAs<'t, Postgres, M, <Postgres as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <Postgres as Database>::Row> + Send + Unpin + ModelTableField<Postgres>,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
pub async fn fetch_all_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryAs<'t, Postgres, M, <Postgres as HasArguments<'_>>::Arguments>, &'t Select<Postgres>) -> QueryAs<'t, Postgres, M, <Postgres as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <Postgres as Database>::Row> + Send + Unpin + ModelTableField<Postgres>,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
M 为 Model 类型
source§impl Select<Postgres>
impl Select<Postgres>
sourcepub async fn fetch_one_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryAs<'t, Postgres, M, <Postgres as HasArguments<'_>>::Arguments>, &'t Select<Postgres>) -> QueryAs<'t, Postgres, M, <Postgres as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <Postgres as Database>::Row> + Send + Unpin + ModelTableField<Postgres>,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
pub async fn fetch_one_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryAs<'t, Postgres, M, <Postgres as HasArguments<'_>>::Arguments>, &'t Select<Postgres>) -> QueryAs<'t, Postgres, M, <Postgres as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <Postgres as Database>::Row> + Send + Unpin + ModelTableField<Postgres>,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
M 为 Model 类型
source§impl Select<Mssql>
impl Select<Mssql>
sourcepub async fn fetch_all_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryAs<'t, Mssql, M, <Mssql as HasArguments<'_>>::Arguments>, &'t Select<Mssql>) -> QueryAs<'t, Mssql, M, <Mssql as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <Mssql as Database>::Row> + Send + Unpin + ModelTableField<Mssql>,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
pub async fn fetch_all_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryAs<'t, Mssql, M, <Mssql as HasArguments<'_>>::Arguments>, &'t Select<Mssql>) -> QueryAs<'t, Mssql, M, <Mssql as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <Mssql as Database>::Row> + Send + Unpin + ModelTableField<Mssql>,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
M 为 Model 类型
source§impl Select<Mssql>
impl Select<Mssql>
sourcepub async fn fetch_one_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryAs<'t, Mssql, M, <Mssql as HasArguments<'_>>::Arguments>, &'t Select<Mssql>) -> QueryAs<'t, Mssql, M, <Mssql as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <Mssql as Database>::Row> + Send + Unpin + ModelTableField<Mssql>,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
pub async fn fetch_one_by_where_call<'c, M, RB, E>(
&self,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryAs<'t, Mssql, M, <Mssql as HasArguments<'_>>::Arguments>, &'t Select<Mssql>) -> QueryAs<'t, Mssql, M, <Mssql as HasArguments<'t>>::Arguments>,
for<'r> M: FromRow<'r, <Mssql as Database>::Row> + Send + Unpin + ModelTableField<Mssql>,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
M 为 Model 类型
source§impl Select<MySql>
impl Select<MySql>
sourcepub async fn fetch_all_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
(M,): for<'r> FromRow<'r, <MySql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
pub async fn fetch_all_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
(M,): for<'r> FromRow<'r, <MySql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
M 为 返回某字段类型
source§impl Select<MySql>
impl Select<MySql>
sourcepub async fn fetch_one_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
(M,): for<'r> FromRow<'r, <MySql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
pub async fn fetch_one_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
(M,): for<'r> FromRow<'r, <MySql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
M 为 返回某字段类型
source§impl Select<Sqlite>
impl Select<Sqlite>
sourcepub async fn fetch_all_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
(M,): for<'r> FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
pub async fn fetch_all_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
(M,): for<'r> FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
M 为 返回某字段类型
source§impl Select<Sqlite>
impl Select<Sqlite>
sourcepub async fn fetch_one_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
(M,): for<'r> FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
pub async fn fetch_one_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
(M,): for<'r> FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
M 为 返回某字段类型
source§impl Select<Postgres>
impl Select<Postgres>
sourcepub async fn fetch_all_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
(M,): for<'r> FromRow<'r, <Postgres as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
pub async fn fetch_all_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
(M,): for<'r> FromRow<'r, <Postgres as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
M 为 返回某字段类型
source§impl Select<Postgres>
impl Select<Postgres>
sourcepub async fn fetch_one_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
(M,): for<'r> FromRow<'r, <Postgres as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
pub async fn fetch_one_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
(M,): for<'r> FromRow<'r, <Postgres as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
M 为 返回某字段类型
source§impl Select<Mssql>
impl Select<Mssql>
sourcepub async fn fetch_all_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
(M,): for<'r> FromRow<'r, <Mssql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
pub async fn fetch_all_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<Vec<M>, Error>where
(M,): for<'r> FromRow<'r, <Mssql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
M 为 返回某字段类型
source§impl Select<Mssql>
impl Select<Mssql>
sourcepub async fn fetch_one_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
(M,): for<'r> FromRow<'r, <Mssql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
pub async fn fetch_one_scalar_by_where<'c, M, E>(
&self,
field_name: &str,
where_sql: &WhereOption,
executor: E
) -> Result<M, Error>where
(M,): for<'r> FromRow<'r, <Mssql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
M 为 返回某字段类型
source§impl Select<MySql>
impl Select<MySql>
sourcepub async fn fetch_all_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, MySql, M, <MySql as HasArguments<'_>>::Arguments>, &'t Select<MySql>) -> QueryScalar<'t, MySql, M, <MySql as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <MySql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
pub async fn fetch_all_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, MySql, M, <MySql as HasArguments<'_>>::Arguments>, &'t Select<MySql>) -> QueryScalar<'t, MySql, M, <MySql as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <MySql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
M 为 返回某字段类型
source§impl Select<MySql>
impl Select<MySql>
sourcepub async fn fetch_one_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, MySql, M, <MySql as HasArguments<'_>>::Arguments>, &'t Select<MySql>) -> QueryScalar<'t, MySql, M, <MySql as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <MySql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
pub async fn fetch_one_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, MySql, M, <MySql as HasArguments<'_>>::Arguments>, &'t Select<MySql>) -> QueryScalar<'t, MySql, M, <MySql as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <MySql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <MySql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, MySql>,
E: Executor<'c, Database = MySql>,
M 为 返回某字段类型
source§impl Select<Sqlite>
impl Select<Sqlite>
sourcepub async fn fetch_all_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, Sqlite, M, <Sqlite as HasArguments<'_>>::Arguments>, &'t Select<Sqlite>) -> QueryScalar<'t, Sqlite, M, <Sqlite as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
pub async fn fetch_all_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, Sqlite, M, <Sqlite as HasArguments<'_>>::Arguments>, &'t Select<Sqlite>) -> QueryScalar<'t, Sqlite, M, <Sqlite as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
M 为 返回某字段类型
source§impl Select<Sqlite>
impl Select<Sqlite>
sourcepub async fn fetch_one_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, Sqlite, M, <Sqlite as HasArguments<'_>>::Arguments>, &'t Select<Sqlite>) -> QueryScalar<'t, Sqlite, M, <Sqlite as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
pub async fn fetch_one_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, Sqlite, M, <Sqlite as HasArguments<'_>>::Arguments>, &'t Select<Sqlite>) -> QueryScalar<'t, Sqlite, M, <Sqlite as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <Sqlite as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Sqlite as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Sqlite>,
E: Executor<'c, Database = Sqlite>,
M 为 返回某字段类型
source§impl Select<Postgres>
impl Select<Postgres>
sourcepub async fn fetch_all_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, Postgres, M, <Postgres as HasArguments<'_>>::Arguments>, &'t Select<Postgres>) -> QueryScalar<'t, Postgres, M, <Postgres as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <Postgres as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
pub async fn fetch_all_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, Postgres, M, <Postgres as HasArguments<'_>>::Arguments>, &'t Select<Postgres>) -> QueryScalar<'t, Postgres, M, <Postgres as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <Postgres as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
M 为 返回某字段类型
source§impl Select<Postgres>
impl Select<Postgres>
sourcepub async fn fetch_one_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, Postgres, M, <Postgres as HasArguments<'_>>::Arguments>, &'t Select<Postgres>) -> QueryScalar<'t, Postgres, M, <Postgres as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <Postgres as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
pub async fn fetch_one_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, Postgres, M, <Postgres as HasArguments<'_>>::Arguments>, &'t Select<Postgres>) -> QueryScalar<'t, Postgres, M, <Postgres as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <Postgres as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Postgres as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Postgres>,
E: Executor<'c, Database = Postgres>,
M 为 返回某字段类型
source§impl Select<Mssql>
impl Select<Mssql>
sourcepub async fn fetch_all_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, Mssql, M, <Mssql as HasArguments<'_>>::Arguments>, &'t Select<Mssql>) -> QueryScalar<'t, Mssql, M, <Mssql as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <Mssql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
pub async fn fetch_all_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<Vec<M>, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, Mssql, M, <Mssql as HasArguments<'_>>::Arguments>, &'t Select<Mssql>) -> QueryScalar<'t, Mssql, M, <Mssql as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <Mssql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
M 为 返回某字段类型
source§impl Select<Mssql>
impl Select<Mssql>
sourcepub async fn fetch_one_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, Mssql, M, <Mssql as HasArguments<'_>>::Arguments>, &'t Select<Mssql>) -> QueryScalar<'t, Mssql, M, <Mssql as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <Mssql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
pub async fn fetch_one_scalar_by_where_call<'c, M, RB, E>(
&self,
field_name: &str,
where_sql: &str,
where_bind: RB,
executor: E
) -> Result<M, Error>where
for<'t> RB: FnOnce(QueryScalar<'t, Mssql, M, <Mssql as HasArguments<'_>>::Arguments>, &'t Select<Mssql>) -> QueryScalar<'t, Mssql, M, <Mssql as HasArguments<'t>>::Arguments>,
(M,): for<'r> FromRow<'r, <Mssql as Database>::Row> + Send + Unpin,
M: Send + Unpin,
for<'n> <Mssql as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, Mssql>,
E: Executor<'c, Database = Mssql>,
M 为 返回某字段类型