3#ifndef BOAT_SQL_CATALOG_HPP
4#define BOAT_SQL_CATALOG_HPP
7#include <boat/sql/detail/exec.hpp>
13 inline static auto err = std::logic_error{
"sql"};
15 auto& dial() {
return dialects::find(
command->dbms()); }
20 std::vector<db::source>
sources()
override {
return {}; }
22 std::vector<db::layer>
layers()
override
30 std::string_view schema_name,
31 std::string_view table_name)
override
33 return sql::get_table(*
command, schema_name, table_name);
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);
53 std::stop_token tok = {})
override
57 check(!rs.
columns.empty(),
"no columns");
58 auto cols = std::vector<std::unique_ptr<adaptors::adaptor>>{};
60 cols.push_back(adaptors::make(tbl.
dbms, find(tbl.
columns, col)));
62 rs | std::views::chunk(std::max<>(1uz, 999uz / cols.size()))) {
63 if (tok.stop_requested())
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,
", ");
83 auto t = migrate(*
command, tbl);
85 return get_table(t.schema_name, t.table_name);
88 void drop(std::string_view schema_name, std::string_view table_name)
91 auto scm = current_schema_or(*
command, schema_name);
92 command->exec({
"drop table if exists ",
id{scm, table_name}});
97 std::generator<std::pair<tile, gil::any_image>>
read(
99 std::vector<tile>)
override
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:14
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
bool empty() const
Definition rowset.hpp:17
std::vector< std::string > columns
Definition rowset.hpp:14
std::vector< column > columns
Definition meta.hpp:58
std::string dbms
Lowercase.
Definition meta.hpp:55
model::box< point > box
Definition vocabulary.hpp:71