TeQuerierDBStr3 Class Reference

#include <TeQuerierDBStr3.h>

Inheritance diagram for TeQuerierDBStr3:

---

Detailed Description

This class implements a mechanism that is responsible for loading spatio-temporal elements from a TerraLib database, following a specific strategy (Strategy 3). Each spatio-temporal elements is represented through a TeSTInstance class. This class is internally used by the factory of queriers. It should NOT be used by anyone. This Strategy 2 works with simple chronon, with geometry (points or cells), theme with collection table and existence operator in the DBMS.

See also:

TeQuerierDB TeQuerierParams TeSTInstance

Definition at line 47 of file TeQuerierDBStr3.h.

bool	initPortal (TeTSEntry *ent=0)
Public Member Functions
void	clear ()
	Empties querier instances.
bool	fetchInstance (TeSTInstance &sto)
	Returns each loaded STO.
TeGeomRep	geometryRep ()
	Returns the geometry representation of the theme.
TeAttributeList	getAttrList ()
	Gets the attribute list from querier.
int	getNumTimeFrames ()
	Gets the number of generated time frames.
bool	getTS (TeTemporalSeries &ts)
	Gets the full temporal serie.
bool	getTSEntry (TeTSEntry &tsEntry, int frame)
	Gets each temporal serie entry, for each time frame.
TeTSParams &	getTSParams ()
	Returns the temporal serie params.
TeLayer *	layer ()
	Returns the pointer to the layer.
virtual bool	loadGeometries (TeMultiGeometry &geometries)
	Loads all geometries.
virtual bool	loadGeometries (TeMultiGeometry &geometries, unsigned int &index)
	Loads all geometries of the index-th geometry representation.
bool	loadInstances (TeTSEntry *ent=0)
	Loads the instances.
bool	loadTimeFrameInstances (int frame=-1)
	Loads the STOs.
int	numElemInstances ()
	Returns the number of instances.
string	objectId ()
	Returns the object identifier.
TeQuerierParams *	params ()
	Returns the querier parameters.
	TeQuerierDBStr3 (TeQuerierParams *params)
	Constructor.
TeTheme *	theme ()
	Returns the pointer to the theme.
Static Public Member Functions
static TeQuerierImpl *	DefaultObject (const TeQuerierParams &)
	Returns a default object.
Protected Member Functions
void	clearVectors ()
	clear internal vectors
string	sqlFrom (string geomTable="")
	Build the sql from clause.
virtual string	sqlWhereRestrictions (TeRepresentation *rep=0)
	Return a where clause in SQL that represent the querier restrictions.
Protected Attributes
int	attrIndex1_
	index in the first portal of the first attribute
int	attrIndex2_
	index in the first portal of the last attribute
TeSharedPtr < TeAttributeList >	attrList_
	this flag indicates if the temporal serie was filled
TeTable	attrTable_
	internal information used to fill the stos
bool	filledSerie_
	temporal series
bool	flagPortal_
	flag to control the portal
vector< int >	geomIndex1_
	index where the geometry information begin in each portal in the vector "portals_"
vector< int >	geomIndex2_
	index where the geometry information finish in each portal in the vector "portals_"
vector < TeRepresentation >	geomRepr_
	keep the geometry representation of each portal
int	groupIndex_
	index in the first portal of the group, if there is collection table
map< int, int >	legendIdGroup_
	map from legend identifier to group number
vector< int >	linkIndex_
	index of the link attributes in each portal in the vector "portals_"
TeQuerierParams *	params_
	querier parameters that define the used querier strategy
vector < TeDatabasePortal * >	portals_
	a portal to each geometry representation
vector< int >	timeIndex1_
	index of the initial time in each portal in the vector "portals_"
vector< int >	timeIndex2_
	index of the final time in each portal in the vector "portals_"
TeTemporalSeries *	ts_
map< int, vector< int > >	uniqueIndex_
	map FROM each portal in the vector "portals_" TO the indexes of the unique attributes
Private Member Functions
bool	fillSTO (TeSTInstance &sto)
	Internal function to fill STO.
Private Attributes
string	fromClause_
TeGeomRep	rep_
int	timeFramePortal_
TeTSEntry	TSEntry_
string	whereClause_

---

Constructor & Destructor Documentation

TeQuerierDBStr3::TeQuerierDBStr3

(

TeQuerierParams *

params

)

[inline]

Definition at line 67 of file TeQuerierDBStr3.h.

                                                : 
                TeQuerierDB(params), 
                timeFramePortal_(-1),
                fromClause_(""),
                whereClause_("")
        {} 

---

Member Function Documentation

void TeQuerierDB::clear

(

void

)

[virtual, inherited]

Reimplemented from TeQuerierImpl.

Definition at line 285 of file TeQuerierDB.cpp.

References TeQuerierDB::clearVectors().

{
        clearVectors();
}

void TeQuerierDB::clearVectors

(

)

[protected, inherited]

Definition at line 269 of file TeQuerierDB.cpp.

References TeQuerierDB::flagPortal_, TeQuerierDB::geomRepr_, and TeQuerierDB::portals_.

Referenced by TeQuerierDB::clear(), TeQuerierDBStr1::fetchInstance(), fillSTO(), TeQuerierDBStr2::fillSTO(), initPortal(), TeQuerierDBStr2::initPortal(), TeQuerierDBStr1::initPortal(), and TeQuerierDBStr1::loadInstances().

{
        vector<TeDatabasePortal*>::iterator itPortal = portals_.begin();
        while(itPortal!=portals_.end())
        {               
                TeDatabasePortal* portal = *itPortal;
                delete portal; 
                ++itPortal;
        }
        
        portals_.clear();
        geomRepr_.clear();
        flagPortal_ = false;
}

static TeQuerierImpl* TeQuerierImpl::DefaultObject

(

const TeQuerierParams &

)

[inline, static, inherited]

