O01eg/freeorion-test-web - Change YUFPADNOF6YVVG7HWMHSAZOQGQJKNWIACI3AS3756MKGZT3P75EQC

Add team info to slow game page data

Created by O01eg on May 9, 2023

YUFPADNOF6YVVG7HWMHSAZOQGQJKNWIACI3AS3756MKGZT3P75EQC

Dependencies

In channels

main

Change contents

Replacement in src/pages/slow_game.rs at line 7 [5.625]

B:BD[5.746] → [6.50:127]

use crate::pages::{insert_security_headers, request_to_jar, CommonAuthInfo};

[5.746]

[7.0]

use crate::pages::{insert_security_headers, naive_to_text, request_to_jar, CommonAuthInfo};

Insertion in src/pages/slow_game.rs at line 20 [5.625]
[8.207]
[9.115]
```
    team_id: i32,
    create_ts: Option<String>,
```
Insertion in src/pages/slow_game.rs at line 62 [5.625]
[10.350]
[11.0]
```
    is_teamed: bool,
```

Replacement in src/pages/slow_game.rs at line 114 [5.625]

B:BD[5.1441] → [12.321:676]

    let stmt = match dbclient.prepare("select g.status::text, g.notes_html, g.fo_forum_url, (select count(*) from games.players p where p.game_uid = g.game_uid and p.client_type = 'p'), MIN(t.turn_ts), MAX(t.turn_ts), COUNT(t.turn) from games.games g left join games.turns t on t.game_uid = g.game_uid where g.game_uid = $1 group by g.game_uid;").await {

[5.1441]

[5.1790]

    let stmt = match dbclient.prepare("select g.status::text, g.notes_html, g.fo_forum_url, g.is_teamed, (select count(*) from games.players p where p.game_uid = g.game_uid and p.client_type = 'p'), MIN(t.turn_ts), MAX(t.turn_ts), COUNT(t.turn) from games.games g left join games.turns t on t.game_uid = g.game_uid where g.game_uid = $1 group by g.game_uid;").await {

Replacement in src/pages/slow_game.rs at line 144 [5.625]

B:BD[11.902] → [11.902:954]

        .get::<_, Option<chrono::NaiveDateTime>>(4)

[11.902]

[11.954]

        .get::<_, Option<chrono::NaiveDateTime>>(5)

Replacement in src/pages/slow_game.rs at line 147 [5.625]

B:BD[11.1025] → [11.1025:1077]

        .get::<_, Option<chrono::NaiveDateTime>>(5)

[11.1025]

[11.1077]

        .get::<_, Option<chrono::NaiveDateTime>>(6)

Replacement in src/pages/slow_game.rs at line 179 [5.625]

B:BD[13.1435] → [13.1435:1636]

        let stmt = match dbclient.prepare("select p.player_name, p.delegate_name, p.player_name = $2, p.delegate_name = $2 from games.players p where p.game_uid = $1 and p.client_type = 'p';").await {

[13.1435]

[13.1636]

        let stmt = match dbclient.prepare("select p.player_name, p.team_id, p.create_ts, p.delegate_name, p.player_name = $2, p.delegate_name = $2 from games.players p where p.game_uid = $1 and p.client_type = 'p';").await {

Replacement in src/pages/slow_game.rs at line 197 [5.625]

B:BD[14.159] → [14.159:224]

∅:D[14.224] → [9.331:386]

B:BD[15.980] → [9.331:386]

B:BD[9.386] → [16.949:1031]

            let delegate_name = row.get::<_, Option<String>>(1);
            let player_itself = row.get::<_, bool>(2);
            let delegate_itself = row.get::<_, Option<bool>>(3).unwrap_or(false);

[14.159]

[2.0]

            let team_id = row.get::<_, i32>(1);
            let create_ts = row
                .get::<_, Option<chrono::NaiveDateTime>>(2)
                .map(naive_to_text);
            let delegate_name = row.get::<_, Option<String>>(3);
            let player_itself = row.get::<_, bool>(4);
            let delegate_itself = row.get::<_, Option<bool>>(5).unwrap_or(false);

Insertion in src/pages/slow_game.rs at line 305 [5.625]
[14.1697]
[14.1697]
```
                team_id,
```
Insertion in src/pages/slow_game.rs at line 312 [5.625]
[13.2390]
[8.343]
```
                create_ts,
```

Replacement in src/pages/slow_game.rs at line 340 [5.625]

B:BD[3.33] → [3.33:175]

        let stmt = match dbclient.prepare("select p.player_name from games.players p where p.game_uid = $1 and p.client_type = 'p';").await {

[3.33]

[3.175]

        let stmt = match dbclient.prepare("select p.player_name, p.team_id from games.players p where p.game_uid = $1 and p.client_type = 'p';").await {

Insertion in src/pages/slow_game.rs at line 358 [5.625]
[3.837]
[3.837]
```
                team_id: row.get::<_, i32>(1),
```
Insertion in src/pages/slow_game.rs at line 365 [5.625]
[3.1080]
[3.1080]
```
                create_ts: None,
```

Replacement in src/pages/slow_game.rs at line 385 [5.625]

B:BD[17.197] → [18.47:90]

            players: row.get::<_, i64>(3),

[17.197]

[11.1124]

            is_teamed: row.get::<_, bool>(3),
            players: row.get::<_, i64>(4),

Replacement in src/pages/slow_game.rs at line 389 [5.625]
∅:D[11.1248] → [19.845:886]
B:BD[19.845] → [19.845:886]
```
            turns: row.get::<_, i64>(6),
```
[11.1248]
[20.1007]
```
            turns: row.get::<_, i64>(7),
```

Replacement in src/pages/my.rs at line 5 [21.979]

B:BD[21.1092] → [21.1092:1169]

use crate::pages::{insert_security_headers, request_to_jar, CommonAuthInfo};

[21.1092]

[21.1169]

use crate::pages::{insert_security_headers, naive_to_text, request_to_jar, CommonAuthInfo};

Deletion in src/pages/my.rs at line 32 [21.979]

B:BD[4.779] → [4.779:960]

}
fn naive_to_text(ts: chrono::NaiveDateTime) -> String {
    chrono::DateTime::<chrono::Utc>::from_utc(ts, chrono::Utc)
        .format("%Y %b %d %H:%M UTC")
        .to_string()

Insertion in src/pages/mod.rs at line 95 [24.50]

[22.1941]

[23.834]

}
pub fn naive_to_text(ts: chrono::NaiveDateTime) -> String {
    chrono::DateTime::<chrono::Utc>::from_utc(ts, chrono::Utc)
        .format("%Y %b %d %H:%M UTC")
        .to_string()

Add team info to slow game page data

Dependencies

In channels

Change contents

Replacement in src/pages/slow_game.rs at line 7 [5.625]

Insertion in src/pages/slow_game.rs at line 20 [5.625]

Insertion in src/pages/slow_game.rs at line 62 [5.625]

Replacement in src/pages/slow_game.rs at line 114 [5.625]

Replacement in src/pages/slow_game.rs at line 144 [5.625]

Replacement in src/pages/slow_game.rs at line 147 [5.625]

Replacement in src/pages/slow_game.rs at line 179 [5.625]

Replacement in src/pages/slow_game.rs at line 197 [5.625]

Insertion in src/pages/slow_game.rs at line 305 [5.625]

Insertion in src/pages/slow_game.rs at line 312 [5.625]

Replacement in src/pages/slow_game.rs at line 340 [5.625]

Insertion in src/pages/slow_game.rs at line 358 [5.625]

Insertion in src/pages/slow_game.rs at line 365 [5.625]

Replacement in src/pages/slow_game.rs at line 385 [5.625]

Replacement in src/pages/slow_game.rs at line 389 [5.625]

Replacement in src/pages/my.rs at line 5 [21.979]

Deletion in src/pages/my.rs at line 32 [21.979]

Insertion in src/pages/mod.rs at line 95 [24.50]