nodedb 0.2.0

Local-first, real-time, edge-to-cloud hybrid database for multi-modal workloads
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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45

// SPDX-License-Identifier: BUSL-1.1

//! Integration tests for scheduled jobs.

mod common;

use common::pgwire_harness::TestServer;

#[tokio::test(flavor = "multi_thread", worker_threads = 4)]
async fn create_alter_drop_schedule() {
    let server = TestServer::start().await;

    server
        .exec("CREATE SCHEDULE cleanup CRON '0 3 * * *' AS BEGIN RETURN 1; END")
        .await
        .unwrap();

    // SHOW SCHEDULES should list it.
    let rows = server.query_text("SHOW SCHEDULES").await.unwrap();
    assert!(!rows.is_empty());

    // ALTER SCHEDULE DISABLE.
    server.exec("ALTER SCHEDULE cleanup DISABLE").await.unwrap();

    // ALTER SCHEDULE SET CRON.
    server
        .exec("ALTER SCHEDULE cleanup SET CRON '0 0 * * *'")
        .await
        .unwrap();

    // ALTER SCHEDULE ENABLE.
    server.exec("ALTER SCHEDULE cleanup ENABLE").await.unwrap();

    // SHOW SCHEDULE HISTORY — should not error.
    let _rows = server
        .query_text("SHOW SCHEDULE HISTORY cleanup")
        .await
        .unwrap();

    // DROP SCHEDULE.
    server.exec("DROP SCHEDULE cleanup").await.unwrap();
    server
        .expect_error("DROP SCHEDULE cleanup", "does not exist")
        .await;
}