Definition at line 87 of file TeQuerierImpl.h.

{ return 0; }

bool TeQuerierDBStr3::fetchInstance

(

TeSTInstance &

sto

)

[virtual]

Implements TeQuerierDB.

Definition at line 363 of file TeQuerierDBStr3.cpp.

References TeQuerierParams::box(), TeSTInstance::clear(), TeQuerierImpl::filledSerie_, fillSTO(), TeMultiGeometry::getBox(), TeBaseSTInstance< GeometryType, TimeType >::getGeometries(), TeBaseSTInstance< GeometryType, TimeType >::getPropertyValue(), TeQuerierImpl::params_, TeTemporalSeries::setTSEntryValue(), TeDATA, TeTSEntry::timeFrame_, TeQuerierImpl::ts_, TSEntry_, and updateBox().

{
        sto.clear();

        if(!fillSTO(sto))
                return false; 
        
        //build a temporal serie to one object
        string val;
        sto.getPropertyValue(val, 0);
        if((ts_) && (ts_->setTSEntryValue(TSEntry_.timeFrame_, atof(val.c_str()), TeDATA)))
                filledSerie_ = true;
        
        updateBox(params_->box(), sto.getGeometries().getBox());
        return true;
}

bool TeQuerierDBStr3::fillSTO

(

TeSTInstance &

sto

)

[private]

Definition at line 237 of file TeQuerierDBStr3.cpp.

References TeSTInstance::addGeometry(), TeBaseSTInstance< GeometryType, TimeType >::addPropertyValue(), TeBaseSTInstance< GeometryType, TimeType >::addUniqueId(), TeQuerierDB::attrIndex1_, TeQuerierDB::attrIndex2_, TeQuerierImpl::attrList_, TeTime::chronon(), TeQuerierDB::clearVectors(), TeDatabasePortal::fetchGeometry(), TeDatabasePortal::fetchRow(), TeQuerierDB::flagPortal_, TeQuerierDB::geomIndex1_, TeDatabasePortal::getData(), TeDatabasePortal::getDate(), TeDatabasePortal::getInt(), TeQuerierDB::groupIndex_, TeQuerierParams::hasSpatialRes(), TeQuerierDB::legendIdGroup_, TeQuerierDB::linkIndex_, TeBaseSTInstance< GeometryType, TimeType >::objectId(), TeQuerierImpl::params_, TeQuerierDB::portals_, rep_, TeBaseSTInstance< GeometryType, TimeType >::setAttrList(), TeBaseSTInstance< GeometryType, TimeType >::setSlice(), TePOINTS, TeTSEntry::time_, TeTSEntry::timeFrame_, timeFramePortal_, TeQuerierDB::timeIndex1_, TeSTInstance::timeInterval(), and TSEntry_.

Referenced by fetchInstance().

{
        if(portals_.empty())
                return false;

        TeDatabasePortal* portal = portals_[0]; 
        if(!portal) 
                return false; 

        if(!flagPortal_)  //end of portal
        {
                clearVectors();
                return false; 
        }

        
        // first : verify the time
        if(TSEntry_.timeFrame_ > -1)
        {
                TeTime t1 = portal->getDate(timeIndex1_[0]);            
                t1.chronon ((TSEntry_.time_).intervalChronon());
                
                //if the time is before the requested interval 
                while ( (TSEntry_.time_).before(t1) && flagPortal_)
                {
                        flagPortal_ = portal->fetchRow();
                        t1 = portal->getDate(timeIndex1_[0]);
                        t1.chronon ((TSEntry_.time_).intervalChronon());
                }
                
                if(!(TSEntry_.time_).during(t1))
                        return false;
                
                TeTimeInterval interval(t1, t1);
                sto.timeInterval(interval);

                timeFramePortal_ = (TSEntry_.timeFrame_)+1; //next time frame 
        }
        
        //if there is spatial restriction, it groups all instances of all objects
        if(!params_->hasSpatialRes())
        {
                // get object_id
                string objId = string(portal->getData(linkIndex_[0]));  // 0: object_id
                sto.objectId (objId);
                sto.addUniqueId (objId);

                //get the group index
                if(groupIndex_!=-1)
                {
                        int gIndex = portal->getInt(groupIndex_);
                        sto.setSlice(legendIdGroup_[gIndex]);
                }
        }

        sto.setAttrList(attrList_);

        //get property
        for(int s=attrIndex1_; s<=attrIndex2_; ++s)  
                sto.addPropertyValue(portal->getData(s));

        // get geometry 
        if(rep_ == TePOINTS)
        {
                TePoint point;
                flagPortal_ = portal->fetchGeometry(point,geomIndex1_[0]);
                sto.addGeometry (point);
        }
        else
        {
                TeCell cell;
                flagPortal_ = portal->fetchGeometry(cell, geomIndex1_[0]);
                sto.addGeometry (cell);
        }

        return true;
}

TeGeomRep TeQuerierDB::geometryRep

(

)

[inherited]

Definition at line 291 of file TeQuerierDB.cpp.

References TeTheme::layer(), TeQuerierImpl::params_, and TeQuerierParams::theme().

{  return TeGeomRep(params_->theme()->layer()->geomRep()); }

TeAttributeList TeQuerierImpl::getAttrList

(

)

[inline, inherited]

Definition at line 84 of file TeQuerierImpl.h.

Referenced by TeQuerier::getAttrList().

{ return (*attrList_); }

int TeQuerierImpl::getNumTimeFrames

(

)

[inherited]

Definition at line 121 of file TeQuerierImpl.cpp.

References TeTemporalSeries::numTimeFrames(), and TeQuerierImpl::ts_.

Referenced by TeQuerier::getNumTimeFrames().

{
        if(!ts_)
                return 0;

        return (ts_->numTimeFrames());
}

bool TeQuerierImpl::getTS

(

TeTemporalSeries &

ts

)

