toolu-orm-core 0.2.0

Schema definitions, migrations and driver traits for toolu-orm
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

use toolu_orm_core::column::{ColumnDef, ColumnType};
use toolu_orm_core::index::IndexDef;
use toolu_orm_core::table::TableDef;

fn col(name: &str, ct: ColumnType, pk: bool, nn: bool) -> ColumnDef {
  ColumnDef {
    name: name.to_owned(),
    column_type: ct,
    primary_key: pk,
    not_null: nn,
    default: None,
    unique: false,
    references: None,
    on_delete: None,
    on_update: None,
    check: None,
    unindexed: false,
  }
}

#[test]
fn test_table_def_creation() {
  let table = TableDef {
    name: "conversations".to_owned(),
    columns: vec![
      ColumnDef {
        name: "id".to_owned(),
        column_type: ColumnType::Text,
        primary_key: true,
        not_null: false,
        default: None,
        unique: false,
        references: None,
        on_delete: None,
        on_update: None,
        check: None,
        unindexed: false,
      },
      ColumnDef {
        name: "title".to_owned(),
        column_type: ColumnType::Text,
        primary_key: false,
        not_null: false,
        default: None,
        unique: false,
        references: None,
        on_delete: None,
        on_update: None,
        check: None,
        unindexed: false,
      },
    ],
    indexes: vec![],
    strict: false,
    kind: toolu_orm_core::table::TableKind::Ordinary,
  };
  assert_eq!(table.name, "conversations");
  assert_eq!(table.columns.len(), 2);
}

#[test]
fn test_table_def_find_column() {
  let table = TableDef {
    name: "messages".to_owned(),
    columns: vec![ColumnDef {
      name: "id".to_owned(),
      column_type: ColumnType::Text,
      primary_key: true,
      not_null: false,
      default: None,
      unique: false,
      references: None,
      on_delete: None,
      on_update: None,
      check: None,
      unindexed: false,
    }],
    indexes: vec![],
    strict: false,
    kind: toolu_orm_core::table::TableKind::Ordinary,
  };
  assert!(table.find_column("id").is_some());
  assert!(table.find_column("nonexistent").is_none());
}

#[test]
fn test_table_def_with_indexes_and_strict() -> Result<(), Box<dyn std::error::Error>> {
  let t = TableDef {
    name: "pipelines".to_owned(),
    columns: vec![col("id", ColumnType::Uuid, true, false)],
    indexes: vec![IndexDef {
      name: "idx_pipelines_repo_id".to_owned(),
      columns: vec!["repo_id".to_owned()],
      unique: false,
    }],
    strict: true,
    kind: toolu_orm_core::table::TableKind::Ordinary,
  };
  assert!(t.strict);
  assert_eq!(t.indexes.len(), 1);
  let first = t.indexes.first().ok_or("expected one index")?;
  assert_eq!(first.name, "idx_pipelines_repo_id");
  Ok(())
}

#[test]
fn test_table_def_defaults_no_strict_no_indexes() {
  let t = TableDef {
    name: "legacy".to_owned(),
    columns: vec![],
    indexes: vec![],
    strict: false,
    kind: toolu_orm_core::table::TableKind::Ordinary,
  };
  assert!(!t.strict);
  assert!(t.indexes.is_empty());
}