1#include <userver/utest/using_namespace_userver.hpp>
3#include <userver/easy.hpp>
5constexpr std::string_view kSchema = R"~(
6CREATE TABLE IF NOT EXISTS key_value_table (
7 key VARCHAR PRIMARY KEY,
8 value VARCHAR
9)
10)~";
12int main(
int argc,
char* argv[]) {
17 [](
const server::
http::HttpRequest& req,
const easy::
PgDep& dep) {
20 "SELECT value FROM key_value_table WHERE key=$1",
28 [](
const server::
http::HttpRequest& req,
const auto& dep) {
31 "INSERT INTO key_value_table(key, value) VALUES($1, $2) ON CONFLICT (key) DO UPDATE SET value = $2",