[inherited]

Definition at line 130 of file TeQuerierImpl.cpp.

References TeQuerierImpl::ts_.

Referenced by TeQuerier::getTS().

{
        if(!ts_)
                return false;
        
        ts = (*ts_);
        return true;
}

bool TeQuerierImpl::getTSEntry	(	TeTSEntry &	tsEntry,
		int	frame
	)			[inherited]

Definition at line 112 of file TeQuerierImpl.cpp.

References TeTemporalSeries::getTSEntry(), and TeQuerierImpl::ts_.

Referenced by TeQuerier::getTSEntry(), and TeQuerierImpl::loadTimeFrameInstances().

{
        if(!ts_)
                return false;

        return(ts_->getTSEntry(tsEntry, frame)); 
}

TeTSParams & TeQuerierImpl::getTSParams

(

)

[inherited]

Definition at line 140 of file TeQuerierImpl.cpp.

References TeQuerierImpl::ts_, and TeTemporalSeries::TSparams_.

Referenced by TeQuerier::getTSParams().

{ 
        return (ts_->TSparams_); 
}

bool TeQuerierDBStr3::initPortal

(

TeTSEntry *

ent = 0

)

[private]

Definition at line 33 of file TeQuerierDBStr3.cpp.

References TeTable::attInitialTime(), TeQuerierDB::attrIndex1_, TeQuerierDB::attrIndex2_, TeQuerierDB::attrTable_, TeTheme::attrTables(), TeQuerierParams::chronon(), TeQuerierDB::clearVectors(), TeTheme::collectionTable(), db, TeDatabasePortal::fetchRow(), TeQuerierDB::flagPortal_, fromClause_, TeQuerierDB::geomIndex1_, TeRepresentation::geomRep_, TeDatabase::getAttributeList(), TeDatabasePortal::getData(), TeDatabase::getPortal(), TeDatabase::getSQLStatistics(), TeDatabase::getSQLTemporalFunction(), TeQuerierParams::groupAttr(), TeQuerierDB::groupIndex_, TeQuerierParams::hasSpatialRes(), TeTheme::layer(), TeAbstractTheme::legend(), TeQuerierDB::legendIdGroup_, TeQuerierDB::linkIndex_, TeTable::linkName(), TeTable::name(), TeQuerierParams::objId(), TeQuerierImpl::params_, TeQuerierDB::portals_, TeDatabasePortal::query(), rep_, TeQuerierDB::sqlWhereRestrictions(), TeRepresentation::tableName_, TeTable::tableType(), TeAttrEvent, TeCELLS, TeConvertToUpperCase(), TeFixedGeomDynAttr, TePOINTS, TeQuerierParams::theme(), TeQuerierDB::timeIndex1_, TeQuerierDB::timeIndex2_, TeTable::uniqueName(), and whereClause_.

Referenced by loadInstances().

