oatpp-sqlite
oatpp-sqlite copied to clipboard
SQLite adapter for oatpp ORM.
how fix `database is locked` when run `ASYNC`?
PRAGMA foreign_keys=ON;
How to do it: ```sql SELECT * FROM users WHERE username in (:usernames); ``` `:usernames` is `array`
I am building a project with the given `CMakeLists.txt` with `conan`: ```CMake cmake_minimum_required(VERSION 3.1) set(PROJECT_NAME my-project) project(${PROJECT_NAME}) set(CMAKE_CXX_STANDARD 14) ############################### CONAN SETUP BEGIN ########################################## if(NOT EXISTS "${CMAKE_BINARY_DIR}/conan.cmake") message(STATUS "Downloading conan.cmake...
Similar switch away from StrBuffer to its std::string representation leads to compile errors like ``` oatpp-sqlite/src/oatpp-sqlite/mapping/type/Blob.hpp:40:57: error: ‘StrBuffer’ is not a member of ‘oatpp::base’ 40 | typedef oatpp::data::mapping::type::ObjectWrapper Blob; ```...
Currently, all statements are created each time the `Executor::execute()` method is called - https://github.com/oatpp/oatpp-sqlite/blob/master/src/oatpp-sqlite/Executor.cpp#L121 We should keep prepared statements per connection and reuse them.
Anyone cares to shed a light on how to enable foreign_keys with this library? I've tried doing the following: ```c++ OATPP_CREATE_COMPONENT(std::shared_ptr, dbConnectionProvider)([] { auto connectionProvider = std::make_shared("database.sqlite"); auto result =...