sql-forge 0.5.0

Proc-macro combining compile-time SQL validation with a runtime QueryBuilder for dynamic queries using named parameters.
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

error[E0277]: the trait bound `TransparentId: FromRow<'_, SqliteRow>` is not satisfied
 --> tests/sqlite/tmp-ui/transparent_without_scalar.rs:7:9
  |
6 |       let _ = sql_forge!(
  |  _____________-
7 | |         support::TransparentId,
  | |         ^^^^^^^^^^^^^^^^^^^^^^ unsatisfied trait bound
8 | |         "SELECT id FROM users LIMIT 1",
9 | |     );
  | |_____- required by a bound introduced by this call
  |
help: the trait `FromRow<'_, SqliteRow>` is not implemented for `TransparentId`
 --> tests/sqlite/tmp-ui/support/mod.rs
  |
  | pub struct TransparentId(pub i64);
  | ^^^^^^^^^^^^^^^^^^^^^^^^
  = help: the following other types implement trait `FromRow<'r, R>`:
            `()` implements `FromRow<'r, R>`
            `(T1, T2)` implements `FromRow<'r, R>`
            `(T1, T2, T3)` implements `FromRow<'r, R>`
            `(T1, T2, T3, T4)` implements `FromRow<'r, R>`
            `(T1, T2, T3, T4, T5)` implements `FromRow<'r, R>`
            `(T1, T2, T3, T4, T5, T6)` implements `FromRow<'r, R>`
            `(T1, T2, T3, T4, T5, T6, T7)` implements `FromRow<'r, R>`
            `(T1, T2, T3, T4, T5, T6, T7, T8)` implements `FromRow<'r, R>`
          and $N others
note: required by a bound in `QueryBuilder::<DB>::build_query_as`
 --> $CARGO/sqlx-core-$VERSION/src/query_builder.rs
  |
  |     pub fn build_query_as<'q, T: FromRow<'q, DB::Row>>(
  |                                  ^^^^^^^^^^^^^^^^^^^^ required by this bound in `QueryBuilder::<DB>::build_query_as`
help: use a unary tuple instead
  |
6 ~     let _ = (sql_forge!(
7 |         support::TransparentId,
8 |         "SELECT id FROM users LIMIT 1",
9 ~     ),);
  |

error[E0599]: the method `fetch_all` exists for struct `QueryAs<'_, Sqlite, TransparentId, SqliteArguments>`, but its trait bounds were not satisfied
 --> tests/sqlite/tmp-ui/transparent_without_scalar.rs:6:13
  |
6 |       let _ = sql_forge!(
  |  _____________^
7 | |         support::TransparentId,
8 | |         "SELECT id FROM users LIMIT 1",
9 | |     );
  | |_____^ method cannot be called due to unsatisfied trait bounds
  |
 ::: tests/sqlite/tmp-ui/support/mod.rs
  |
  |   pub struct TransparentId(pub i64);
  |   ------------------------ doesn't satisfy `TransparentId: FromRow<'r, SqliteRow>`
  |
  = note: the following trait bounds were not satisfied:
          `TransparentId: FromRow<'r, SqliteRow>`
  = note: this error originates in the macro `sql_forge` (in Nightly builds, run with -Z macro-backtrace for more info)

error[E0599]: the method `fetch_one` exists for struct `QueryAs<'_, Sqlite, TransparentId, SqliteArguments>`, but its trait bounds were not satisfied
 --> tests/sqlite/tmp-ui/transparent_without_scalar.rs:6:13
  |
6 |       let _ = sql_forge!(
  |  _____________^
7 | |         support::TransparentId,
8 | |         "SELECT id FROM users LIMIT 1",
9 | |     );
  | |_____^ method cannot be called due to unsatisfied trait bounds
  |
 ::: tests/sqlite/tmp-ui/support/mod.rs
  |
  |   pub struct TransparentId(pub i64);
  |   ------------------------ doesn't satisfy `TransparentId: FromRow<'r, SqliteRow>`
  |
  = note: the following trait bounds were not satisfied:
          `TransparentId: FromRow<'r, SqliteRow>`
  = note: this error originates in the macro `sql_forge` (in Nightly builds, run with -Z macro-backtrace for more info)

error[E0599]: the method `fetch_optional` exists for struct `QueryAs<'_, Sqlite, TransparentId, SqliteArguments>`, but its trait bounds were not satisfied
 --> tests/sqlite/tmp-ui/transparent_without_scalar.rs:6:13
  |
6 |       let _ = sql_forge!(
  |  _____________^
7 | |         support::TransparentId,
8 | |         "SELECT id FROM users LIMIT 1",
9 | |     );
  | |_____^ method cannot be called due to unsatisfied trait bounds
  |
 ::: tests/sqlite/tmp-ui/support/mod.rs
  |
  |   pub struct TransparentId(pub i64);
  |   ------------------------ doesn't satisfy `TransparentId: FromRow<'r, SqliteRow>`
  |
  = note: the following trait bounds were not satisfied:
          `TransparentId: FromRow<'r, SqliteRow>`
  = note: this error originates in the macro `sql_forge` (in Nightly builds, run with -Z macro-backtrace for more info)

error[E0560]: struct `TransparentId` has no field named `id`
 --> tests/sqlite/tmp-ui/transparent_without_scalar.rs:6:13
  |
6 |       let _ = sql_forge!(
  |  _____________^
7 | |         support::TransparentId,
8 | |         "SELECT id FROM users LIMIT 1",
9 | |     );
  | |_____^ field does not exist
  |
 ::: tests/sqlite/tmp-ui/support/mod.rs
  |
  |   pub struct TransparentId(pub i64);
  |              ------------- `TransparentId` defined here
  |
  = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sql_forge` (in Nightly builds, run with -Z macro-backtrace for more info)
help: `TransparentId` is a tuple struct, use the appropriate syntax
  |
6 -     let _ = sql_forge!(
7 -         support::TransparentId,
8 -         "SELECT id FROM users LIMIT 1",
9 -     );
6 +     let _ = TransparentId(/* i64 */);
  |