I recommend a good example of a compound index in tests\statement_serializator_tests\schema\index.cpp

[juandent]

Hi Eugene,

I came up with this example and if you like it I recommend adding it to your test files.

// Juan Dent added:
TEST_CASE("Compound index") {
    struct User {
        int id = 0;
        std::string name;
    };
    auto table = make_table("users", make_column("id", &User::id), make_column("name", &User::name));

    using storage_impl_t = internal::storage_impl<decltype(table)>;
    auto storageImpl = storage_impl_t{table};
    using context_t = internal::serializator_context<storage_impl_t>;
    context_t context{storageImpl};
    std::string value;
    decltype(value) expected;

    auto index = make_index("idx_users_id_and_name", indexed_column(&User::id).asc(), indexed_column(&User::name).asc());
    value = internal::serialize(index, context);
    expected = "CREATE INDEX IF NOT EXISTS 'idx_users_id_and_name' ON 'users' (\"id\" ASC, \"name\" ASC)";
    REQUIRE(value == expected);
    auto storage = make_storage("compound_index.sqlite", index, table);
    storage.sync_schema();
    storage.insert(User{ 1,"juan" });
}

Regards,
Juan Dent

[fnc12]

Hi Juan. I'll add it soon. Thanks

[fnc12]

#904