Add info about status of the game

O01eg

Sep 12, 2022, 7:58 AM

AMBIOSDGYNMPYZMXP75NX6TWVUJWYWOMKENYTZA72BG2FABV2QCAC

Dependencies

[2] 3GGMBQ2N Update dependencies and add list of slow games
[3] IXY6NZLM Start to use migrations files for PostgreSQL database
[4] EY5VZOAO Update dependencies
[5] K7FOI6UN Update dependencies and fix game link
[6] ZRU62WXD Send email with change game password link
[7] 556ZESEO Add RSS for new games
[8] WVHXYKCV Add postgresql pools
[9] BCXEUKX6 Add config, static files and web server
[10] DNFB7TNI Add new pages and links to slow games and reset game password
[11] WXRGEQOE Add HTTP client dependency
[12] CMA5SKJ3 Copy turns Atom generator
[13] FVYTV3D2 Add custom notes to new games feed
[14] DGGFYSEG Use non-escaped template for Atom XML
[15] NLEIFOAG Add dependency to send mails
[16] HZDCKIXQ Use constants for templates
[17] 72WRIXYS Update dependencies
[18] OWZ67OEC Add openssl dependency
[19] IM5ZPD4N Update dependencies
[20] XMUKNMKY Prepare for release
[21] OJO4B4QO Add login form and empty handler

Change contents

replacement in src/pages/slow_games.rs at line 28

[2.865]→[2.865:943](∅→∅)

.prepare("select g.game_uid from games.games g order by g.game_uid;")

[2.865]

[2.943]

.prepare("select g.game_uid, g.status::text from games.games g order by g.game_uid;")
edit in src/pages/slow_games.rs at line 50

[2.1516]

[2.1516]

let _status = row.get::<_, Option<&str>>(1);
file addition: 20220912_0_games-started-finished.sql (----------)

[3.15]

-- Add field to mark games as finished and started

DO $$
BEGIN
IF NOT EXISTS (
SELECT 1 FROM pg_type t
INNER JOIN pg_namespace p ON t.typnamespace=p.oid
WHERE t.typname='status' AND p.nspname='games'
) THEN
CREATE TYPE games.status AS ENUM ('started', 'finished');
END IF;

IF NOT EXISTS (
SELECT 1 FROM pg_class c
INNER JOIN pg_namespace n ON n.oid = c.relnamespace
INNER JOIN pg_attribute a ON a.attrelid = c.oid
WHERE c.relname = 'games' AND n.nspname = 'games' AND a.attname = 'status'
) THEN
ALTER TABLE games.games ADD COLUMN status games.status NULL;
END IF;
END
$$;
replacement in Cargo.lock at line 47

[4.9366]→[2.2031:2049](∅→∅)

version = "3.2.1"

[4.9366]

[4.9391]

version = "3.2.2"
replacement in Cargo.lock at line 49

[4.9456]→[2.2050:2128](∅→∅)

checksum = "6f9ffb6db08c1c3a1f4aef540f1a63193adc73c4fbd40b75a95fc8c5258f6e51"

[4.9456]

[4.9534]

checksum = "0c83abf9903e1f0ad9973cc4f7b9767fd5a03a583f51a5b7a339e07987cd2724"
replacement in Cargo.lock at line 174

[4.12130]→[2.2152:2170](∅→∅)

version = "4.1.0"

[4.12130]

[4.12155]

version = "4.2.0"
replacement in Cargo.lock at line 176

[4.12220]→[2.2171:2249](∅→∅)

checksum = "a27e8fe9ba4ae613c21f677c2cfaf0696c3744030c6f485b34634e502d6bb379"

[4.12220]

[4.12298]

checksum = "b482a38b5d7b97f9bd4b69e667b49c92634dbcde71b305d039c75dd63f526f56"
edit in Cargo.lock at line 196

[4.12571]

[4.559]

"http",
replacement in Cargo.lock at line 215

[4.12744]→[2.2267:2285](∅→∅)

version = "4.0.1"

[4.12744]

[4.12769]

version = "4.1.0"
replacement in Cargo.lock at line 217

[4.12834]→[2.2286:2364](∅→∅)

checksum = "5f270541caec49c15673b0af0e9a00143421ad4f118d2df7edcb68b627632f56"

[4.12834]

[4.12912]

checksum = "1fa9362663c8643d67b2d5eafba49e4cb2c8a053a29ed00a0bea121f17c76b13"
replacement in Cargo.lock at line 244

[4.13443]→[4.3148:3167](∅→∅)

version = "0.7.18"

