tests/statement_serializer_tests/column_constraints/generated.cpp - master - UCS/sqlite_orm

tests/statement_serializer_tests/column_constraints/generated.cpp
81 строка3 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>

using namespace sqlite_orm;

#if SQLITE_VERSION_NUMBER >= 3031000
TEST_CASE("issue893") {
    struct Object {
        std::string name;
        int nameLen;
        int number;
    };
    auto storage =
        make_storage("",
                     make_table("objects",
                                make_column("name", &Object::name),
                                make_column("name_len", &Object::nameLen, generated_always_as(length(&Object::name))),
                                make_column("number", &Object::number)));
    storage.sync_schema();
}

TEST_CASE("statement_serializer generated") {
    using internal::serialize;
    struct Type {
        int a = 0;
        int b = 0;
        std::string c;
        int d = 0;
        std::string e;
    };
    auto table = make_table(
        "t1",
        make_column("a", &Type::a, primary_key()),
        make_column("b", &Type::b),
        make_column("c", &Type::c),
        make_column("d", &Type::d, generated_always_as(&Type::a * sqlite_orm::abs(&Type::b)).virtual_()),
        make_column("e", &Type::e, generated_always_as(substr(&Type::c, &Type::b, add(&Type::b, 1))).stored()));
    using db_objects_t = internal::db_objects_tuple<decltype(table)>;
    auto dbObjects = db_objects_t{table};
    using context_t = internal::serializer_context<db_objects_t>;
    context_t context{dbObjects};
    std::string value;
    decltype(value) expected;
    SECTION("full") {
        auto constraint = generated_always_as(&Type::a * sqlite_orm::abs(&Type::b));
        value = serialize(constraint, context);
        expected = R"(GENERATED ALWAYS AS (("a" * (ABS("b")))))";
    }
    SECTION("full virtual") {
        auto constraint = generated_always_as(&Type::a * sqlite_orm::abs(&Type::b)).virtual_();
        value = serialize(constraint, context);
        expected = R"(GENERATED ALWAYS AS (("a" * (ABS("b")))) VIRTUAL)";
    }
    SECTION("full stored") {
        auto constraint = generated_always_as(&Type::a * sqlite_orm::abs(&Type::b)).stored();
        value = serialize(constraint, context);
        expected = R"(GENERATED ALWAYS AS (("a" * (ABS("b")))) STORED)";
    }
    SECTION("not full") {
        auto constraint = as(&Type::a * sqlite_orm::abs(&Type::b));
        value = serialize(constraint, context);
        expected = R"(AS (("a" * (ABS("b")))))";
    }
    SECTION("not full virtual") {
        auto constraint = as(&Type::a * sqlite_orm::abs(&Type::b)).virtual_();
        value = serialize(constraint, context);
        expected = R"(AS (("a" * (ABS("b")))) VIRTUAL)";
    }
    SECTION("not full stored") {
        auto constraint = as(&Type::a * sqlite_orm::abs(&Type::b)).stored();
        value = serialize(constraint, context);
        expected = R"(AS (("a" * (ABS("b")))) STORED)";
    }
    SECTION("length") {
        auto constraint = generated_always_as(length(&Type::a));
        value = serialize(constraint, context);
        expected = R"(GENERATED ALWAYS AS ((LENGTH("a"))))";
    }
    REQUIRE(value == expected);
}
#endif