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 >
Query &	addCondition (const T &value, const std::string condition="=")
template<typename C1 , typename C2 >
Query &	addCondition (const std::string condition="=")
template<typename C >
Query &	addOrderClause (bool ascending=true)
template<typename Col >
Query &	addTable ()
const QueryIterator< Types... >	begin ()
const coral::AttributeList &	currentRow () const
const QueryIterator< Types... >	end ()
Query &	groupBy (const std::string &expression)
bool	next ()
	Query (const coral::ISchema &schema, bool distinct=false)
size_t	retrievedRows () const
Query &	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 307 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 395 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 404 of file DbCore.h.

            {
    }

Member Function Documentation

template<typename... Types>

template<int n>

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

inline

Definition at line 416 of file DbCore.h.

{}

template<typename... Types>

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

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

inline

Definition at line 419 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 >

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

inline

Definition at line 425 of file DbCore.h.

Referenced by cond::persistency::IOV::Table::getGroups(), cond::persistency::RUN_INFO::Table::getInclusiveRunRange(), cond::persistency::RUN_INFO::Table::getInclusiveTimeRange(), cond::persistency::IOV::Table::getLastIov(), cond::persistency::TAG::Table::getMetadata(), cond::persistency::IOV::Table::getRange(), cond::persistency::IOV::Table::getSize(), cond::persistency::PAYLOAD::Table::getType(), cond::persistency::GLOBAL_TAG::Table::select(), cond::persistency::TAG::Table::select(), cond::persistency::RUN_INFO::Table::select(), cond::persistency::GLOBAL_TAG_MAP::Table::select(), cond::persistency::PAYLOAD::Table::select(), and cond::persistency::IOV::Table::select().

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

template<typename... Types>

template<typename C1 , typename C2 >

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

inline

Definition at line 431 of file DbCore.h.

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

template<typename... Types>

template<typename C >

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

inline

Definition at line 438 of file DbCore.h.

Referenced by cond::persistency::IOV::Table::getGroups(), cond::persistency::IOV::Table::getLastIov(), cond::persistency::GLOBAL_TAG_MAP::Table::select(), and cond::persistency::IOV::Table::select().

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

template<typename... Types>

template<typename Col >

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

inline

Definition at line 407 of file DbCore.h.

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

template<typename... Types>

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

inline

Definition at line 467 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 462 of file DbCore.h.

Referenced by Vispa.Plugins.ConfigEditor.CodeTableView.CodeTableView::itemClicked(), and Vispa.Views.TableView.TableView::itemSelectionChanged().

                                                 {
      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 475 of file DbCore.h.

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

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

template<typename... Types>

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

inline

Definition at line 445 of file DbCore.h.

Referenced by cond::persistency::IOV::Table::getGroups(), cond::persistency::Query< Types... >::groupBy(), and SpecificationBuilder_cfi.Specification::saveAll().

                                                 {
      m_coralQuery->groupBy( expression );
      return *this;
    }

template<typename... Types>

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

inline

Definition at line 455 of file DbCore.h.

               {
      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 479 of file DbCore.h.

                                 {
      return m_retrievedRows;
    }

template<typename... Types>

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

inline

Definition at line 450 of file DbCore.h.

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

                         {
      m_coralQuery->setForUpdate();
      return *this;
    }

Member Data Documentation

template<typename... Types>

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

private

Definition at line 484 of file DbCore.h.

template<typename... Types>

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

private

Definition at line 485 of file DbCore.h.

template<typename... Types>

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

private

Definition at line 486 of file DbCore.h.

template<typename... Types>

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

private

Definition at line 489 of file DbCore.h.

template<typename... Types>

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

private

Definition at line 488 of file DbCore.h.

template<typename... Types>

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

private

Definition at line 487 of file DbCore.h.