Function sentry::db::insert_channel

source ·
pub async fn insert_channel(
    pool: &DbPool,
    channel_chain: &ChainOf<Channel>
) -> Result<Channel, PoolError>
Expand description

Used to insert/get Channel when creating a Campaign If channel already exists it will return it instead. This call should never trigger a SqlState::UNIQUE_VIOLATION

INSERT INTO channels (id, leader, follower, guardian, token, nonce, chain_id, created)
VALUES ($1, $2, $3, $4, $5, $6, $7, NOW())
ON CONFLICT ON CONSTRAINT channels_pkey DO UPDATE SET created=EXCLUDED.created
RETURNING leader, follower, guardian, token, nonce