import db from './db.js';

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;');
const newGameStatement = db.prepare('INSERT INTO games (player1, player2, data) VALUES (?, ?, ?);');

export function getGame(id) {
	try {
		return getGameStatement.get(id);
	} catch (err) {
		return null;
	}
}

export function listGames(userId) {
	try {
		return listGamesStatement.all({ 1: userId });
	} catch (err) {
		console.log(err);
		return [];
	}
}

export function newGame(player1, player2, data) {
	try {
		return newGameStatement.run(player1, player2, JSON.stringify(data)).lastInsertRowid;
	} catch (err) {
		return null;
	}
}