Struct PostgresQueryBuilder 

pub struct PostgresQueryBuilder;

PostgreSQL query builder

This struct implements SQL generation for PostgreSQL, using the following conventions:

• Identifiers: Double quotes ("table_name")
• Placeholders: Numbered ($1, $2, …)

Examples

use reinhardt_query::backend::{PostgresQueryBuilder, QueryBuilder};
use reinhardt_query::prelude::*;

let builder = PostgresQueryBuilder::new();
let stmt = Query::select()
    .column("id")
    .from("users");

let (sql, values) = builder.build_select(&stmt);
// sql: SELECT "id" FROM "users"

Implementations

impl PostgresQueryBuilder

pub fn new() -> Self

Create a new PostgreSQL query builder

Trait Implementations

impl Clone for PostgresQueryBuilder

fn clone(&self) -> PostgresQueryBuilder

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for PostgresQueryBuilder

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

Formats the value using the given formatter.

impl Default for PostgresQueryBuilder

fn default() -> PostgresQueryBuilder

Returns the “default value” for a type.

impl QueryBuilder for PostgresQueryBuilder

fn build_select(&self, stmt: &SelectStatement) -> (String, Values)

Build SELECT statement

fn build_insert(&self, stmt: &InsertStatement) -> (String, Values)

Build INSERT statement

fn build_update(&self, stmt: &UpdateStatement) -> (String, Values)

Build UPDATE statement

fn build_delete(&self, stmt: &DeleteStatement) -> (String, Values)

Build DELETE statement

fn build_create_table(&self, stmt: &CreateTableStatement) -> (String, Values)

Build CREATE TABLE statement

fn build_alter_table(&self, stmt: &AlterTableStatement) -> (String, Values)

Build ALTER TABLE statement

fn build_drop_table(&self, stmt: &DropTableStatement) -> (String, Values)

Build DROP TABLE statement

fn build_create_index(&self, stmt: &CreateIndexStatement) -> (String, Values)

Build CREATE INDEX statement

fn build_drop_index(&self, stmt: &DropIndexStatement) -> (String, Values)

Build DROP INDEX statement

fn build_create_view(&self, stmt: &CreateViewStatement) -> (String, Values)

Build CREATE VIEW statement

fn build_drop_view(&self, stmt: &DropViewStatement) -> (String, Values)

Build DROP VIEW statement

fn build_truncate_table( &self, stmt: &TruncateTableStatement, ) -> (String, Values)

Build TRUNCATE TABLE statement

fn build_create_trigger( &self, stmt: &CreateTriggerStatement, ) -> (String, Values)

Build CREATE TRIGGER statement

fn build_drop_trigger(&self, stmt: &DropTriggerStatement) -> (String, Values)

Build DROP TRIGGER statement

fn build_alter_index(&self, stmt: &AlterIndexStatement) -> (String, Values)

Build ALTER INDEX statement

fn build_reindex(&self, stmt: &ReindexStatement) -> (String, Values)

Build REINDEX statement

fn build_optimize_table( &self, _stmt: &OptimizeTableStatement, ) -> (String, Values)

Build OPTIMIZE TABLE statement

fn build_repair_table(&self, _stmt: &RepairTableStatement) -> (String, Values)

Build REPAIR TABLE statement

fn build_check_table(&self, _stmt: &CheckTableStatement) -> (String, Values)

Build CHECK TABLE statement

fn build_create_function( &self, stmt: &CreateFunctionStatement, ) -> (String, Values)

Build CREATE FUNCTION statement

fn build_alter_function( &self, stmt: &AlterFunctionStatement, ) -> (String, Values)

Build ALTER FUNCTION statement

fn build_drop_function(&self, stmt: &DropFunctionStatement) -> (String, Values)

Build DROP FUNCTION statement

fn build_grant(&self, stmt: &GrantStatement) -> (String, Values)

Build GRANT statement

fn build_revoke(&self, stmt: &RevokeStatement) -> (String, Values)

Build REVOKE statement

fn build_grant_role(&self, stmt: &GrantRoleStatement) -> (String, Values)

Build GRANT role membership statement

fn build_revoke_role(&self, stmt: &RevokeRoleStatement) -> (String, Values)

Build REVOKE role membership statement

fn build_create_role(&self, stmt: &CreateRoleStatement) -> (String, Values)

Build CREATE ROLE statement

fn build_drop_role(&self, stmt: &DropRoleStatement) -> (String, Values)

