aboutsummaryrefslogtreecommitdiff
path: root/planetwars-server/src/db
diff options
context:
space:
mode:
authorIlion Beyst <ilion.beyst@gmail.com>2022-07-04 20:16:42 +0200
committerIlion Beyst <ilion.beyst@gmail.com>2022-07-04 20:16:42 +0200
commit268e080ec1b11e75309c3b134e16cf6ea7004ac6 (patch)
tree6cf54c91b4575494f1f2c2feb7790aadae817eb7 /planetwars-server/src/db
parentbbed87755419f97b0ee8967617af0c6573c168af (diff)
parent7a3b801f58752a78b65e3e7e7b998b6479f980f7 (diff)
downloadplanetwars.dev-268e080ec1b11e75309c3b134e16cf6ea7004ac6.tar.xz
planetwars.dev-268e080ec1b11e75309c3b134e16cf6ea7004ac6.zip
Merge branch 'bot-api' into next
Diffstat (limited to 'planetwars-server/src/db')
-rw-r--r--planetwars-server/src/db/matches.rs18
1 files changed, 12 insertions, 6 deletions
diff --git a/planetwars-server/src/db/matches.rs b/planetwars-server/src/db/matches.rs
index dfff3cf..54fd113 100644
--- a/planetwars-server/src/db/matches.rs
+++ b/planetwars-server/src/db/matches.rs
@@ -25,7 +25,7 @@ pub struct NewMatchPlayer {
/// player id within the match
pub player_id: i32,
/// id of the bot behind this player
- pub code_bundle_id: i32,
+ pub code_bundle_id: Option<i32>,
}
#[derive(Queryable, Identifiable)]
@@ -44,11 +44,11 @@ pub struct MatchBase {
pub struct MatchPlayer {
pub match_id: i32,
pub player_id: i32,
- pub code_bundle_id: i32,
+ pub code_bundle_id: Option<i32>,
}
pub struct MatchPlayerData {
- pub code_bundle_id: i32,
+ pub code_bundle_id: Option<i32>,
}
pub fn create_match(
@@ -92,7 +92,10 @@ pub fn list_matches(conn: &PgConnection) -> QueryResult<Vec<FullMatchData>> {
let matches = matches::table.get_results::<MatchBase>(conn)?;
let match_players = MatchPlayer::belonging_to(&matches)
- .inner_join(code_bundles::table)
+ .left_join(
+ code_bundles::table
+ .on(match_players::code_bundle_id.eq(code_bundles::id.nullable())),
+ )
.left_join(bots::table.on(code_bundles::bot_id.eq(bots::id.nullable())))
.load::<FullMatchPlayerData>(conn)?
.grouped_by(&matches);
@@ -120,7 +123,7 @@ pub struct FullMatchData {
// #[primary_key(base.match_id, base::player_id)]
pub struct FullMatchPlayerData {
pub base: MatchPlayer,
- pub code_bundle: CodeBundle,
+ pub code_bundle: Option<CodeBundle>,
pub bot: Option<Bot>,
}
@@ -142,7 +145,10 @@ pub fn find_match(id: i32, conn: &PgConnection) -> QueryResult<FullMatchData> {
let match_base = matches::table.find(id).get_result::<MatchBase>(conn)?;
let match_players = MatchPlayer::belonging_to(&match_base)
- .inner_join(code_bundles::table)
+ .left_join(
+ code_bundles::table
+ .on(match_players::code_bundle_id.eq(code_bundles::id.nullable())),
+ )
.left_join(bots::table.on(code_bundles::bot_id.eq(bots::id.nullable())))
.load::<FullMatchPlayerData>(conn)?;