mirror of
https://github.com/clockworklabs/SpacetimeDB.git
synced 2026-06-28 00:38:30 -04:00
Jason Larabie
346e2b2514
# Description of Changes - Added a query builder for C++ module bindings - Added query-builder table/filter/join types - Added semijoin support with compile-time checks for lookup-table and indexed-field usage - Added support for returning query-builder queries from C++ views - Hooked query-builder metadata into the C++ table/view macros and V10 module-def path - Added test coverage for the new C++ query-builder behavior - Compile tests for pass/fail cases - SQL tests for generated query output - Added a C++ test module for view primary key coverage - **Update:** Switched the core to pass the columns and index-columns metadata with the table source for better client-side codegen to have some shared code between server + client. # API and ABI breaking changes - No intended API or ABI breaking changes - Adds a new public query-builder API to the C++ bindings - C++ views can now return query-builder query types in addition to materialized row results # Expected complexity level and risk 3 - Mostly contained to C++ bindings, but it touches macros, view registration/serialization, and module-def generation, so there are a few places where the pieces need to stay in sync. # Testing I've done end to end testing of I think every type as well as built some tests to confirm the SQL output. - [x] Run the C++ query-builder SQL tests [crates/bindings-cpp/tests/query-builder-compile/run_query_builder_compile_tests.sh] - [x] Smoke test a generated C++ module using query-builder views --------- Signed-off-by: Jason Larabie <jason@clockworklabs.io> Co-authored-by: Ryan <r.ekhoff@clockworklabs.io> Co-authored-by: Zeke Foppa <196249+bfops@users.noreply.github.com>
34 lines
907 B
C++
34 lines
907 B
C++
#include <spacetimedb.h>
|
|
|
|
using namespace SpacetimeDB;
|
|
|
|
template<typename TRow>
|
|
auto TableFor(const char* table_name) {
|
|
return QueryBuilder{}.table<TRow>(
|
|
table_name,
|
|
query_builder::HasCols<TRow>::get(table_name),
|
|
query_builder::HasIxCols<TRow>::get(table_name));
|
|
}
|
|
|
|
struct User {
|
|
Identity identity;
|
|
uint64_t tenant_id;
|
|
};
|
|
SPACETIMEDB_STRUCT(User, identity, tenant_id)
|
|
SPACETIMEDB_TABLE(User, user, Public)
|
|
FIELD_PrimaryKey(user, identity)
|
|
|
|
struct Membership {
|
|
Identity identity;
|
|
uint64_t tenant_id;
|
|
};
|
|
SPACETIMEDB_STRUCT(Membership, identity, tenant_id)
|
|
SPACETIMEDB_TABLE(Membership, membership, Public)
|
|
FIELD_PrimaryKey(membership, identity)
|
|
|
|
auto invalid_join = TableFor<User>("user").right_semijoin(
|
|
TableFor<Membership>("membership"),
|
|
[](const auto& users, const auto& memberships) {
|
|
return users.tenant_id.eq(memberships.tenant_id);
|
|
});
|