v2.0.0: reset plays audit to a generic per-game schema

2 files changed, 18 insertions, 17 deletions

diff --git a/src/server/core.rs b/src/server/core.rs
index 350fe18..7231577 100644
--- a/src/server/core.rs
+++ b/src/server/core.rs
@@ -259,16 +259,17 @@ impl ServerCore {
             .get("win_cells")
             .cloned()
             .unwrap_or_else(|| "-".to_string());
+        let details =
+            serde_json::to_string(&result.result_data).unwrap_or_else(|_| "{}".to_string());
 
-        match database::apply_spin(
+        match database::apply_play(
             &mut self.conn,
             &session_id,
             user,
             game_type,
             bet_amount,
             winnings,
-            &reels,
-            &win_type,
+            &details,
         ) {
             Ok(new_balance) => {
                 let _ = self.sessions.remove_session(&session_id);
diff --git a/src/server/database.rs b/src/server/database.rs
index f6c8872..2a1fc40 100644
--- a/src/server/database.rs
+++ b/src/server/database.rs
@@ -24,9 +24,8 @@ pub fn init_db(conn: &Connection) {
             game_type TEXT NOT NULL,
             bet_amount INTEGER NOT NULL,
             winnings INTEGER NOT NULL,
-            reels TEXT NOT NULL DEFAULT '',
-            win_type TEXT NOT NULL DEFAULT '',
             balance_after INTEGER NOT NULL,
+            details TEXT NOT NULL DEFAULT '{}',
             created_at DATETIME DEFAULT CURRENT_TIMESTAMP
         )",
         [],
@@ -111,20 +110,22 @@ pub fn get_balance(conn: &Connection, username: &str) -> Option<i64> {
     }
 }
 
-/// Settle one spin and record its audit row in a single transaction.
+/// Settle one play and record its audit row in a single transaction.
 ///
-/// Returns the balance after the spin. All SQL is parameterized: usernames
-/// are data, never part of the statement text.
+/// `details` is a JSON object with game-specific fields (reels, cards,
+/// winning number, crash point, ...). All SQL is parameterized: usernames are
+/// data, never part of the statement text.
+///
+/// Returns the balance after the play.
 #[allow(clippy::too_many_arguments)]
-pub fn apply_spin(
+pub fn apply_play(
     conn: &mut Connection,
     session_id: &str,
     username: &str,
     game_type: &str,
     bet_amount: i64,
     winnings: i64,
-    reels: &str,
-    win_type: &str,
+    details: &str,
 ) -> rusqlite::Result<i64> {
     let tx = conn.transaction()?;
 
@@ -150,18 +151,17 @@ pub fn apply_spin(
 
     tx.execute(
         "INSERT INTO plays
-            (session_id, username, game_type, bet_amount, winnings, reels,
-             win_type, balance_after)
-         VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8)",
+            (session_id, username, game_type, bet_amount, winnings,
+             balance_after, details)
+         VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7)",
         params![
             session_id,
             username,
             game_type,
             bet_amount,
             winnings,
-            reels,
-            win_type,
-            balance_after
+            balance_after,
+            details
         ],
     )?;