Struct QueryBuilder 

pub struct QueryBuilder {
    pub table_name: String,
    pub criteria: Vec<Criteria>,
    pub sort_orders: Vec<SortOrder>,
    pub pagination: Option<Pagination>,
    pub select_columns: Option<Vec<String>>,
    pub group_by_columns: Option<Vec<String>>,
    pub having_criteria: Vec<Criteria>,
    pub distinct: bool,
    pub joins: Vec<JoinClause>,
}

Fields

table_name: String

criteria: Vec<Criteria>

sort_orders: Vec<SortOrder>

pagination: Option<Pagination>

select_columns: Option<Vec<String>>

group_by_columns: Option<Vec<String>>

having_criteria: Vec<Criteria>

distinct: bool

joins: Vec<JoinClause>

Implementations

impl QueryBuilder

pub fn new(table_name: &str) -> Self

pub fn select(&mut self, columns: Vec<&str>) -> &mut Self

pub fn where_criteria(&mut self, criteria: Criteria) -> &mut Self

pub fn and_where(&mut self, criteria: Criteria) -> &mut Self

pub fn or_where(&mut self, criteria: Criteria) -> &mut Self

pub fn order_by(&mut self, sort_order: SortOrder) -> &mut Self

pub fn paginate(&mut self, page: u64, page_size: u64) -> &mut Self

pub fn distinct(&mut self) -> &mut Self

pub fn group_by(&mut self, columns: Vec<&str>) -> &mut Self

pub fn inner_join( &mut self, table_name: &str, on_column: &str, referenced_column: &str, ) -> &mut Self

pub fn left_join( &mut self, table_name: &str, on_column: &str, referenced_column: &str, ) -> &mut Self

pub fn build(&self) -> (String, Vec<Value>)

Trait Implementations

impl Clone for QueryBuilder

fn clone(&self) -> QueryBuilder

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for QueryBuilder

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

Formats the value using the given formatter.

impl<'py> IntoPyObject<'py> for QueryBuilder

type Target = QueryBuilder

The Python output type

type Output = Bound<'py, <QueryBuilder as IntoPyObject<'py>>::Target>

The smart pointer type to use.

type Error = PyErr

The type returned in the event of a conversion error.

fn into_pyobject( self, py: Python<'py>, ) -> Result<<Self as IntoPyObject<'_>>::Output, <Self as IntoPyObject<'_>>::Error>

Performs the conversion.

impl PyClass for QueryBuilder

type Frozen = False

Whether the pyclass is frozen.

impl PyClassImpl for QueryBuilder

const IS_BASETYPE: bool = false

#[pyclass(subclass)]

const IS_SUBCLASS: bool = false

#[pyclass(extends=…)]

const IS_MAPPING: bool = false

#[pyclass(mapping)]

const IS_SEQUENCE: bool = false

#[pyclass(sequence)]

const IS_IMMUTABLE_TYPE: bool = false

#[pyclass(immutable_type)]

const RAW_DOC: &'static CStr = c"\x00"

Docstring for the class provided on the struct or enum.

const DOC: &'static CStr

Fully rendered class doc, including the text_signature if a constructor is defined.

type BaseType = PyAny

Base class

type ThreadChecker = SendablePyClass<QueryBuilder>

This handles following two situations:

type PyClassMutability = <<PyAny as PyClassBaseType>::PyClassMutability as PyClassMutability>::MutableChild

Immutable or mutable

type Dict = PyClassDummySlot

Specify this class has #[pyclass(dict)] or not.

type WeakRef = PyClassDummySlot

Specify this class has #[pyclass(weakref)] or not.

type BaseNativeType = PyAny

The closest native ancestor. This is PyAny by default, and when you declare #[pyclass(extends=PyDict)], it’s PyDict.

fn items_iter() -> PyClassItemsIter

fn lazy_type_object() -> &'static LazyTypeObject<Self>

fn dict_offset() -> Option<isize>

fn weaklist_offset() -> Option<isize>

impl PyTypeInfo for QueryBuilder

const NAME: &'static str = "QueryBuilder"

Class name.

const MODULE: Option<&'static str> = ::core::option::Option::None

Module name, if any.

fn type_object_raw(py: Python<'_>) -> *mut PyTypeObject

Returns the PyTypeObject instance for this type.

fn type_object(py: Python<'_>) -> Bound<'_, PyType>

Returns the safe abstraction over the type object.

fn is_type_of(object: &Bound<'_, PyAny>) -> bool

Checks if object is an instance of this type or a subclass of this type.

fn is_exact_type_of(object: &Bound<'_, PyAny>) -> bool

Checks if object is an instance of this type.

impl DerefToPyAny for QueryBuilder

impl ExtractPyClassWithClone for QueryBuilder