Enum rorm_sql::DBImpl

pub enum DBImpl {
    SQLite,
    Postgres,
    MySQL,
}

The main interface for creating sql strings

Variants

SQLite

Implementation of SQLite

Postgres

Implementation of Postgres

MySQL

Implementation of MySQL / MariaDB

Implementations

impl DBImpl

pub fn create_table<'until_build, 'post_build>(
    &self,
    name: &'until_build str
) -> impl CreateTable<'until_build, 'post_build>where
    'post_build: 'until_build,

The entry point to create a table.

Parameter:

• name: Name of the table

pub fn create_trigger(
    &self,
    name: &str,
    table_name: &str,
    point_in_time: Option<SQLCreateTriggerPointInTime>,
    operation: SQLCreateTriggerOperation
) -> SQLCreateTrigger

The entry point to create a trigger.

Parameter:

• name: Name of the trigger.
• table_name: Name of the table to create the trigger on.
• point_in_time: Option of SQLCreateTriggerPointInTime: When to execute the trigger.
• operation: SQLCreateTriggerOperation: The operation that invokes the trigger.

Examples found in repository

src/create_trigger.rs (lines 130-135)

pub(crate) fn trigger_annotation_to_trigger_sqlite(
    annotation: &Annotation,
    db_type: &DbType,
    table_name: &str,
    column_name: &str,
    statements: &mut Vec<(String, Vec<Value>)>,
) {
    if annotation == &Annotation::AutoUpdateTime {
        let update_statement = format!(
            "UPDATE {} SET {} = {} WHERE ROWID = NEW.ROWID;",
            table_name,
            column_name,
            match db_type {
                DbType::Date => "CURRENT_DATE",
                DbType::DateTime => "CURRENT_TIMESTAMP",
                DbType::Timestamp => "CURRENT_TIMESTAMP",
                DbType::Time => "CURRENT_TIME",
                _ => "",
            }
        );
        statements.push((
            DBImpl::SQLite
                .create_trigger(
                    format!("{}_{}_auto_update_time", table_name, column_name).as_str(),
                    table_name,
                    Some(SQLCreateTriggerPointInTime::After),
                    SQLCreateTriggerOperation::Update { columns: None },
                )
                .for_each_row()
                .if_not_exists()
                .add_statement(update_statement)
                .build(),
            vec![],
        ))
    }
}

pub fn create_index<'until_build>(
    &self,
    name: &'until_build str,
    table_name: &'until_build str
) -> impl CreateIndex<'until_build>

The entry point to create an index.

Parameter:

• name: Name of the index.
• table_name: Table to create the index on.

pub fn drop_table<'until_build>(
    &self,
    name: &'until_build str
) -> impl DropTable + 'until_build

The entry point to drop a table.

Parameter:

• name: Name of the table to drop.

pub fn alter_table<'until_build, 'post_build>(
    &self,
    name: &'until_build str,
    operation: AlterTableOperation<'until_build, 'post_build>
) -> impl AlterTable<'post_build> + 'until_buildwhere
    'post_build: 'until_build,

The entry point to alter a table.

Parameter:

• name: Name of the table to execute the operation on.
• operation: AlterTableOperation: The operation to execute.

pub fn create_column<'until_build, 'post_build>(
    &self,
    table_name: &'until_build str,
    name: &'until_build str,
    data_type: DbType,
    annotations: &'post_build [Annotation]
) -> CreateColumnImpl<'until_build, 'post_build>

The entry point to create a column in a table.

Parameter:

• table_name: Name of the table.
• name: Name of the column.
• data_type: DbType: Data type of the column
• annotations: slice of Annotation: List of annotations.

pub fn select<'until_build, 'post_build>(
    &self,
    columns: &'until_build [SelectColumnImpl<'_>],
    from_clause: &'until_build str,
    joins: &'until_build [JoinTableImpl<'until_build, 'post_build>],
    order_by_clause: &'until_build [OrderByEntry<'until_build>]
) -> impl Select<'until_build, 'post_build>

Build a select query.

Parameter:

• columns: The columns to select.
• from_clause: Specifies from what to select. This can be a table name or another query itself.
• joins: List of join tables.

pub fn insert<'until_build, 'post_build>(
    &self,
    into_clause: &'until_build str,
    insert_columns: &'until_build [&'until_build str],
    insert_values: &'until_build [&'until_build [Value<'post_build>]],
    returning_clause: Option<&'until_build [&'until_build str]>
) -> impl Insert<'post_build> + 'until_buildwhere
    'post_build: 'until_build,

Build an INSERT query.

Parameter:

• into_clause: The table to insert into.
• insert_columns: The column names to insert into.
• insert_values: slice of slice of Value: The values to insert.
• returning_clause: Optional slice of string to retrieve after the insert.

pub fn delete<'until_build, 'post_query>(
    &self,
    table_name: &'until_build str
) -> impl Delete<'until_build, 'post_query>

Build a delete operation.

Parameter:

• table_name: Name of the table to delete from.

pub fn update<'until_build, 'post_query>(
    &self,
    table_name: &'until_build str
) -> impl Update<'until_build, 'post_query>

Build an update operation.

Parameter:

• table_name: Name of the table the updates should be executed for.

pub fn join_table<'until_build, 'post_query>(
    &self,
    join_type: JoinType,
    table_name: &'until_build str,
    join_alias: &'until_build str,
    join_condition: &'until_build Condition<'post_query>
) -> JoinTableImpl<'until_build, 'post_query>

The entry point for a JOIN expression builder.

Parameter:

• join_type: JoinType: Type for a JOIN expression
• table_name: Table to perform the join on
• join_alias: Alias for the join table
• join_condition: Condition to apply to the join

pub fn select_column<'until_build>(
    &self,
    table_name: Option<&'until_build str>,
    column_name: &'until_build str,
    select_alias: Option<&'until_build str>,
    aggregation: Option<SelectAggregator>
) -> SelectColumnImpl<'until_build>

The entry point for a column selector builder.

Parameter:

• table_name: Optional table name
• column_name: Name of the column
• select_alias: Alias for the selector
• aggregation: Optional aggregation function

Trait Implementations

impl Clone for DBImpl

fn clone(&self) -> DBImpl

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Copy for DBImpl