yang-db 0.3.1

个人使用数据库操作
Documentation
/// 事务 SELECT 的行锁模式。
///
/// 锁模式只能交给 MySQL/PostgreSQL 的 `Transaction::select_locked` 或便捷方法使用;
/// 普通 `QueryBuilder` 不暴露加锁入口,避免锁语句在自动提交连接上失去预期语义。
#[derive(Debug, Clone, Copy, PartialEq, Eq)]
#[non_exhaustive]
pub enum RowLock {
    /// 排他行锁:`FOR UPDATE`。
    ForUpdate,
    /// 共享行锁:`FOR SHARE`。
    ForShare,
    /// 排他行锁并跳过已锁定行:`FOR UPDATE SKIP LOCKED`。
    ForUpdateSkipLocked,
    /// 共享行锁并跳过已锁定行:`FOR SHARE SKIP LOCKED`。
    ForShareSkipLocked,
    /// 排他行锁,但不禁外键引用:`FOR NO KEY UPDATE`(PostgreSQL)。
    NoKeyUpdate,
    /// 键共享锁:`FOR KEY SHARE`(PostgreSQL)。
    KeyShare,
}

impl RowLock {
    #[cfg(any(feature = "mysql", feature = "postgres"))]
    pub(crate) const fn as_sql(self) -> &'static str {
        match self {
            Self::ForUpdate => "FOR UPDATE",
            Self::ForShare => "FOR SHARE",
            Self::ForUpdateSkipLocked => "FOR UPDATE SKIP LOCKED",
            Self::ForShareSkipLocked => "FOR SHARE SKIP LOCKED",
            Self::NoKeyUpdate => "FOR NO KEY UPDATE",
            Self::KeyShare => "FOR KEY SHARE",
        }
    }
}

#[cfg(all(test, any(feature = "mysql", feature = "postgres")))]
mod tests {
    use super::RowLock;

    #[test]
    fn skip_locked_modes_render_expected_sql() {
        assert_eq!(
            RowLock::ForUpdateSkipLocked.as_sql(),
            "FOR UPDATE SKIP LOCKED"
        );
        assert_eq!(
            RowLock::ForShareSkipLocked.as_sql(),
            "FOR SHARE SKIP LOCKED"
        );
        assert_eq!(RowLock::ForUpdate.as_sql(), "FOR UPDATE");
        assert_eq!(RowLock::ForShare.as_sql(), "FOR SHARE");
        assert_eq!(RowLock::NoKeyUpdate.as_sql(), "FOR NO KEY UPDATE");
        assert_eq!(RowLock::KeyShare.as_sql(), "FOR KEY SHARE");
    }
}