postg 0.1.7

Embedded PostgreSQL manager for Rust
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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77

use assert_cmd::Command;
use predicates::prelude::*;
use tempfile::TempDir;

#[test]
fn test_parquet_dump_and_restore_e2e() {
    let tmp = TempDir::new().unwrap();
    let data_dir = tmp.path().join("pgdata");
    let parquet_file = tmp.path().join("output.parquet");

    // 1. Create table via query
    let mut cmd = Command::cargo_bin("postg").unwrap();
    cmd.arg("--data-dir")
        .arg(&data_dir)
        .arg("query")
        .arg("CREATE TABLE test_parquet (id SERIAL PRIMARY KEY, col_i16 INT2, col_i32 INT4, col_i64 INT8, col_f32 FLOAT4, col_f64 FLOAT8, col_bool BOOL, col_bin BYTEA, col_utf8 TEXT)")
        .assert()
        .success();

    // 1b. Insert data via query
    let mut cmd = Command::cargo_bin("postg").unwrap();
    cmd.arg("--data-dir")
        .arg(&data_dir)
        .arg("query")
        .arg("INSERT INTO test_parquet (col_i16, col_i32, col_i64, col_f32, col_f64, col_bool, col_bin, col_utf8) VALUES (16, 32, 64, 3.14, 2.718, true, '\\xDEADBEEF', 'hello'), (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)")
        .assert()
        .success();

    // 2. Dump to Parquet
    let mut cmd = Command::cargo_bin("postg").unwrap();
    cmd.arg("--data-dir")
        .arg(&data_dir)
        .arg("dump")
        .arg("--format")
        .arg("parquet")
        .arg("--query")
        .arg("SELECT * FROM test_parquet ORDER BY id")
        .arg("--file")
        .arg(&parquet_file)
        .assert()
        .success();

    assert!(parquet_file.exists(), "Parquet file should be created");

    // 3. Drop the table
    let mut cmd = Command::cargo_bin("postg").unwrap();
    cmd.arg("--data-dir")
        .arg(&data_dir)
        .arg("query")
        .arg("DROP TABLE test_parquet;")
        .assert()
        .success();

    // 4. Restore from Parquet
    let mut cmd = Command::cargo_bin("postg").unwrap();
    cmd.arg("--data-dir")
        .arg(&data_dir)
        .arg("restore")
        .arg("--format")
        .arg("parquet")
        .arg("--table")
        .arg("test_parquet")
        .arg("--create-table")
        .arg(&parquet_file)
        .assert()
        .success();

    // 5. Verify restored data
    let mut cmd = Command::cargo_bin("postg").unwrap();
    cmd.arg("--data-dir")
        .arg(&data_dir)
        .arg("query")
        .arg("SELECT * FROM test_parquet;")
        .assert()
        .success()
        .stdout(predicate::str::contains("2 row(s) returned"));
}