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: TableNametable_field: TableFieldstable_pk: TableFields

Implementations

source

impl<DB> Select<DB> where
DB: Database,

source

pub fn new(
    table_name: TableName,
    table_field: TableFields,
    table_pk: TableFields
) -> Self

source

pub fn type_new<T>() -> Self where
T: ModelTableField<DB> + ModelTableName,

source

pub async fn fetch_one_by_sql<'c, M, SQ>(
 &self,
 sql_call: SQ,
 pool: &'c Pool<DB>
) -> Result<M, Error> where
 SQ: FnOnce(&Select<DB>) -> String,
 M: for<'r> FromRow<'r, DB::Row> + Send + Unpin,
 for<'n> <DB as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, DB>,
 &'c Pool<DB>: Executor<'c, Database = DB>,

source

pub async fn fetch_all_by_sql<'c, M, SQ>(
 &self,
 sql_call: SQ,
 pool: &'c Pool<DB>
) -> Result<Vec<M>, Error> where
 SQ: FnOnce(&Select<DB>) -> String,
 M: for<'r> FromRow<'r, DB::Row> + Send + Unpin,
 for<'n> <DB as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, DB>,
 &'c Pool<DB>: Executor<'c, Database = DB>,

source

pub async fn fetch_one_by_sql_call<'c, M, SQ, RB>(
 &self,
 sql_call: SQ,
 bind_call: RB,
 pool: &'c Pool<DB>
) -> Result<M, Error> where
 SQ: FnOnce(&Select<DB>) -> String,
 RB: for<'t> FnOnce(QueryAs<'t, DB, M, <DB as HasArguments<'_>>::Arguments>, &'t Select<DB>) -> QueryAs<'t, DB, M, <DB as HasArguments<'t>>::Arguments>,
 M: for<'r> FromRow<'r, DB::Row> + Send + Unpin,
 for<'n> <DB as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, DB>,
 &'c Pool<DB>: Executor<'c, Database = DB>,

source

pub async fn fetch_all_by_sql_call<'c, M, SQ, RB>(
 &self,
 sql_call: SQ,
 bind_call: RB,
 pool: &'c Pool<DB>
) -> Result<Vec<M>, Error> where
 SQ: FnOnce(&Select<DB>) -> String,
 RB: for<'t> FnOnce(QueryAs<'t, DB, M, <DB as HasArguments<'_>>::Arguments>, &'t Select<DB>) -> QueryAs<'t, DB, M, <DB as HasArguments<'t>>::Arguments>,
 M: for<'r> FromRow<'r, DB::Row> + Send + Unpin,
 for<'n> <DB as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, DB>,
 &'c Pool<DB>: Executor<'c, Database = DB>,

source

pub async fn fetch_one_scalar_by_sql<'c, M, SQ>(
 &self,
 sql_call: SQ,
 pool: &'c Pool<DB>
) -> Result<M, Error> where
 SQ: FnOnce(&Select<DB>) -> String,
 (M,): for<'r> FromRow<'r, DB::Row> + Send + Unpin,
 M: Send + Unpin,
 for<'n> <DB as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, DB>,
 &'c Pool<DB>: Executor<'c, Database = DB>,

M 为返回某字段类型

source

pub async fn fetch_all_scalar_by_sql<'c, M, SQ>(
 &self,
 sql_call: SQ,
 pool: &'c Pool<DB>
) -> Result<Vec<M>, Error> where
 SQ: FnOnce(&Select<DB>) -> String,
 (M,): for<'r> FromRow<'r, DB::Row> + Send + Unpin,
 M: Send + Unpin,
 for<'n> <DB as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, DB>,
 &'c Pool<DB>: Executor<'c, Database = DB>,

M 为返回某字段类型

source

pub async fn fetch_one_scalar_by_sql_call<'c, M, SQ, RB>(
 &self,
 sql_call: SQ,
 bind_call: RB,
 pool: &'c Pool<DB>
) -> Result<M, Error> where
 SQ: FnOnce(&Select<DB>) -> String,
 for<'t> RB: FnOnce(QueryScalar<'t, DB, M, <DB as HasArguments<'_>>::Arguments>, &'t Select<DB>) -> QueryScalar<'t, DB, M, <DB as HasArguments<'t>>::Arguments>,
 (M,): for<'r> FromRow<'r, DB::Row> + Send + Unpin,
 M: Send + Unpin,
 for<'n> <DB as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, DB>,
 &'c Pool<DB>: Executor<'c, Database = DB>,

