cet::sqlite::detail Namespace Reference

Classes
struct	bind_parameters
struct	bind_parameters< TUP, 1 >
class	DefaultDatabaseOpenPolicy

Functions
template<typename T , typename... Constraints>
std::string	column_info (column< T, Constraints... > const &col)
template<typename H , typename... T>
std::string	columns (H const &h, T const &...t)
std::string	create_table (std::string const &tablename)
template<typename... Cols>
std::string	create_table_ddl (std::string const &tablename, Cols const &...cols)
std::string	create_table_as_ddl (std::string const &tablename, SelectStmt const &stmt)
void	bind_one_parameter (sqlite3_stmt *s, std::size_t const idx, double const v)
void	bind_one_parameter (sqlite3_stmt *s, std::size_t const idx, int const v)
void	bind_one_parameter (sqlite3_stmt *s, std::size_t const idx, std::uint32_t const v)
void	bind_one_parameter (sqlite3_stmt *s, std::size_t const idx, sqlite_int64 const v)
void	bind_one_parameter (sqlite3_stmt *s, std::size_t const idx, std::string const &v)
void	bind_one_null (sqlite3_stmt *s, std::size_t const idx)
template<typename T >
auto	convertTo (std::string const &arg)
template<>
auto	convertTo< int > (std::string const &arg)
template<>
auto	convertTo< long > (std::string const &arg)
template<>
auto	convertTo< long long > (std::string const &arg)
template<>
auto	convertTo< unsigned > (std::string const &arg)
template<>
auto	convertTo< unsigned long > (std::string const &arg)
template<>
auto	convertTo< unsigned long long > (std::string const &arg)
template<>
auto	convertTo< float > (std::string const &arg)
template<>
auto	convertTo< double > (std::string const &arg)
template<>
auto	convertTo< long double > (std::string const &arg)
template<std::size_t I, typename Tuple >
std::enable_if_t<(I==std::tuple_size_v< Tuple >)>	fillData (Tuple &, int const ncols[[maybe_unused]], int const currentcol[[maybe_unused]], char **)
template<std::size_t I, typename Tuple >
std::enable_if_t<(I< std::tuple_size_v< Tuple >)>	fillData (Tuple &data, int const ncols, int currentcol, char **results)
template<typename... Args>
int	get_result (void *data, int ncols, char **results, char **cnames)
void	normalize_statement (std::string &to_replace)
std::string	normalized_statement (std::string to_replace)
std::string	maybe_quote (std::string const &s)
std::string	maybe_quote (char const *s)
template<typename T >
T	maybe_quote (T const &t)
void	values_str_impl (std::ostream &)
template<typename H , typename... T>
void	values_str_impl (std::ostream &os, H const &h, T const &...t)
template<typename... Args>
std::string	values_str (Args const &...args)
template<typename H , typename... T>
std::string	concatenate (H const &h, T const &...t)

Function Documentation

void cet::sqlite::detail::bind_one_null	(	sqlite3_stmt *	s,
		std::size_t const	idx
	)

Definition at line 69 of file bind_parameters.cc.

{
  int const rc{sqlite3_bind_null(s, idx)};
  if (rc != SQLITE_OK)
    throw_bind_failure("null", rc);
}

void cet::sqlite::detail::bind_one_parameter	(	sqlite3_stmt *	s,
		std::size_t const	idx,
		double const	v
	)

Definition at line 19 of file bind_parameters.cc.

{
  int const rc{sqlite3_bind_double(s, idx, v)};
  if (rc != SQLITE_OK)
    throw_bind_failure("double", rc);
}

void cet::sqlite::detail::bind_one_parameter	(	sqlite3_stmt *	s,
		std::size_t const	idx,
		int const	v
	)

Definition at line 29 of file bind_parameters.cc.

{
  int const rc{sqlite3_bind_int(s, idx, v)};
  if (rc != SQLITE_OK)
    throw_bind_failure("int", rc);
}

void cet::sqlite::detail::bind_one_parameter	(	sqlite3_stmt *	s,
		std::size_t const	idx,
		std::uint32_t const	v
	)

