cond::persistency::Query< Types > Class Template Reference

#include <DbCore.h>

Public Member Functions
template<int n>
void	_Query ()
template<int n, typename Arg1 , typename... Args>
void	_Query ()
template<typename C , typename T >
void	addCondition (const T &value, const std::string condition="=")
template<typename C1 , typename C2 >
void	addCondition (const std::string condition="=")
template<typename C >
void	addOrderClause (bool ascending=true)
template<typename Col >
void	addTable ()
const QueryIterator< Types...>	begin ()
const coral::AttributeList &	currentRow () const
const QueryIterator< Types...>	end ()
void	groupBy (const std::string &expression)
bool	next ()
	Query (const coral::ISchema &schema, bool distinct=false)
size_t	retrievedRows () const
void	setForUpdate ()
	~Query ()

Private Attributes
std::unique_ptr< coral::IQuery >	m_coralQuery
coral::ICursor *	m_cursor = 0
size_t	m_retrievedRows = 0
std::set< std::string >	m_tables
std::string	m_whereClause
coral::AttributeList	m_whereData

Detailed Description

template<typename... Types>
class cond::persistency::Query< Types >

Definition at line 311 of file DbCore.h.

Constructor & Destructor Documentation

template<typename... Types>

cond::persistency::Query< Types >::Query ( const coral::ISchema &  schema, bool  distinct = false  )

inline

Definition at line 399 of file DbCore.h.

                                                            :
      m_coralQuery( schema.newQuery() ),
      m_whereData(),
      m_whereClause(""),
      m_tables(){
      _Query<0, Types...>();
      if( distinct ) m_coralQuery->setDistinct();
    }

template<typename... Types>

cond::persistency::Query< Types >::~Query ( )

inline

Definition at line 408 of file DbCore.h.

            {
    }

Member Function Documentation

template<typename... Types>

template<int n>

void cond::persistency::Query< Types >::_Query ( )

inline

Definition at line 419 of file DbCore.h.

Referenced by cond::persistency::Query< Types...>::_Query(), and cond::persistency::Query< Types...>::Query().

{}

template<typename... Types>

template<int n, typename Arg1 , typename... Args>

void cond::persistency::Query< Types >::_Query ( )

inline

Definition at line 422 of file DbCore.h.

                  {
      addTable<Arg1>();
      DefineQueryOutput<typename Arg1::type>::make( *m_coralQuery, Arg1::fullyQualifiedName() );
      _Query<n+1, Args...>();
    }

template<typename... Types>

template<typename C , typename T >

void cond::persistency::Query< Types >::addCondition ( const T &  value, const std::string  condition = "="  )

inline

Definition at line 428 of file DbCore.h.

Referenced by cond::persistency::IOV::Table::getLastIov(), cond::persistency::TAG::Table::getMetadata(), cond::persistency::IOV::Table::getSize(), cond::persistency::IOV::Table::getSnapshotLastIov(), cond::persistency::IOV::Table::getSnapshotSize(), cond::persistency::PAYLOAD::Table::getType(), cond::persistency::GLOBAL_TAG::Table::select(), cond::persistency::TAG::Table::select(), cond::persistency::GLOBAL_TAG_MAP::Table::select(), cond::persistency::PAYLOAD::Table::select(), cond::persistency::IOV::Table::selectGroups(), cond::persistency::IOV::Table::selectLatest(), cond::persistency::IOV::Table::selectLatestByGroup(), cond::persistency::IOV::Table::selectSnapshot(), cond::persistency::IOV::Table::selectSnapshotByGroup(), and cond::persistency::IOV::Table::selectSnapshotGroups().

                                                                                                        {
      addTable<C>();
      f_add_condition_data<C>( m_whereData, m_whereClause, value, condition );       
    }

template<typename... Types>

template<typename C1 , typename C2 >

void cond::persistency::Query< Types >::addCondition ( const std::string  condition = "=" )

inline

Definition at line 433 of file DbCore.h.

                                                                                          {
      addTable<C1>();
      addTable<C2>();
      f_add_condition<C1,C2>( m_whereClause, condition );      
    }

template<typename... Types>

template<typename C >

void cond::persistency::Query< Types >::addOrderClause ( bool  ascending = true )

inline

Definition at line 439 of file DbCore.h.

Referenced by cond::persistency::IOV::Table::getLastIov(), cond::persistency::IOV::Table::getSnapshotLastIov(), cond::persistency::GLOBAL_TAG_MAP::Table::select(), cond::persistency::IOV::Table::selectGroups(), cond::persistency::IOV::Table::selectLatest(), cond::persistency::IOV::Table::selectLatestByGroup(), cond::persistency::IOV::Table::selectSnapshot(), cond::persistency::IOV::Table::selectSnapshotByGroup(), and cond::persistency::IOV::Table::selectSnapshotGroups().

                                                                   {
      std::string orderClause( C::fullyQualifiedName() );
      if(!ascending) orderClause += " DESC";
      m_coralQuery->addToOrderList( orderClause );
    }