[4.13443]

[4.13462]

version = "0.7.19"
replacement in Cargo.lock at line 246

[4.13527]→[4.3168:3246](∅→∅)

checksum = "1e37cfd5e7657ada45f742d6e99ca5788580b5c529dc78faf11ece6dc702656f"

[4.13527]

[4.13605]

checksum = "b4f55bd91a0978cbfd91c457a164bab8b4001c833b7f323132c0a4e1922dd44e"
replacement in Cargo.lock at line 253

[4.607]→[4.607:625](∅→∅)

version = "2.0.3"

[4.607]

[4.625]

version = "2.0.4"
replacement in Cargo.lock at line 255

[4.690]→[4.690:768](∅→∅)

checksum = "35ef4730490ad1c4eae5c4325b2a95f521d023e5c885853ff7aca0a6a1631db3"

[4.690]

[4.13635]

checksum = "cc7bb162ec39d46ab1ca8c77bf72e890535becd1751bb45f64c597edb4c8c6b3"
replacement in Cargo.lock at line 259

[4.791]→[4.791:809](∅→∅)

version = "0.2.1"

[4.791]

[4.809]

version = "0.2.2"
replacement in Cargo.lock at line 261

[4.874]→[4.874:952](∅→∅)

checksum = "697ed7edc0f1711de49ce108c541623a0af97c6c60b2f6e2b65229847ac843c2"

[4.874]

[4.952]

checksum = "94fb8275041c72129eb51b7d0322c29b8387a0386127718b096429201a5d6ece"
replacement in Cargo.lock at line 268

[2.2400]→[2.2400:2418](∅→∅)

version = "0.1.4"

[2.2400]

[2.2418]

version = "0.1.5"
replacement in Cargo.lock at line 270

[2.2483]→[2.2483:2561](∅→∅)

checksum = "d7ed72e1635e121ca3e79420540282af22da58be50de153d36f81ddc6b83aa9e"

[2.2483]

[2.2561]

checksum = "819e7219dbd41043ac279b19830f2efc897156490d7fd6ea916720117ee66311"
replacement in Cargo.lock at line 357

[4.1895]→[4.4560:4579](∅→∅)

version = "0.10.2"

[4.15532]

[4.15550]

version = "0.10.3"
replacement in Cargo.lock at line 359

[4.15615]→[4.4580:4658](∅→∅)

checksum = "0bf7fe51849ea569fd452f37822f606a5cabb684dc918707a0193fd4664ff324"

[4.15615]

[4.2120]

checksum = "69cce20737498f97b993470a6e536b8523f0af7892a4f928cceb1ac5e52ebe7e"
replacement in Cargo.lock at line 444

[4.17200]→[2.3278:3297](∅→∅)

version = "3.2.18"

[4.17200]

[4.17219]

version = "3.2.20"
replacement in Cargo.lock at line 446

[4.17284]→[2.3298:3376](∅→∅)

checksum = "b15f2ea93df33549dbe2e8eecd1ca55269d63ae0b3ba1f55db030817d1c2867f"

[4.17284]

[4.17362]

checksum = "23b71c3ce99b7611011217b366d923f1d0a7e07a92bb2dbf1e84508c673ca3bd"
replacement in Cargo.lock at line 491

[4.4307]→[2.3696:3714](∅→∅)

version = "0.2.4"

[4.4307]

[4.17972]

version = "0.2.5"
replacement in Cargo.lock at line 493

[4.18037]→[2.3715:3793](∅→∅)

checksum = "dc948ebb96241bb40ab73effeb80d9f93afaad49359d159a5e61be51619fe813"

[4.18037]

[4.4404]

checksum = "28d997bd5e24a5928dd43e46dc529867e207907fe0b239c3477d924f7f2ca320"
replacement in Cargo.lock at line 652

[4.20175]→[4.5593:5611](∅→∅)

version = "1.0.1"

[4.20175]

[4.20193]

version = "1.1.0"
replacement in Cargo.lock at line 654

[4.20258]→[4.5612:5690](∅→∅)

checksum = "5fc25a87fa4fd2094bffb06925852034d90a17f0d1e05197d4956d3555752191"

[4.20258]

[4.20336]

checksum = "a9c384f161156f5260c24a097c56119f9be8c798586aecc13afbcbe7b7e26bf8"
edit in Cargo.lock at line 656

[4.20353]→[4.20353:20365](∅→∅)

"matches",
replacement in Cargo.lock at line 789

[4.3277]→[2.5659:5677](∅→∅)

version = "4.3.3"

