Struct easy_sqlx_core::sql::builder::select_builder::SelectBuilder

source · 
pub struct SelectBuilder<'a> { /* private fields */ }

Implementations§

source§

impl<'a> SelectBuilder<'a>

source

pub fn new(table: TableSchema) -> Self

source

pub fn with_default_schema(self, schema: &'a str) -> Self

source

pub fn order_by(self, item: Order) -> Self

Trait Implementations§

source§

impl<'a> Debug for SelectBuilder<'a>

source§

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter. Read more
source§

impl<'a> QueryBuilder<'a> for SelectBuilder<'a>

source§

type DB = Postgres

source§

async fn one<'e, 'c: 'e, E, O>(self, executor: E) -> Result<O, Error>
where E: 'e + Executor<'c, Database = Self::DB>, for<'r> O: 'e + FromRow<'r, <Self::DB as Database>::Row> + Send + Unpin,

获取一条记录
source§

async fn optional<'e, 'c: 'e, E, O>( self, executor: E, ) -> Result<Option<O>, Error>
where E: 'e + Executor<'c, Database = Self::DB>, for<'r> O: 'e + Send + Unpin + FromRow<'r, <Self::DB as Database>::Row>,

获取一条记录，如果不存在返回 None
source§

async fn all<'e, 'c: 'e, E, O>(self, executor: E) -> Result<Vec<O>, Error>
where E: 'e + Executor<'c, Database = Self::DB>, for<'r> O: FromRow<'r, <Self::DB as Database>::Row> + 'e + Send + Unpin,

获取全部记录
source§

async fn page<'e, 'c: 'e, E, O>( &self, executor: E, page: &PageRequest, ) -> Result<PageResult<O>, Error>
where E: 'e + Executor<'c, Database = Self::DB> + 'c + Copy, for<'r> O: FromRow<'r, <Self::DB as Database>::Row> + 'e + Send + Unpin,

分页查询
source§

async fn one_scalar<'c, E, O>( &self, executor: E, field: &str, ) -> Result<O, Error>
where (O,): for<'r> FromRow<'r, <Self::DB as Database>::Row>, E: 'c + Executor<'c, Database = Self::DB>, O: Send + Unpin,

获取一个标量
source§

async fn optional_scalar<'q, 'c, E, O>( &self, executor: E, field: &'q str, ) -> Result<Option<O>, Error>
where (O,): for<'r> FromRow<'r, <Self::DB as Database>::Row>, E: 'c + Executor<'c, Database = Self::DB>, O: Send + Unpin,

获取一个可选标量，如果不存在返回 None
source§

async fn all_scalars<'q, 'c, E, O>( &self, executor: E, field: &'q str, ) -> Result<Vec<O>, Error>
where (O,): for<'r> FromRow<'r, <Self::DB as Database>::Row>, E: 'c + Executor<'c, Database = Self::DB>, O: Send + Unpin,

获取全部标量
source§

async fn count<'c, E>(&self, executor: E) -> Result<usize, Error>
where E: 'c + Executor<'c, Database = Self::DB>,

查询记录数
source§

async fn page_scalars<'e, 'c: 'e, E, O>( &self, executor: E, field: &'c str, page: &PageRequest, ) -> Result<PageResult<O>, Error>
where (O,): for<'r> FromRow<'r, <Self::DB as Database>::Row>, E: 'e + Executor<'c, Database = Self::DB> + 'c + Copy, O: Send + Unpin,

分页获取标量
source§

impl<'a> WhereAppend<Condition> for SelectBuilder<'a>

source§

fn and(self, cond: Condition) -> Self

source§

fn or(self, cond: Condition) -> Self

source§

impl<'a> WhereAppend<Where> for SelectBuilder<'a>

source§

fn and(self, wh: Where) -> Self

source§

fn or(self, wh: Where) -> Self

Auto Trait Implementations§

§

impl<'a> Freeze for SelectBuilder<'a>

§

impl<'a> RefUnwindSafe for SelectBuilder<'a>

§

impl<'a> Send for SelectBuilder<'a>

§

impl<'a> Sync for SelectBuilder<'a>

§

impl<'a> Unpin for SelectBuilder<'a>

§

impl<'a> UnwindSafe for SelectBuilder<'a>

Blanket Implementations§

source§

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

source§

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more
source§

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

source§

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more
source§

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

source§

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

Mutably borrows from an owned value. Read more
source§

impl<T> From<T> for T

source§

fn from(t: T) -> T

Returns the argument unchanged.

source§

impl<T> Instrument for T

source§

fn instrument(self, span: Span) -> Instrumented<Self>

Instruments this type with the provided Span, returning an Instrumented wrapper. Read more
source§

fn in_current_span(self) -> Instrumented<Self>

Instruments this type with the current Span, returning an Instrumented wrapper. Read more
source§

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

source§

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

source§

impl<T> IntoEither for T

source§

fn into_either(self, into_left: bool) -> Either<Self, Self>

Converts self into a Left variant of Either<Self, Self> if into_left is true. Converts self into a Right variant of Either<Self, Self> otherwise. Read more
source§

fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
where F: FnOnce(&Self) -> bool,

Converts self into a Left variant of Either<Self, Self> if into_left(&self) returns true. Converts self into a Right variant of Either<Self, Self> otherwise. Read more
source§

impl<T> Same for T

source§

type Output = T

Should always be Self
source§

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

source§

type Error = Infallible

The type returned in the event of a conversion error.
source§

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

Performs the conversion.
source§

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

source§

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

The type returned in the event of a conversion error.
source§

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

Performs the conversion.
source§

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

source§

fn vzip(self) -> V

source§

impl<T> WithSubscriber for T

source§

fn with_subscriber<S>(self, subscriber: S) -> WithDispatch<Self>
where S: Into<Dispatch>,

Attaches the provided Subscriber to this type, returning a WithDispatch wrapper. Read more
source§

fn with_current_subscriber(self) -> WithDispatch<Self>

Attaches the current default Subscriber to this type, returning a WithDispatch wrapper. Read more