toolu-orm-query 0.2.0

Type-safe query builders 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
118
119
120
121
122

use toolu_orm_query::select::RelationalSelectBuilder;

#[test]
fn postgres_single_has_many_generates_lateral_join() {
  let builder = RelationalSelectBuilder::new("users", &["id", "name"]).with_many(
    "posts",
    "posts",
    "id",
    "author_id",
    &["id", "title"],
  );
  let sql = builder.to_sql_postgres();
  assert!(
    sql.contains("LEFT JOIN LATERAL"),
    "should contain LEFT JOIN LATERAL, got: {sql}"
  );
  assert!(
    sql.contains("json_agg"),
    "should contain json_agg, got: {sql}"
  );
  assert!(
    sql.contains("json_build_array"),
    "should contain json_build_array, got: {sql}"
  );
  assert!(
    sql.contains(r#""posts_sub"."author_id" = "users"."id""#),
    "should contain join condition, got: {sql}"
  );
}

#[test]
fn postgres_has_one_generates_lateral_join_with_limit() {
  let builder = RelationalSelectBuilder::new("posts", &["id", "title"]).with_one(
    "author",
    "users",
    "author_id",
    "id",
    &["id", "name"],
  );
  let sql = builder.to_sql_postgres();
  assert!(
    sql.contains("LEFT JOIN LATERAL"),
    "should contain LEFT JOIN LATERAL, got: {sql}"
  );
  assert!(
    sql.contains("LIMIT 1"),
    "has-one should contain LIMIT 1, got: {sql}"
  );
}

#[test]
fn postgres_multiple_relations_generate_multiple_lateral_joins() {
  let builder = RelationalSelectBuilder::new("users", &["id", "name"])
    .with_many("posts", "posts", "id", "author_id", &["id", "title"])
    .with_many("comments", "comments", "id", "user_id", &["id", "body"]);
  let sql = builder.to_sql_postgres();
  let lateral_count = sql.matches("LEFT JOIN LATERAL").count();
  assert_eq!(
    lateral_count, 2,
    "should have 2 lateral joins, got {lateral_count} in: {sql}"
  );
}

#[test]
fn postgres_source_columns_are_qualified() {
  let builder = RelationalSelectBuilder::new("users", &["id", "name", "email"]).with_many(
    "posts",
    "posts",
    "id",
    "author_id",
    &["id", "title"],
  );
  let sql = builder.to_sql_postgres();
  assert!(
    sql.contains(r#""users"."id""#),
    "should qualify source columns, got: {sql}"
  );
  assert!(
    sql.contains(r#""users"."name""#),
    "should qualify source columns, got: {sql}"
  );
  assert!(
    sql.contains(r#""users"."email""#),
    "should qualify source columns, got: {sql}"
  );
}

#[test]
fn postgres_coalesce_wraps_json_agg() {
  let builder = RelationalSelectBuilder::new("users", &["id"]).with_many(
    "posts",
    "posts",
    "id",
    "author_id",
    &["id"],
  );
  let sql = builder.to_sql_postgres();
  assert!(
    sql.contains("coalesce"),
    "should wrap json_agg with coalesce, got: {sql}"
  );
  assert!(
    sql.contains("'[]'::json"),
    "coalesce fallback should be empty JSON array, got: {sql}"
  );
}

#[test]
fn postgres_on_true_terminates_lateral_join() {
  let builder = RelationalSelectBuilder::new("users", &["id"]).with_many(
    "posts",
    "posts",
    "id",
    "author_id",
    &["id"],
  );
  let sql = builder.to_sql_postgres();
  assert!(
    sql.contains("ON true"),
    "lateral join should end with ON true, got: {sql}"
  );
}