diff options
author | louiz’ <louiz@louiz.org> | 2017-06-13 10:38:39 +0200 |
---|---|---|
committer | louiz’ <louiz@louiz.org> | 2017-06-14 00:19:15 +0200 |
commit | 50cadf3dac0d56ef8181d1800cc30f8dcb749141 (patch) | |
tree | 23e56307a6fba4f926d261f858c8df8b6b8d5ea7 /src/database/query.hpp | |
parent | 7ca95a09740297ae9c041c5f8ae4caa0a57a149a (diff) | |
download | biboumi-50cadf3dac0d56ef8181d1800cc30f8dcb749141.tar.gz biboumi-50cadf3dac0d56ef8181d1800cc30f8dcb749141.tar.bz2 biboumi-50cadf3dac0d56ef8181d1800cc30f8dcb749141.tar.xz biboumi-50cadf3dac0d56ef8181d1800cc30f8dcb749141.zip |
Implement our own database ORM, and update the whole code to use it
Entirely replace LiteSQL
fix #3271
Diffstat (limited to 'src/database/query.hpp')
-rw-r--r-- | src/database/query.hpp | 46 |
1 files changed, 46 insertions, 0 deletions
diff --git a/src/database/query.hpp b/src/database/query.hpp new file mode 100644 index 0000000..92845d0 --- /dev/null +++ b/src/database/query.hpp @@ -0,0 +1,46 @@ +#pragma once + +#include <logger/logger.hpp> + +#include <vector> +#include <string> + +#include <sqlite3.h> + +struct Query +{ + std::string body; + std::vector<std::string> params; + + Query(std::string str): + body(std::move(str)) + {} + + sqlite3_stmt* prepare(sqlite3* db) + { + sqlite3_stmt* statement; + log_debug(this->body); + auto res = sqlite3_prepare(db, this->body.data(), static_cast<int>(this->body.size()) + 1, + &statement, nullptr); + if (res != SQLITE_OK) + { + log_error("Error preparing statement: ", sqlite3_errmsg(db)); + return nullptr; + } + return statement; + } +}; + +template <typename ColumnType> +void add_param(Query& query, const ColumnType& column) +{ + actual_add_param(query, column.value); +} + +template <typename T> +void actual_add_param(Query& query, const T& val) +{ + query.params.push_back(std::to_string(val)); +} + +void actual_add_param(Query& query, const std::string& val); |