M 为 Model 类型

source

pub async fn fetch_all_scalar_by_sql_call<'c, M, SQ, RB>(
 &self,
 sql_call: SQ,
 bind_call: RB,
 pool: &'c Pool<DB>
) -> Result<Vec<M>, Error> where
 SQ: FnOnce(&Select<DB>) -> String,
 for<'t> RB: FnOnce(QueryScalar<'t, DB, M, <DB as HasArguments<'_>>::Arguments>, &'t Select<DB>) -> QueryScalar<'t, DB, M, <DB as HasArguments<'t>>::Arguments>,
 (M,): for<'r> FromRow<'r, DB::Row> + Send + Unpin,
 M: Send + Unpin,
 for<'n> <DB as HasArguments<'n>>::Arguments: Arguments<'n> + IntoArguments<'n, DB>,
 &'c Pool<DB>: Executor<'c, Database = DB>,

M 为 Model 类型

source

pub async fn fetch_one_by_scalar_pk<'c, M, PT>(
 &self,
 pk_scalar: PT,
 pool: &'c Pool<DB>
) -> 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>,
 &'c Pool<DB>: Executor<'c, Database = DB>,

非联合主键的表通过主键值查找某记录 @field_name 需要获取的字段名 @pk_scalar 主键值 @pool DB连接 M 为 Model 类型

source

pub async fn fetch_one_scalar_by_scalar_pk<'c, M, PT>(
 &self,
 field_name: &str,
 pk_scalar: PT,
 pool: &'c Pool<DB>
) -> 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>,
 &'c Pool<DB>: Executor<'c, Database = DB>,

非联合主键的表通过主键值查找某字段值 @field_name 需要获取的字段名 @pk_scalar 主键值 @pool DB连接 M 为 @field_name 字段类型

source

pub async fn reload<'c, M>(
 &self,
 val: &M,
 pool: &'c Pool<DB>
) -> 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>,
 &'c Pool<DB>: Executor<'c, Database = DB>,

从DB中重新加载Model里值 @val Model 变量 @pool DB连接

source

impl Select<MySql>

source

pub async fn fetch_all_by_where<'c, M>(
 &self,
 where_sql: Option<String>,
 pool: &'c Pool<MySql>
) -> 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>,
 &'c Pool<MySql>: Executor<'c, Database = MySql>,

M 为 Model 类型

source

impl Select<MySql>

source

pub async fn fetch_one_by_where<'c, M>(
 &self,
 where_sql: Option<String>,
 pool: &'c Pool<MySql>
) -> 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>,
 &'c Pool<MySql>: Executor<'c, Database = MySql>,

M 为 Model 类型

source

impl Select<Sqlite>

source

pub async fn fetch_all_by_where<'c, M>(
 &self,
 where_sql: Option<String>,
 pool: &'c Pool<Sqlite>
) -> 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>,
 &'c Pool<Sqlite>: Executor<'c, Database = Sqlite>,

M 为 Model 类型

source

impl Select<Sqlite>

source

pub async fn fetch_one_by_where<'c, M>(
 &self,
 where_sql: Option<String>,
 pool: &'c Pool<Sqlite>
) -> 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>,
 &'c Pool<Sqlite>: Executor<'c, Database = Sqlite>,

M 为 Model 类型

source

impl Select<Postgres>

source

pub async fn fetch_all_by_where<'c, M>(
 &self,
 where_sql: Option<String>,
 pool: &'c Pool<Postgres>
) -> 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>,
 &'c Pool<Postgres>: Executor<'c, Database = Postgres>,

M 为 Model 类型

source

impl Select<Postgres>

source

pub async fn fetch_one_by_where<'c, M>(
 &self,
 where_sql: Option<String>,
 pool: &'c Pool<Postgres>
) -> 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>,
 &'c Pool<Postgres>: Executor<'c, Database = Postgres>,

M 为 Model 类型

source

impl Select<Mssql>

source

