elif-orm 0.7.1

Production-ready ORM with migrations, database services, connection pooling, and query builder
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57

//! Transaction Isolation Levels
//!
//! Provides isolation level management for different database systems.

/// Transaction isolation levels supported by PostgreSQL
#[derive(Debug, Clone, Copy, PartialEq, Eq)]
pub enum IsolationLevel {
    /// Read Uncommitted - lowest isolation level
    ReadUncommitted,
    /// Read Committed - default PostgreSQL isolation level
    ReadCommitted,
    /// Repeatable Read - stronger consistency guarantees
    RepeatableRead,
    /// Serializable - highest isolation level
    Serializable,
}

impl IsolationLevel {
    /// Convert to SQL string for SET TRANSACTION ISOLATION LEVEL command
    pub fn as_sql(&self) -> &'static str {
        match self {
            IsolationLevel::ReadUncommitted => "READ UNCOMMITTED",
            IsolationLevel::ReadCommitted => "READ COMMITTED",
            IsolationLevel::RepeatableRead => "REPEATABLE READ",
            IsolationLevel::Serializable => "SERIALIZABLE",
        }
    }

    /// Get the default isolation level for a database dialect
    pub fn default_for_dialect(dialect: &crate::backends::SqlDialect) -> Self {
        match dialect {
            crate::backends::SqlDialect::PostgreSQL => IsolationLevel::ReadCommitted,
            crate::backends::SqlDialect::MySQL => IsolationLevel::RepeatableRead,
            crate::backends::SqlDialect::SQLite => IsolationLevel::Serializable,
        }
    }

    /// Check if this isolation level is supported by the given dialect
    pub fn is_supported_by(&self, dialect: &crate::backends::SqlDialect) -> bool {
        match dialect {
            crate::backends::SqlDialect::PostgreSQL => true, // All levels supported
            crate::backends::SqlDialect::MySQL => {
                matches!(
                    self,
                    IsolationLevel::ReadUncommitted
                        | IsolationLevel::ReadCommitted
                        | IsolationLevel::RepeatableRead
                        | IsolationLevel::Serializable
                )
            }
            crate::backends::SqlDialect::SQLite => {
                // SQLite only effectively supports Serializable
                matches!(self, IsolationLevel::Serializable)
            }
        }
    }
}