sqlite-err-parser 0.5.0

Deconstruct certain sqlite errors
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

use rusqlite::{Connection, params};

use sqlite_err_parser::{InterpretedError, deconstruct_error};

#[test]
fn primary() {
  let conn = Connection::open_in_memory().unwrap();
  conn
    .execute(
      "CREATE TABLE agents (
  id   INTEGER PRIMARY KEY,
  name TEXT UNIQUE NOT NULL
)",
      ()
    )
    .unwrap();
  conn
    .execute(
      "INSERT INTO agents (id, name) VALUES (?, ?)",
      params![1, "frank"]
    )
    .unwrap();

  let Err(err) = conn.execute(
    "INSERT INTO agents (id, name) VALUES (?, ?)",
    params![1, "bill"]
  ) else {
    panic!("Unexpectedly not Err()");
  };
  let Some(InterpretedError::NotUnique(v)) = deconstruct_error(&err) else {
    panic!("Not treated as InterpretedError::NotUnique(); {err}");
  };
  assert_eq!(&v, &[("agents", "id")]);
}

#[test]
fn simple_name() {
  let conn = Connection::open_in_memory().unwrap();
  conn
    .execute(
      "CREATE TABLE agents (
  id   INTEGER PRIMARY KEY,
  name TEXT UNIQUE NOT NULL
)",
      ()
    )
    .unwrap();
  conn
    .execute("INSERT INTO agents (name) VALUES (?)", ["frank"])
    .unwrap();

  let Err(err) =
    conn.execute("INSERT INTO agents (name) VALUES (?)", ["frank"])
  else {
    panic!("Unexpectedly not Err()");
  };
  let Some(InterpretedError::NotUnique(v)) = deconstruct_error(&err) else {
    panic!("Not treated as InterpretedError::NotUnique(); {err}");
  };
  assert_eq!(&v, &[("agents", "name")]);
}

#[test]
fn pair() {
  let conn = Connection::open_in_memory().unwrap();
  conn
    .execute(
      "CREATE TABLE agents (
  id   INTEGER PRIMARY KEY,
  role TEXT NOT NULL,
  name TEXT NOT NULL,
  UNIQUE(role,name)
)",
      ()
    )
    .unwrap();
  conn
    .execute(
      "INSERT INTO agents (role,name) VALUES (?, ?)",
      ["janitor", "frank"]
    )
    .unwrap();

  let Err(err) = conn.execute(
    "INSERT INTO agents (role,name) VALUES (?, ?)",
    ["janitor", "frank"]
  ) else {
    panic!("Unexpectedly not Err()");
  };
  let Some(InterpretedError::NotUnique(v)) = deconstruct_error(&err) else {
    panic!("Not treated as InterpretedError::NotUnique(); {err}");
  };
  assert_eq!(&v, &[("agents", "name"), ("agents", "role")]);
}

// vim: set ft=rust et sw=2 ts=2 sts=2 cinoptions=2 tw=79 :