cet::sqlite Namespace Reference

Namespaces
	detail
	errors
	ExceptionDetail

Classes
struct	column
struct	column< double, Constraints... >
struct	column< float, Constraints... >
struct	column< int, Constraints... >
struct	column< long long, Constraints... >
struct	column< long, Constraints... >
struct	column< std::string, Constraints... >
struct	column< unsigned int, Constraints... >
struct	column< unsigned long long, Constraints... >
struct	column< unsigned long, Constraints... >
class	column_base
class	Connection
class	ConnectionFactory
struct	IncompleteInsert
struct	IncompleteSelectStmt
class	Ntuple
struct	permissive_column
struct	permissive_column< column< T, Constraints... > >
struct	primary_key
struct	query_result
struct	SelectStmt
class	Transaction

Typedefs
template<size_t N>
using	name_array = std::array< std::string, N >
using	Exception = cet::coded_exception< errors::ErrorCodes, ExceptionDetail::translate >

Functions
template<typename... Cols>
void	create_table (sqlite3 *const db, std::string const &tablename, Cols const &...cols)
void	create_table_as (std::string const &tablename, SelectStmt const &stmt)
void	exec (sqlite3 *db, std::string const &ddl)
std::string	assembleNoLockURI (std::string const &filename)
bool	hasTableWithSchema (sqlite3 *db, std::string const &tablename, std::string expectedSchema)
unsigned	nrows (sqlite3 *db, std::string const &tablename)
void	delete_from (sqlite3 *db, std::string const &tablename)
void	drop_table (sqlite3 *db, std::string const &tablename)
void	drop_table_if_exists (sqlite3 *db, std::string const &tablename)
template<typename... Args>
void	createTableIfNeeded (sqlite3 *db, bool const delete_contents, std::string const &tablename, permissive_column< Args > const &...cols)
auto	insert_into (sqlite3 *const db, std::string const &tablename)
template<typename T >
T	unique_value (query_result< T > const &r)
template<typename... Args>
std::ostream &	operator<< (std::ostream &os, query_result< Args... > const &res)
template<typename... Args>
query_result< Args... >	query (sqlite3 *db, std::string const &ddl)
template<typename... T>
auto	select (T const &...t)
template<typename... T>
auto	select_distinct (T const &...t)
template<typename... Args>
void	operator<< (query_result< Args... > &r, SelectStmt const &cq)
template<typename T = double>
T	min (sqlite3 *const db, std::string const &table_name, std::string const &column_name)
template<typename T = double>
T	max (sqlite3 *const db, std::string const &table_name, std::string const &column_name)
double	mean (sqlite3 *db, std::string const &table_name, std::string const &column_name)
double	median (sqlite3 *db, std::string const &table_name, std::string const &column_name)
double	rms (sqlite3 *db, std::string const &table_name, std::string const &column_name)

Typedef Documentation

using cet::sqlite::Exception = typedef cet::coded_exception<errors::ErrorCodes, ExceptionDetail::translate>

Definition at line 33 of file Exception.h.

template<size_t N>

using cet::sqlite::name_array = typedef std::array<std::string, N>

Definition at line 42 of file column.h.

Function Documentation

std::string cet::sqlite::assembleNoLockURI

(

std::string const &

filename

)

template<typename... Cols>

void cet::sqlite::create_table	(	sqlite3 *const	db,
		std::string const &	tablename,
		Cols const &...	cols
	)

Definition at line 156 of file create_table.h.

References cet::sqlite::detail::create_table_ddl(), and exec().

    {
      auto const& ddl = detail::create_table_ddl(tablename, cols...);
      sqlite::exec(db, ddl);
    }

void cet::sqlite::create_table_as ( std::string const &  tablename, SelectStmt const &  stmt  )

inline

Definition at line 165 of file create_table.h.

References cet::sqlite::detail::create_table_as_ddl(), cet::sqlite::SelectStmt::db_, and exec().

