db.insertion.helpers

class DataManipulationEvent

Bases: ABC

Execution of DML (Data Manipulation Language) statements.

class OnConflict(value, names=<not given>, *values, module=None, qualname=None, type=None, start=1, boundary=None)

Bases: Enum

DO_NOTHING = 1

DO_UPDATE = 2

insert_on_conflict(dialect: SupportedSQLDialect, table: Any, values: Mapping[str, Any], constraint: str, column_names: Sequence[str], on_conflict: OnConflict = OnConflict.DO_NOTHING, set_: Mapping[str, Any] | None = None) → Insert

Dialect specific insertion statement using ON CONFLICT DO syntax.