{"header":{"message":"Implement query for delegation","description":null,"timestamp":"2022-10-22T15:07:17.972118806Z","authors":[{}]},"hash":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC","authors":[{"login":"O01eg","key":"6xbZsEkjnZZpiD9GashW1D8feyXEWg43TbWGcJeUX1KQ"}],"deps":{"hashes":[["JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC","Implement query for delegation"],["AA",null],["YDWTHWAI7RPLW3KGM32J2JVUOSFTW4WOV3XPUMNTU3MDNGMQIOZAC","Show form to revoke delegation"],["D3RL62X5NQTWDZXMDHAXS7K5GSTCCEH7L3YT5JMTPWJON3WKRKUAC","Implement revoking delegation"],["5RQCVFRHI353OFKZPVCNJLJLQPEKJVNEDCTM2224U4WABT2YLMQQC","Start leave game form"],["OJO4B4QO2JQLMZTGTJJIXEUNDIN45RFLEJBUZBYA7IS34XDPUAVAC","Add login form and empty handler"],["WVHXYKCVPKAFVMXBEMD3IHG54RKOIDSOCVNR3OIPEZQG36IGYJZQC","Add postgresql pools"],["6NYILMKIHYQMGMCRZANU2FDO66DGINOMCX2J4JFTUI6VL3HZ6D5QC","Add page for slow game"],["LTQCLSBUUATO4LYIXEW6R2QF6EZ7ETGXGSHWXP2U3JQOTU7QQGSQC","Split database usage in pages"],["DNFB7TNICXFHRGPNZTT2I4VQNBPGVA2HQMUJWLNEPHF2M4SRZ3SQC","Add new pages and links to slow games and reset game password"],["WW3KRXX63EYWW4563QM3VSEN4PGCPR76KJQBYIKCKOCNMDG6JW4QC","Add page for reset game password"],["EVP2FSBHQUCAXQ6IIMBD6IS24ODKHP6HFWYCHIMYG6KOFRQG3RVQC","Split index page"],["NY766BOQIWOQUA44QDD7YKQB5GK735ZUJ3YNXXVUUE2VQZP2YWPQC","Accept form to add player"],["HZDCKIXQ3LCD7YPL7ZZBCRMD7YMKDJ2QAALETTG3FYMBF4TNFUBAC","Use constants for templates"],["B7PYGLH3IXJXPUF7XUBMESMSEH26MEINQJIVMBDDOY4RLT356K4AC","Show delegate bold if it's logged user itself"],["6BDGQ4VMUAGK5BTJAJVQOGTRHSUOQ5GRRUCZ3M6AVLWKCJNY52HAC","Show player names for registered players"],["TEB4R7OU65GZAGPNINWHOR4Q23OJYVUQK5RT75SV26W7JJEVT5DQC","Add form to join game"],["4MZ4VIR7FU3PQ3WKJI6TJIKYOIIBODFEPKLMQ32S4AKPZSDFO6AQC","Initial commit"],["IXY6NZLMLIDWQFPI2FBNF2PYJCM2TLNQIZKFUDLTTARHFWFQYCGQC","Start to use migrations files for PostgreSQL database"]],"deps":["YDWTHWAI7RPLW3KGM32J2JVUOSFTW4WOV3XPUMNTU3MDNGMQIOZAC","D3RL62X5NQTWDZXMDHAXS7K5GSTCCEH7L3YT5JMTPWJON3WKRKUAC"],"known":["OJO4B4QO2JQLMZTGTJJIXEUNDIN45RFLEJBUZBYA7IS34XDPUAVAC","EVP2FSBHQUCAXQ6IIMBD6IS24ODKHP6HFWYCHIMYG6KOFRQG3RVQC","WW3KRXX63EYWW4563QM3VSEN4PGCPR76KJQBYIKCKOCNMDG6JW4QC","WVHXYKCVPKAFVMXBEMD3IHG54RKOIDSOCVNR3OIPEZQG36IGYJZQC","HZDCKIXQ3LCD7YPL7ZZBCRMD7YMKDJ2QAALETTG3FYMBF4TNFUBAC","DNFB7TNICXFHRGPNZTT2I4VQNBPGVA2HQMUJWLNEPHF2M4SRZ3SQC","6NYILMKIHYQMGMCRZANU2FDO66DGINOMCX2J4JFTUI6VL3HZ6D5QC","LTQCLSBUUATO4LYIXEW6R2QF6EZ7ETGXGSHWXP2U3JQOTU7QQGSQC","NY766BOQIWOQUA44QDD7YKQB5GK735ZUJ3YNXXVUUE2VQZP2YWPQC","5RQCVFRHI353OFKZPVCNJLJLQPEKJVNEDCTM2224U4WABT2YLMQQC"]},"hunks":[{"Edit":{"inode":{"change":4,"pos":120},"path":"src/templates/slow-game.html","line":80,"atom":{"NewVertex":{"up_context":[{"change":15,"pos":680}],"down_context":[{"change":15,"pos":680}],"flag":"BLOCK","start":0,"end":672,"inode":{"change":4,"pos":120}}},"contents":[{"Add":{"text":" {{/if}}","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:19"}},{"Add":{"text":" {{#if player.query_delegate_data}}","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:66"}},{"Add":{"text":" ","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:671"}}]}},{"Edit":{"inode":{"change":4,"pos":625},"path":"src/pages/slow_game.rs","line":17,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":103}],"down_context":[{"change":16,"pos":207}],"flag":"BLOCK","start":673,"end":721,"inode":{"change":4,"pos":625}}},"contents":[{"Add":{"text":" query_delegate_data: Option,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:720"}}]}},{"Edit":{"inode":{"change":4,"pos":625},"path":"src/pages/slow_game.rs","line":22,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":272}],"down_context":[{"change":17,"pos":269}],"flag":"BLOCK","start":722,"end":811,"inode":{"change":4,"pos":625}}},"contents":[{"Add":{"text":" csrf: Uuid,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:737"}},{"Add":{"text":"}","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:739"}},{"Add":{"text":"","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:740"}},{"Add":{"text":"#[derive(serde_derive::Deserialize)]","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:777"}},{"Add":{"text":"pub struct QueryDelegationData {","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:810"}}]}},{"Edit":{"inode":{"change":4,"pos":625},"path":"src/pages/slow_game.rs","line":28,"atom":{"NewVertex":{"up_context":[{"change":17,"pos":285}],"down_context":[{"change":17,"pos":285}],"flag":"BLOCK","start":812,"end":839,"inode":{"change":4,"pos":625}}},"contents":[{"Add":{"text":" delegate_name: String,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:838"}}]}},{"Edit":{"inode":{"change":4,"pos":625},"path":"src/pages/slow_game.rs","line":192,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":1667}],"down_context":[{"change":16,"pos":253}],"flag":"BLOCK","start":840,"end":1447,"inode":{"change":4,"pos":625}}},"contents":[{"Add":{"text":" let query_delegate_data = if status.map_or(true, |x| x == \"started\")","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:920"}},{"Add":{"text":" && player_itself","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:953"}},{"Add":{"text":" && delegate_name.is_none()","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:996"}},{"Add":{"text":" {","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1010"}},{"Add":{"text":" let csrf = Uuid::new_v4();","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1053"}},{"Add":{"text":" let mut cache = data.cache_query_delegation_game.lock().await;","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1132"}},{"Add":{"text":" cache.insert(","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1162"}},{"Add":{"text":" csrf,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1188"}},{"Add":{"text":" (gameuid.clone(), user.to_lowercase()),","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1248"}},{"Add":{"text":" std::time::Duration::from_secs(data.cache_duration_sec),","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1325"}},{"Add":{"text":" );","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1344"}},{"Add":{"text":" Some(JoinLeaveData { csrf })","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1389"}},{"Add":{"text":" } else {","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1410"}},{"Add":{"text":" None","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1431"}},{"Add":{"text":" };","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1446"}}]}},{"Edit":{"inode":{"change":4,"pos":625},"path":"src/pages/slow_game.rs","line":213,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":1767}],"down_context":[{"change":16,"pos":343}],"flag":"BLOCK","start":1448,"end":1485,"inode":{"change":4,"pos":625}}},"contents":[{"Add":{"text":" query_delegate_data,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1484"}}]}},{"Edit":{"inode":{"change":4,"pos":625},"path":"src/pages/slow_game.rs","line":467,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":2140}],"down_context":[{"change":3,"pos":2140}],"flag":"BLOCK","start":1486,"end":2479,"inode":{"change":4,"pos":625}}},"contents":[{"Add":{"text":" }","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1491"}},{"Add":{"text":"","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1492"}},{"Add":{"text":" HttpResponse::Found()","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1518"}},{"Add":{"text":" .append_header((","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1543"}},{"Add":{"text":" header::LOCATION,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1573"}},{"Add":{"text":" format!(\"slow-game-{}.html\", cached_data.0),","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1630"}},{"Add":{"text":" ))","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1641"}},{"Add":{"text":" .finish()","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1659"}},{"Add":{"text":"}","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1661"}},{"Add":{"text":"","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1662"}},{"Add":{"text":"pub async fn post_query_delegate(","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1696"}},{"Add":{"text":" request: HttpRequest,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1722"}},{"Add":{"text":" form: web::Form,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1764"}},{"Add":{"text":" data: web::Data>,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1798"}},{"Add":{"text":" data_rw: web::Data,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1834"}},{"Add":{"text":") -> HttpResponse {","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1854"}},{"Add":{"text":" let cached_data = {","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1878"}},{"Add":{"text":" let mut cache = data.cache_query_delegation_game.lock().await;","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1949"}},{"Add":{"text":" cache.remove(&form.csrf)","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1982"}},{"Add":{"text":" };","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:1989"}},{"Add":{"text":" let cached_data = if let Some(cd) = cached_data {","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2043"}},{"Add":{"text":" cd","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2054"}},{"Add":{"text":" } else {","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2067"}},{"Add":{"text":" log::warn!(\"Unknown data for CSRF: {}\", form.csrf);","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2127"}},{"Add":{"text":" return HttpResponse::BadRequest().body(\"Incorrect\");","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2188"}},{"Add":{"text":" };","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2195"}},{"Add":{"text":"","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2196"}},{"Add":{"text":" let jar = request_to_jar(request);","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2235"}},{"Add":{"text":"","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2236"}},{"Add":{"text":" if jar","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2247"}},{"Add":{"text":" .private(&data.cookies_key)","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2283"}},{"Add":{"text":" .get(\"auth\")","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2304"}},{"Add":{"text":" .map_or(true, |x| x.value().to_lowercase() != cached_data.1)","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2373"}},{"Add":{"text":" {","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2379"}},{"Add":{"text":" log::warn!(\"Incorrect user\");","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2417"}},{"Add":{"text":" return HttpResponse::BadRequest().body(\"Incorrect\");","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2478"}}]}},{"Edit":{"inode":{"change":4,"pos":625},"path":"src/pages/slow_game.rs","line":505,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":2147}],"down_context":[{"change":3,"pos":2147}],"flag":"BLOCK","start":2480,"end":3500,"inode":{"change":4,"pos":625}}},"contents":[{"Add":{"text":" let dbclient_rw = match data_rw.0.get().await {","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2531"}},{"Add":{"text":" Ok(c) => c,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2551"}},{"Add":{"text":" Err(e) => {","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2571"}},{"Add":{"text":" log::error!(\"Pool RW error {}\", e);","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2619"}},{"Add":{"text":" return HttpResponse::ServiceUnavailable().body(actix_web::body::None::new());","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2709"}},{"Add":{"text":" }","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2719"}},{"Add":{"text":" };","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2726"}},{"Add":{"text":" let stmt = match dbclient_rw","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2759"}},{"Add":{"text":" .prepare(\"insert into games.query_delegation (game_uid, player_name, delegate_name) values ($1, $2, $3) on conflict do nothing;\")","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2897"}},{"Add":{"text":" .await","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2912"}},{"Add":{"text":" {","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2918"}},{"Add":{"text":" Ok(stmt) => stmt,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2944"}},{"Add":{"text":" Err(e) => {","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:2964"}},{"Add":{"text":" log::error!(\"Pool RW statement error {}\", e);","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3022"}},{"Add":{"text":" return HttpResponse::ServiceUnavailable().body(actix_web::body::None::new());","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3112"}},{"Add":{"text":" }","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3122"}},{"Add":{"text":" };","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3129"}},{"Add":{"text":" match dbclient_rw","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3151"}},{"Add":{"text":" .execute(","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3169"}},{"Add":{"text":" &stmt,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3188"}},{"Add":{"text":" &[&cached_data.0, &cached_data.1, &form.delegate_name],","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3256"}},{"Add":{"text":" )","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3266"}},{"Add":{"text":" .await","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3281"}},{"Add":{"text":" {","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3287"}},{"Add":{"text":" Ok(_) => (),","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3308"}},{"Add":{"text":" Err(e) => {","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3328"}},{"Add":{"text":" log::error!(\"Pool RW execute insert error {}\", e);","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3391"}},{"Add":{"text":" return HttpResponse::ServiceUnavailable().body(actix_web::body::None::new());","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3481"}},{"Add":{"text":" }","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3491"}},{"Add":{"text":" };","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3498"}},{"Add":{"text":"","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3499"}}]}},{"Edit":{"inode":{"change":4,"pos":50},"path":"src/pages/mod.rs","line":50,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":1643}],"down_context":[{"change":2,"pos":1815}],"flag":"BLOCK","start":3501,"end":3579,"inode":{"change":4,"pos":50}}},"contents":[{"Add":{"text":" pub cache_query_delegation_game: Mutex>,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3578"}}]}},{"Replacement":{"inode":{"change":18,"pos":17},"path":"src/main.rs","line":22,"ins":{"up_context":[{"change":4,"pos":1187}],"down_context":[{"change":4,"pos":2243}],"flag":"BLOCK","start":3580,"end":3698,"inode":{"change":18,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":1187},"to":{"change":3,"start":2317,"end":2407},"introduced_by":3}],"inode":{"change":18,"pos":17}},"ins_contents":[{"Add":{"text":"use pages::slow_game::{","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3603"}},{"Add":{"text":" post_join_game, post_leave_game, post_query_delegate, post_revoke_delegate, slow_game,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3694"}},{"Add":{"text":"};","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3697"}}],"del_contents":[{"Del":{"text":"use pages::slow_game::{post_join_game, post_leave_game, post_revoke_delegate, slow_game};","pos":"D3RL62X5NQTWDZXMDHAXS7K5GSTCCEH7L3YT5JMTPWJON3WKRKUAC:2406"}}]}},{"Edit":{"inode":{"change":18,"pos":17},"path":"src/main.rs","line":222,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":1806}],"down_context":[{"change":2,"pos":2055}],"flag":"BLOCK","start":3699,"end":3826,"inode":{"change":18,"pos":17}}},"contents":[{"Add":{"text":" cache_query_delegation_game: tokio::sync::Mutex::new(ttl_cache::TtlCache::new(","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3785"}},{"Add":{"text":" cache_capacity,","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3813"}},{"Add":{"text":" )),","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3825"}}]}},{"Edit":{"inode":{"change":18,"pos":17},"path":"src/main.rs","line":279,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":2488}],"down_context":[{"change":4,"pos":2328}],"flag":"BLOCK","start":3827,"end":3905,"inode":{"change":18,"pos":17}}},"contents":[{"Add":{"text":" .route(\"/query-delegate.do\", web::post().to(post_query_delegate))","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:3904"}}]}},{"FileAdd":{"meta":{"basename":"20221022_0_query_delegate.sql","metadata":0},"context":[{"change":19,"pos":15}],"contents":[{"Add":{"text":"-- Add table to store queries to delegation","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:4004"}},{"Add":{"text":"","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:4005"}},{"Add":{"text":"CREATE TABLE IF NOT EXISTS games.query_delegation (","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:4057"}},{"Add":{"text":" game_uid VARCHAR(20) REFERENCES games.games(game_uid),","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:4116"}},{"Add":{"text":" player_name CITEXT REFERENCES auth.users(player_name),","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:4175"}},{"Add":{"text":" delegate_name CITEXT REFERENCES auth.users(player_name), ","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:4237"}},{"Add":{"text":" CONSTRAINT pk_query_delegation PRIMARY KEY (game_uid, player_name, delegate_name)","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:4323"}},{"Add":{"text":");","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:4326"}},{"Add":{"text":"GRANT SELECT, INSERT, DELETE ON games.query_delegation TO freeorion;","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:4395"}},{"Add":{"text":"","pos":"JG2BQCRDWKCGVC56DCRBFCOXPHGT33LJ4FHWLIPOM64W6343D7CQC:4396"}}]}}],"owner":"O01eg","repo":"freeorion-test-web","token":"QCnsjoXBd5wDu4j/aEGJub75QE8Icd3GMtljo70fp8A=","login":null}

…

Dependencies

Change contents

Review