msi 0.10.0

Read/write Windows Installer (MSI) files
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
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125

#[macro_use]
mod testutil;

use msi::{Column, Delete, Expr, Insert, Package, PackageType, Select, Value};
use std::io::{Cursor, ErrorKind};

// ========================================================================= //

#[test]
fn nonexistent_table() {
    let cursor = Cursor::new(Vec::new());
    let mut package = Package::create(PackageType::Installer, cursor).unwrap();
    let query =
        Delete::from("Foobar").with(Expr::col("Foo").eq(Expr::integer(1)));
    assert_error!(
        package.delete_rows(query),
        ErrorKind::NotFound,
        "Table \"Foobar\" does not exist"
    );
}

#[test]
fn nonexistent_column() {
    let cursor = Cursor::new(Vec::new());
    let mut package = Package::create(PackageType::Installer, cursor).unwrap();
    let columns = vec![
        Column::build("Foo").primary_key().int32(),
        Column::build("Bar").nullable().string(6),
    ];
    package.create_table("Foobar", columns).unwrap();
    let query = Delete::from("Foobar").with(
        (Expr::col("Bar").ne(Expr::null()))
            .and(Expr::col("Baz").eq(Expr::integer(1))),
    );
    assert_error!(
        package.delete_rows(query),
        ErrorKind::InvalidInput,
        "Table \"Foobar\" has no column named \"Baz\""
    );
}

#[test]
fn delete_one_row() {
    let cursor = Cursor::new(Vec::new());
    let mut package = Package::create(PackageType::Installer, cursor).unwrap();
    let columns = vec![
        Column::build("Foo").primary_key().int32(),
        Column::build("Bar").nullable().string(6),
    ];
    package.create_table("Foobar", columns).unwrap();

    let query = Insert::into("Foobar")
        .row(vec![Value::Int(1), Value::from("One")])
        .row(vec![Value::Int(2), Value::from("Two")])
        .row(vec![Value::Int(3), Value::from("Three")]);
    package.insert_rows(query).unwrap();

    let query =
        Delete::from("Foobar").with(Expr::col("Foo").eq(Expr::integer(2)));
    package.delete_rows(query).unwrap();

    let cursor = package.into_inner().unwrap();
    let mut package = Package::open(cursor).unwrap();
    let rows = package.select_rows(Select::table("Foobar")).unwrap();
    assert_eq!(rows.len(), 2);
    let keys = rows.map(|row| row[0].as_int().unwrap()).collect::<Vec<i32>>();
    assert_eq!(keys, vec![1, 3]);
}

#[test]
fn delete_multiple_rows() {
    let cursor = Cursor::new(Vec::new());
    let mut package = Package::create(PackageType::Installer, cursor).unwrap();
    let columns = vec![
        Column::build("Key").primary_key().int16(),
        Column::build("Value").nullable().int32(),
    ];
    package.create_table("Mapping", columns).unwrap();

    let query = Insert::into("Mapping")
        .row(vec![Value::Int(1), Value::Int(17)])
        .row(vec![Value::Int(2), Value::Int(42)])
        .row(vec![Value::Int(3), Value::Int(17)]);
    package.insert_rows(query).unwrap();

    let query =
        Delete::from("Mapping").with(Expr::col("Value").eq(Expr::integer(17)));
    package.delete_rows(query).unwrap();

    let cursor = package.into_inner().unwrap();
    let mut package = Package::open(cursor).unwrap();
    let rows = package.select_rows(Select::table("Mapping")).unwrap();
    let values: Vec<(i32, i32)> = rows
        .map(|row| (row[0].as_int().unwrap(), row[1].as_int().unwrap()))
        .collect();
    assert_eq!(values, vec![(2, 42)]);
}

#[test]
fn delete_all_rows() {
    let cursor = Cursor::new(Vec::new());
    let mut package = Package::create(PackageType::Installer, cursor).unwrap();
    let columns = vec![
        Column::build("Foo").primary_key().int32(),
        Column::build("Bar").nullable().string(6),
    ];
    package.create_table("Foobar", columns).unwrap();

    let query = Insert::into("Foobar")
        .row(vec![Value::Int(1), Value::from("One")])
        .row(vec![Value::Int(2), Value::from("Two")])
        .row(vec![Value::Int(3), Value::from("Three")]);
    package.insert_rows(query).unwrap();

    package.delete_rows(Delete::from("Foobar")).unwrap();

    let cursor = package.into_inner().unwrap();
    let mut package = Package::open(cursor).unwrap();
    let rows = package.select_rows(Select::table("Foobar")).unwrap();
    assert_eq!(rows.len(), 0);
    let keys = rows.map(|row| row[0].as_int().unwrap()).collect::<Vec<i32>>();
    assert!(keys.is_empty());
}

// ========================================================================= //