[4.3277]

[4.3295]

version = "4.3.4"
replacement in Cargo.lock at line 791

[4.3360]→[2.5678:5756](∅→∅)

checksum = "360d9740069b2f6cbb63ce2dbaa71a20d3185350cbb990d7bebeb9318415eb17"

[4.3360]

[4.3438]

checksum = "56b224eaa4987c03c30b251de7ef0c15a6a59f34222905850dbc3026dfb24d5f"
replacement in Cargo.lock at line 855

[4.23216]→[4.702:720](∅→∅)

version = "1.7.1"

[4.23216]

[4.23234]

version = "1.8.0"
replacement in Cargo.lock at line 857

[4.23299]→[4.721:799](∅→∅)

checksum = "496ce29bb5a52785b44e0f7ca2847ae0bb839c9bd28f69acac9b99d461c0c04c"

[4.23299]

[4.23377]

checksum = "d897f394bad6a705d5f4104762e116a75639e470d80901eed05a860a95cb1904"
replacement in Cargo.lock at line 873

[2.6005]→[2.6005:6024](∅→∅)

version = "0.1.46"

[2.6005]

[2.6024]

version = "0.1.47"
replacement in Cargo.lock at line 875

[2.6089]→[2.6089:6167](∅→∅)

checksum = "ad2bfd338099682614d3ee3fe0cd72e0b6a41ca6a87f6a74a3bd593c91650501"

[2.6089]

[2.6167]

checksum = "4c495f162af0bf17656d0014a0eded5f3cd2f365fdd204548c2869db89359dc7"
edit in Cargo.lock at line 880

[2.6249]

[2.6249]

"once_cell",
edit in Cargo.lock at line 892

[4.23787]

[4.23787]

"unicode-bidi",
"unicode-normalization",
]

