oatpp / oatpp-sqlite

SQLite adapter for oatpp ORM.
https://oatpp.io/
Apache License 2.0
23 stars 18 forks source link

Full text search support #19

Closed papaj-na-wrotkach closed 1 year ago

papaj-na-wrotkach commented 1 year ago

Can I use fts with oatpp-sqlite? I tried but I failed: [oatpp::sqlite::Executor::migrateSchema()]:Error. Migration failed for version 1. no such module: fts5 Getting similar error when trying to use fts4.

papaj-na-wrotkach commented 1 year ago

I had to enable fts5 in conan:

conan_cmake_configure(
    REQUIRES
        oatpp/1.3.0
        oatpp-swagger/1.3.0
        oatpp-sqlite/1.3.0
        oatpp-openssl/1.3.0
        jwt-cpp/0.6.0
        openssl/3.0.8

    GENERATORS
        cmake_paths
        cmake_find_package

    OPTIONS
        sqlite3:enable_fts5=True # This line
)