tests/constraints/unique.cpp - master - UCS/sqlite_orm

tests/constraints/unique.cpp
68 строк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("Unique") {
    using Catch::Matchers::ContainsSubstring;

    struct Contact {
        int id = 0;
        std::string firstName;
        std::string lastName;
        std::string email;

#ifndef SQLITE_ORM_AGGREGATE_NSDMI_SUPPORTED
        Contact() = default;
        Contact(int id, std::string firstName, std::string lastName, std::string email) :
            id{id}, firstName{move(firstName)}, lastName{move(lastName)}, email{move(email)} {}
#endif
    };
    struct Shape {
        int id = 0;
        std::string backgroundColor;
        std::string foregroundColor;

#ifndef SQLITE_ORM_AGGREGATE_NSDMI_SUPPORTED
        Shape() = default;
        Shape(int id, std::string backgroundColor, std::string foregroundColor) :
            id{id}, backgroundColor{move(backgroundColor)}, foregroundColor{move(foregroundColor)} {}
#endif
    };
    struct List {
        int id = 0;
        std::unique_ptr<std::string> email;

#ifndef SQLITE_ORM_AGGREGATE_NSDMI_SUPPORTED
        List() = default;
        List(int id, decltype(email) email) : id{id}, email{move(email)} {}
#endif
    };

    auto storage = make_storage(
        {},
        make_table("contacts",
                   make_column("contact_id", &Contact::id, primary_key()),
                   make_column("first_name", &Contact::firstName),
                   make_column("last_name", &Contact::lastName),
                   make_column("email", &Contact::email, unique())),
        make_table("shapes",
                   make_column("shape_id", &Shape::id, primary_key()),
                   make_column("background_color", &Shape::backgroundColor),
                   make_column("foreground_color", &Shape::foregroundColor),
                   sqlite_orm::unique(&Shape::backgroundColor, &Shape::foregroundColor)),
        make_table("lists", make_column("list_id", &List::id, primary_key()), make_column("email", &List::email)));
    storage.sync_schema();

    storage.insert(Contact{0, "John", "Doe", "john.doe@gmail.com"});

    REQUIRE_THROWS_WITH(storage.insert(Contact{0, "Johnny", "Doe", "john.doe@gmail.com"}),
                        ContainsSubstring("constraint failed"));

    storage.insert(Shape{0, "red", "green"});
    storage.insert(Shape{0, "red", "blue"});
    REQUIRE_THROWS_WITH(storage.insert(Shape{0, "red", "green"}), ContainsSubstring("constraint failed"));

    std::vector<List> lists(2);
    REQUIRE_NOTHROW(storage.insert_range(lists.begin(), lists.end()));
}