Add barebones db testing

1 files changed, 14 insertions, 0 deletions

diff --git a/server/tests/db_test.rs b/server/tests/db_test.rs
new file mode 100644
index 0000000..6acc21e
--- /dev/null
+++ b/server/tests/db_test.rs
@@ -0,0 +1,14 @@
+use sqlx::Row;
+use tracing::info;
+
+mod common;
+
+#[tokio::test]
+#[ignore]
+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));
+    Ok(())
+}