wasm-dbms-sql 0.11.0

SQL front-end (parser, planner, executor) for the wasm-dbms DBMS engine
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

//! Tables and schema shared by the planner and engine tests.

use wasm_dbms_api::prelude::{
    Blob, Boolean, ColumnDef, Date, DateTime, Decimal, Int64, Json, Nullable, Table,
    TableSchema as _, Text, Uint8, Uint32, Uint64, Uuid,
};
use wasm_dbms_macros::DatabaseSchema;

#[derive(Debug, Table, Clone, PartialEq, Eq)]
#[table = "users"]
pub(crate) struct User {
    #[primary_key]
    pub id: Uint32,
    pub name: Text,
    pub email: Nullable<Text>,
    pub age: Uint8,
}

#[derive(Debug, Table, Clone, PartialEq, Eq)]
#[table = "posts"]
pub(crate) struct Post {
    #[primary_key]
    pub id: Uint32,
    pub title: Text,
    pub published: Boolean,
    #[foreign_key(entity = "User", table = "users", column = "id")]
    pub user_id: Uint32,
}

#[derive(Debug, Table, Clone, PartialEq, Eq)]
#[table = "comments"]
pub(crate) struct Comment {
    #[primary_key]
    pub id: Uint32,
    pub body: Text,
    #[foreign_key(entity = "Post", table = "posts", column = "id")]
    pub post_id: Uint32,
}

#[derive(Debug, Table, Clone, PartialEq, Eq)]
#[table = "sales"]
pub(crate) struct Sale {
    #[primary_key]
    pub id: Uint32,
    #[index(group = "idx_category_region")]
    pub category: Text,
    #[index(group = "idx_category_region")]
    pub region: Text,
    pub quantity: Uint32,
    #[index]
    pub bonus: Nullable<Uint32>,
    pub price: Decimal,
}

/// One column of every type that needs a string literal or a typed parameter.
#[derive(Debug, Table, Clone, PartialEq, Eq)]
#[table = "events"]
pub(crate) struct Event {
    #[primary_key]
    #[autoincrement]
    pub id: Uint64,
    pub day: Date,
    pub at: DateTime,
    pub payload: Blob,
    pub meta: Json,
    pub delta: Int64,
    pub token: Uuid,
}

#[derive(Debug, Clone, Copy, DatabaseSchema)]
#[tables(
    User = "users",
    Post = "posts",
    Comment = "comments",
    Sale = "sales",
    Event = "events"
)]
pub(crate) struct TestSchema;

/// Column definitions of the test tables, by table name.
pub(crate) fn catalog(table: &str) -> Option<&'static [ColumnDef]> {
    match table {
        "users" => Some(User::columns()),
        "posts" => Some(Post::columns()),
        "comments" => Some(Comment::columns()),
        "sales" => Some(Sale::columns()),
        "events" => Some(Event::columns()),
        _ => None,
    }
}