Definition at line 39 of file bind_parameters.cc.

{
  int const rc{sqlite3_bind_int64(s, idx, v)};
  if (rc != SQLITE_OK)
    throw_bind_failure("int64", rc);
}

void cet::sqlite::detail::bind_one_parameter	(	sqlite3_stmt *	s,
		std::size_t const	idx,
		sqlite_int64 const	v
	)

Definition at line 49 of file bind_parameters.cc.

{
  int const rc{sqlite3_bind_int64(s, idx, v)};
  if (rc != SQLITE_OK)
    throw_bind_failure("int64", rc);
}

void cet::sqlite::detail::bind_one_parameter	(	sqlite3_stmt *	s,
		std::size_t const	idx,
		std::string const &	v
	)

Definition at line 59 of file bind_parameters.cc.

{
  int const rc{sqlite3_bind_text(s, idx, v.c_str(), v.size(), nullptr)};
  if (rc != SQLITE_OK)
    throw_bind_failure("text", rc);
}

template<typename T , typename... Constraints>

std::string cet::sqlite::detail::column_info

(

column< T, Constraints... > const &

col

)

Definition at line 74 of file create_table.h.

    {
      std::string info{col.name() + col.sqlite_type()};
      info += (Constraints::snippet() + ... + ""s);
      return info;
    }

template<typename H , typename... T>

std::string cet::sqlite::detail::columns ( H const &  h, T const &...  t  )

inline

Definition at line 83 of file create_table.h.

    {
      return (column_info(h) + ... + (", " + column_info(t)));
    }

template<typename H , typename... T>

std::string cet::sqlite::detail::concatenate	(	H const &	h,
		T const &...	t
	)

Definition at line 138 of file select.h.

    {
      return (std::string{h} + ... + ("," + std::string{t}));
    }

template<typename T >

auto cet::sqlite::detail::convertTo ( std::string const &  arg )

inline

Definition at line 30 of file convert.h.

  {
    return arg;
  }

template<>

auto cet::sqlite::detail::convertTo< double > ( std::string const &  arg )

inline

Definition at line 79 of file convert.h.

  {
    return std::stod(arg);
  }

template<>

auto cet::sqlite::detail::convertTo< float > ( std::string const &  arg )

inline

Definition at line 73 of file convert.h.

  {
    return std::stof(arg);
  }

template<>

auto cet::sqlite::detail::convertTo< int > ( std::string const &  arg )

inline

Definition at line 37 of file convert.h.

  {
    return std::stoi(arg);
  }

template<>

auto cet::sqlite::detail::convertTo< long > ( std::string const &  arg )

inline

Definition at line 43 of file convert.h.

  {
    return std::stol(arg);
  }

template<>

auto cet::sqlite::detail::convertTo< long double > ( std::string const &  arg )

inline

Definition at line 85 of file convert.h.

  {
    return std::stold(arg);
  }

template<>

auto cet::sqlite::detail::convertTo< long long > ( std::string const &  arg )

inline

Definition at line 49 of file convert.h.

  {
    return std::stoll(arg);
  }

template<>

auto cet::sqlite::detail::convertTo< unsigned > ( std::string const &  arg )

inline

Definition at line 55 of file convert.h.

  {
    return std::stoul(arg);
  }

template<>

auto cet::sqlite::detail::convertTo< unsigned long > ( std::string const &  arg )

inline

Definition at line 61 of file convert.h.

  {
    return std::stoul(arg);
  }

template<>

auto cet::sqlite::detail::convertTo< unsigned long long > ( std::string const &  arg )

inline

Definition at line 67 of file convert.h.

  {
    return std::stoull(arg);
  }

std::string cet::sqlite::detail::create_table ( std::string const &  tablename )

inline

Definition at line 89 of file create_table.h.

    {
      return "CREATE TABLE "s + tablename;
    }

std::string cet::sqlite::detail::create_table_as_ddl ( std::string const &  tablename, SelectStmt const &  stmt  )

inline

Definition at line 106 of file create_table.h.

    {
      std::string ddl{create_table(tablename)};
      ddl += " AS ";
      ddl += stmt.ddl_;
      return ddl;
    }