template<typename... Types>

template<typename Col >

void cond::persistency::Query< Types >::addTable ( )

inline

Definition at line 411 of file DbCore.h.

                                          {
      if( m_tables.find( Col::tableName() )==m_tables.end() ){
    m_coralQuery->addToTableList( Col::tableName() );
    m_tables.insert( Col::tableName() );
      }
    }

template<typename... Types>

const QueryIterator<Types...> cond::persistency::Query< Types >::begin ( void  )

inline

Definition at line 465 of file DbCore.h.

                                          {
      m_coralQuery->setCondition( m_whereClause, m_whereData );
      m_cursor = &m_coralQuery->execute();
      m_retrievedRows = 0;
      QueryIterator<Types...> ret ( this );
      return ++ret; 
    }

template<typename... Types>

const coral::AttributeList& cond::persistency::Query< Types >::currentRow ( ) const

inline

Definition at line 460 of file DbCore.h.

Referenced by Vispa.Plugins.ConfigEditor.CodeTableView.CodeTableView::itemClicked(), Vispa.Views.TableView.TableView::itemSelectionChanged(), and cond::persistency::QueryIterator< Types >::operator++().

                                                 {
      if(!m_cursor) throwException( "The query has not been executed.","Query::currentRow");
      return m_cursor->currentRow();
    }

template<typename... Types>

const QueryIterator<Types...> cond::persistency::Query< Types >::end ( void  )

inline

Definition at line 473 of file DbCore.h.

Referenced by Types.LuminosityBlockRange::cppID(), and Types.EventRange::cppID().

                                        {
      return QueryIterator<Types...>( this );
    }

template<typename... Types>

void cond::persistency::Query< Types >::groupBy ( const std::string &  expression )

inline

Definition at line 445 of file DbCore.h.

Referenced by cond::persistency::IOV::Table::selectGroups(), and cond::persistency::IOV::Table::selectSnapshotGroups().

                                               {
      m_coralQuery->groupBy( expression );
    }

template<typename... Types>

bool cond::persistency::Query< Types >::next ( void  )

inline

Definition at line 453 of file DbCore.h.

Referenced by BeautifulSoup.PageElement::_invert(), and cond::persistency::QueryIterator< Types >::operator++().

               {
      if(!m_cursor) throwException( "The query has not been executed.","Query::currentRow");
      bool ret = m_cursor->next();
      if( ret ) m_retrievedRows++;
      return ret;
    }

template<typename... Types>

size_t cond::persistency::Query< Types >::retrievedRows ( ) const

inline

Definition at line 477 of file DbCore.h.

                                 {
      return m_retrievedRows;
    }

template<typename... Types>

void cond::persistency::Query< Types >::setForUpdate ( )

inline

Definition at line 449 of file DbCore.h.

                       {
      m_coralQuery->setForUpdate();
    }

Member Data Documentation

template<typename... Types>

std::unique_ptr<coral::IQuery> cond::persistency::Query< Types >::m_coralQuery

private

Definition at line 482 of file DbCore.h.

Referenced by cond::persistency::Query< Types...>::_Query(), cond::persistency::Query< Types...>::addOrderClause(), cond::persistency::Query< Types...>::addTable(), cond::persistency::Query< Types...>::begin(), cond::persistency::Query< Types...>::groupBy(), cond::persistency::Query< Types...>::Query(), and cond::persistency::Query< Types...>::setForUpdate().

template<typename... Types>

coral::ICursor* cond::persistency::Query< Types >::m_cursor = 0

private

Definition at line 483 of file DbCore.h.

Referenced by cond::persistency::Query< Types...>::begin(), cond::persistency::Query< Types...>::currentRow(), and cond::persistency::Query< Types...>::next().

template<typename... Types>

size_t cond::persistency::Query< Types >::m_retrievedRows = 0

private

Definition at line 484 of file DbCore.h.

Referenced by cond::persistency::Query< Types...>::begin(), cond::persistency::Query< Types...>::next(), and cond::persistency::Query< Types...>::retrievedRows().

template<typename... Types>

std::set<std::string> cond::persistency::Query< Types >::m_tables

private

Definition at line 487 of file DbCore.h.

Referenced by cond::persistency::Query< Types...>::addTable().

template<typename... Types>

std::string cond::persistency::Query< Types >::m_whereClause

private

Definition at line 486 of file DbCore.h.

Referenced by cond::persistency::Query< Types...>::addCondition(), and cond::persistency::Query< Types...>::begin().

template<typename... Types>

coral::AttributeList cond::persistency::Query< Types >::m_whereData

private

Definition at line 485 of file DbCore.h.

Referenced by cond::persistency::Query< Types...>::addCondition(), and cond::persistency::Query< Types...>::begin().