Struct toql_core::sql_builder::SqlBuilder

pub struct SqlBuilder<'a> { /* private fields */ }

The Sql builder to build normal queries and count queries.

Implementations

impl<'a> SqlBuilder<'a>

pub fn new(
    root_mapper: &'a str,
    table_mapper_registry: &'a TableMapperRegistry
) -> Self

Create a new SQL Builder from a root mapper and the table mapper registry

pub fn with_roles(self, roles: HashSet<String>) -> Self

Use these roles with the builder.

pub fn with_aux_params(self, aux_params: HashMap<String, SqlArg>) -> Self

Use these auxiliary parameters with the builder.

pub fn with_extra_join<T: Into<String>>(self, join: T) -> Self

Add this raw SQL join statement to the result. (For internal merge joins)

pub fn columns_expr(
    &self,
    query_field_path: &str,
    alias: &str
) -> Result<(SqlExpr, SqlExpr)>

pub fn merge_expr(&self, query_field_path: &str) -> Result<(SqlExpr, SqlExpr)>

pub fn build_delete<M>(&mut self, query: &Query<M>) -> Result<BuildResult>

Build a delete statement from the Query. This build a delete filter predicate from the field filters and predicates in the query. Any field selections are ignored.

Returns a BuildResult that can be turned into SQL.

pub fn build_merge_delete(
    &mut self,
    merge_path: &FieldPath<'_>,
    key_predicate: SqlExpr
) -> Result<SqlExpr>

pub fn build_select<M>(
    &mut self,
    query_home_path: &str,
    query: &Query<M>
) -> Result<BuildResult>

Build a normal select statement from the Query.

Returns a BuildResult that can be turned into SQL.

pub fn build_count<M>(
    &mut self,
    query_root_path: &str,
    query: &Query<M>,
    count_selection_only: bool
) -> Result<BuildResult>

Build a count statement from the Query. This build a count filter predicate from the field filters and predicates. If count_selection_ony is true then only filters are used that are part of the count selection ($cnt) or predicates that are marked as count_filters.

Returns a BuildResult that can be turned into SQL.

pub fn joined_mapper_for_local_path(
    &self,
    local_path: &FieldPath<'_>
) -> Result<&TableMapper>

pub fn joined_mapper_for_query_path(
    &self,
    query_path: &FieldPath<'_>
) -> Result<&TableMapper>

pub fn mapper_for_query_path(
    &self,
    query_path: &FieldPath<'_>
) -> Result<&TableMapper>