pub async fn fetch_all_by_where<'c, M>(
 &self,
 where_sql: Option<String>,
 pool: &'c Pool<Mssql>
) -> 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>,
 &'c Pool<Mssql>: Executor<'c, Database = Mssql>,

M 为 Model 类型

source

impl Select<Mssql>

source

pub async fn fetch_one_by_where<'c, M>(
 &self,
 where_sql: Option<String>,
 pool: &'c Pool<Mssql>
) -> 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>,
 &'c Pool<Mssql>: Executor<'c, Database = Mssql>,

M 为 Model 类型

source

impl Select<MySql>

source

pub async fn fetch_all_by_where_call<'c, M, RB>(
 &self,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<MySql>
) -> 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>,
 &'c Pool<MySql>: Executor<'c, Database = MySql>,

M 为 Model 类型

source

impl Select<MySql>

source

pub async fn fetch_one_by_where_call<'c, M, RB>(
 &self,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<MySql>
) -> 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>,
 &'c Pool<MySql>: Executor<'c, Database = MySql>,

M 为 Model 类型

source

impl Select<Sqlite>

source

pub async fn fetch_all_by_where_call<'c, M, RB>(
 &self,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<Sqlite>
) -> 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>,
 &'c Pool<Sqlite>: Executor<'c, Database = Sqlite>,

M 为 Model 类型

source

impl Select<Sqlite>

source

pub async fn fetch_one_by_where_call<'c, M, RB>(
 &self,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<Sqlite>
) -> 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>,
 &'c Pool<Sqlite>: Executor<'c, Database = Sqlite>,

M 为 Model 类型

source

impl Select<Postgres>

source

pub async fn fetch_all_by_where_call<'c, M, RB>(
 &self,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<Postgres>
) -> 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>,
 &'c Pool<Postgres>: Executor<'c, Database = Postgres>,

M 为 Model 类型

source

impl Select<Postgres>

source

pub async fn fetch_one_by_where_call<'c, M, RB>(
 &self,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<Postgres>
) -> 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>,
 &'c Pool<Postgres>: Executor<'c, Database = Postgres>,

M 为 Model 类型

source

impl Select<Mssql>

source

pub async fn fetch_all_by_where_call<'c, M, RB>(
 &self,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<Mssql>
) -> 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>,
 &'c Pool<Mssql>: Executor<'c, Database = Mssql>,

M 为 Model 类型

source

impl Select<Mssql>

source

pub async fn fetch_one_by_where_call<'c, M, RB>(
 &self,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<Mssql>
) -> 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>,
 &'c Pool<Mssql>: Executor<'c, Database = Mssql>,

M 为 Model 类型

source

impl Select<MySql>

source

pub async fn fetch_all_scalar_by_where<'c, M>(
 &self,
 field_name: &str,
 where_sql: Option<String>,
 pool: &'c Pool<MySql>
) -> 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>,
 &'c Pool<MySql>: Executor<'c, Database = MySql>,

M 为返回某字段类型

source

impl Select<MySql>

source

pub async fn fetch_one_scalar_by_where<'c, M>(
 &self,
 field_name: &str,
 where_sql: Option<String>,
 pool: &'c Pool<MySql>
) -> 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>,
 &'c Pool<MySql>: Executor<'c, Database = MySql>,

M 为返回某字段类型

source

impl Select<Sqlite>

source

pub async fn fetch_all_scalar_by_where<'c, M>(
 &self,
 field_name: &str,
 where_sql: Option<String>,
 pool: &'c Pool<Sqlite>
) -> 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>,
 &'c Pool<Sqlite>: Executor<'c, Database = Sqlite>,

M 为返回某字段类型

source

impl Select<Sqlite>

source

pub async fn fetch_one_scalar_by_where<'c, M>(
 &self,
 field_name: &str,
 where_sql: Option<String>,
 pool: &'c Pool<Sqlite>
) -> 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>,
 &'c Pool<Sqlite>: Executor<'c, Database = Sqlite>,

M 为返回某字段类型

source

impl Select<Postgres>

source

pub async fn fetch_all_scalar_by_where<'c, M>(
 &self,
 field_name: &str,
 where_sql: Option<String>,
 pool: &'c Pool<Postgres>
) -> 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>,
 &'c Pool<Postgres>: Executor<'c, Database = Postgres>,

