Function insert_or_overwrite_interaction

crates/database/src/orders.rs:316–345

(
    ex: &mut PgConnection,
    interaction: &Interaction,
    order_uid: &OrderUid,
)

#[instrument(skip_all)]
pub async fn insert_or_overwrite_interaction(
    ex: &mut PgConnection,
    interaction: &Interaction,
    order_uid: &OrderUid,
) -> Result<(), sqlx::Error> {
    const QUERY: &str = r#"
INSERT INTO interactions (
    order_uid,
    index,
    target,
    value,
    data,
    execution
)
VALUES ($1, $2, $3, $4, $5, $6)
ON CONFLICT (order_uid, index, execution) DO UPDATE
SET target = $3,
value = $4, data = $5
    "#;
    sqlx::query(QUERY)
        .bind(order_uid)
        .bind(interaction.index)
        .bind(interaction.target)
        .bind(&interaction.value)
        .bind(&interaction.data)
        .bind(interaction.execution)
        .execute(ex)
        .await?;
    Ok(())
}

/// One row in the `order_quotes` table.
#[derive(Clone, Default, Debug, PartialEq, sqlx::FromRow)]