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) |
using cet::sqlite::Exception = typedef cet::coded_exception<errors::ErrorCodes, ExceptionDetail::translate> |
Definition at line 33 of file Exception.h.
using cet::sqlite::name_array = typedef std::array<std::string, N> |
std::string cet::sqlite::assembleNoLockURI | ( | std::string const & | filename | ) |
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().
|
inline |
Definition at line 165 of file create_table.h.
References cet::sqlite::detail::create_table_as_ddl(), cet::sqlite::SelectStmt::db_, exec(), and string.
Referenced by art::TimeTracker::postEndJob().
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().
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 | ||
) |
bool cet::sqlite::hasTableWithSchema | ( | sqlite3 * | db, |
std::string const & | tablename, | ||
std::string | expectedSchema | ||
) |
Referenced by createTableIfNeeded().
|
inline |
Definition at line 112 of file insert.h.
References febshutoff_auto::db, fillBadChanDBTables::result, and string.
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(), genie::utils::kinematics::CohQ2Lim(), compare_cos_numi(), ana::ComparePredictions(), genie::utils::CosTheta0Max(), 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(), DrawHiddenParameter(), DrawUtils::DrawPlotStack(), DrawSpectrum(), 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(), ana::GenieMultiverseSpectra::FindBandBoundaries(), FindLimitY(), 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(), GoodDataSelDate(), GoodDataSelDuration(), GoodDataSelEmptySpillFrac(), GoodDataSelGoodDB(), GoodDataSelLiveTime(), GoodDataSelMipRate(), GoodDataSelNumSlices(), GoodDataSelRuns(), GoodDataSelTimingPeakEnd(), GoodDataSelTimingPeakStart(), GoodDataSelTrkFrac(), goodness_of_fit(), muonid::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(), 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::NuElectronXSec::LoadConfig(), genie::MECXSec::LoadConfig(), genie::NewQELXSec::LoadConfig(), ana::SingleNucAnalysis::LoadFrom(), ana::NumuCC2p2hAnalysis::LoadFrom(), ana::CrossSectionAnalysis::LoadFrom(), LogClone(), EmPlot::make_plot(), MakeComparisonPlots(), MakeComparisonPlotsWithRatio(), cmf::CovarianceFitHelper::MakeDataMCCanv(), 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(), 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(), 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(), calib::AttenuationFit::readResults(), cmf::CovarianceMatrixFitter::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(), and validation().
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 | ||
) |
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().
unsigned cet::sqlite::nrows | ( | sqlite3 * | db, |
std::string const & | tablename | ||
) |
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.
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().
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, cet::sqlite::errors::SQLExecutionError, and string.
Referenced by operator<<().
double cet::sqlite::rms | ( | sqlite3 * | db, |
std::string const & | table_name, | ||
std::string const & | column_name | ||
) |
auto cet::sqlite::select | ( | T const &... | t | ) |
Definition at line 155 of file select.h.
References cet::sqlite::detail::concatenate(), fillBadChanDBTables::result, string, and T.
Referenced by max(), min(), art::TimeTracker::postEndJob(), and art::MemoryTracker::summary_().
auto cet::sqlite::select_distinct | ( | T const &... | t | ) |
Definition at line 163 of file select.h.
References cet::sqlite::detail::concatenate(), fillBadChanDBTables::result, and string.
Referenced by art::TimeTracker::postEndJob().
|
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_().