M 为返回某字段类型

source

impl Select<Postgres>

source

pub async fn fetch_one_scalar_by_where<'c, M>(
 &self,
 field_name: &str,
 where_sql: Option<String>,
 pool: &'c Pool<Postgres>
) -> 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>,
 &'c Pool<Postgres>: Executor<'c, Database = Postgres>,

M 为返回某字段类型

source

impl Select<Mssql>

source

pub async fn fetch_all_scalar_by_where<'c, M>(
 &self,
 field_name: &str,
 where_sql: Option<String>,
 pool: &'c Pool<Mssql>
) -> 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>,
 &'c Pool<Mssql>: Executor<'c, Database = Mssql>,

M 为返回某字段类型

source

impl Select<Mssql>

source

pub async fn fetch_one_scalar_by_where<'c, M>(
 &self,
 field_name: &str,
 where_sql: Option<String>,
 pool: &'c Pool<Mssql>
) -> 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>,
 &'c Pool<Mssql>: Executor<'c, Database = Mssql>,

M 为返回某字段类型

source

impl Select<MySql>

source

pub async fn fetch_all_scalar_by_where_call<'c, M, RB>(
 &self,
 field_name: &str,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<MySql>
) -> 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>,
 &'c Pool<MySql>: Executor<'c, Database = MySql>,

M 为返回某字段类型

source

impl Select<MySql>

source

pub async fn fetch_one_scalar_by_where_call<'c, M, RB>(
 &self,
 field_name: &str,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<MySql>
) -> 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>,
 &'c Pool<MySql>: Executor<'c, Database = MySql>,

M 为返回某字段类型

source

impl Select<Sqlite>

source

pub async fn fetch_all_scalar_by_where_call<'c, M, RB>(
 &self,
 field_name: &str,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<Sqlite>
) -> 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>,
 &'c Pool<Sqlite>: Executor<'c, Database = Sqlite>,

M 为返回某字段类型

source

impl Select<Sqlite>

source

pub async fn fetch_one_scalar_by_where_call<'c, M, RB>(
 &self,
 field_name: &str,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<Sqlite>
) -> 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>,
 &'c Pool<Sqlite>: Executor<'c, Database = Sqlite>,

M 为返回某字段类型

source

impl Select<Postgres>

source

pub async fn fetch_all_scalar_by_where_call<'c, M, RB>(
 &self,
 field_name: &str,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<Postgres>
) -> 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>,
 &'c Pool<Postgres>: Executor<'c, Database = Postgres>,

M 为返回某字段类型

source

impl Select<Postgres>

source

pub async fn fetch_one_scalar_by_where_call<'c, M, RB>(
 &self,
 field_name: &str,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<Postgres>
) -> 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>,
 &'c Pool<Postgres>: Executor<'c, Database = Postgres>,

M 为返回某字段类型

source

impl Select<Mssql>

source

pub async fn fetch_all_scalar_by_where_call<'c, M, RB>(
 &self,
 field_name: &str,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<Mssql>
) -> 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>,
 &'c Pool<Mssql>: Executor<'c, Database = Mssql>,

M 为返回某字段类型

source

impl Select<Mssql>

source

pub async fn fetch_one_scalar_by_where_call<'c, M, RB>(
 &self,
 field_name: &str,
 where_sql: String,
 where_bind: RB,
 pool: &'c Pool<Mssql>
) -> 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>,
 &'c Pool<Mssql>: Executor<'c, Database = Mssql>,

M 为返回某字段类型

Auto Trait Implementations

impl<DB> RefUnwindSafe for Select<DB> where
DB: RefUnwindSafe,

impl<DB> Send for Select<DB>

impl<DB> Sync for Select<DB> where
DB: Sync,

impl<DB> Unpin for Select<DB> where
DB: Unpin,

impl<DB> UnwindSafe for Select<DB> where
DB: UnwindSafe,

Blanket Implementations

source

impl<T> Any for T where
T: 'static + ?Sized,

source

pub fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more

source

impl<T> Borrow<T> for T where
T: ?Sized,

const: unstable · source

pub fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more

source

impl<T> BorrowMut<T> for T where
T: ?Sized,

const: unstable · source

pub fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more

source

impl<T> From<T> for T

const: unstable · source

