zj/nidobyte - Change IWM4EE63YXP2B6KHE2UL3CORFZGXMUKLWB43TXYCYABKAFSTA6FQC

database: Add migration support Fairly minor change codewise; add support for creating migrations and run them at the start of the runtime. In this case not a lot of changes happen, only the migrations tracking table is added. The sqlx command line tool is used to manage migrations; invoke `cargo sqlx --help` for more info.

Created by zj on July 20, 2021

IWM4EE63YXP2B6KHE2UL3CORFZGXMUKLWB43TXYCYABKAFSTA6FQC

Dependencies

In channels

main

Change contents

Insertion in src/sqlx/mod.rs at line 19 [3.48]

[3.541]

    if let Err(e) = sqlx::migrate!("./migrations").run(&pool).await {
        error!("Failed to migrate PG database: {}", e);
        return Err(rocket);
    }

Insertion in shell.nix at line 16 [4.853]
[2.57]
[2.57]
```
	pkgs.sqlx-cli
```
File addition: migrations (d--x------)
[1.0]
File addition: 20210720185911_test_migration.sql (----------)
[0.199]
```
-- Add migration script here
```

Replacement in Cargo.toml at line 15 [4.1253]

B:BD[3.1853] → [3.1853:1914]

features = [ "runtime-tokio-rustls", "postgres", "migrate" ]

[3.1853]

features = [ "runtime-tokio-rustls", "postgres", "macros", "migrate" ]

Dependencies

In channels

Change contents

Insertion in src/sqlx/mod.rs at line 19 [3.48]

Insertion in shell.nix at line 16 [4.853]

File addition: migrations (d--x------)

File addition: 20210720185911_test_migration.sql (----------)

Replacement in Cargo.toml at line 15 [4.1253]