{
        string selectClause, fromClause, whereClause, groupByClause;
        string initialTime, finalTime;
        linkIndex_.clear();
        linkIndex_.push_back(-1); 
        attrIndex1_=-1;
        attrIndex2_=-1;
        timeIndex1_.clear();
        timeIndex1_.push_back(-1);
        timeIndex2_.clear();
        timeIndex2_.push_back(-1);
        geomIndex1_.clear();
        geomIndex1_.push_back(-1);
        groupIndex_=-1;

        TeDatabase* db = params_->theme()->layer()->database();

        if(params_->groupAttr().empty())
                return false;

        //get the table name
        string tableName;
        TeGroupingAttr groupAttr = params_->groupAttr();
        TeGroupingAttr::iterator it = groupAttr.begin();
        size_t pos = (it->first.name_).find(".", 0, 1);
        if (pos != string::npos)
                tableName = (it->first.name_).substr(0,pos);

        //group information
        legendIdGroup_.clear();
        legendIdGroup_[0]=0;
        TeLegendEntryVector& legVec = params_->theme()->legend();
        for(unsigned int l=0; l<legVec.size(); ++l)
                legendIdGroup_[legVec[l].id()]=legVec[l].group();
                        
        clearVectors();

        // ---------------------------------------------  Monut SQL
        
        //------- Select and Group By clause

        //load the attribute table 
        int index = -1;
        unsigned int i=0;
        TeAttrTableVector attr = params_->theme()->attrTables();
        for(i=0; i<attr.size(); ++i)
        {
                if(TeConvertToUpperCase(attr[i].name()) == TeConvertToUpperCase(tableName))
                {
                        index = i;
                        attrTable_ = attr[i];
                        break;
                }
        }
 
        //not find the table
        if(index<0)
                return false;

        //verify the attribute table
        if((ent) && (attrTable_.tableType()!=TeAttrEvent) && (attrTable_.tableType()!=TeFixedGeomDynAttr))
                return false;

        //geometric Table
        TeAttributeList geomTableAttrs;
        string geomTable;
        if(params_->theme()->layer()->hasGeometry(TePOINTS))
        {
                geomTable = params_->theme()->layer()->tableName(TePOINTS);
                if(!db->getAttributeList(geomTable, geomTableAttrs))
                        return false; 
                rep_ = TePOINTS;
        } 
        else if (params_->theme()->layer()->hasGeometry(TeCELLS))
        {
                geomTable = params_->theme()->layer()->tableName(TeCELLS);
                if(!db->getAttributeList(geomTable, geomTableAttrs))
                        return false; 
                rep_ = TeCELLS;
        }
        else
                return false; //this strategy is valid only for cells and point geometry

        //object_id
        string linkName = attrTable_.name() +"."+ attrTable_.linkName(); //geomTable.name()+ ".object_id ";
        string uniqueIdName = attrTable_.name() +"."+ attrTable_.uniqueName(); 
        
        if(params_->hasSpatialRes())
                selectClause = " MIN("+ linkName +")";          
        else
                selectClause = linkName;        
        linkIndex_[0]=0;

        if(ent)
        {
                //date
                initialTime = attrTable_.name() +"."+ attrTable_.attInitialTime();

                groupByClause = db->getSQLTemporalFunction(params_->chronon(), initialTime);
                if(!params_->hasSpatialRes())
                        groupByClause += ","+ linkName;
                
                selectClause += ", MAX("+ initialTime +")";
                timeIndex1_[0]=1;
                timeIndex2_[0]=1;
        }
        else if(!params_->hasSpatialRes())
                groupByClause = linkName;

        //statistic
        selectClause += ","+ db->getSQLStatistics(groupAttr);   
        if(timeIndex1_[0]<0)
                attrIndex1_=1;
        else
                attrIndex1_=2;
        attrIndex2_ = attrIndex1_+(params_->groupAttr().size()-1);

        //group index
        selectClause += ", MIN("+ params_->theme()->collectionTable()+".c_legend_id )";
        groupIndex_ = attrIndex2_+1;    
        
        //----- insert geometrical information in the select clause
        for(i=0; i<geomTableAttrs.size(); ++i)
                selectClause += ", MIN( "+ geomTable +"."+ geomTableAttrs[i].rep_.name_ +" ) AS "+ geomTableAttrs[i].rep_.name_;
        geomIndex1_[0] = attrIndex2_+2;
        //----- 

        //------- From clause 
        fromClause = this->sqlFrom(geomTable);
        if(fromClause.empty())
                return false;

        //where clause
        if(!params_->objId().empty())
                whereClause = linkName +" = '"+ params_->objId() +"'";  

        //---------- querier restriction
        TeRepresentation rep;
        rep.tableName_ = geomTable;
        rep.geomRep_ = rep_;

        string sqlQuerierRest = sqlWhereRestrictions(&rep);
        if(!whereClause.empty())
                whereClause += " AND ";

        whereClause += sqlQuerierRest;

        //----------
        fromClause_ = fromClause;
        whereClause_ = whereClause;

        string sql = " SELECT "+ selectClause; 
        sql += " FROM "+ fromClause; 
        if(!whereClause.empty())
                sql += " WHERE "+ whereClause; 
        if(!groupByClause.empty())
                sql += " GROUP BY "+ groupByClause;
        
        // ---------------------------------------------  Submit the query
        
        portals_.clear();
        TeDatabasePortal* portal = db->getPortal();
        
        if(!portal)
                return false;
        
        if(!portal->query(sql))
        {
                delete (portal);
                flagPortal_ = false;
                return false;
        }

        if(!portal->fetchRow())
        {
                delete (portal);
                flagPortal_ = false;
                return false;
        }

        string id = portal->getData(linkIndex_[0]); //object_Id
        bool flag = true;
        while(id.empty() && flag) 
        {
                flag = portal->fetchRow();
                if(flag)
                        id = portal->getData(linkIndex_[0]); //object_Id
        }
        
        if(id.empty() || (!flag))
        {
                delete (portal);
                flagPortal_ = false;
                return false;
        }

        portals_.push_back (portal);
        flagPortal_ = true;
        return true;
}

TeLayer* TeQuerierDB::layer

(

)

[inline, inherited]

Definition at line 101 of file TeQuerierDB.h.

References TeTheme::layer().

{       return  params_->theme()->layer(); }

bool TeQuerierDB::loadGeometries

(

TeMultiGeometry &

geometries

)

[virtual, inherited]

Implements TeQuerierImpl.

Definition at line 523 of file TeQuerierDB.cpp.

References TeQuerierParams::loadGeom(), TeQuerierDB::loadGeometries(), TeQuerierImpl::params_, and TeQuerierDB::portals_.

{
        bool flag = false;
        
        if(!params_->loadGeom())
                return flag;
        
        for(unsigned int i=0; i<portals_.size(); ++i)
                flag = loadGeometries(geometries, i);
        
        return flag;
}

bool TeQuerierDB::loadGeometries	(	TeMultiGeometry &	geometries,
		unsigned int &	index
	)			[virtual, inherited]

Implements TeQuerierImpl.

Definition at line 507 of file TeQuerierDB.cpp.

References addGeometry(), TeRepresentation::geomRep_, TeQuerierDB::geomRepr_, and TeQuerierDB::portals_.

Referenced by TeQuerierDB::loadGeometries().

{
        if((portals_.size()<(index+1)) || (geomRepr_.size()<(index+1)))
                return false;

        TeDatabasePortal* portal = portals_[index]; 
        TeRepresentation rep = geomRepr_[index];
        if(!portal)
                return false; 
        
        bool flag = addGeometry(portal, rep.geomRep_, geometries);

        return flag;
}

bool TeQuerierDBStr3::loadInstances

(

TeTSEntry *

ent = 0

)

[virtual]

Implements TeQuerierDB.

Definition at line 317 of file TeQuerierDBStr3.cpp.

References TeQuerierImpl::attrList_, TeQuerierParams::box(), TeQuerierParams::groupAttr(), initPortal(), TeQuerierImpl::params(), TeQuerierImpl::params_, TeAttribute::rep_, TeQuerierParams::theme(), TeTSEntry::timeFrame_, timeFramePortal_, and TSEntry_.

{
        if(!params_->theme())
                return false;

        //set a invalid box
        TeBox box;
        params_->box(box);

        if(ent)
        {
                //if the portal was not initialised (timeFramePortal_==-1) or
                //if the time frame requested is lesser than the time frame appointed by the portal
                if((timeFramePortal_<0) || (ent->timeFrame_<timeFramePortal_))
                {
                        if(!initPortal(ent))
                                return false;

                        timeFramePortal_ = 0;
                }
                TSEntry_ = (*ent);
        }
        else // no chronon
        {
                if(!initPortal())
                        return false;
 
                timeFramePortal_ = -1;
        }

        attrList_->clear();
        TeAttribute at;
        TeGroupingAttr::iterator it = params()->groupAttr().begin();
        while(it!=params()->groupAttr().end())
        {
                TeAttribute at;
                at.rep_ = it->first;
                attrList_->push_back (at);
                ++it;
        }

        return true;
}

