samples/ydb_service/views/upsert-row/post/view.cpp

#include "view.hpp"
 
#include <userver/formats/json.hpp>
#include <userver/ydb/table.hpp>
 
namespace sample {

formats::json::Value UpsertRowHandler::
    HandleRequestJsonThrow(const server::http::HttpRequest& http_request, const formats::json::Value& request, server::request::RequestContext&)
        const {
    http_request.GetHttpResponse().SetContentType(http::content_type::kApplicationJson);
    static const ydb::Query kUpsertQuery{
        R"(
--!syntax_v1
DECLARE $id_key AS String;
DECLARE $name_key AS Utf8;
DECLARE $service_key AS String;
DECLARE $channel_key AS Int64;
DECLARE $state_key AS Json?;
 
UPSERT INTO events (id, name, service, channel, created, state)
VALUES ($id_key, $name_key, $service_key, $channel_key, CurrentUtcTimestamp(), $state_key);
      )",
        ydb::Query::NameLiteral{"upsert-row"},
        ydb::Query::LogMode::kNameOnly,
    };
 
    auto response = Ydb().ExecuteDataQuery(
        kUpsertQuery,  //
        "$id_key",
        request["id"].As<std::string>(),  //
        "$name_key",
        request["name"].As<ydb::Utf8>(),  //
        "$service_key",
        request["service"].As<std::string>(),  //
        "$channel_key",
        request["channel"].As<std::int64_t>(),  //
        "$state_key",
        request["state"].As<std::optional<formats::json::Value>>()  //
    );
 
    if (response.GetCursorCount()) {
        throw std::runtime_error("Unexpected response data");
    }
 
    return formats::json::MakeObject();
}
 
}  // namespace sample