Enum UpsertStrategy 

pub enum UpsertStrategy {
    None,
    OnConflictDoNothing(Vec<String>),
    OnConflictDoUpdate(Vec<String>, Vec<(String, String)>),
    OnDuplicateKeyUpdate(Vec<(String, String)>),
    Replace,
}

Upsert (insert or update) strategy

Supports conflict-handling syntax of three mainstream databases:

• PostgreSQL/SQLite: ON CONFLICT ... DO NOTHING / DO UPDATE
• MySQL/MariaDB/TiDB: ON DUPLICATE KEY UPDATE / REPLACE INTO

Dialect compatibility

Strategy	MySQL	PostgreSQL	SQLite
OnConflictDoNothing	✗	✓	✓
OnConflictDoUpdate	✗	✓	✓
OnDuplicateKeyUpdate	✓	✗	✗
Replace	✓	✗	✓ (INSERT OR REPLACE)

Incompatible combinations are skipped in build_with_dialect (no error; the caller must ensure dialect match).

Variants

None

No upsert (default)

OnConflictDoNothing(Vec<String>)

PostgreSQL/SQLite: ON CONFLICT (cols) DO NOTHING

OnConflictDoUpdate(Vec<String>, Vec<(String, String)>)

PostgreSQL/SQLite: ON CONFLICT (cols) DO UPDATE SET col = expr, ... (conflict_cols, update_assignments)

OnDuplicateKeyUpdate(Vec<(String, String)>)

MySQL: ON DUPLICATE KEY UPDATE col = expr, ...

Replace

MySQL: REPLACE INTO (delete conflicting rows first, then insert)

Trait Implementations

impl Clone for UpsertStrategy

fn clone(&self) -> UpsertStrategy

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for UpsertStrategy

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

Formats the value using the given formatter.

impl Default for UpsertStrategy

fn default() -> UpsertStrategy

Returns the “default value” for a type.