pubky-homeserver 0.10.0

Pubky core's homeserver.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

use async_trait::async_trait;
use sqlx::Transaction;

use crate::persistence::sql::migration::MigrationTrait;

/// Adds the timestamp for signup token consumption.
pub struct M20260609AddSignupCodeUsedAtMigration;

#[async_trait]
impl MigrationTrait for M20260609AddSignupCodeUsedAtMigration {
    async fn up(&self, tx: &mut Transaction<'static, sqlx::Postgres>) -> anyhow::Result<()> {
        sqlx::query("ALTER TABLE signup_codes ADD COLUMN IF NOT EXISTS used_at TIMESTAMP")
            .execute(&mut **tx)
            .await?;
        sqlx::query(
            "UPDATE signup_codes SET used_at = created_at WHERE used_by IS NOT NULL AND used_at IS NULL",
        )
        .execute(&mut **tx)
        .await?;
        Ok(())
    }

    fn name(&self) -> &str {
        "m20260609_add_signup_code_used_at"
    }
}