bool TeQuerierImpl::loadTimeFrameInstances

(

int

frame = -1

)

[inherited]

Definition at line 97 of file TeQuerierImpl.cpp.

References TeQuerierImpl::getTSEntry(), and TeQuerierImpl::loadInstances().

Referenced by TeQuerier::loadInstances().

{
        if(frame>-1) 
        {
                TeTSEntry ent;
                if(!getTSEntry(ent, frame))
                        return false;
                
                return(loadInstances(&ent));
        }
        else
                return(loadInstances());
}

int TeQuerierDBStr3::numElemInstances

(

)

[virtual]

Reimplemented from TeQuerierImpl.

Definition at line 381 of file TeQuerierDBStr3.cpp.

References TeDatabasePortal::fetchRow(), fromClause_, TeTheme::getAttTables(), TeTheme::layer(), TeDatabasePortal::numRows(), TeQuerierImpl::params_, TeDatabasePortal::query(), TeQuerierParams::theme(), and whereClause_.

{
        //load the attribute tables
        TeAttrTableVector atts; 
        params_->theme()->getAttTables(atts); 
        if(atts.empty())
                return 0;

        string selectClause = " DISTINCT ";
        for(unsigned int i=0; i<atts.size(); ++i)
        {
                if(i>0)
                        selectClause+= ",";
                selectClause+= atts[i].name() +"."+ atts[i].linkName();

                if(atts[i].linkName()!=atts[i].uniqueName())
                        selectClause+= ","+ atts[i].name() +"."+ atts[i].uniqueName();
        }
        
    string sql = "SELECT "+ selectClause + fromClause_;
        if(!whereClause_.empty())
                sql += " WHERE "+ whereClause_;

        TeDatabasePortal* portal = params_->theme()->layer()->database()->getPortal();
        if(!portal)
                return 0;
        
        if(!portal->query(sql) || !portal->fetchRow())
        {
                delete (portal);
                return 0;
        }
        int result = portal->numRows();
        delete portal;
        return result;
}

string TeQuerierImpl::objectId

(

)

[inline, inherited]

Definition at line 63 of file TeQuerierImpl.h.

Referenced by TeQuerierDBStr1::initGeomPortal(), and TeQuerierDBStr1::initPortal().

{ return params_->objId();}

TeQuerierParams* TeQuerierImpl::params

(

)

[inline, inherited]

Definition at line 90 of file TeQuerierImpl.h.

Referenced by TeQuerierDBStr1::fillSTONoGrouped(), TeQuerier::getBox(), loadInstances(), TeQuerierDBStr2::loadInstances(), TeQuerierDBStr1::loadInstances(), TeQuerier::operator=(), TeQuerier::params(), and TeQuerier::TeQuerier().

{ return params_; }

string TeQuerierDB::sqlFrom

(

string

geomTable = ""

)

[protected, inherited]

join with collection table

join with geometry table

join with collection table

join with geometry table

Definition at line 391 of file TeQuerierDB.cpp.

References TeQuerierDB::attrTable_, TeTheme::attrTables(), TeTheme::collectionAuxTable(), TeTheme::collectionTable(), TeRepresentation::geomRep_, TeQuerierParams::hasSpatialRes(), TeTheme::layer(), TeTable::linkName(), TeTable::name(), TeQuerierImpl::params_, TeQuerierParams::selectedObjs(), TeTable::tableType(), Te2String(), TeAll, TeAttrEvent, TeAttrExternal, TeAttrStatic, TeFixedGeomDynAttr, TeQuerierDB::theme(), TeQuerierParams::theme(), and TeTable::uniqueName().

Referenced by TeQuerierDBStr2::initPortal().

