Enum DBType

pub enum DBType {
    PostgreSQL,
    MySQL,
    SQLite,
}

Database type enumeration supporting major database systems

Variants

PostgreSQL

PostgreSQL database

MySQL

MySQL database

SQLite

SQLite database

Implementations

impl DBType

pub fn new(db_name: &str) -> Result<Self, Error>

Creates a DBType instance from database name

Arguments

• db_name - Database identifier (“PostgreSQL”|“MySQL”|“SQLite”)

Errors

Returns Error::Protocol for unsupported database types

Example

let db_type = DBType::new("PostgreSQL")?;

impl DBType

pub fn get_encode_placeholder_fn(&self) -> Option<fn(usize, &mut String)>

Gets placeholder generation function for parameter binding

Database-specific placeholder formats:

• PostgreSQL: $1, $2…
• MySQL/SQLite: ?

Returns

Option<fn(usize, &mut String)> placeholder generation function

pub fn write_count_sql(&self, sql: &mut String)

Wraps SQL in count query

Arguments

• sql - Original SQL to modify

pub fn write_page_sql<'c, 'q, DB>( &self, sql: &mut String, page_size: i64, page_no: i64, arg: &mut DB::Arguments<'q>, ) -> Result<(), Error>

where DB: Database, i64: Encode<'q, DB> + Type<DB>,

Generates pagination SQL clause

Arguments

• sql - Original SQL statement to modify
• page_size - Items per page
• page_no - Page number (auto-corrected to >=1)
• arg - SQL arguments container

Note

Automatically handles invalid page numbers

Trait Implementations

impl Debug for DBType

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

Formats the value using the given formatter.

impl PartialEq for DBType

fn eq(&self, other: &DBType) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl StructuralPartialEq for DBType