Add custom notes to new games feed

O01eg

Apr 21, 2022, 7:57 PM

FVYTV3D2AJ5SHXNN3HELIWSI5G7CR3WP45D5J6HMT5WOVKALQDKQC

Dependencies

• [2] AKZRCLIW Copy Atom templates
• [3] NLEIFOAG Add dependency to send mails
• [4] WXRGEQOE Add HTTP client dependency
• [5] HZDCKIXQ Use constants for templates
• [6] 3JLRYVG2 Fix base URL for Atoms
• [7] CMA5SKJ3 Copy turns Atom generator
• [8] EY5VZOAO Update dependencies
• [9] BCXEUKX6 Add config, static files and web server
• [10] 556ZESEO Add RSS for new games
• [11] XMUKNMKY Prepare for release
• [12] IM5ZPD4N Update dependencies
• [13] WVHXYKCV Add postgresql pools
• [14] 72WRIXYS Update dependencies
• [15] 7R6HAATP Optional publish static files if use reverse-proxy
• [*] 4MZ4VIR7 Initial commit
• [*] HTYEGVBU Add data to reset password page
• [*] ZE5UFPX4 Add TTL cache for CSRF

Change contents

• replacement in src/templates/games.xml at line 13
  [2.1216]→[2.1216:1294](∅→∅)
  − <id>urn:freeorion-new-game:{{ entry.gameuidenc }}:{{ entry.start_ts }}</id>
  [2.1216]

  [2.1294]
  + <id>urn:freeorion-new-game:{{ entry.gameuidenc }}:{{ entry.start_ts }}:{{ entry.notes_summ }}</id>
• replacement in src/templates/games.xml at line 16
  [2.1403]→[2.1403:1445](∅→∅)
  − <content>Don't miss new game!</content>
  [2.1403]

  [2.1445]
  + <summary>Don't miss new {{ entry.gameuid }} game!</summary>

  + <content type="html">

  + {{ entry.notes }}

  + </content>
• edit in src/pages/atom_games.rs at line 20
  [5.466]

  [5.466]
  + notes_summ: String,

  + notes: String,