{
        string fromPar = "";
        string fromClause = "";
        
        //get collection tables 
        string collAuxTable = params_->theme()->collectionAuxTable();
        string collTable = params_->theme()->collectionTable();
        
        if(collAuxTable.empty() || collTable.empty())
                return attrTable_.name();

        if(attrTable_.name().empty())
                return "";
        
        string uniqueIdName = attrTable_.name() +"."+ attrTable_.uniqueName(); 
        string objectIdName = attrTable_.name() +"."+ attrTable_.linkName(); 
        string linkName; 
        if(attrTable_.tableType() != TeAttrExternal)
                linkName = attrTable_.name() +"."+ attrTable_.linkName(); 
        else
                linkName = collTable +".c_object_id "; 

        //load geometry table if there is spatial restriction
        if(geomTable.empty() && params_->hasSpatialRes())
        {
                TeRepresentation* rep = (theme()->layer()->vectRepres())[0];
                geomTable = theme()->layer()->tableName(rep->geomRep_);
        }

        //get the extern table position 
        int posExtern = -1;
        TeAttrTableVector attr = params_->theme()->attrTables();
        for(unsigned int i=0; i<attr.size(); ++i)
        {
                if(attr[i].tableType() == TeAttrExternal)
                        ++posExtern;
        }
        
        //if the table is temporal   
        if((attrTable_.tableType()==TeAttrEvent) || (attrTable_.tableType()==TeFixedGeomDynAttr))
        {
                fromPar += "((";
                fromClause = attrTable_.name()+" RIGHT JOIN "+ collAuxTable; 
                                
                if(attrTable_.tableType()==TeFixedGeomDynAttr)
                {
                        fromClause += " ON "+ uniqueIdName +" = ";
                        fromClause += collAuxTable +".aux0";
                        fromClause += ")";
                }
                else
                {
                        fromClause += " ON "+ objectIdName +" = ";
                        fromClause += collAuxTable +".object_id"+ ")";
                }

                fromClause += " LEFT JOIN "+ collTable; 
                fromClause += " ON "+ collAuxTable +".object_id = "+ collTable +".c_object_id )";
                
                if(!geomTable.empty())
                {
                        fromPar += "(";
                        fromClause += " LEFT JOIN "+ geomTable +" ON ";
                        fromClause += collAuxTable +".object_id = "+ geomTable +".object_id )";
                }

                if(params_->selectedObjs() != TeAll) //! join with collection table
                {
                        fromPar += "(";
                        fromClause += " LEFT JOIN "+ collTable +" ON ";
                        fromClause += collAuxTable +".object_id = "+ collTable +".c_object_id )";
                }
        } 

        else if (attrTable_.tableType()==TeAttrStatic)
        {
                fromPar += "(";
                fromClause =  attrTable_.name()+" RIGHT JOIN "+ collTable; 
                fromClause += " ON "+ linkName +" = "+ collTable +".c_object_id)";

                if(!geomTable.empty()) //! join with geometry table
                {
                        fromPar += "(";
                        fromClause += " LEFT JOIN "+ geomTable +" ON ";
                        fromClause += collTable +".c_object_id = "+ geomTable +".object_id )";
                }

                if(params_->selectedObjs() != TeAll) //! join with collection table
                {
                        fromPar += "(";
                        fromClause += " LEFT JOIN "+ collAuxTable +" ON ";
                        fromClause += collTable +".c_object_id = "+ collAuxTable +".object_id )";
                }
        }
        else if (attrTable_.tableType()==TeAttrExternal)
        {
                fromPar += "((";
                fromClause = collAuxTable +" RIGHT JOIN "+ collTable; 
                fromClause += " ON "+ collAuxTable +".object_id = "+ collTable +".c_object_id )";
                fromClause += " LEFT JOIN "+ attrTable_.name() +" ON ";
                fromClause +=  collAuxTable +".aux"+ Te2String(posExtern) +" = ";
                fromClause +=  uniqueIdName +" )";

                if(!geomTable.empty()) //! join with geometry table
                {
                        fromPar += "(";
                        fromClause += " LEFT JOIN "+ geomTable +" ON ";
                        fromClause += collTable +".c_object_id = "+ geomTable +".object_id )";
                } 
        }
                
        return (fromPar+fromClause);
}

string TeQuerierDB::sqlWhereRestrictions

(

TeRepresentation *

rep = 0

)

[protected, virtual, inherited]

Definition at line 295 of file TeQuerierDB.cpp.

References TeQuerierParams::boxRest(), db, TeRepresentation::geomRep_, TeQuerierParams::geomRepRest(), TeQuerierParams::geomRest(), TeDatabase::getSQLBoxWhere(), TeQuerierParams::hasSpatialRes(), TeSingleton< TePrecision >::instance(), TeBox::isValid(), TeTheme::layer(), TeQuerierImpl::params_, TeQuerierParams::selectedObjs(), TePrecision::setPrecision(), TeQuerierParams::spatialRelation(), TeDatabase::spatialRelation(), TeRepresentation::tableName_, TeAll, TeGetPrecision(), TeGrouped, TeNotGrouped, TeNotSelectedByPointing, TeNotSelectedByQuery, TeSelectedByPointing, TeSelectedByPointingAndQuery, TeSelectedByPointingOrQuery, TeSelectedByQuery, and TeQuerierParams::theme().

Referenced by TeQuerierDBStr1::initGeomPortal(), initPortal(), TeQuerierDBStr2::initPortal(), and TeQuerierDBStr1::initPortal().

{
        TeKeys objs;
        string whereClause= " 1 = 1 ";
        TeDatabase* db = params_->theme()->layer()->database();
        if(!db)
                return "";
        
        // load the first representation 
        if(!rep)
                rep = (params_->theme()->layer()->vectRepres())[0];

        // spatial restriction with other geometry representation
        if (params_->hasSpatialRes() && rep)
        {
                if(params_->boxRest().isValid())
                {
            TeBox b =  params_->boxRest();
            TeGeomRep gRep = rep->geomRep_;
                        string geomTableRest = params_->theme()->layer()->tableName(params_->geomRepRest());
                        whereClause += " AND "+ db->getSQLBoxWhere(b, gRep, geomTableRest);
                }
                else if(params_->geomRest())
                {
                        string geomTableRest = params_->theme()->layer()->tableName(params_->geomRepRest());
                        TePrecision::instance().setPrecision(TeGetPrecision(params_->theme()->layer()->projection()));

                        if((db->spatialRelation(geomTableRest, params_->geomRepRest(), params_->geomRest(),  
                                                           objs, params_->spatialRelation())) && (!objs.empty()))
                        {
                                string obs;
                                for(unsigned int i=0; i<objs.size(); i++)
                                {
                                        if(i!=0)
                                                obs += ",";
                                        obs += "'"+ objs[i] +"'";
                                }
                                
                                whereClause += " AND "+ rep->tableName_ +".object_id IN ("+ obs +")";
                        }
                        else
                                whereClause += " AND 1 <> 1 "; // no geometry was found 

                }
        }

        //selected objects
        switch (params_->selectedObjs())
        {
                case TeAll:
                        break;
                
                case TeSelectedByPointing:
                        whereClause += " AND (grid_status = 1 OR grid_status = 3";
                        whereClause += " OR (grid_status IS NULL AND (c_object_status = 1 OR c_object_status = 3)))";
                        break;
                
                case TeNotSelectedByPointing:
                        whereClause += " AND (grid_status = 0 OR grid_status = 2";
                        whereClause += " OR (grid_status is null AND (c_object_status = 0 OR c_object_status = 2)))";
                        break;
                
                case TeSelectedByQuery:
                        whereClause += " AND (grid_status = 2 OR grid_status = 3";
                        whereClause += " OR (grid_status is null AND (c_object_status = 2 OR c_object_status = 3)))";
                        break;
                
                case TeNotSelectedByQuery:
                        whereClause += " AND (grid_status = 0 OR grid_status = 1";
                        whereClause += " OR (grid_status is null AND (c_object_status = 0 OR c_object_status = 1)))";
                        break;
        
                case TeGrouped:
                        whereClause += " AND c_legend_id <> 0";
                        break;

                case TeNotGrouped:
                        whereClause += " AND c_legend_id = 0";
                        break;

                case TeSelectedByPointingAndQuery:
                        whereClause += " AND grid_status = 3";
                        whereClause += " OR (grid_status is null AND c_object_status = 3)";
                        break;

                case TeSelectedByPointingOrQuery:
                        whereClause += " AND (grid_status = 1 OR grid_status = 2 OR grid_status = 3)";
                        whereClause += " OR  (grid_status is null AND (c_object_status = 3 OR c_object_status = 1 OR c_object_status = 2))";
                        break;  
        }

        return whereClause;
}