[[package]]
name = "idna"
version = "0.3.0"
source = "registry+https://github.com/rust-lang/crates.io-index"
checksum = "e14ddfc70884202db2244c223200c204c2bda1bc6e0998d11b5e024d657209e6"
dependencies = [
replacement in Cargo.lock at line 970

[4.2204]→[4.1086:1095](∅→∅),[4.1086]→[4.1086:1095](∅→∅)

"idna",

[4.2204]

[4.2205]

"idna 0.2.3",
replacement in Cargo.lock at line 1046

[4.5810]→[4.7569:7588](∅→∅)

version = "0.10.1"

[4.5810]

[4.5829]

version = "0.10.4"
replacement in Cargo.lock at line 1048

[4.5894]→[4.7589:7667](∅→∅)

checksum = "658646b21e0b72f7866c7038ab086d3d5e1cd6271f060fd37defb241949d0582"

[4.5894]

[4.5972]

checksum = "66b48670c893079d3c2ed79114e3644b7004df1c361a4e0ad52e2e6940d07c3d"
replacement in Cargo.lock at line 1083

[4.26341]→[2.7027:7045](∅→∅)

version = "0.5.3"

[4.26341]

[4.26359]

version = "0.5.4"
replacement in Cargo.lock at line 1085

[4.26424]→[2.7046:7124](∅→∅)

checksum = "6f5c75688da582b8ffc1f1799e9db273f32133c49e048f614d22ec3256773ccc"

[4.26424]

[4.26502]

checksum = "96590ba8f175222643a85693f33d26e9c8a015f599c216509b1a6894af675d34"
replacement in Cargo.lock at line 1152

[4.27513]→[2.7223:7242](∅→∅)

version = "1.13.1"

[4.27513]

[4.27531]

version = "1.14.0"
replacement in Cargo.lock at line 1154

[4.27596]→[2.7243:7321](∅→∅)

checksum = "074864da206b4973b84eb91683020dbefd6a8c3f0f38e054d93954e891935e4e"

[4.27596]

[4.27674]

checksum = "2f7254b99e31cad77da24b08ebf628882739a608578bb1bcdfc1f9c21260d7c0"
replacement in Cargo.lock at line 1187

[4.10271]→[2.7519:7537](∅→∅)

version = "1.0.8"

[4.10271]

[4.10289]

version = "1.0.9"
replacement in Cargo.lock at line 1189

[4.10354]→[2.7538:7616](∅→∅)

checksum = "9423e2b32f7a043629287a536f21951e8c6a82482d0acb1eeebfc90bc2225b22"

[4.10354]

[4.28424]

checksum = "b1de2e551fb905ac83f73f7aedf2f0cb4a0da7e35efa24a202a936269f1f18e1"
replacement in Cargo.lock at line 1199

[4.28463]→[4.28463:28481](∅→∅)

version = "2.1.0"

[4.28463]

[4.28481]

version = "2.2.0"
replacement in Cargo.lock at line 1201

[4.28546]→[4.28546:28624](∅→∅)

checksum = "d4fd5641d01c8f18a23da7b6fe29298ff4b55afcccdf78973b24cf3175fee32e"

[4.28546]

[4.28624]

checksum = "478c572c3d73181ff3c2539045f6eb99e5491218eae919370993b890cdbdd98e"
replacement in Cargo.lock at line 1205

[4.3932]→[2.7617:7635](∅→∅)

version = "2.3.0"

[4.3932]

[4.3950]

version = "2.3.1"
replacement in Cargo.lock at line 1207

[4.4015]→[2.7636:7714](∅→∅)

checksum = "4b0560d531d1febc25a3c9398a62a71256c0178f2e3443baedd9ad4bb8c9deb4"

[4.4015]

[4.4093]

checksum = "cb779fcf4bb850fbbb0edc96ff6cf34fd90c4b1a112ce042653280d9a7364048"
replacement in Cargo.lock at line 1215

[4.4159]→[2.7730:7748](∅→∅)

version = "2.3.0"

[4.4159]

[4.4177]

version = "2.3.1"
replacement in Cargo.lock at line 1217

[4.4242]→[2.7749:7827](∅→∅)

checksum = "905708f7f674518498c1f8d644481440f476d39ca6ecae83319bba7c6c12da91"

[4.4242]

[4.4320]

checksum = "502b62a6d0245378b04ffe0a7fb4f4419a4815fce813bd8a0ec89a56e07d67b1"
replacement in Cargo.lock at line 1225

[4.4404]→[2.7828:7846](∅→∅)

version = "2.3.0"

[4.4404]

[4.4422]

version = "2.3.1"
replacement in Cargo.lock at line 1227

[4.4487]→[2.7847:7925](∅→∅)

checksum = "5803d8284a629cc999094ecd630f55e91b561a1d1ba75e233b00ae13b91a69ad"

[4.4487]

[4.4565]

checksum = "451e629bf49b750254da26132f1a5a9d11fd8a95a3df51d15c4abd1ba154cb6c"
replacement in Cargo.lock at line 1238

[4.4673]→[2.7926:7944](∅→∅)

version = "2.3.0"

[4.4673]

[4.4691]

version = "2.3.1"
replacement in Cargo.lock at line 1240

[4.4756]→[2.7945:8023](∅→∅)

checksum = "1538eb784f07615c6d9a8ab061089c6c54a344c5b4301db51990ca1c241e8c04"

[4.4756]

[4.4834]

checksum = "bcec162c71c45e269dfc3fc2916eaeb97feab22993a21bcce4721d08cd7801a6"
replacement in Cargo.lock at line 1244

[4.4871]→[2.8039:8049](∅→∅)

"sha-1",

[4.4871]

[4.29118]

"sha1",
edit in Cargo.lock at line 1511

[4.34025]→[4.5099:5129](∅→∅),[4.5129]→[2.9651:9670](∅→∅),[2.9670]→[4.5147:5212](∅→∅),[4.5147]→[4.5147:5212](∅→∅),[4.5212]→[2.9671:9749](∅→∅),[2.9749]→[4.5290:5307](∅→∅),[4.5290]→[4.5290:5307](∅→∅),[4.5307]→[2.9750:9788](∅→∅)

]