Referenced by art::TimeTracker::postEndJob().

    {
      std::string ddl{detail::create_table_as_ddl(tablename, stmt)};
      sqlite::exec(stmt.db_, ddl);
    }

template<typename... Args>

void cet::sqlite::createTableIfNeeded	(	sqlite3 *	db,
		bool const	delete_contents,
		std::string const &	tablename,
		permissive_column< Args > const &...	cols
	)

Definition at line 49 of file helpers.h.

References cet::sqlite::detail::create_table_ddl(), delete_from(), exec(), and hasTableWithSchema().

Referenced by cet::sqlite::Ntuple< Args >::Ntuple().

{
  auto const& sqlddl = detail::create_table_ddl(tablename, cols...);
  if (hasTableWithSchema(db, tablename, sqlddl)) {
    if (delete_contents) {
      delete_from(db, tablename); // Prefer drop_table, but failure-to-prepare
                                  // exception ends up being thrown.
    }
  } else {
    exec(db, sqlddl);
  }
}

void cet::sqlite::delete_from	(	sqlite3 *	db,
		std::string const &	tablename
	)

Referenced by createTableIfNeeded().

void cet::sqlite::drop_table	(	sqlite3 *	db,
		std::string const &	tablename
	)

Referenced by art::TimeTracker::postEndJob().

void cet::sqlite::drop_table_if_exists	(	sqlite3 *	db,
		std::string const &	tablename
	)

void cet::sqlite::exec	(	sqlite3 *	db,
		std::string const &	ddl
	)

Referenced by create_table(), create_table_as(), createTableIfNeeded(), art::TimeTracker::postEndJob(), and cet::sqlite::IncompleteInsert::values().

bool cet::sqlite::hasTableWithSchema	(	sqlite3 *	db,
		std::string const &	tablename,
		std::string	expectedSchema
	)

Referenced by createTableIfNeeded().

auto cet::sqlite::insert_into ( sqlite3 *const  db, std::string const &  tablename  )

inline

Definition at line 112 of file insert.h.

References febshutoff_auto::db, and fillBadChanDBTables::result.

    {
      std::string result{"insert into " + tablename};
      return IncompleteInsert{db, std::move(result)};
    }

template<typename T = double>

T cet::sqlite::max	(	sqlite3 *const	db,
		std::string const &	table_name,
		std::string const &	column_name
	)

Definition at line 68 of file statistics.h.

References r(), select(), and unique_value().

