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

tests/statement_serializer_tests/column_constraints/check.cpp
74 строки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;

TEST_CASE("statement_serializer check") {
    SECTION("greater than") {
        struct Table {
            int col1 = 0;
            std::string col2;
            int col3 = 0;
        };
        auto ch = check(greater_than(&Table::col3, 0));
        auto table = make_table("tablename",
                                make_column("col1", &Table::col1, primary_key()),
                                make_column("col2", &Table::col2),
                                make_column("col3", &Table::col3, ch));

        using db_objects_t = internal::db_objects_tuple<decltype(table)>;

        db_objects_t dbObjects{table};

        using context_t = internal::serializer_context<db_objects_t>;

        context_t context{dbObjects};
        std::string value;
        std::string expected;
        SECTION("with parentheses") {
            context.use_parentheses = true;
            value = serialize(ch, context);
            expected = R"(CHECK (("col3" > 0)))";
        }
        SECTION("without parentheses") {
            context.use_parentheses = false;
            value = serialize(ch, context);
            expected = R"(CHECK ("col3" > 0))";
        }
        REQUIRE(value == expected);
    }
    SECTION("lesser than") {
        struct Book {
            int id = 0;
            std::string name;
            std::string pubName;
            int price = 0;
        };
        auto ch = check(lesser_than(0, &Book::price));
        auto table = make_table("BOOK",
                                make_column("Book_id", &Book::id, primary_key()),
                                make_column("Book_name", &Book::name),
                                make_column("Pub_name", &Book::pubName),
                                make_column("PRICE", &Book::price, ch));
        using db_objects_t = internal::db_objects_tuple<decltype(table)>;

        db_objects_t dbObjects{table};

        using context_t = internal::serializer_context<db_objects_t>;

        context_t context{dbObjects};
        std::string value;
        std::string expected;
        SECTION("with parentheses") {
            context.use_parentheses = true;
            value = serialize(ch, context);
            expected = R"(CHECK ((0 < "PRICE")))";
        }
        SECTION("without parentheses") {
            context.use_parentheses = false;
            value = serialize(ch, context);
            expected = R"(CHECK (0 < "PRICE"))";
        }
        REQUIRE(value == expected);
    }
}