constexpr-sql/example.cpp at master · mkitzan/constexpr-sql · GitHub

41 lines (34 loc) · 973 Bytes

#include <iostream>

#include <string>

#include "sql.hpp"

using books =

sql::schema<

"books", sql::index<"title">,

sql::column<"title", std::string>,

sql::column<"genre", std::string>,

sql::column<"year", unsigned>,

sql::column<"pages", unsigned>

using authored =

sql::schema<

"authored", sql::index<>,

sql::column<"title", std::string>,

sql::column<"name", std::string>

using query =

sql::query<

"SELECT title AS book, name AS author, year, pages "

"FROM books NATURAL JOIN (SELECT * FROM authored WHERE name = \"Harlan Ellison\") "

"WHERE year = 1967 OR year >= 1972 AND genre = \"science fiction\"",

books, authored

int main()

{

authored a{ sql::load<authored>("tests/data/authored.tsv", '\t') };

books b{ sql::load<books>("tests/data/books.tsv", '\t') };

for (query q{ b, a }; auto const& [book, author, year, pages] : q)

{

std::cout << book << '\t' << author << '\t' << year << '\t' << pages << '\n';

}

return 0;

}

Expand file tree