Skip to main content

yang_db/
isolation.rs

1//! 事务隔离级别(NG-2)。
2//!
3//! yang-db 的 `transaction()` 此前裸 `pool.begin()`,使用数据库默认隔离级别
4//! (MySQL InnoDB 默认 REPEATABLE READ、PostgreSQL 默认 READ COMMITTED),无法按需调整,
5//! 跨后端差异静默隐埋竞态。本枚举 + `transaction_with_isolation` 入口提供显式配置。
6
7/// 事务隔离级别(SQL 标准四级)。
8#[derive(Debug, Clone, Copy, PartialEq, Eq)]
9#[non_exhaustive]
10pub enum IsolationLevel {
11    /// 读未提交(最低)
12    ReadUncommitted,
13    /// 读已提交(PostgreSQL 默认)
14    ReadCommitted,
15    /// 可重复读(MySQL InnoDB 默认)
16    RepeatableRead,
17    /// 串行化(最高)
18    Serializable,
19}
20
21impl IsolationLevel {
22    /// 级别名(不含方言前缀),用于拼 `SET TRANSACTION ISOLATION LEVEL <name>`。
23    ///
24    /// 返回 `&'static str` 字面量,**不含**任何外部输入,拼接安全。
25    pub fn as_sql(&self) -> &'static str {
26        match self {
27            IsolationLevel::ReadUncommitted => "READ UNCOMMITTED",
28            IsolationLevel::ReadCommitted => "READ COMMITTED",
29            IsolationLevel::RepeatableRead => "REPEATABLE READ",
30            IsolationLevel::Serializable => "SERIALIZABLE",
31        }
32    }
33}
34
35#[cfg(test)]
36mod tests {
37    use super::*;
38
39    #[test]
40    fn test_as_sql() {
41        assert_eq!(IsolationLevel::ReadUncommitted.as_sql(), "READ UNCOMMITTED");
42        assert_eq!(IsolationLevel::ReadCommitted.as_sql(), "READ COMMITTED");
43        assert_eq!(IsolationLevel::RepeatableRead.as_sql(), "REPEATABLE READ");
44        assert_eq!(IsolationLevel::Serializable.as_sql(), "SERIALIZABLE");
45    }
46}