Add database conversion for bridge types

1 files changed, 43 insertions, 2 deletions

diff --git a/server/tests/db_test.rs b/server/tests/db_test.rs
index 6acc21e..e495d78 100644
--- a/server/tests/db_test.rs
+++ b/server/tests/db_test.rs
@@ -1,3 +1,4 @@
+use protocol::card::{Rank, Suit};
 use sqlx::Row;
 use tracing::info;
 
@@ -8,7 +9,47 @@ mod common;
 async fn basic_db_query() -> Result<(), anyhow::Error> {
     let db = common::TestDb::new().await;
     let db = db.db();
-    let number = sqlx::query!(r#"select 1 + 1 as number"#).fetch_one(&db).await?;
-    assert_eq!(number.number, Some(2));
+    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(())
 }