[[package]]
name = "sha-1"
version = "0.10.0"
source = "registry+https://github.com/rust-lang/crates.io-index"
checksum = "028f48d513f9678cda28f6e4064755b3fbb2af6acd672f2c209b62323f7aea0f"
dependencies = [
"cfg-if",
"cpufeatures",
"digest",
replacement in Cargo.lock at line 1515

[2.9803]→[2.9803:9822](∅→∅)

version = "0.10.1"

[2.9803]

[4.34073]

version = "0.10.4"
replacement in Cargo.lock at line 1517

[4.34138]→[2.9823:9901](∅→∅)

checksum = "c77f4e7f65455545c2153c1253d25056825e77ee2533f0e41deb65a93a34852f"

[4.34138]

[4.34216]

checksum = "006769ba83e921b3085caa8334186b00cf92b4cb1a6cf4632fbccc8eff5c7549"
replacement in Cargo.lock at line 1526

[4.7316]→[4.9595:9614](∅→∅)

version = "0.10.2"

[4.7316]

[4.7335]

version = "0.10.5"
replacement in Cargo.lock at line 1528

[4.7400]→[4.9615:9693](∅→∅)

checksum = "55deaec60f81eefe3cce0dc50bda92d6d8e88f2a27df7c5033b42afeb1ed2676"

[4.7400]

[4.7478]

checksum = "cf9db03534dff993187064c4e0c05a5708d2a9728ace9a8959b77bedf415dac5"
replacement in Cargo.lock at line 1567

[4.35136]→[2.10153:10171](∅→∅)

version = "0.4.6"

[4.35136]

[4.35155]

version = "0.4.7"
replacement in Cargo.lock at line 1569

[4.35220]→[2.10172:10250](∅→∅)

checksum = "10c98bba371b9b22a71a9414e420f92ddeb2369239af08200816169d5e2dd7aa"

[4.35220]

[4.35298]

checksum = "02e2d2db9033d13a1567121ddd7a095ee144db4e1ca1b1bda3419bc0da294ebd"
replacement in Cargo.lock at line 1631

[2.10388]→[2.10388:10407](∅→∅)

version = "1.0.32"

[2.10388]

[2.10407]

version = "1.0.34"
replacement in Cargo.lock at line 1633

[2.10472]→[2.10472:10550](∅→∅)

checksum = "f5f6586b7f764adc0231f4c79be7b920e766bb2f3e51b3661cdb263828f19994"

[2.10472]

[2.10550]

checksum = "8c1b05ca9d106ba7d2e31a9dab4a64e7be2cce415321966ea3132c49a656e252"
replacement in Cargo.lock at line 1640

[2.10625]→[2.10625:10644](∅→∅)

version = "1.0.32"

[2.10625]

[2.10644]

version = "1.0.34"
replacement in Cargo.lock at line 1642

[2.10709]→[2.10709:10787](∅→∅)

checksum = "12bafc5b54507e0149cdf1b145a5d80ab80a90bcd9275df43d4fff68460f6c21"

[2.10709]

[2.10787]

checksum = "e8f2591983642de85c921015f3f070c665a197ed69e417af436115e3a1407487"
replacement in Cargo.lock at line 1695

[4.39137]→[2.11092:11111](∅→∅)

version = "1.20.1"

[4.39137]

[4.39155]

version = "1.21.0"
replacement in Cargo.lock at line 1697

[4.39220]→[2.11112:11190](∅→∅)

checksum = "7a8325f63a7d4774dd041e363b2409ed1c5cbbd0f867795e661df066b2b0a581"

[4.39220]

[4.39298]

checksum = "89797afd69d206ccd11fb0ea560a44bbb87731d020670e79416d442919257d42"
replacement in Cargo.lock at line 1749

[4.39487]→[2.11340:11358](∅→∅)

version = "0.7.3"

[4.39487]

[4.10631]

version = "0.7.4"
replacement in Cargo.lock at line 1751

[4.10696]→[2.11359:11437](∅→∅)

checksum = "cc463cd8deddc3770d20f9852143d50bf6094e640b485cb2e189a2099085ff45"

[4.10696]

[4.10774]

checksum = "0bb2e075f03b3d66d8d8785356224ba688d2906a371015e225beeb65ca92c740"
replacement in Cargo.lock at line 1808

[4.5481]→[2.11651:11669](∅→∅)

version = "0.1.4"

[4.5481]

[4.5499]

version = "0.1.5"
replacement in Cargo.lock at line 1810

[4.5564]→[2.11670:11748](∅→∅)

checksum = "89570599c4fe5585de2b388aab47e99f7fa4e9238a1399f707a02e356058141c"

[4.5564]

[4.40897]

checksum = "9e79c4d996edb816c91e4308506774452e55e95c3c9de07b6729e17e15a5ef81"
replacement in Cargo.lock at line 1850

[4.42007]→[4.14195:14213](∅→∅)

version = "2.2.2"

[4.42007]

[4.42025]

version = "2.3.1"
replacement in Cargo.lock at line 1852

[4.42090]→[4.14214:14292](∅→∅)

checksum = "a507c383b2d33b5fc35d1861e77e6b383d158b2da5e14fe51b83dfedf6fd578c"

[4.42090]

[4.42168]

checksum = "0d68c799ae75762b8c3fe375feb6600ef5602c883c5d21eb51c09f22b83c4643"
replacement in Cargo.lock at line 1855

[4.42205]→[4.42205:42226](∅→∅)

"idna",
"matches",

[4.42205]

[4.42226]

"idna 0.3.0",