rustbasic-core 0.1.26

Core framework logic for RustBasic - A modern web framework for Rust
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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105

use std::sync::{Arc, Mutex};
use std::collections::VecDeque;
use crate::sql::driver::mysql::connection::MySqlConnection;
use crate::sql::driver::error::SqlError;

#[derive(Clone)]
pub struct MySqlPool {
    inner: Arc<Mutex<PoolInner>>,
}

struct PoolInner {
    connections: VecDeque<MySqlConnection>,
    host: String,
    port: u16,
    user: String,
    pass: String,
    db: String,
}

pub struct PoolConnection {
    conn: Option<MySqlConnection>,
    pool: Arc<Mutex<PoolInner>>,
}

impl MySqlPool {
    pub fn new(
        host: &str,
        port: u16,
        user: &str,
        password: &str,
        database: &str,
    ) -> Self {
        Self {
            inner: Arc::new(Mutex::new(PoolInner {
                connections: VecDeque::new(),
                host: host.to_string(),
                port,
                user: user.to_string(),
                pass: password.to_string(),
                db: database.to_string(),
            })),
        }
    }

    pub fn acquire(&self) -> Result<PoolConnection, SqlError> {
        let mut inner = self.inner.lock().unwrap();
        
        while let Some(mut conn) = inner.connections.pop_front() {
            // Check if connection is still healthy
            if conn.execute("SELECT 1", &[]).is_ok() {
                return Ok(PoolConnection {
                    conn: Some(conn),
                    pool: self.inner.clone(),
                });
            }
        }

        // None available or all dead, connect new
        let conn = MySqlConnection::connect(
            &inner.host,
            inner.port,
            &inner.user,
            &inner.pass,
            &inner.db,
        )?;

        Ok(PoolConnection {
            conn: Some(conn),
            pool: self.inner.clone(),
        })
    }
}

impl std::ops::Deref for PoolConnection {
    type Target = MySqlConnection;
    fn deref(&self) -> &Self::Target {
        self.conn.as_ref().unwrap()
    }
}

impl std::ops::DerefMut for PoolConnection {
    fn deref_mut(&mut self) -> &mut Self::Target {
        self.conn.as_mut().unwrap()
    }
}

impl Drop for PoolConnection {
    fn drop(&mut self) {
        if let Some(conn) = self.conn.take() {
            if let Ok(mut inner) = self.pool.lock() {
                inner.connections.push_back(conn);
            }
        }
    }
}

impl crate::sql::driver::SqlConnection for PoolConnection {
    fn execute(&mut self, sql: &str, params: &[crate::sql::driver::SqlValue]) -> Result<crate::sql::driver::QueryResult, SqlError> {
        self.conn.as_mut().unwrap().execute(sql, params)
    }

    fn query(&mut self, sql: &str, params: &[crate::sql::driver::SqlValue]) -> Result<Vec<crate::sql::driver::SqlRow>, SqlError> {
        self.conn.as_mut().unwrap().query(sql, params)
    }
}