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 crate::prelude::*;

pub async fn upsert(
    conn: &mut PgConnection,
    pkey_policy: PKeyPolicy<Uuid>,
    destination_page_id: Uuid,
    old_url_path: &str,
    course_id: Uuid,
) -> ModelResult<Uuid> {
    let res = sqlx::query!(
        "
INSERT INTO url_redirections (id, destination_page_id, old_url_path, course_id)
VALUES ($1, $2, $3, $4)
ON CONFLICT (old_url_path, course_id, deleted_at) DO UPDATE SET
    destination_page_id = $2
RETURNING id
        ",
        pkey_policy.into_uuid(),
        destination_page_id,
        old_url_path,
        course_id,
    )
    .fetch_one(conn)
    .await?;
    Ok(res.id)
}