blob: f635ad5a5e8e75866aef3affef69c8a9029a5687 (
plain)
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
|
use protocol::card::{Rank, Suit};
mod common;
#[tokio::test]
#[ignore]
async fn basic_db_query() -> Result<(), anyhow::Error> {
let db = common::TestDb::new().await;
let db = db.db();
let row = sqlx::query!(r#"select 1 + 1 as number"#)
.fetch_one(&db)
.await?;
assert_eq!(row.number, Some(2));
Ok(())
}
#[tokio::test]
#[ignore]
async fn rank_type_conversion() -> Result<(), anyhow::Error> {
let db = common::TestDb::new().await;
let db = db.db();
let row = sqlx::query!(r#"select cast (2 as rank) as "rank!: Rank""#)
.fetch_one(&db)
.await?;
assert_eq!(Rank::Two, row.rank);
let rank = Rank::Ace;
let (equal,): (bool,) = sqlx::query_as(r#"select ($1 is not distinct from 14)"#)
.bind(rank)
.fetch_one(&db)
.await?;
assert!(equal);
Ok(())
}
#[tokio::test]
#[ignore]
async fn suit_type_conversion() -> Result<(), anyhow::Error> {
let db = common::TestDb::new().await;
let db = db.db();
let row = sqlx::query!(r#"select cast ('heart' as suit) as "suit!: Suit""#)
.fetch_one(&db)
.await?;
assert_eq!(Suit::Heart, row.suit);
let suit = Suit::Spade;
let (equal,): (bool,) = sqlx::query_as(r#"select ($1 is not distinct from 'spade')"#)
.bind(suit)
.fetch_one(&db)
.await?;
assert!(equal);
Ok(())
}
|