Referenced by stan::variational::advi< stan_model, stan::variational::normal_meanfield, rng_t >::adapt_eta(), genie::flux::GCylindTH1Flux::AddEnergySpectrum(), generic.views.Pages.ComparisonTablePage::AddTable(), AddUpDwUncerts(), AddUpDwUncerts2D(), AnaPlotMaker(), APDPlots(), calib::DCMTimingOffset::beginJob(), evgen::TextFileGen::beginJob(), calib::DriftResponseCalc::beginRun(), calib::DCMTimingOffset::beginRun(), bin_composition_pie_chart(), BinSigma(), ana::GenieMultiverseSpectra::BinSigma(), genie::GMCJDriver::BootstrapXSecSplineSummation(), genie::SKKinematicsGenerator::CalculateKin_AtharSingleKaon(), genie::COHKinematicsGenerator::CalculateKin_ReinSehgal(), stan::math::choose(), cmf::ChiSqrInfo::Clear(), genie::utils::kinematics::CohQ2Lim(), compare_cos_numi(), ana::ComparePredictions(), genie::utils::CosTheta0Max(), cmf::ChiSqrCalculator::CovarianceMatrixEntry(), cmf::ContourFromLibrary::CreateChiSqrMaps(), ViewHighcharts::dataToSeries(), DCMOffsetCalculator(), genie::mueloss::KokoulinPetrukhinModel::dE_dx(), plot_xsec_1d::do_focusing_1bin(), plot_xsec_1d::do_multiverse_1bin(), plot_xsec_1d::do_up_down_1bin(), Canvas.Canvas::draw(), generic.tools.ImageMaker.ImageMaker::draw(), DrawAxes(), fnex::CorrectedSpectrum::DrawCounts(), fnex::CorrectedSpectrum::DrawDataVsMC(), DrawHiddenParameter(), DrawUtils::DrawPlotStack(), DrawSpectrum(), fnex::CorrectedSpectrum::DrawStacks(), ana::TwoSampleDecomp::DrawTwoSamplesWithRatios(), ValidCalibPDF::DriftTex(), calib::TimingCalFilter::endSubRun(), calib::DCMTimingOffset::endSubRun(), ErrorBand(), ValidCalibPDF::EssentialComparisonTex(), event_reweighting_all_knobs(), Tier.Tier::executeProcess(), fd_plot(), raw2daq::RawDigit2DAQHit::FillDAQHits(), cmf::CovarianceMatrixFitter::FillDataSpectrum(), skim::SkimmerAna::FillNumuHistograms(), skim::CosmicBeamComparison::FillNumuHistograms(), fnex::NuMuAnalysisSetup::FillVars(), ana::GenieMultiverseSpectra::FindBandBoundaries(), cmf::CovarianceFitHelper::FindInitialGuess(), FindLimitY(), cmf::SpectrumPredictionMaker::FindOscillationPoints(), ViewBokeh::findRange(), PandAna.weight.xsec_utils.NuWeightDFWrapper::FindXBin(), PandAna.weight.xsec_utils.NuWeightDFWrapper::FindYBin(), ana::FitToFourier::Fit(), FixMCHist(), FormatErrorBand(), ana::FormatErrorBand(), FormatFullCovMxPlot(), get_cosmic_sample(), stan::lang::function_signatures::get_result_type(), stan::lang::function_signatures::get_signature_matches(), DrawUtils::GetBestYRange(), ana::CovMxManager::GetCovarianceMatrix(), GetHistMax(), canMan.Table::getLatex(), GetMaxUpDown(), GetMaxUpDown2D(), canMan.Table::getReadable(), ana::GenieMultiverseSpectra::GetSigmaHistograms(), fnex::CorrectedSpectrum::GetStacksCanvasCopy(), GoodDataSelDate(), GoodDataSelDuration(), GoodDataSelEmptySpillFrac(), GoodDataSelGoodDB(), GoodDataSelLiveTime(), GoodDataSelMipRate(), GoodDataSelNumSlices(), GoodDataSelRuns(), GoodDataSelTimingPeakEnd(), GoodDataSelTimingPeakStart(), GoodDataSelTrkFrac(), goodness_of_fit(), muonid::HighestPIDTrack(), fnex::NuMuAnalysisSetup::HighestPIDTrack(), remid::HighestPIDTrack(), ana::FitTanSqTheta12::HighLimit(), HandyFuncs::HorizontalRange(), genie::HAIntranuke::Inelastic(), genie::HAIntranuke2018::Inelastic(), art::detail::info_success(), genie::BLI2DUnifGrid::Init(), genie::BLI2DNonUnifGrid::Init(), mono::DataCheckMonopole::initialize(), cmf::CovarianceFitHelper::InitializeGlobalVars(), fnex::ParameterConstraints::InsertConstraint(), art::ScheduleID::invalid_id_(), art::RangeSet::invalidChecksum(), art::ModuleDescription::invalidID(), jointsensitivity(), skim::EvaluatorNue::KeepSlice(), PandAna.var.analysis_vars::kMaxY(), nerd::NERDEval::load_truth(), genie::IMDXSec::LoadConfig(), genie::RESXSec::LoadConfig(), genie::DMELXSec::LoadConfig(), genie::DFRXSec::LoadConfig(), genie::MECXSec::LoadConfig(), genie::NuElectronXSec::LoadConfig(), genie::NewQELXSec::LoadConfig(), ana::SingleNucAnalysis::LoadFrom(), ana::NumuCC2p2hAnalysis::LoadFrom(), ana::CrossSectionAnalysis::LoadFrom(), LogClone(), EmPlot::make_plot(), MakeComparisonPlots(), MakeComparisonPlotsWithRatio(), cmf::CovarianceFitHelper::MakeDataMCCanv(), fnex::CovarianceFitHelper::MakeDataMCFitCanvs(), PandAna.Demos.tute_plots::MakeDeltaCVNPlots(), MakeLegend(), SupernovaUtilities::MakeLogList(), MakeMePlot(), MakePlot(), MakeStackNME(), MakeStackPlot(), MatrixValidation(), std::numeric_limits< stan::math::fvar< T > >::max(), std::numeric_limits< stan::math::var >::max(), art::debugging_allocator< T >::max_size(), maxID(), ana::MCMCSamples::MaxValue(), cmf::CovarianceFitHelper::Minimize(), MoveDeltaToT2KUnits(), multihough_production_validation(), myBarChart(), MyPlotWithSystErrorBand(), NDHists(), stan::math::neg_binomial_2_cdf(), stan::math::neg_binomial_cdf(), stan::math::neg_binomial_lccdf(), stan::math::neg_binomial_lcdf(), zcl::FastMonopoleTriggers::NumberOfHitsInOverlapPlanesCut(), novaddt::FastMMTrigger::NumberOfHitsInOverlapPlanesCut(), novaddt::NNFastMMTrigger::NumberOfHitsInOverlapPlanesCut(), zcl::FmmTriggerEvd::NumberOfHitsInOverlapPlanesCut(), zcl::FastMMStudy::NumberOfHitsInOverlapPlanesCut(), OnMonPlotMaker(), skim::ParametersNue::ParametersNue(), skim::ParametersNumu::ParametersNumu(), fnex::InputPoint::ParameterValue(), ParserDBUsage.DBUsage::peak(), PlotErrorBand(), ana::PlotErrorBand(), PlotEvents(), PlotNumuPredData(), PlotRat(), PlotStack(), PlotSystErrorBand(), ana::PlotWithSystErrorBand(), ana::PlotWithSystErrorBand_Quant(), stan::math::poisson_cdf(), stan::math::poisson_lccdf(), stan::math::poisson_lcdf(), pred_err(), HandyFuncs::PrintError(), HandyFuncs::printlist(), plot_xsec_2d::process_focusing(), plot_xsec_2d::process_light_calibration_mue(), plot_xsec_2d::process_multiuniverse(), genie::RESKinematicsGenerator::ProcessEventRecord(), MergeDaqCollections::MergeDaqCollections::produce(), skim::ParametersNumu::ProjectDistToEdge(), ana::RatioPlot(), RatioPlot(), fnex::ContourMaker::readResults(), fnex::StarPlot::readResults(), calib::AttenuationFit::readResults(), fnex::NuEAnalysisSetup::Reconfigure(), art::Defaults::seconds_max(), selection_story_plots(), genie::MECGenerator::SelectNSVLeptonKinematics(), sensitivity2018(), sensitivity2020(), genie::flux::GAstroFlux::SetEnergyPowLawIdx(), evdb::ParameterSetEditRow::SetupSlider(), slicer_production_validation(), ana::sort_chisq_bkg(), ana::sort_chisq_sig(), ana::sort_chisq_tot(), stan::variational::advi< stan_model, stan::variational::normal_meanfield, rng_t >::stochastic_gradient_ascent(), systematics_extrap_comp_from_pred_interp(), systematics_summary_from_pred_interp(), TEST(), test_genieweights(), testfom(), Projections::tierEfficiency(), art::Defaults::unsigned_max(), progbar.ProgressBar::Update(), validation(), and cmf::CovarianceMatrixFitter::~CovarianceMatrixFitter().

