Function sentry::db::spendable::fetch_spendable
source · pub async fn fetch_spendable(
pool: DbPool,
spender: &Address,
channel_id: &ChannelId
) -> Result<Option<Spendable>, PoolError>
Expand description
SELECT spender, total, channels.leader, channels.follower, channels.guardian, channels.token, channels.nonce FROM spendable INNER JOIN channels ON channels.id = spendable.channel_id WHERE spender = $1 AND channel_id = $2