|
#include <iomanip>
|
|
#include <iostream>
|
|
#include <tuple>
|
|
|
|
#include "DBManager.h"
|
|
|
|
|
|
// helper function to print a tuple of any size
|
|
template<class Tuple, std::size_t N>
|
|
struct TuplePrinter {
|
|
static void print(const Tuple& t)
|
|
{
|
|
TuplePrinter<Tuple, N-1>::print(t);
|
|
std::cout << ", " << std::get<N-1>(t);
|
|
}
|
|
};
|
|
|
|
template<class Tuple>
|
|
struct TuplePrinter<Tuple, 1> {
|
|
static void print(const Tuple& t)
|
|
{
|
|
std::cout << std::get<0>(t);
|
|
}
|
|
};
|
|
|
|
template<class... Args>
|
|
void print(const std::tuple<Args...>& t)
|
|
{
|
|
std::cout << "(";
|
|
TuplePrinter<decltype(t), sizeof...(Args)>::print(t);
|
|
std::cout << ")\n";
|
|
}
|
|
|
|
|
|
int main(int argc, char** argv)
|
|
{
|
|
std::cout << "SQLite Proof of Concept Exerciser" << std::endl;
|
|
|
|
// Make a DBManager instance which will connect to our test DB automagically
|
|
DBManager db_mgr("database.db");
|
|
|
|
// Make a query
|
|
std::string query("SELECT Number, Words, Float FROM sample;");
|
|
|
|
// Execute the query making sure the template params match up with the
|
|
// query params
|
|
int rc = 0;
|
|
auto results = db_mgr.execute_query<int64_t, std::string, double>(query, rc);
|
|
std::cout << "Return code: " << rc << std::endl;
|
|
|
|
// If we returned successfully, print out the result rows
|
|
if (! rc)
|
|
{
|
|
uint32_t row_index = 0;
|
|
for (auto row : *results)
|
|
{
|
|
std::cout << "Row: " << std::setw(4) << row_index << " - ";
|
|
print(*row);
|
|
++row_index;
|
|
delete row;
|
|
}
|
|
|
|
delete results;
|
|
}
|
|
|
|
return 0;
|
|
}
|