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

use sqlx::mysql::{MySqlPool, MySqlQueryAs};

use async_trait::async_trait;

use crate::{Leaf, LeafDao, Result};

pub struct MySqlLeafDao {
    pool: MySqlPool,
}

#[async_trait]
impl LeafDao for MySqlLeafDao {
    async fn leaves(&self) -> Result<Vec<Leaf>> {
        let mut conn = self.pool.acquire().await?;
        let leaves: Vec<Leaf> = sqlx::query_as("SELECT tag, max_id, step FROM leaf_alloc")
            .fetch_all(&mut conn)
            .await?;
        Ok(leaves)
    }

    async fn leaf(&self, tag: i32) -> Result<Leaf> {
        let mut conn = self.pool.acquire().await?;
        let leaf: Leaf = sqlx::query_as("SELECT tag, max_id, step FROM leaf_alloc WHERE tag = ?")
            .bind(tag)
            .fetch_one(&mut conn)
            .await?;
        Ok(leaf)
    }

    async fn insert(&self, leaf: Leaf) -> Result<()> {
        let mut conn = self.pool.acquire().await?;
        sqlx::query("INSERT INTO leaf_alloc (tag, max_id, step) VALUES (?, ?, ?)")
            .bind(leaf.tag)
            .bind(leaf.max_id)
            .bind(leaf.step)
            .execute(&mut conn)
            .await?;
        Ok(())
    }

    async fn tags(&self) -> Result<Vec<i32>> {
        let mut conn = self.pool.acquire().await?;
        let rows: Vec<(i32,)> = sqlx::query_as("SELECT tag FROM leaf_alloc")
            .fetch_all(&mut conn)
            .await?;
        Ok(rows.into_iter().map(|row| row.0).collect())
    }

    async fn update_max(&self, tag: i32) -> Result<Leaf> {
        let mut conn = self.pool.acquire().await?;
        sqlx::query("UPDATE leaf_alloc SET max_id = max_id + step WHERE tag = ?")
            .bind(tag)
            .execute(&mut conn)
            .await?;
        self.get_leaf(tag).await
    }

    async fn update_max_by_step(&self, tag: i32, step: i32) -> Result<Leaf> {
        let mut conn = self.pool.acquire().await?;
        sqlx::query("UPDATE leaf_alloc SET max_id = max_id + ? WHERE tag = ?")
            .bind(step)
            .bind(tag)
            .execute(&mut conn)
            .await?;
        self.get_leaf(tag).await
    }
}

impl MySqlLeafDao {
    pub async fn new(db_url: &str) -> Result<Self> {
        Ok(Self {
            pool: MySqlPool::new(db_url).await?,
        })
    }

    pub async fn create_table(&self) -> Result<()> {
        let mut conn = self.pool.acquire().await?;
        sqlx::query(
            r#"CREATE TABLE leaf_alloc (
                    tag INT PRIMARY KEY,
                    max_id INT NOT NULL,
                    step INT NOT NULL
                )"#,
        )
        .execute(&mut conn)
        .await?;
        Ok(())
    }
}