tests/statement_serializer_tests/foreign_key.cpp - master - UCS/sqlite_orm

tests/statement_serializer_tests/foreign_key.cpp
384 строки18 KB
klaus triendl
Updated to Catch2 v3
15 янв 2023, 22:59
15 янв 2023, 22:593154d24
#include <sqlite_orm/sqlite_orm.h>
#include <catch2/catch_all.hpp>

#include <type_traits>  //  std::is_same

#include "../static_tests/static_tests_storage_traits.h"

using namespace sqlite_orm;

#if SQLITE_VERSION_NUMBER >= 3006019

TEST_CASE("statement_serializer foreign key") {
    SECTION("one to one") {
        struct User {
            int id = 0;
            std::string name;
        };

        struct Visit {
            int id = 0;
            decltype(User::id) userId;
            long time = 0;
        };

        auto usersTable = make_table("users",
                                     make_column("id", &User::id, primary_key().autoincrement()),
                                     make_column("name", &User::name));

        SECTION("simple") {
            auto fk = foreign_key(&Visit::userId).references(&User::id);

            using ForeignKey = decltype(fk);
            STATIC_REQUIRE(std::is_same<ForeignKey::target_type, User>::value);
            STATIC_REQUIRE(std::is_same<ForeignKey::source_type, Visit>::value);

            auto visitsTable = make_table("visits",
                                          make_column("id", &Visit::id, primary_key().autoincrement()),
                                          make_column("user_id", &Visit::userId),
                                          make_column("time", &Visit::time),
                                          fk);

            using db_objects_t = internal::db_objects_tuple<decltype(usersTable), decltype(visitsTable)>;

            db_objects_t dbObjects{usersTable, visitsTable};

            using context_t = internal::serializer_context<db_objects_t>;

            context_t context{dbObjects};
            auto value = serialize(fk, context);
            REQUIRE(value == R"(FOREIGN KEY("user_id") REFERENCES "users"("id"))");
        }
        SECTION("on update") {
            SECTION("no_action") {
                auto fk = foreign_key(&Visit::userId).references(&User::id).on_update.no_action();

                using ForeignKey = decltype(fk);
                STATIC_REQUIRE(std::is_same<ForeignKey::target_type, User>::value);
                STATIC_REQUIRE(std::is_same<ForeignKey::source_type, Visit>::value);

                auto visitsTable = make_table("visits",
                                              make_column("id", &Visit::id, primary_key().autoincrement()),
                                              make_column("user_id", &Visit::userId),
                                              make_column("time", &Visit::time),
                                              fk);

                using db_objects_t = internal::db_objects_tuple<decltype(usersTable), decltype(visitsTable)>;

                db_objects_t dbObjects{usersTable, visitsTable};

                using context_t = internal::serializer_context<db_objects_t>;

                context_t context{dbObjects};
                auto value = serialize(fk, context);
                REQUIRE(value == R"(FOREIGN KEY("user_id") REFERENCES "users"("id") ON UPDATE NO ACTION)");
            }
            SECTION("restrict_") {
                auto fk = foreign_key(&Visit::userId).references(&User::id).on_update.restrict_();

                using ForeignKey = decltype(fk);
                STATIC_REQUIRE(std::is_same<ForeignKey::target_type, User>::value);
                STATIC_REQUIRE(std::is_same<ForeignKey::source_type, Visit>::value);

                auto visitsTable = make_table("visits",
                                              make_column("id", &Visit::id, primary_key().autoincrement()),
                                              make_column("user_id", &Visit::userId),
                                              make_column("time", &Visit::time),
                                              fk);

                using db_objects_t = internal::db_objects_tuple<decltype(usersTable), decltype(visitsTable)>;

                db_objects_t dbObjects{usersTable, visitsTable};

                using context_t = internal::serializer_context<db_objects_t>;

                context_t context{dbObjects};
                auto value = serialize(fk, context);
                REQUIRE(value == R"(FOREIGN KEY("user_id") REFERENCES "users"("id") ON UPDATE RESTRICT)");
            }
            SECTION("set_null") {
                auto fk = foreign_key(&Visit::userId).references(&User::id).on_update.set_null();

                using ForeignKey = decltype(fk);
                STATIC_REQUIRE(std::is_same<ForeignKey::target_type, User>::value);
                STATIC_REQUIRE(std::is_same<ForeignKey::source_type, Visit>::value);

                auto visitsTable = make_table("visits",
                                              make_column("id", &Visit::id, primary_key().autoincrement()),
                                              make_column("user_id", &Visit::userId),
                                              make_column("time", &Visit::time),
                                              fk);

                using db_objects_t = internal::db_objects_tuple<decltype(usersTable), decltype(visitsTable)>;

                db_objects_t dbObjects{usersTable, visitsTable};

                using context_t = internal::serializer_context<db_objects_t>;

                context_t context{dbObjects};
                auto value = serialize(fk, context);
                REQUIRE(value == R"(FOREIGN KEY("user_id") REFERENCES "users"("id") ON UPDATE SET NULL)");
            }
            SECTION("set_default") {
                auto fk = foreign_key(&Visit::userId).references(&User::id).on_update.set_default();

                using ForeignKey = decltype(fk);
                STATIC_REQUIRE(std::is_same<ForeignKey::target_type, User>::value);
                STATIC_REQUIRE(std::is_same<ForeignKey::source_type, Visit>::value);

                auto visitsTable = make_table("visits",
                                              make_column("id", &Visit::id, primary_key().autoincrement()),
                                              make_column("user_id", &Visit::userId),
                                              make_column("time", &Visit::time),
                                              fk);

                using db_objects_t = internal::db_objects_tuple<decltype(usersTable), decltype(visitsTable)>;

                db_objects_t dbObjects{usersTable, visitsTable};

                using context_t = internal::serializer_context<db_objects_t>;

                context_t context{dbObjects};
                auto value = serialize(fk, context);
                REQUIRE(value == R"(FOREIGN KEY("user_id") REFERENCES "users"("id") ON UPDATE SET DEFAULT)");
            }
            SECTION("cascade") {
                auto fk = foreign_key(&Visit::userId).references(&User::id).on_update.cascade();

                using ForeignKey = decltype(fk);
                STATIC_REQUIRE(std::is_same<ForeignKey::target_type, User>::value);
                STATIC_REQUIRE(std::is_same<ForeignKey::source_type, Visit>::value);

                auto visitsTable = make_table("visits",
                                              make_column("id", &Visit::id, primary_key().autoincrement()),
                                              make_column("user_id", &Visit::userId),
                                              make_column("time", &Visit::time),
                                              fk);

                using db_objects_t = internal::db_objects_tuple<decltype(usersTable), decltype(visitsTable)>;

                db_objects_t dbObjects{usersTable, visitsTable};

                using context_t = internal::serializer_context<db_objects_t>;

                context_t context{dbObjects};
                auto value = serialize(fk, context);
                REQUIRE(value == R"(FOREIGN KEY("user_id") REFERENCES "users"("id") ON UPDATE CASCADE)");
            }
        }
        SECTION("on delete") {
            SECTION("no_action") {
                auto fk = foreign_key(&Visit::userId).references(&User::id).on_delete.no_action();

                using ForeignKey = decltype(fk);
                STATIC_REQUIRE(std::is_same<ForeignKey::target_type, User>::value);
                STATIC_REQUIRE(std::is_same<ForeignKey::source_type, Visit>::value);

                auto visitsTable = make_table("visits",
                                              make_column("id", &Visit::id, primary_key().autoincrement()),
                                              make_column("user_id", &Visit::userId),
                                              make_column("time", &Visit::time),
                                              fk);

                using db_objects_t = internal::db_objects_tuple<decltype(usersTable), decltype(visitsTable)>;

                db_objects_t dbObjects{usersTable, visitsTable};

                using context_t = internal::serializer_context<db_objects_t>;

                context_t context{dbObjects};
                auto value = serialize(fk, context);
                REQUIRE(value == R"(FOREIGN KEY("user_id") REFERENCES "users"("id") ON DELETE NO ACTION)");
            }
            SECTION("restrict_") {
                auto fk = foreign_key(&Visit::userId).references(&User::id).on_delete.restrict_();

                using ForeignKey = decltype(fk);
                STATIC_REQUIRE(std::is_same<ForeignKey::target_type, User>::value);
                STATIC_REQUIRE(std::is_same<ForeignKey::source_type, Visit>::value);

                auto visitsTable = make_table("visits",
                                              make_column("id", &Visit::id, primary_key().autoincrement()),
                                              make_column("user_id", &Visit::userId),
                                              make_column("time", &Visit::time),
                                              fk);

                using db_objects_t = internal::db_objects_tuple<decltype(usersTable), decltype(visitsTable)>;

                db_objects_t dbObjects{usersTable, visitsTable};

                using context_t = internal::serializer_context<db_objects_t>;

                context_t context{dbObjects};
                auto value = serialize(fk, context);
                REQUIRE(value == R"(FOREIGN KEY("user_id") REFERENCES "users"("id") ON DELETE RESTRICT)");
            }
            SECTION("set_null") {
                auto fk = foreign_key(&Visit::userId).references(&User::id).on_delete.set_null();

                using ForeignKey = decltype(fk);
                STATIC_REQUIRE(std::is_same<ForeignKey::target_type, User>::value);
                STATIC_REQUIRE(std::is_same<ForeignKey::source_type, Visit>::value);

                auto visitsTable = make_table("visits",
                                              make_column("id", &Visit::id, primary_key().autoincrement()),
                                              make_column("user_id", &Visit::userId),
                                              make_column("time", &Visit::time),
                                              fk);

                using db_objects_t = internal::db_objects_tuple<decltype(usersTable), decltype(visitsTable)>;

                db_objects_t dbObjects{usersTable, visitsTable};

                using context_t = internal::serializer_context<db_objects_t>;

                context_t context{dbObjects};
                auto value = serialize(fk, context);
                REQUIRE(value == R"(FOREIGN KEY("user_id") REFERENCES "users"("id") ON DELETE SET NULL)");
            }
            SECTION("set_default") {
                auto fk = foreign_key(&Visit::userId).references(&User::id).on_delete.set_default();

                using ForeignKey = decltype(fk);
                STATIC_REQUIRE(std::is_same<ForeignKey::target_type, User>::value);
                STATIC_REQUIRE(std::is_same<ForeignKey::source_type, Visit>::value);

                auto visitsTable = make_table("visits",
                                              make_column("id", &Visit::id, primary_key().autoincrement()),
                                              make_column("user_id", &Visit::userId),
                                              make_column("time", &Visit::time),
                                              fk);

                using db_objects_t = internal::db_objects_tuple<decltype(usersTable), decltype(visitsTable)>;

                db_objects_t dbObjects{usersTable, visitsTable};

                using context_t = internal::serializer_context<db_objects_t>;

                context_t context{dbObjects};
                auto value = serialize(fk, context);
                REQUIRE(value == R"(FOREIGN KEY("user_id") REFERENCES "users"("id") ON DELETE SET DEFAULT)");
            }
            SECTION("cascade") {
                auto fk = foreign_key(&Visit::userId).references(&User::id).on_delete.cascade();

                using ForeignKey = decltype(fk);
                STATIC_REQUIRE(std::is_same<ForeignKey::target_type, User>::value);
                STATIC_REQUIRE(std::is_same<ForeignKey::source_type, Visit>::value);

                auto visitsTable = make_table("visits",
                                              make_column("id", &Visit::id, primary_key().autoincrement()),
                                              make_column("user_id", &Visit::userId),
                                              make_column("time", &Visit::time),
                                              fk);

                using db_objects_t = internal::db_objects_tuple<decltype(usersTable), decltype(visitsTable)>;

                db_objects_t dbObjects{usersTable, visitsTable};

                using context_t = internal::serializer_context<db_objects_t>;

                context_t context{dbObjects};
                auto value = serialize(fk, context);
                REQUIRE(value == R"(FOREIGN KEY("user_id") REFERENCES "users"("id") ON DELETE CASCADE)");
            }
        }
    }
    SECTION("one to explicit one") {
        struct Object {
            int id = 0;

#ifndef SQLITE_ORM_AGGREGATE_NSDMI_SUPPORTED
            Object() = default;
            Object(int id) : id{id} {}
#endif
        };

        struct User : Object {
            std::string name;

            User(decltype(id) id_, decltype(name) name_) : Object{id_}, name(move(name_)) {}
        };

        struct Token : Object {
            std::string token;
            int usedId = 0;

            Token(decltype(id) id_, decltype(token) token_, decltype(usedId) usedId_) :
                Object{id_}, token(std::move(token_)), usedId(usedId_) {}
        };
        auto fk = foreign_key(&Token::usedId).references(column<User>(&User::id));

        using ForeignKey = decltype(fk);
        STATIC_REQUIRE(std::is_same<ForeignKey::target_type, User>::value);
        STATIC_REQUIRE(std::is_same<ForeignKey::source_type, Token>::value);

        auto usersTable =
            make_table<User>("users", make_column("id", &User::id, primary_key()), make_column("name", &User::name));
        auto tokensTable = make_table<Token>("tokens",
                                             make_column("id", &Token::id, primary_key()),
                                             make_column("token", &Token::token),
                                             make_column("user_id", &Token::usedId),
                                             fk);

        using db_objects_t = internal::db_objects_tuple<decltype(usersTable), decltype(tokensTable)>;

        db_objects_t dbObjects{usersTable, tokensTable};

        using context_t = internal::serializer_context<db_objects_t>;

        context_t context{dbObjects};
        auto value = serialize(fk, context);
        REQUIRE(value == R"(FOREIGN KEY("user_id") REFERENCES "users"("id"))");
    }
    SECTION("composite key") {
        using namespace sqlite_orm::internal::storage_traits;

        struct User {
            int id = 0;
            std::string firstName;
            std::string lastName;
        };

        struct UserVisit {
            int userId = 0;
            std::string userFirstName;
            time_t time = 0;
        };

        auto fk = foreign_key(&UserVisit::userId, &UserVisit::userFirstName).references(&User::id, &User::firstName);

        using ForeignKey = decltype(fk);
        STATIC_REQUIRE(std::is_same<ForeignKey::target_type, User>::value);
        STATIC_REQUIRE(std::is_same<ForeignKey::source_type, UserVisit>::value);

        auto usersTable = make_table("users",
                                     make_column("id", &User::id),
                                     make_column("first_name", &User::firstName),
                                     make_column("last_name", &User::lastName),
                                     primary_key(&User::id, &User::firstName));

        STATIC_REQUIRE(table_foreign_keys_count<decltype(usersTable), User>::value == 0);
        STATIC_REQUIRE(table_foreign_keys_count<decltype(usersTable), UserVisit>::value == 0);

        auto visitsTable = make_table("visits",
                                      make_column("user_id", &UserVisit::userId),
                                      make_column("user_first_name", &UserVisit::userFirstName),
                                      make_column("time", &UserVisit::time),
                                      fk);
        STATIC_REQUIRE(table_foreign_keys_count<decltype(visitsTable), User>::value == 1);
        STATIC_REQUIRE(table_foreign_keys_count<decltype(visitsTable), UserVisit>::value == 0);

        using db_objects_t = internal::db_objects_tuple<decltype(usersTable), decltype(visitsTable)>;

        db_objects_t dbObjects{usersTable, visitsTable};

        using context_t = internal::serializer_context<db_objects_t>;

        context_t context{dbObjects};
        auto value = serialize(fk, context);
        REQUIRE(value == R"(FOREIGN KEY("user_id", "user_first_name") REFERENCES "users"("id", "first_name"))");
    }
}

#endif  //  SQLITE_VERSION_NUMBER