template<typename... Cols>

std::string cet::sqlite::detail::create_table_ddl	(	std::string const &	tablename,
		Cols const &...	cols
	)

Definition at line 96 of file create_table.h.

    {
      std::string ddl{create_table(tablename)};
      ddl += "( ";
      ddl += columns(cols...);
      ddl += " )";
      return ddl;
    }

template<std::size_t I, typename Tuple >

std::enable_if_t<(I == std::tuple_size_v<Tuple>)> cet::sqlite::detail::fillData	(	Tuple &	,
		int const ncols]	[[maybe_unused],
		int const currentcol]	[[maybe_unused],
		char **
	)

Definition at line 14 of file get_result.h.

  {
    assert(currentcol == ncols);
  }

template<std::size_t I, typename Tuple >

std::enable_if_t<(I < std::tuple_size_v<Tuple>)> cet::sqlite::detail::fillData	(	Tuple &	data,
		int const	ncols,
		int	currentcol,
		char **	results
	)

Definition at line 24 of file get_result.h.

  {
    assert(currentcol != ncols);
    using ET = std::tuple_element_t<I, Tuple>;
    std::get<I>(data) = detail::convertTo<ET>(results[currentcol]);
    fillData<I + 1>(data, ncols, ++currentcol, results);
  }

template<typename... Args>

int cet::sqlite::detail::get_result	(	void *	data,
		int	ncols,
		char **	results,
		char **	cnames
	)

Definition at line 34 of file get_result.h.

  {
    assert(ncols >= 1);
    auto j = static_cast<cet::sqlite::query_result<Args...>*>(data);
    if (j->columns.empty()) {
      for (int i{}; i < ncols; ++i)
        j->columns.push_back(cnames[i]);
    }

    assert(sizeof...(Args) == ncols);
    std::tuple<Args...> rowdata;
    int currentCol{};
    fillData<0u>(rowdata, ncols, currentCol, results);
    j->data.emplace_back(rowdata);
    return 0;
  }

std::string cet::sqlite::detail::maybe_quote ( std::string const &  s )

inline

Definition at line 47 of file insert.h.

    {
      return "\"" + s + "\"";
    }

std::string cet::sqlite::detail::maybe_quote ( char const *  s )

inline

Definition at line 53 of file insert.h.

    {
      return maybe_quote(std::string{s});
    }

template<typename T >

T cet::sqlite::detail::maybe_quote

(

T const &

t

)

Definition at line 60 of file insert.h.

    {
      return t;
    }

void cet::sqlite::detail::normalize_statement

(

std::string &

to_replace

)

Definition at line 6 of file normalize_statement.cc.

{
  // Remove spaces around commas
  {
    std::regex const r{"\\s*,\\s*"};
    to_replace = std::regex_replace(to_replace, r, ",");
  }
  // Remove spaces around parentheses
  {
    std::regex const r{R"(\s*([\(\)])\s*)"};
    to_replace = std::regex_replace(to_replace, r, "$1");
  }
  // Replace multiple spaces with 1 space.
  {
    std::regex const r{"\\s+"};
    to_replace = std::regex_replace(to_replace, r, " ");
  }
}

std::string cet::sqlite::detail::normalized_statement

(

std::string

to_replace

)

Definition at line 25 of file normalize_statement.cc.

{
  normalize_statement(to_replace);
  return to_replace;
}

template<typename... Args>

std::string cet::sqlite::detail::values_str

(

Args const &...

args

)

Definition at line 82 of file insert.h.

    {
      std::ostringstream oss;
      values_str_impl(oss, args...);
      return oss.str();
    }

void cet::sqlite::detail::values_str_impl ( std::ostream &  )

inline

Definition at line 66 of file insert.h.

    {}

template<typename H , typename... T>

void cet::sqlite::detail::values_str_impl	(	std::ostream &	os,
		H const &	h,
		T const &...	t
	)

Definition at line 71 of file insert.h.

    {
      if (sizeof...(T) != 0u) {
        os << maybe_quote(h) << ',';
        values_str_impl(os, t...);
      } else
        os << maybe_quote(h);
    }