{
  query_result<T> r;
  r << select("max(" + column_name + ")").from(db, table_name);
  return unique_value(r);
}

double cet::sqlite::mean	(	sqlite3 *	db,
		std::string const &	table_name,
		std::string const &	column_name
	)

double cet::sqlite::median	(	sqlite3 *	db,
		std::string const &	table_name,
		std::string const &	column_name
	)

template<typename T = double>

T cet::sqlite::min	(	sqlite3 *const	db,
		std::string const &	table_name,
		std::string const &	column_name
	)

Definition at line 57 of file statistics.h.

References r(), select(), T, and unique_value().

{
  query_result<T> r;
  r << select("min(" + column_name + ")").from(db, table_name);
  return unique_value(r);
}

unsigned cet::sqlite::nrows	(	sqlite3 *	db,
		std::string const &	tablename
	)

template<typename... Args>

std::ostream& cet::sqlite::operator<<	(	std::ostream &	os,
		query_result< Args... > const &	res
	)

Definition at line 112 of file query_result.h.

References cet::sqlite::query_result< Args >::columns, cet::sqlite::query_result< Args >::data, MECModelEnuComparisons::i, and check_grl::row.

    {
      using size_t = decltype(res.columns.size());
      auto const ncolumns = res.columns.size();
      for (size_t i{}; i != ncolumns; ++i) {
        os << res.columns[i] << ' ';
      }
      os << "\n--------------------------------\n";
      for (auto const& row : res.data) {
        //        os << row.str() << '\n';
      }
      return os;
    }

