show only completed matches in match log

1 files changed, 3 insertions, 0 deletions

diff --git a/planetwars-server/src/db/matches.rs b/planetwars-server/src/db/matches.rs
index 86939be..2041296 100644
--- a/planetwars-server/src/db/matches.rs
+++ b/planetwars-server/src/db/matches.rs
@@ -141,6 +141,7 @@ fn fetch_full_match_data(
 pub fn list_matches(amount: i64, conn: &PgConnection) -> QueryResult<Vec<FullMatchData>> {
     conn.transaction(|| {
         let matches = matches::table
+            .filter(matches::state.eq(MatchState::Finished))
             .order_by(matches::created_at.desc())
             .limit(amount)
             .get_results::<MatchBase>(conn)?;
@@ -158,6 +159,7 @@ pub fn list_public_matches(
     conn.transaction(|| {
         // TODO: how can this common logic be abstracted?
         let query = matches::table
+            .filter(matches::state.eq(MatchState::Finished))
             .filter(matches::is_public.eq(true))
             .into_boxed();
 
@@ -175,6 +177,7 @@ pub fn list_bot_matches(
     conn: &PgConnection,
 ) -> QueryResult<Vec<FullMatchData>> {
     let query = matches::table
+        .filter(matches::state.eq(MatchState::Finished))
         .filter(matches::is_public.eq(true))
         .order_by(matches::created_at.desc())
         .inner_join(match_players::table)