v3.2.0: straight and split bets anywhere on the felt; add history command

1 files changed, 27 insertions, 0 deletions

diff --git a/src/server/database.rs b/src/server/database.rs
index 6dd71a3..cfc48c1 100644
--- a/src/server/database.rs
+++ b/src/server/database.rs
@@ -399,3 +399,30 @@ fn abandoned_details(raw: &str) -> String {
     }
     value.to_string()
 }
+
+/// Most recent settled plays for a user, newest first.
+pub fn recent_plays(
+    conn: &Connection,
+    username: &str,
+    limit: u32,
+) -> rusqlite::Result<Vec<crate::history::PlayRecord>> {
+    let mut statement = conn.prepare(
+        "SELECT game_type, bet_amount, winnings, balance_after, details, created_at
+         FROM plays
+         WHERE username = ?1
+         ORDER BY created_at DESC, rowid DESC
+         LIMIT ?2",
+    )?;
+    let rows = statement.query_map(params![username, limit], |row| {
+        let details: String = row.get(4)?;
+        Ok(crate::history::PlayRecord {
+            game: row.get(0)?,
+            bet: row.get(1)?,
+            winnings: row.get(2)?,
+            balance_after: row.get(3)?,
+            at: row.get(5)?,
+            details: serde_json::from_str(&details).unwrap_or(serde_json::Value::Null),
+        })
+    })?;
+    rows.collect()
+}