template<typename... Args>

void cet::sqlite::operator<<	(	query_result< Args... > &	r,
		SelectStmt const &	cq
	)

Definition at line 171 of file select.h.

References cet::sqlite::SelectStmt::db_, cet::sqlite::SelectStmt::ddl_, and query().

    {
      r = query<Args...>(cq.db_, cq.ddl_ + ";");
    }

template<typename... Args>

query_result<Args...> cet::sqlite::query	(	sqlite3 *	db,
		std::string const &	ddl
	)

Definition at line 76 of file select.h.

References cet::sqlite::detail::get_result(), lem_server::msg, and cet::sqlite::errors::SQLExecutionError.

Referenced by operator<<().

    {
      query_result<Args...> res;
      char* errmsg{nullptr};
      if (sqlite3_exec(
            db, ddl.c_str(), detail::get_result<Args...>, &res, &errmsg) !=
          SQLITE_OK) {
        std::string msg{errmsg};
        sqlite3_free(errmsg);
        throw sqlite::Exception{sqlite::errors::SQLExecutionError} << msg;
      }
      return res;
    }

double cet::sqlite::rms	(	sqlite3 *	db,
		std::string const &	table_name,
		std::string const &	column_name
	)

template<typename... T>

auto cet::sqlite::select

(

T const &...

t

)

Definition at line 155 of file select.h.

References cet::sqlite::detail::concatenate(), fillBadChanDBTables::result, and T.

Referenced by max(), min(), art::TimeTracker::postEndJob(), and art::MemoryTracker::summary_().

    {
      std::string result{"select " + detail::concatenate(t...)};
      return IncompleteSelectStmt{std::move(result)};
    }

template<typename... T>

auto cet::sqlite::select_distinct

(

T const &...

t

)

Definition at line 163 of file select.h.

References cet::sqlite::detail::concatenate(), and fillBadChanDBTables::result.

Referenced by art::TimeTracker::postEndJob().

    {
      std::string result{"select distinct " + detail::concatenate(t...)};
      return IncompleteSelectStmt{std::move(result)};
    }

template<typename T >

T cet::sqlite::unique_value ( query_result< T > const &  r )

inline

Definition at line 101 of file query_result.h.

References cet::sqlite::query_result< Args >::data, and cet::sqlite::errors::SQLExecutionError.

Referenced by max(), min(), art::TimeTracker::postEndJob(), and art::MemoryTracker::summary_().

    {
      if (r.data.size() != 1ull) {
        throw sqlite::Exception{sqlite::errors::SQLExecutionError}
          << "unique_value expected of non-unique query.";
      }
      return std::get<T>(r.data[0]);
    }