nautilus_infrastructure/sql/models/
mod.rs

1// -------------------------------------------------------------------------------------------------
2//  Copyright (C) 2015-2026 Nautech Systems Pty Ltd. All rights reserved.
3//  https://nautechsystems.io
4//
5//  Licensed under the GNU Lesser General Public License Version 3.0 (the "License");
6//  You may not use this file except in compliance with the License.
7//  You may obtain a copy of the License at https://www.gnu.org/licenses/lgpl-3.0.en.html
8//
9//  Unless required by applicable law or agreed to in writing, software
10//  distributed under the License is distributed on an "AS IS" BASIS,
11//  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
12//  See the License for the specific language governing permissions and
13//  limitations under the License.
14// -------------------------------------------------------------------------------------------------
15
16//! SQL database model definitions and schemas.
17
18use std::fmt::Display;
19
20use sqlx::{Row, postgres::PgRow};
21
22pub mod accounts;
23pub mod data;
24pub mod enums;
25pub mod general;
26pub mod instruments;
27pub mod orders;
28pub mod positions;
29pub mod types;
30
31pub(crate) fn read_u8(row: &PgRow, column: &str) -> Result<u8, sqlx::Error> {
32    let value = row.try_get::<i32, _>(column)?;
33    i32_to_u8(value, column)
34}
35
36pub(crate) fn read_u16(row: &PgRow, column: &str) -> Result<u16, sqlx::Error> {
37    let value = row.try_get::<i32, _>(column)?;
38    i32_to_u16(value, column)
39}
40
41pub(crate) fn read_usize(row: &PgRow, column: &str) -> Result<usize, sqlx::Error> {
42    let value = row.try_get::<i32, _>(column)?;
43    i32_to_usize(value, column)
44}
45
46pub(crate) fn read_u64(row: &PgRow, column: &str) -> Result<u64, sqlx::Error> {
47    let value = row.try_get::<i64, _>(column)?;
48    i64_to_u64(value, column)
49}
50
51pub(crate) fn i64_to_u64(value: i64, label: &str) -> Result<u64, sqlx::Error> {
52    u64::try_from(value).map_err(|e| decode_error(label, value, e))
53}
54
55fn i32_to_u8(value: i32, label: &str) -> Result<u8, sqlx::Error> {
56    u8::try_from(value).map_err(|e| decode_error(label, value, e))
57}
58
59fn i32_to_u16(value: i32, label: &str) -> Result<u16, sqlx::Error> {
60    u16::try_from(value).map_err(|e| decode_error(label, value, e))
61}
62
63fn i32_to_usize(value: i32, label: &str) -> Result<usize, sqlx::Error> {
64    usize::try_from(value).map_err(|e| decode_error(label, value, e))
65}
66
67fn decode_error(label: &str, value: impl Display, error: impl Display) -> sqlx::Error {
68    sqlx::Error::Decode(format!("Invalid {label} value {value}: {error}").into())
69}
70
71#[cfg(test)]
72mod tests {
73    use rstest::rstest;
74
75    use super::{i32_to_u8, i32_to_u16, i32_to_usize, i64_to_u64};
76
77    #[rstest]
78    #[case::negative(-1, "Invalid price_precision value -1")]
79    #[case::too_large(i32::from(u8::MAX) + 1, "Invalid price_precision value 256")]
80    fn i32_to_u8_rejects_out_of_range(#[case] value: i32, #[case] expected: &str) {
81        let error = i32_to_u8(value, "price_precision").unwrap_err();
82
83        assert_decode_error_contains(&error, expected);
84    }
85
86    #[rstest]
87    #[case::negative(-1, "Invalid iso4217 value -1")]
88    #[case::too_large(i32::from(u16::MAX) + 1, "Invalid iso4217 value 65536")]
89    fn i32_to_u16_rejects_out_of_range(#[case] value: i32, #[case] expected: &str) {
90        let error = i32_to_u16(value, "iso4217").unwrap_err();
91
92        assert_decode_error_contains(&error, expected);
93    }
94
95    #[rstest]
96    fn i32_to_usize_rejects_negative_values() {
97        let error = i32_to_usize(-1, "step").unwrap_err();
98
99        assert_decode_error_contains(&error, "Invalid step value -1");
100    }
101
102    #[rstest]
103    fn i64_to_u64_rejects_negative_values() {
104        let error = i64_to_u64(-1, "duration_ns").unwrap_err();
105
106        assert_decode_error_contains(&error, "Invalid duration_ns value -1");
107    }
108
109    fn assert_decode_error_contains(error: &sqlx::Error, expected: &str) {
110        assert!(matches!(error, sqlx::Error::Decode(_)));
111        assert!(error.to_string().contains(expected));
112    }
113}
nautilus_infrastructure/sql/models/mod.rs

nautilus_infrastructure/sql/models/
mod.rs
