1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
/*
* This file is part of laurelin/api
* Copyright (C) 2023 Jonni Liljamo <jonni@liljamo.com>
*
* Licensed under GPL-3.0-only.
* See LICENSE for licensing information.
*/
use diesel::{BoolExpressionMethods, ExpressionMethods, PgConnection, QueryDsl, RunQueryDsl};
use laurelin_schema::schema::games;
use laurelin_shared::{error::api::APIError, types::game::Game};
use uuid::Uuid;
pub(crate) fn my_games(conn: &mut PgConnection, user_id: &str) -> Result<Vec<Game>, APIError> {
let games_res = games::table
.filter(
games::host_id
.eq(Uuid::parse_str(user_id).unwrap())
.or(games::guest_id.eq(Uuid::parse_str(user_id).unwrap())),
)
.load::<Game>(conn);
let games = match games_res {
Err(_) => return Err(APIError::Undefined), // TODO: new error type
Ok(games) => games,
};
Ok(games)
}