ormer 0.2.8

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

#![cfg(feature = "postgresql")]

pub mod _test_common;

#[derive(Debug, Clone, ormer::Model)]
#[table = "test_postgresql_null_binary_params"]
struct NullableBinary {
    #[primary]
    id: i32,
    payload: Option<Vec<u8>>,
}

#[tokio::test]
async fn test_insert_or_ignore_null_binary_param() -> Result<(), Box<dyn std::error::Error>> {
    let config = _test_common::postgresql_config();
    let db = _test_common::create_db_connection(&config).await?;
    let _ = db.drop_table::<NullableBinary>().execute().await;

    let sql = ormer::generate_create_table_sql::<NullableBinary>(config.0)?;
    assert!(sql.contains("payload BYTEA"));

    db.create_table::<NullableBinary>().execute().await?;
    db.validate_table::<NullableBinary>().await?;

    db.insert_or_ignore(&NullableBinary {
        id: 1,
        payload: None,
    })
    .execute()
    .await?;

    let items = db.select::<NullableBinary>().collect::<Vec<_>>().await?;
    assert_eq!(items.len(), 1);
    assert_eq!(items[0].payload, None);

    db.drop_table::<NullableBinary>().execute().await?;
    Ok(())
}