• replacement in src/pages/atom_games.rs at line 34
  [5.827]→[5.827:1051](∅→∅)
  − let stmt = match dbclient.prepare("select g.game_uid, g.start_ts, g.fo_forum_url, g.create_ts from games.games g where g.create_ts IS NOT NULL and g.fo_forum_url IS NOT NULL order by g.create_ts desc limit 50;").await {
  [5.827]

  [5.1051]
  + let stmt = match dbclient.prepare("select g.game_uid, g.start_ts, g.fo_forum_url, g.create_ts, g.notes_html from games.games g where g.create_ts IS NOT NULL and g.fo_forum_url IS NOT NULL AND g.notes_html IS NOT NULL order by g.create_ts desc limit 50;").await {
• replacement in src/pages/atom_games.rs at line 60
  [5.1794]→[5.1794:1844](∅→∅)
  − let fo_forum_url = row.get::<_, &str>(2);
  [5.1794]

  [5.1844]
  + let fo_forum_url = row.get::<_, String>(2);
• edit in src/pages/atom_games.rs at line 63
  [5.1961]

  [5.1961]
  + let notes = row.get::<_, String>(4);

  +

  + use sha2::Digest;

  + let mut hasher = sha2::Sha224::new();

  + hasher.update(notes.as_bytes());

  + let notes_summ = base64::encode_config(hasher.finalize(), base64::URL_SAFE_NO_PAD);
• edit in src/pages/atom_games.rs at line 70
  [5.1962]

  [5.1962]
  + log::info!("Notes: {}", notes);

  +
• replacement in src/pages/atom_games.rs at line 80
  [5.2344]→[5.2344:2400](∅→∅)
  − fo_forum_url: fo_forum_url.to_string(),
  [5.2344]

  [5.2400]
  + fo_forum_url,

  + notes,

  + notes_summ,
• edit in Cargo.toml at line 27
  [5.4054]

  [18.2575]
  + sha2 = "0.10.2"

  + base64 = "0.13.0"
• replacement in Cargo.lock at line 459
  [5.17200]→[5.4856:4874](∅→∅)
  − version = "3.1.8"
  [5.17200]

  [5.17219]
  + version = "3.1.10"
• replacement in Cargo.lock at line 461
  [5.17284]→[5.4875:4953](∅→∅)
  − checksum = "71c47df61d9e16dc010b55dba1952a57d8c215dbb533fd13cdd13369aac73b1c"
  [5.17284]

  [5.17362]
  + checksum = "3124f3f75ce09e22d1410043e1e24f2ecc44fad3afe4f08408f1f7663d68da2b"
• edit in Cargo.lock at line 465
  [5.17415]

  [5.4021]
  + "clap_lex",
• edit in Cargo.lock at line 467
  [5.4034]→[5.4034:4051](∅→∅)
  − "os_str_bytes",
• edit in Cargo.lock at line 470
  [5.17439]

  [5.17469]
  + ]

  +

  + [[package]]

  + name = "clap_lex"

  + version = "0.1.1"

  + source = "registry+https://github.com/rust-lang/crates.io-index"

  + checksum = "189ddd3b5d32a70b35e7686054371742a937b0d99128e76dde6340210e966669"

  + dependencies = [

  + "os_str_bytes",
• edit in Cargo.lock at line 686
  [4.1000]

  [5.4414]
  + "base64",
• edit in Cargo.lock at line 697
  [5.20545]

  [19.420]
  + "sha2",
• replacement in Cargo.lock at line 1022
  [5.24897]→[5.311:331](∅→∅)
  − version = "0.2.123"
  [5.24897]

  [5.8299]
  + version = "0.2.124"
• replacement in Cargo.lock at line 1024
  [5.8364]→[5.332:410](∅→∅)
  − checksum = "cb691a747a7ab48abc15c5b42066eaafde10dc427e3b6ee2a1cf43db04c763bd"
  [5.8364]

  [5.8442]
  + checksum = "21a41fed9d98f27ab1c6d161da622a4fa35e8a54a8adc24bbf3ddd0ef70b0e50"
• edit in Cargo.lock at line 1230
  [5.10015]→[5.10015:10045](∅→∅)
  − dependencies = [

  − "memchr",

  − ]
• replacement in Cargo.lock at line 1862
  [5.39777]→[5.39777:39795](∅→∅)
  − version = "0.5.8"
  [5.39777]

  [5.39795]
  + version = "0.5.9"
• replacement in Cargo.lock at line 1864
  [5.39860]→[5.39860:39938](∅→∅)
  − checksum = "a31142970826733df8241ef35dc040ef98c679ab14d7c3e54d827099b3acecaa"
  [5.39860]

  [5.39938]
  + checksum = "8d82e1a7758622a465f8cee077614c73484dac5b836c02ff6a40d5d1010324d7"
• replacement in Cargo.lock at line 1871
  [5.39997]→[5.803:822](∅→∅)
  − version = "0.1.33"
  [5.39997]

  [5.40016]
  + version = "0.1.34"
• replacement in Cargo.lock at line 1873
  [5.40081]→[5.823:901](∅→∅)
  − checksum = "80b9fa4360528139bc96100c160b7ae879f5567f49f1782b0b02035b0358ebf3"
  [5.40081]

  [5.40159]
  + checksum = "5d0ecdcb44a79f0fe9844f0c4f33a342cbcbb5117de8001e6ba0dc2351327d09"
• replacement in Cargo.lock at line 1895
  [5.40262]→[3.3278:3297](∅→∅)
  − version = "0.1.25"
  [5.40262]

  [5.40281]
  + version = "0.1.26"
• replacement in Cargo.lock at line 1897
  [5.40346]→[3.3298:3376](∅→∅)
  − checksum = "6dfce9f3241b150f36e8e54bb561a742d5daa1a47b5dd9a5ce369fd4a4db2210"
  [5.40346]

  [5.40424]
  + checksum = "f54c8ca710e81886d498c2fd3331b56c93aa248d49de2222ad2742247c60072f"