Build DROP ROLE statement

fn build_alter_role(&self, stmt: &AlterRoleStatement) -> (String, Values)

Build ALTER ROLE statement

fn build_create_user(&self, stmt: &CreateUserStatement) -> (String, Values)

Build CREATE USER statement

fn build_drop_user(&self, stmt: &DropUserStatement) -> (String, Values)

Build DROP USER statement

fn build_alter_user(&self, stmt: &AlterUserStatement) -> (String, Values)

Build ALTER USER statement

fn build_rename_user(&self, _stmt: &RenameUserStatement) -> (String, Values)

Build RENAME USER statement

fn build_set_role(&self, stmt: &SetRoleStatement) -> (String, Values)

Build SET ROLE statement

fn build_reset_role(&self, _stmt: &ResetRoleStatement) -> (String, Values)

Build RESET ROLE statement

fn build_set_default_role( &self, _stmt: &SetDefaultRoleStatement, ) -> (String, Values)

Build SET DEFAULT ROLE statement

fn escape_identifier(&self, ident: &str) -> String

Escape an identifier (table name, column name, etc.)

fn format_placeholder(&self, index: usize) -> String

Format a value for SQL

fn build_create_schema(&self, stmt: &CreateSchemaStatement) -> (String, Values)

Build CREATE SCHEMA statement

fn build_alter_schema(&self, stmt: &AlterSchemaStatement) -> (String, Values)

Build ALTER SCHEMA statement

fn build_drop_schema(&self, stmt: &DropSchemaStatement) -> (String, Values)

Build DROP SCHEMA statement

fn build_create_sequence( &self, stmt: &CreateSequenceStatement, ) -> (String, Values)

Build CREATE SEQUENCE statement

fn build_alter_sequence( &self, stmt: &AlterSequenceStatement, ) -> (String, Values)

Build ALTER SEQUENCE statement

fn build_drop_sequence(&self, stmt: &DropSequenceStatement) -> (String, Values)

Build DROP SEQUENCE statement

fn build_comment(&self, stmt: &CommentStatement) -> (String, Values)

Build COMMENT ON statement

fn build_create_database( &self, stmt: &CreateDatabaseStatement, ) -> (String, Values)

Build CREATE DATABASE statement

fn build_alter_database( &self, stmt: &AlterDatabaseStatement, ) -> (String, Values)

Build ALTER DATABASE statement

fn build_drop_database(&self, stmt: &DropDatabaseStatement) -> (String, Values)

Build DROP DATABASE statement

fn build_analyze(&self, stmt: &AnalyzeStatement) -> (String, Values)

Build ANALYZE statement

fn build_vacuum(&self, stmt: &VacuumStatement) -> (String, Values)

Build VACUUM statement

fn build_create_materialized_view( &self, stmt: &CreateMaterializedViewStatement, ) -> (String, Values)

Build CREATE MATERIALIZED VIEW statement

fn build_alter_materialized_view( &self, stmt: &AlterMaterializedViewStatement, ) -> (String, Values)

Build ALTER MATERIALIZED VIEW statement

fn build_drop_materialized_view( &self, stmt: &DropMaterializedViewStatement, ) -> (String, Values)

Build DROP MATERIALIZED VIEW statement

fn build_refresh_materialized_view( &self, stmt: &RefreshMaterializedViewStatement, ) -> (String, Values)

Build REFRESH MATERIALIZED VIEW statement

fn build_create_procedure( &self, stmt: &CreateProcedureStatement, ) -> (String, Values)

Build CREATE PROCEDURE statement

fn build_alter_procedure( &self, stmt: &AlterProcedureStatement, ) -> (String, Values)

Build ALTER PROCEDURE statement

fn build_drop_procedure( &self, stmt: &DropProcedureStatement, ) -> (String, Values)

Build DROP PROCEDURE statement

fn build_create_type(&self, stmt: &CreateTypeStatement) -> (String, Values)

Build CREATE TYPE statement

fn build_alter_type(&self, stmt: &AlterTypeStatement) -> (String, Values)

Build ALTER TYPE statement

fn build_drop_type(&self, stmt: &DropTypeStatement) -> (String, Values)

Build DROP TYPE statement

impl QueryBuilderTrait for PostgresQueryBuilder

fn placeholder(&self) -> (&str, bool)

Get placeholder format for this backend

fn quote_char(&self) -> char

Get quote character for this backend