Function insert

crates/database/src/app_data.rs:7–34

Tries to associate the contract app data with the full app data. If this contract app data already existed then the existing full app data is returned, otherwise `None` is returned.

(
    ex: &mut PgConnection,
    contract_app_data: &AppId,
    full_app_data: &[u8],
)

/// If this contract app data already existed then the existing full app data is
/// returned, otherwise `None` is returned.
pub async fn insert(
    ex: &mut PgConnection,
    contract_app_data: &AppId,
    full_app_data: &[u8],
) -> Result<Option<Vec<u8>>, sqlx::Error> {
    const QUERY: &str = r#"
WITH inserted AS (
    INSERT INTO app_data (contract_app_data, full_app_data)
    VALUES ($1, $2)
    -- returns null on conflict
    ON CONFLICT DO NOTHING
    -- returns TRUE if the insertion succeeded
    RETURNING TRUE
)
SELECT
    CASE
        WHEN (SELECT * FROM inserted) THEN
            NULL
        ELSE
            (SELECT full_app_data FROM app_data WHERE contract_app_data = $1)
    END
;"#;
    sqlx::query_scalar(QUERY)
        .bind(contract_app_data)
        .bind(full_app_data)
        .fetch_one(ex)
        .await
}

pub async fn fetch(
    ex: &mut PgConnection,