TeTheme* TeQuerierDB::theme

(

)

[inline, inherited]

Reimplemented from TeQuerierImpl.

Definition at line 98 of file TeQuerierDB.h.

Referenced by TeQuerierDB::sqlFrom().

{       return params_->theme();        }

---

Field Documentation

int TeQuerierDB::attrIndex1_ [protected, inherited]

Definition at line 63 of file TeQuerierDB.h.

Referenced by fillSTO(), TeQuerierDBStr2::fillSTO(), TeQuerierDBStr1::fillSTOGrouped(), TeQuerierDBStr1::fillSTONoGrouped(), initPortal(), TeQuerierDBStr2::initPortal(), and TeQuerierDBStr1::initPortal().

int TeQuerierDB::attrIndex2_ [protected, inherited]

Definition at line 65 of file TeQuerierDB.h.

Referenced by fillSTO(), TeQuerierDBStr2::fillSTO(), TeQuerierDBStr1::fillSTOGrouped(), TeQuerierDBStr1::fillSTONoGrouped(), initPortal(), TeQuerierDBStr2::initPortal(), and TeQuerierDBStr1::initPortal().

TeSharedPtr<TeAttributeList> TeQuerierImpl::attrList_ [protected, inherited]

Definition at line 47 of file TeQuerierImpl.h.

Referenced by TeQuerierSHP::fetchInstance(), fillSTO(), TeQuerierDBStr2::fillSTO(), TeQuerierDBStr1::fillSTOGrouped(), TeQuerierDBStr1::fillSTONoGrouped(), TeQuerierSHP::loadInstances(), loadInstances(), TeQuerierDBStr2::loadInstances(), TeQuerierDBStr1::loadInstances(), TeQuerierImpl::operator=(), and TeQuerierImpl::TeQuerierImpl().

TeTable TeQuerierDB::attrTable_ [protected, inherited]

Definition at line 52 of file TeQuerierDB.h.

Referenced by TeQuerierDBStr1::fillSTONoGrouped(), TeQuerierDBStr1::initGeomPortal(), initPortal(), TeQuerierDBStr2::initPortal(), TeQuerierDBStr1::initPortal(), and TeQuerierDB::sqlFrom().

bool TeQuerierImpl::filledSerie_ [protected, inherited]

Definition at line 46 of file TeQuerierImpl.h.

Referenced by fetchInstance(), TeQuerierDBStr2::fetchInstance(), TeQuerierImpl::operator=(), and TeQuerierImpl::TeQuerierImpl().

bool TeQuerierDB::flagPortal_ [protected, inherited]

Definition at line 54 of file TeQuerierDB.h.

Referenced by TeQuerierDB::clearVectors(), TeQuerierDBStr1::fetchInstance(), TeQuerierDBStr1::fillGeomSTO(), fillSTO(), TeQuerierDBStr2::fillSTO(), TeQuerierDBStr1::fillSTOGrouped(), TeQuerierDBStr1::fillSTONoGrouped(), initPortal(), TeQuerierDBStr2::initPortal(), and TeQuerierDBStr1::initPortal().

string TeQuerierDBStr3::fromClause_ [private]

Definition at line 54 of file TeQuerierDBStr3.h.

Referenced by initPortal(), and numElemInstances().

vector<int> TeQuerierDB::geomIndex1_ [protected, inherited]

Definition at line 69 of file TeQuerierDB.h.

Referenced by TeQuerierDBStr1::fillGeomSTO(), fillSTO(), TeQuerierDBStr1::fillSTOGrouped(), TeQuerierDBStr1::fillSTONoGrouped(), TeQuerierDBStr1::initGeomPortal(), initPortal(), and TeQuerierDBStr1::initPortal().

vector<int> TeQuerierDB::geomIndex2_ [protected, inherited]

Definition at line 71 of file TeQuerierDB.h.

Referenced by TeQuerierDBStr1::initGeomPortal(), and TeQuerierDBStr1::initPortal().

vector<TeRepresentation> TeQuerierDB::geomRepr_ [protected, inherited]

Definition at line 50 of file TeQuerierDB.h.

Referenced by TeQuerierDB::clearVectors(), TeQuerierDBStr1::fillGeomSTO(), TeQuerierDBStr1::fillSTOGrouped(), TeQuerierDBStr1::fillSTONoGrouped(), TeQuerierDBStr1::initGeomPortal(), TeQuerierDBStr1::initPortal(), TeQuerierDB::loadGeometries(), and TeQuerierDB::~TeQuerierDB().

int TeQuerierDB::groupIndex_ [protected, inherited]

Definition at line 67 of file TeQuerierDB.h.

Referenced by fillSTO(), TeQuerierDBStr2::fillSTO(), TeQuerierDBStr1::fillSTOGrouped(), TeQuerierDBStr1::fillSTONoGrouped(), initPortal(), TeQuerierDBStr2::initPortal(), and TeQuerierDBStr1::initPortal().

