Implemented game creation

1 files changed, 14 insertions, 11 deletions

diff --git a/database/games.js b/database/games.js
index b378eb2..dae3ce6 100644
--- a/database/games.js
+++ b/database/games.js
@@ -1,21 +1,14 @@
 import db from "./db.js";
 
-const createGameStatement = db.prepare("INSERT INTO games (player1, player2, data) VALUES (?, ?, ?);");
 const getGameStatement = db.prepare("SELECT * from games where id = ?;");
 const listGamesStatement = db.prepare("SELECT * from games where player1 = ?1 OR player2 = ?1 ORDER BY last_move_at;");
-
-export function createGame(player1, player2, data) {
-	try {
-		return createGameStatement.run(player1, player2, data).lastInsertRowId;
-	} catch {
-		return null;
-	}
-}
+const newGameStatement = db.prepare("INSERT INTO games (player1, player2, data) VALUES (?, ?, ?);");
 
 export function getGame(id) {
 	try {
 		return getGameStatement.get(id);
-	} catch {
+	} catch (err) {
+		console.log(err);
 		return null;
 	}
 }
@@ -23,7 +16,17 @@ export function getGame(id) {
 export function listGames(userId) {
 	try {
 		return listGamesStatement.all({ 1: userId });
-	} catch {
+	} catch (err) {
+		console.log(err);
 		return [];
 	}
 }
+
+export function newGame(player1, player2, data) {
+	try {
+		return newGameStatement.run(player1, player2, JSON.stringify(data)).lastInsertRowid;
+	} catch (err) {
+		console.log(err);
+		return null;
+	}
+}