shindo_coding_utils 0.3.9

A utils crates which will be used in various micro-services
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
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124

use async_stream::stream;
use async_trait::async_trait;
use futures::Stream;
use sea_orm::{
    ColumnTrait, DatabaseConnection, DbErr, EntityTrait, PaginatorTrait, QueryFilter, QueryOrder,
};
use std::pin::Pin;
use std::sync::Arc;

use crate::models::StockMarket;
use crate::schemas::stock_market_schema::{
    self as stock_market_schema, Entity as StockMarketEntity, Model as StockMarketModel,
};

#[async_trait]
pub trait StockMarketRepository: Send + Sync {
    fn get_tickers_by_cursor_stream(
        &self,
        cursor: Option<String>,
        limit: u64,
    ) -> Pin<Box<dyn Stream<Item = Result<StockMarket, DbErr>> + Send>>;

    async fn get_all_tickers(&self) -> Result<Vec<StockMarket>, DbErr>;

    async fn get_all_tickers_by_cursor(&self, ticker: String) -> Result<Vec<StockMarket>, DbErr>;
}

pub struct SeaOrmStockMarketRepository {
    db_conn: Arc<DatabaseConnection>,
}

impl SeaOrmStockMarketRepository {
    pub fn new(db_conn: Arc<DatabaseConnection>) -> Self {
        Self { db_conn }
    }
}

#[async_trait]
impl StockMarketRepository for SeaOrmStockMarketRepository {
    async fn get_all_tickers(&self) -> Result<Vec<StockMarket>, DbErr> {
        let db = self.db_conn.clone();
        let models = StockMarketEntity::find()
            .order_by_asc(stock_market_schema::Column::Ticker)
            .all(&*db)
            .await?;
        Ok(models
            .into_iter()
            .map(|m| StockMarket {
                ticker: m.ticker,
                market: m.market_name,
                stock_type: m.stock_type,
            })
            .collect())
    }

    async fn get_all_tickers_by_cursor(&self, ticker: String) -> Result<Vec<StockMarket>, DbErr> {
        let db = self.db_conn.clone();
        let models = StockMarketEntity::find()
            .filter(stock_market_schema::Column::Ticker.gte(ticker))
            .order_by_asc(stock_market_schema::Column::Ticker)
            .all(&*db)
            .await?;
        Ok(models
            .into_iter()
            .map(|m| StockMarket {
                ticker: m.ticker,
                market: m.market_name,
                stock_type: m.stock_type,
            })
            .collect())
    }

    fn get_tickers_by_cursor_stream(
        &self,
        cursor: Option<String>,
        limit: u64,
    ) -> Pin<Box<dyn Stream<Item = Result<StockMarket, DbErr>> + Send>> {
        let db = self.db_conn.clone();

        Box::pin(stream! {
            let mut query = StockMarketEntity::find()
                .order_by_asc(stock_market_schema::Column::Ticker);

            if let Some(c) = cursor {
                query = query.filter(stock_market_schema::Column::Ticker.gte(c));
            }

            let mut paginator = query.paginate(&*db, limit);

            loop {
                match paginator.fetch_and_next().await {
                    Ok(Some(tickers)) => {
                        for model in tickers {
                            yield Ok(StockMarket {
                                ticker: model.ticker,
                                market: model.market_name,
                                stock_type: model.stock_type,
                            });
                        }
                    }
                    Ok(None) => {
                        // End of stream, break the loop
                        break;
                    }
                    Err(e) => {
                        // Yield the database error and break the loop
                        yield Err(e);
                        break;
                    }
                }
            }
        })
    }
}

impl From<StockMarketModel> for StockMarket {
    fn from(model: StockMarketModel) -> Self {
        Self {
            ticker: model.ticker,
            market: model.market_name,
            stock_type: model.stock_type,
        }
    }
}