boat
C++23 geospatial library
Loading...
Searching...
No Matches
catalog.hpp
Go to the documentation of this file.
1// Andrew Naplavkov
2
3#ifndef BOAT_SQL_CATALOG_HPP
4#define BOAT_SQL_CATALOG_HPP
5
6#include <boat/db/catalog.hpp>
7#include <boat/sql/detail/exec.hpp>
8
9namespace boat::sql {
10
12class catalog : public db::catalog {
13 inline static auto err = std::logic_error{"sql"};
14
15 auto& dial() { return dialects::find(command->dbms()); }
16
17public:
18 std::unique_ptr<db::command> command;
19
20 std::vector<db::source> sources() override { return {}; }
21
22 std::vector<db::layer> layers() override
23 {
24 return {
25 std::from_range,
26 command->exec(dial().layers()) | db::view<db::layer>};
27 }
28
30 std::string_view schema_name,
31 std::string_view table_name) override
32 {
33 return sql::get_table(*command, schema_name, table_name);
34 }
35
36 db::rowset select(db::table const& tbl, db::page const& rq) override
37 {
38 auto q = db::query{};
39 q << "\n select " << select_list{tbl, rq.select_list} << "\n from "
40 << id{tbl} << order_by{tbl, rq.order_by} << "\n limit "
41 << to_chars(rq.limit) << "\n offset " << to_chars(rq.offset);
42 return command->exec(q);
43 }
44
45 db::rowset select(db::table const& tbl, db::bbox const& rq) override
46 {
47 return command->exec(dial().select(tbl, rq));
48 }
49
50 void insert(
51 db::table const& tbl,
52 db::rowset const& rs,
53 std::stop_token tok = {}) override
54 {
55 if (rs.empty())
56 return;
57 check(!rs.columns.empty(), "no columns");
58 auto cols = std::vector<std::unique_ptr<adaptors::adaptor>>{};
59 for (auto& col : rs.columns)
60 cols.push_back(adaptors::make(tbl.dbms, find(tbl.columns, col)));
61 for (auto&& rows :
62 rs | std::views::chunk(std::max<>(1uz, 999uz / cols.size()))) {
63 if (tok.stop_requested())
64 break;
65 auto q = db::query{"\n insert into ", id{tbl}};
66 for (auto sep{"\n ("}; auto& col : rs.columns)
67 q << std::exchange(sep, ", ") << db::id(col);
68 for (auto sep1{")\n values\n "}; auto& row : rows) {
69 q << std::exchange(sep1, "\n , ");
70 for (auto sep2{"("}; auto [c, v] : std::views::zip(cols, row)) {
71 q << std::exchange(sep2, ", ");
72 c->insert(q, v);
73 }
74 q << ")";
75 }
76 command->exec(q, tok);
77 }
78 }
79
81 db::table create(db::table const& tbl) override
82 {
83 auto t = migrate(*command, tbl);
84 command->exec(dial().create(t));
85 return get_table(t.schema_name, t.table_name);
86 }
87
88 void drop(std::string_view schema_name, std::string_view table_name)
89 override
90 {
91 auto scm = current_schema_or(*command, schema_name);
92 command->exec({"drop table if exists ", id{scm, table_name}});
93 }
94
95 db::raster get_raster(db::layer const&) override { throw err; }
96
97 std::generator<std::pair<tile, gil::any_image>> read(
99 std::vector<tile>) override
100 {
101 throw err;
102 co_return;
103 }
104
105 void write(
106 db::raster const&,
108 gil::any_image_view) override
109 {
110 throw err;
111 }
112
113 void set_autocommit(bool on) override { command->set_autocommit(on); }
114
115 void commit() override { command->commit(); }
116};
117
118} // namespace boat::sql
119
120#endif // BOAT_SQL_CATALOG_HPP
Definition query.hpp:19
Raster operations throw std::logic_error.
Definition catalog.hpp:12
db::table get_table(std::string_view schema_name, std::string_view table_name) override
Definition catalog.hpp:29
std::unique_ptr< db::command > command
Definition catalog.hpp:18
std::vector< db::source > sources() override
May include nested data sources.
Definition catalog.hpp:20
db::raster get_raster(db::layer const &) override
Definition catalog.hpp:95
std::generator< std::pair< tile, gil::any_image > > read(db::raster, std::vector< tile >) override
Definition catalog.hpp:97
db::rowset select(db::table const &tbl, db::page const &rq) override
Definition catalog.hpp:36
std::vector< db::layer > layers() override
Definition catalog.hpp:22
void drop(std::string_view schema_name, std::string_view table_name) override
Definition catalog.hpp:88
void insert(db::table const &tbl, db::rowset const &rs, std::stop_token tok={}) override
Cancellation may leave a partially inserted range.
Definition catalog.hpp:50
db::rowset select(db::table const &tbl, db::bbox const &rq) override
Definition catalog.hpp:45
void commit() override
Definition catalog.hpp:115
void write(db::raster const &, geometry::raster::box const &, gil::any_image_view) override
Definition catalog.hpp:105
db::table create(db::table const &tbl) override
Adapts column types and adds missing spatial indexes.
Definition catalog.hpp:81
void set_autocommit(bool on) override
Definition catalog.hpp:113
constexpr auto view
Columns must match the field count and order; scalars need one column.
Definition rowset.hpp:27
any_image::const_view_t any_image_view
Definition gil.hpp:51
Definition catalog.hpp:9
Definition meta.hpp:69
Definition catalog.hpp:14
Definition meta.hpp:18
Definition meta.hpp:81
int limit
Definition meta.hpp:85
std::vector< order_key > order_by
Definition meta.hpp:83
size_t offset
Definition meta.hpp:84
std::vector< std::string > select_list
Definition meta.hpp:82
Definition meta.hpp:93
Definition rowset.hpp:13
bool empty() const
Definition rowset.hpp:17
std::vector< std::string > columns
Definition rowset.hpp:14
Definition meta.hpp:54
std::vector< column > columns
Definition meta.hpp:58
std::string dbms
Lowercase.
Definition meta.hpp:55
model::box< point > box
Definition vocabulary.hpp:71