oatpp-sqlite icon indicating copy to clipboard operation
oatpp-sqlite copied to clipboard

SQLite adapter for oatpp ORM.

Results 7 oatpp-sqlite issues
Sort by recently updated
recently updated
newest added

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.

enhancement

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 =...