pub fn from(t: T) -> T

Performs the conversion.

source

impl<T, U> Into for T where
U: From<T>,

const: unstable · source

pub fn into(self) -> U

Performs the conversion.

source

impl<T> Same<T> for T

type Output = T

Should always be Self

source

impl<T, U> TryFrom for T where
U: Into<T>,

type Error = Infallible

The type returned in the event of a conversion error.

const: unstable · source

pub fn try_from(value: U) -> Result<T, <T as TryFrom>::Error>

Performs the conversion.

source

impl<T, U> TryInto for T where
U: TryFrom<T>,

type Error = >::Error

The type returned in the event of a conversion error.

const: unstable · source

pub fn try_into(self) -> Result<U, >::Error>

Performs the conversion.

Struct sqlx_model::Select

Fields

Implementations

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>() -> Self where T: ModelTableField<DB> + ModelTableName,

pub async fn reload<'c, M>( &self, val: &M, pool: &'c Pool<DB>) -> 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>, &'c Pool<DB>: Executor<'c, Database = DB>,

impl Select<MySql>

impl Select<MySql>

impl Select<Sqlite>

impl Select<Sqlite>

impl Select<Postgres>

impl Select<Postgres>

impl Select<Mssql>

impl Select<Mssql>

impl Select<MySql>

impl Select<MySql>

impl Select<Sqlite>

impl Select<Sqlite>

impl Select<Postgres>

impl Select<Postgres>

impl Select<Mssql>

impl Select<Mssql>

impl Select<MySql>

impl Select<MySql>

impl Select<Sqlite>

impl Select<Sqlite>

impl Select<Postgres>

impl Select<Postgres>

impl Select<Mssql>

impl Select<Mssql>

impl Select<MySql>

impl Select<MySql>

impl Select<Sqlite>

impl Select<Sqlite>

impl Select<Postgres>

impl Select<Postgres>

impl Select<Mssql>

impl Select<Mssql>

Auto Trait Implementations

impl<DB> RefUnwindSafe for Select<DB> where DB: RefUnwindSafe,

impl<DB> Send for Select<DB>

impl<DB> Sync for Select<DB> where DB: Sync,

impl<DB> Unpin for Select<DB> where DB: Unpin,

impl<DB> UnwindSafe for Select<DB> where DB: UnwindSafe,

Blanket Implementations

impl<T> Any for T where T: 'static + ?Sized,

pub fn type_id(&self) -> TypeId

impl<T> Borrow<T> for T where T: ?Sized,

pub fn borrow(&self) -> &T

impl<T> BorrowMut<T> for T where T: ?Sized,

pub fn borrow_mut(&mut self) -> &mut T

impl<T> From<T> for T

pub fn from(t: T) -> T

impl<T, U> Into<U> for T where U: From<T>,

pub fn into(self) -> U

impl<T> Same<T> for T

type Output = T

impl<T, U> TryFrom<U> for T where U: Into<T>,

type Error = Infallible

pub fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>

impl<T, U> TryInto<U> for T where U: TryFrom<T>,

type Error = <U as TryFrom<T>>::Error

pub fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

impl<V, T> VZip<V> for T where V: MultiLane<T>,

pub fn vzip(self) -> V

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>() -> Self where
T: ModelTableField<DB> + ModelTableName,

pub async fn reload<'c, M>(
&self,
val: &M,
pool: &'c Pool<DB>
) -> 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>,
&'c Pool<DB>: Executor<'c, Database = DB>,

impl<DB> RefUnwindSafe for Select<DB> where
DB: RefUnwindSafe,

impl<DB> Sync for Select<DB> where
DB: Sync,

impl<DB> Unpin for Select<DB> where
DB: Unpin,

impl<DB> UnwindSafe for Select<DB> where
DB: UnwindSafe,

impl<T> Any for T where
T: 'static + ?Sized,

impl<T> Borrow<T> for T where
T: ?Sized,

impl<T> BorrowMut<T> for T where
T: ?Sized,

impl<T, U> Into<U> for T where
U: From<T>,

impl<T, U> TryFrom<U> for T where
U: Into<T>,

impl<T, U> TryInto<U> for T where
U: TryFrom<T>,

impl<V, T> VZip<V> for T where
V: MultiLane<T>,