map<int, int> TeQuerierDB::legendIdGroup_ [protected, inherited]

Definition at line 78 of file TeQuerierDB.h.

Referenced by fillSTO(), TeQuerierDBStr2::fillSTO(), TeQuerierDBStr1::fillSTOGrouped(), TeQuerierDBStr1::fillSTONoGrouped(), initPortal(), TeQuerierDBStr2::initPortal(), and TeQuerierDBStr1::initPortal().

vector<int> TeQuerierDB::linkIndex_ [protected, inherited]

Definition at line 60 of file TeQuerierDB.h.

Referenced by TeQuerierDBStr1::fillGeomSTO(), fillSTO(), TeQuerierDBStr2::fillSTO(), TeQuerierDBStr1::fillSTOGrouped(), TeQuerierDBStr1::fillSTONoGrouped(), TeQuerierDBStr1::initGeomPortal(), initPortal(), TeQuerierDBStr2::initPortal(), and TeQuerierDBStr1::initPortal().

TeQuerierParams* TeQuerierImpl::params_ [protected, inherited]

Definition at line 44 of file TeQuerierImpl.h.

Referenced by fetchInstance(), TeQuerierDBStr1::fetchInstance(), TeQuerierSHP::fileName(), fillSTO(), TeQuerierDBStr2::fillSTO(), TeQuerierDBStr1::fillSTOGrouped(), TeQuerierDBStr1::fillSTONoGrouped(), TeQuerierDB::geometryRep(), TeQuerierDBStr1::initGeomPortal(), initPortal(), TeQuerierDBStr2::initPortal(), TeQuerierDBStr1::initPortal(), TeQuerierDB::loadGeometries(), TeQuerierSHP::loadInstances(), loadInstances(), TeQuerierDBStr2::loadInstances(), TeQuerierDBStr1::loadInstances(), numElemInstances(), TeQuerierDBStr1::numElemInstances(), TeQuerierImpl::operator=(), TeQuerierDB::sqlFrom(), TeQuerierDB::sqlWhereRestrictions(), TeQuerierImpl::TeQuerierImpl(), and TeQuerierImpl::~TeQuerierImpl().

vector<TeDatabasePortal*> TeQuerierDB::portals_ [protected, inherited]

Definition at line 48 of file TeQuerierDB.h.

Referenced by TeQuerierDB::clearVectors(), TeQuerierDBStr1::fetchInstance(), TeQuerierDBStr1::fillGeomSTO(), fillSTO(), TeQuerierDBStr2::fillSTO(), TeQuerierDBStr1::fillSTOGrouped(), TeQuerierDBStr1::fillSTONoGrouped(), TeQuerierDBStr1::initGeomPortal(), initPortal(), TeQuerierDBStr2::initPortal(), TeQuerierDBStr1::initPortal(), TeQuerierDB::loadGeometries(), TeQuerierDBStr2::numElemInstances(), TeQuerierDBStr1::numElemInstances(), and TeQuerierDB::~TeQuerierDB().

TeGeomRep TeQuerierDBStr3::rep_ [private]

Definition at line 52 of file TeQuerierDBStr3.h.

Referenced by fillSTO(), and initPortal().

int TeQuerierDBStr3::timeFramePortal_ [private]

Definition at line 50 of file TeQuerierDBStr3.h.

Referenced by fillSTO(), and loadInstances().

vector<int> TeQuerierDB::timeIndex1_ [protected, inherited]

Definition at line 73 of file TeQuerierDB.h.

Referenced by TeQuerierDBStr1::fillGeomSTO(), fillSTO(), TeQuerierDBStr2::fillSTO(), TeQuerierDBStr1::fillSTOGrouped(), TeQuerierDBStr1::fillSTONoGrouped(), TeQuerierDBStr1::initGeomPortal(), initPortal(), TeQuerierDBStr2::initPortal(), and TeQuerierDBStr1::initPortal().

vector<int> TeQuerierDB::timeIndex2_ [protected, inherited]

Definition at line 75 of file TeQuerierDB.h.

Referenced by TeQuerierDBStr1::fillGeomSTO(), TeQuerierDBStr1::fillSTOGrouped(), TeQuerierDBStr1::fillSTONoGrouped(), TeQuerierDBStr1::initGeomPortal(), initPortal(), TeQuerierDBStr2::initPortal(), and TeQuerierDBStr1::initPortal().

TeTemporalSeries* TeQuerierImpl::ts_ [protected, inherited]

Definition at line 45 of file TeQuerierImpl.h.

Referenced by fetchInstance(), TeQuerierDBStr2::fetchInstance(), TeQuerierImpl::getNumTimeFrames(), TeQuerierImpl::getTS(), TeQuerierImpl::getTSEntry(), TeQuerierImpl::getTSParams(), TeQuerierImpl::operator=(), TeQuerierImpl::TeQuerierImpl(), and TeQuerierImpl::~TeQuerierImpl().

TeTSEntry TeQuerierDBStr3::TSEntry_ [private]

Definition at line 51 of file TeQuerierDBStr3.h.

Referenced by fetchInstance(), fillSTO(), and loadInstances().

map<int, vector<int> > TeQuerierDB::uniqueIndex_ [protected, inherited]

Definition at line 57 of file TeQuerierDB.h.

Referenced by TeQuerierDBStr1::fillSTOGrouped(), TeQuerierDBStr1::initGeomPortal(), and TeQuerierDBStr1::initPortal().

string TeQuerierDBStr3::whereClause_ [private]

Definition at line 55 of file TeQuerierDBStr3.h.

Referenced by initPortal(), and numElemInstances().

---

The documentation for this class was generated from the following files:

• TeQuerierDBStr3.h
• TeQuerierDBStr3.cpp

---