ormer 0.2.9

A minimalist ORM framework that supports SQLite, PostgreSQL, MySQL, and SqlServer
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

#![cfg(any(feature = "sqlite", feature = "postgresql", feature = "mysql"))]

pub mod _test_common;

#[derive(Debug, Clone, ormer::Model)]
#[table = "test_duration_field_1"]
struct DurationFieldModel {
    #[primary]
    id: i32,
    duration: std::time::Duration,
}

async fn test_duration_sql_type_impl(
    config: &_test_common::DbConfig,
) -> Result<(), Box<dyn std::error::Error>> {
    let sql = ormer::generate_create_table_sql::<DurationFieldModel>(config.0)?;
    println!("SQL: {}", sql);

    match config.0 {
        #[cfg(feature = "sqlite")]
        ormer::DbType::Sqlite => {
            assert!(sql.contains("duration INTEGER NOT NULL"));
        }
        #[cfg(feature = "postgresql")]
        ormer::DbType::PostgreSQL => {
            assert!(sql.contains("duration INTERVAL NOT NULL"));
        }
        #[cfg(feature = "mysql")]
        ormer::DbType::MySQL => {
            assert!(sql.contains("duration BIGINT NOT NULL"));
        }
        #[cfg(feature = "mssql")]
        ormer::DbType::MSSQL => {
            assert!(sql.contains("duration BIGINT NOT NULL"));
        }
        #[cfg(feature = "duckdb")]
        ormer::DbType::DuckDB => {}
        #[cfg(feature = "clickhouse")]
        ormer::DbType::ClickHouse => {}
    }

    Ok(())
}

#[test]
fn duration_value_roundtrip() {
    let duration = std::time::Duration::from_millis(1234);
    let value = ormer::Value::from(duration);
    let decoded = <std::time::Duration as ormer::FromValue>::from_value(&value).unwrap();
    assert_eq!(decoded, duration);
}

test_on_all_dbs_result!(test_duration_sql_type_impl);