TeDatabasePortal Class Reference

#include <TeDatabase.h>

Inheritance diagram for TeDatabasePortal:

Detailed Description

A portal has a concept of a record set, that is generated by a selection (query) on the data accessible through a connection to a database server.

See also:: TeDatabase, TeGeometry, TeTable, TeTheme, TeView, TeLayer

Examples:: createTable.cpp, and databaseSQLQuery.cpp.

Definition at line 1614 of file TeDatabase.h.

Fetch Geometry

The following methods decodify geometries as stored in the database according to the data model proposed in TerraLib.

Parameters:

	geom	the geometry that will be filled from portal
	initIndex	the position index in the portal where begins the geometry information

Returns:: The fetchGeometry methods advance the portal to the next record and they return TRUE if there are more records to be read and FALSE otherwise.

virtual bool fetchGeometry (TeText &geom, const unsigned int &initIndex)

virtual bool fetchGeometry (TeText &geom)

virtual bool fetchGeometry (TeArc &geom, const unsigned int &initIndex)

virtual bool fetchGeometry (TeArc &geom)

virtual bool fetchGeometry (TeCell &geom, const unsigned int &initIndex)

virtual bool fetchGeometry (TeCell &geom)

virtual bool fetchGeometry (TePoint &geom, const unsigned int &initIndex)

virtual bool fetchGeometry (TePoint &geom)=0

virtual bool fetchGeometry (TeNode &geom, const unsigned int &initIndex)

virtual bool fetchGeometry (TeNode &geom)=0

virtual bool fetchGeometry (TeLine2D &geom, const unsigned int &initIndex)

virtual bool fetchGeometry (TeLine2D &geom)=0

virtual bool fetchGeometry (TePolygon &geom, const unsigned int &initIndex)

virtual bool fetchGeometry (TePolygon &geom)=0

Data Model

The following methods decodify structures as stored in the database according to the data model proposed in TerraLib.

virtual bool getAttrTable (TeTable &table, const unsigned int &initIndex=0)

virtual TeColor getColor ()

virtual void getDatum (TeDatum &datum, const unsigned int &initIndex=0)

virtual bool getGrouping (TeGrouping &group, const unsigned int &initIndex=0)

virtual bool getLayer (TeLayer &layer, const unsigned int &initIndex=0)

virtual bool getLegend (TeLegendEntry &leg, const unsigned int &initIndex=0)

virtual TeLegendEntry getLegend ()

virtual bool getProjection (TeProjection **proj, const unsigned int &initIndex=0)

virtual bool getRasterBlock (unsigned long &size, unsigned char *ptData)=0

virtual bool getRasterVisual (TeRasterVisual &vis, const unsigned int &initIndex=0)

virtual bool getRepresentation (TeRepresentation &rep, const unsigned int &initIndex=0)

virtual bool getTheme (TeAbstractTheme &theme, const unsigned int &initIndex=0)

virtual bool getView (TeView &view, const unsigned int &initIndex=0)

virtual void getViewNodeParams (TeViewNodeParams &params, const unsigned int &initIndex=0)

virtual TeViewTree * getViewTree ()

virtual bool getVisual (TeVisual *vis, TeGeomRep &rep, const unsigned int &initIndex)

virtual void getVisual (TeVisual *)

Public Member Functions

virtual string errorMessage ()

Gets the last error message.

virtual int errorNum ()

Gets the number of the last error message.

virtual bool fetchRow (int i)=0

Fetchs a particular row.

virtual bool fetchRow ()=0

Fetchs the next row in a record set that shouldve been previously opened.

virtual void freeResult ()=0

Frees the current record set.

TeAttribute getAttribute (const string &s)

Retrieves an attribute by name.

TeAttribute getAttribute (int i)

Retrieves the i-th attribute in this portal.

TeAttributeList & getAttributeList ()

Retrieves attribute list in this portal.

virtual bool getBlob (const string &s, unsigned char *&data, long &size)=0

Gets the value of a named BLOB attribute.

virtual bool getBool (int i)=0

Gets the value of the i-th attribute as a boolean.

virtual bool getBool (const string &s)=0

Gets the value of a named attribute as a boolean.

int getColumnIndex (const string &s)

Gets the index of a named attribute.

string getColumnName (int i)

Gets the name of the i-th attribute.

virtual char * getData (const string &s)=0

Gets the value of a named attribute as a literal.

virtual char * getData (int i)=0

Gets the value of the i-th attribute as a literal.

TeDatabase * getDatabase ()

Returns the database associated to this portal.

virtual TeTime getDate (const string &s)=0

Gets the value of a named attribute as a date.

virtual TeTime getDate (int i)=0

Gets the value of the i-th attribute as a date.

virtual string getDateAsString (const string &s)=0

Gets the of a date/time attribute as a string formatted as accepted in further SQL statements.

virtual string getDateAsString (int i)=0

Gets the of a date/time attribute as a string formatted as accepted in further SQL statements.

virtual double getDouble (const string &s)

Gets the value of a named attribute as a double.

virtual double getDouble (int i)

Gets the value of the i-th attribute as a double.

virtual int getInt (const string &s)

Gets the value of a named attribute as an integer.

virtual int getInt (int i)

Gets the value of the i-th attribute as an integer.

int numFields ()

Retrieves the number of fields in this portal.

int numRows ()

Retrieves the number of rows in a portal. Some drivers (like PostgreSQL and PostGIS) brings to the client only a part of the row, and then this number can be less than the number of rows returned by query.

virtual bool query (const string &qry, TeCursorLocation l=TeSERVERSIDE, TeCursorType t=TeUNIDIRECTIONAL, TeCursorEditType e=TeREADONLY, TeCursorDataType dt=TeTEXTCURSOR)=0

Executes a SQL query that opens a record set.

TeDatabasePortal ()

Constructor.

virtual ~TeDatabasePortal ()

Destructor.

Protected Attributes

TeAttributeList

attList_

the list of attributes associated to this portal

TeDatabase * db_

the database associated to this portal

string

errorMessage_

error message

int errorNumber_

error number

int numFields_

the number of fields in this portal

int numRows_

the number of rows in this portal

Constructor & Destructor Documentation

TeDatabasePortal::TeDatabasePortal ( )

Definition at line 10225 of file TeDatabase.cpp.

10225                                   :
10226         db_(0),                 
10227         numRows_(0),
10228         numFields_ (0), 
10229         errorMessage_(""),
10230         errorNumber_(0)
10231         {}

TeDatabasePortal::~TeDatabasePortal ( ) [virtual]

Definition at line 10233 of file TeDatabase.cpp.

10234 {
10235 }

Member Function Documentation

virtual string TeDatabasePortal::errorMessage ( ) [inline, virtual]

Reimplemented in TeMySQLPortal, TePostgreSQLPortal, and TeSQLitePortal.

Definition at line 1650 of file TeDatabase.h.

References errorMessage_.

Referenced by TeFirebird::generateLabelPositions(), generateLablesForPolygonal(), TeSQLite::insertRasterBlock(), and TeFirebird::insertRasterBlock().

01651         { return errorMessage_; }

virtual int TeDatabasePortal::errorNum ( ) [inline, virtual]

Reimplemented in TeMySQLPortal.

Definition at line 1654 of file TeDatabase.h.

01655         { return errorNumber_; }

bool TeDatabasePortal::fetchGeometry	(	TeText &	geom,
		const unsigned int &	initIndex
	)			`[virtual]`

Definition at line 10470 of file TeDatabase.cpp.

References fetchRow(), TeGeometry::geomId(), getData(), getDouble(), TeGeometry::objectId(), TeText::setAlignmentHoriz(), TeText::setAlignmentVert(), TeText::setAngle(), and TeText::setHeight().

10471 {
10472         TeCoord2D c(getDouble(initIndex+2), getDouble(initIndex+3));
10473         string txt = getData(initIndex+4);
10474         TeText t2(c,txt);
10475         t2.geomId(atoi(getData(initIndex)));
10476         t2.objectId(string(getData(initIndex+1)));
10477         t2.setAngle (getDouble(initIndex+5));
10478         t2.setHeight (getDouble(initIndex+6));
10479         t2.setAlignmentVert(getDouble(initIndex+7));
10480         t2.setAlignmentHoriz(getDouble(initIndex+8));
10481         t = t2;
10482         return (fetchRow());
10483 }

bool TeDatabasePortal::fetchGeometry ( TeText & geom ) [virtual]

Definition at line 10454 of file TeDatabase.cpp.

References fetchRow(), TeGeometry::geomId(), getData(), getDouble(), TeGeometry::objectId(), TeText::setAlignmentHoriz(), TeText::setAlignmentVert(), TeText::setAngle(), and TeText::setHeight().

10455 {
10456         TeCoord2D c(getDouble("x"), getDouble("y"));
10457         string txt = getData ("text_value");
10458         TeText t2(c,txt);
10459         t2.geomId(atoi(getData("geom_id")));
10460         t2.objectId(string(getData("object_id")));
10461         t2.setAngle (getDouble("angle"));
10462         t2.setHeight (getDouble("height"));
10463         t2.setAlignmentVert(getDouble("alignment_vert"));
10464         t2.setAlignmentHoriz(getDouble("alignment_horiz"));
10465         t = t2;
10466         return (fetchRow());
10467 }

bool TeDatabasePortal::fetchGeometry	(	TeArc &	geom,
		const unsigned int &	initIndex
	)			`[virtual]`

Definition at line 10496 of file TeDatabase.cpp.

References fetchRow(), TeArc::fromId(), TeGeometry::geomId(), getData(), TeGeometry::objectId(), and TeArc::toId().

10497 {
10498         arc.fromId(atoi(getData(initIndex+2)));
10499         arc.toId(atoi(getData(initIndex+3)));
10500         arc.geomId(atol(getData(initIndex+0)));
10501         arc.objectId(string(getData(initIndex+1)));
10502         return fetchRow();
10503 }

bool TeDatabasePortal::fetchGeometry ( TeArc & geom ) [virtual]

Definition at line 10486 of file TeDatabase.cpp.

References fetchRow(), TeArc::fromId(), TeGeometry::geomId(), getData(), TeGeometry::objectId(), and TeArc::toId().

10487 {
10488         arc.fromId(atoi(getData(2)));
10489         arc.toId(atoi(getData(3)));
10490         arc.geomId(atol(getData(0)));
10491         arc.objectId(string(getData(1)));
10492         return fetchRow();
10493 }

bool TeDatabasePortal::fetchGeometry	(	TeCell &	geom,
		const unsigned int &	initIndex
	)			`[virtual]`

Reimplemented in TeOracleSpatialPortal, TePostGISPortal, and TePostgreSQLPortal.

Definition at line 10304 of file TeDatabase.cpp.

References TeCell::column(), fetchRow(), TeGeometry::geomId(), getData(), TeCell::line(), TeGeometry::objectId(), and TeGeometry::setBox().

10305 {
10306         int index = atoi(getData(initIndex));
10307         string object_id = getData(initIndex+1);
10308         TeBox b (atof(getData(initIndex+2)),atof(getData(initIndex+3)),atof(getData(initIndex+4)),atof(getData(initIndex+5)));
10309         cell.geomId(index);
10310         cell.objectId(object_id);
10311         cell.setBox (b);
10312         cell.column(atoi(getData(initIndex+6)));
10313         cell.line(atoi(getData(initIndex+7)));
10314         return (fetchRow());
10315 }

bool TeDatabasePortal::fetchGeometry ( TeCell & geom ) [virtual]

Reimplemented in TeOracleSpatialPortal, TePostGISPortal, and TePostgreSQLPortal.

Definition at line 10290 of file TeDatabase.cpp.

References TeCell::column(), fetchRow(), TeGeometry::geomId(), getData(), TeCell::line(), TeGeometry::objectId(), and TeGeometry::setBox().

10291 {
10292         int index = atoi(getData("geom_id"));
10293         string object_id = getData("object_id");
10294         TeBox b (atof(getData("lower_x")),atof(getData("lower_y")),atof(getData("upper_x")),atof(getData("upper_y")));
10295         cell.geomId(index);
10296         cell.objectId(object_id);
10297         cell.setBox (b);
10298         cell.column(atoi(getData("col_number")));
10299         cell.line(atoi(getData("row_number")));
10300         return (fetchRow());
10301 }

bool TeDatabasePortal::fetchGeometry	(	TePoint &	geom,
		const unsigned int &	initIndex
	)			`[virtual]`

Reimplemented in TeAdoPortal, TeSqlServerSpatialPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TeOracleSpatialPortal, TePostGISPortal, TePostgreSQLPortal, and TeSQLitePortal.

Definition at line 10284 of file TeDatabase.cpp.

References fetchGeometry().

10285 {
10286         return fetchGeometry(geom);
10287 }

virtual bool TeDatabasePortal::fetchGeometry ( TePoint & geom ) [pure virtual]

Implemented in TeAdoPortal, TeSqlServerSpatialPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TeOracleSpatialPortal, TePostGISPortal, TePostgreSQLPortal, and TeSQLitePortal.

bool TeDatabasePortal::fetchGeometry	(	TeNode &	geom,
		const unsigned int &	initIndex
	)			`[virtual]`

Reimplemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TeOracleSpatialPortal, TePostGISPortal, TePostgreSQLPortal, and TeSQLitePortal.

Definition at line 10278 of file TeDatabase.cpp.

References fetchGeometry().

10279 {
10280         return fetchGeometry(geom);
10281 }

virtual bool TeDatabasePortal::fetchGeometry ( TeNode & geom ) [pure virtual]

Implemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TeOracleSpatialPortal, TePostGISPortal, TePostgreSQLPortal, and TeSQLitePortal.

bool TeDatabasePortal::fetchGeometry	(	TeLine2D &	geom,
		const unsigned int &	initIndex
	)			`[virtual]`

Reimplemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TeOracleSpatialPortal, TePostGISPortal, TePostgreSQLPortal, and TeSQLitePortal.

Definition at line 10272 of file TeDatabase.cpp.

References fetchGeometry().

10273 {
10274         return fetchGeometry(geom);
10275 }

virtual bool TeDatabasePortal::fetchGeometry ( TeLine2D & geom ) [pure virtual]

Implemented in TeAdoPortal, TeSqlServerSpatialPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TeOracleSpatialPortal, TePostGISPortal, TePostgreSQLPortal, and TeSQLitePortal.

bool TeDatabasePortal::fetchGeometry	(	TePolygon &	geom,
		const unsigned int &	initIndex
	)			`[virtual]`

Reimplemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TeOracleSpatialPortal, TePostGISPortal, TePostgreSQLPortal, and TeSQLitePortal.

Definition at line 10266 of file TeDatabase.cpp.

References fetchGeometry().

10267 {
10268         return fetchGeometry(geom);
10269 }

virtual bool TeDatabasePortal::fetchGeometry ( TePolygon & geom ) [pure virtual]

Implemented in TeAdoPortal, TeSqlServerSpatialPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TeOracleSpatialPortal, TePostGISPortal, TePostgreSQLPortal, and TeSQLitePortal.

Examples:: databaseSQLQuery.cpp.

virtual bool TeDatabasePortal::fetchRow ( int i ) [pure virtual]

Implemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TePostgreSQLPortal, and TeSQLitePortal.

virtual bool TeDatabasePortal::fetchRow ( ) [pure virtual]

Implemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TePostgreSQLPortal, and TeSQLitePortal.

Examples:: createTable.cpp, and databaseSQLQuery.cpp.

virtual void TeDatabasePortal::freeResult ( ) [pure virtual]

Implemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TePostgreSQLPortal, and TeSQLitePortal.

Referenced by TeAddressLocator::addCompleteNameColumn(), TeQtGrid::arrangeGridToPortalRowVector(), TeQtGridSource::changePortalQuery(), TeDecoderDatabase::clear(), TeQtGrid::clearPortal(), TeExternalTheme::copyRemoteCollection(), deleteGPMTable(), TeDatabase::deleteLayer(), deletePointedObjects(), TeDatabase::deleteTheme(), TeSqlServer::deleteTheme(), TeDatabase::deleteView(), TeSqlServer::deleteView(), generateTextUsingCentroid(), TeAddressLocator::getAddressTablePortal(), TePostgreSQL::getAttributeList(), TeOCIOracle::getAttributeList(), TeOracle::getAttributeList(), TeDBConnectionsPool::getConnectionInfo(), TeSQLite::getIndexesFromTable(), TePostgreSQL::getIndexesFromTable(), TeOCIOracle::getIndexesFromTable(), TeMySQL::getIndexesFromTable(), TeFirebird::getIndexesFromTable(), getItems(), TeTheme::getItemVector(), TeDatabase::getNewLayerName(), TeLayer::getNewObjectId(), TeDatabase::getNewThemeName(), getObject2ItemsMap(), getObjects(), TeTheme::getObjects(), TeLayer::getRasterGeometries(), TeDatabase::getRasterTable(), TeSFSTheme::getRemoteThemeInfo(), TeExternalTheme::getRemoteThemeInfo(), TeQtGLWidget::getValues(), TeQtGrid::init(), TeDecoderDatabase::init(), TeQtGrid::initPortal(), TeMySQL::listDatabases(), loadAppTheme(), TeBlockLoader::loadBlocks(), TeDatabase::loadCellSet(), loadDefaultGPM(), TeDBConnectionsPool::loadExternalDBConnections(), loadKernelParams(), TeDatabase::loadLayerRaster(), TeExternalTheme::loadObjectLegendMap(), TeDatabase::loadRasterLUT(), TeDatabase::loadTableInfo(), TeDatabase::loadViewTree(), TeDatabase::mask(), TeOracleSpatial::nearestNeighbors(), objBoxInCanvas(), TeQtTable::openTable(), plotPieBars(), plotTexts(), plotTextWV(), TeDatabase::projectExist(), TeQtGridSource::reloadPortal(), TeLayer::removeGeometry(), TeDatabase::selectCellSet(), TeQtGLWidget::selectFromHexaedro(), TeQtGridSource::setCell(), TeQtGrid::sort(), TeOracleSpatial::spatialRelation(), TeCopyDatabase(), TeCopyExternThemeToLayer(), TeCopyLayerToLayer(), TeCopyThemeToLayer(), TeCreateCells(), TeExportShapefile(), TeGeoOpAggregation(), TeGetCentroid(), TePlotFrame(), TePlotObjects(), TePlotSelectedObjects(), TePlotTexts(), TePlotTextWV(), TeRetrieveCoverageIds(), TeRetrieveCoverageLayerTable(), TeRetrieveCoverageNumElements(), TeRetrieveCoverageTable(), TeTopologicalRelation(), updateDB20To30(), updateDB301To302(), updateDB320To3201(), updateDB400To412(), TeQtGrid::updatePortalContents(), TeFirebird::updateRasterRepresentation(), TeDatabase::updateRasterRepresentation(), TeDatabase::zonal(), and TeQtGrid::~TeQtGrid().

TeAttribute TeDatabasePortal::getAttribute ( const string & s )

Definition at line 10331 of file TeDatabase.cpp.

References attList_, and TeConvertToUpperCase().

10332 {
10333         TeAttributeList::iterator it = attList_.begin();
10334         while ( it != attList_.end() )
10335         {
10336                 if (TeConvertToUpperCase(s) == TeConvertToUpperCase((*it).rep_.name_))
10337                         return (*it);
10338                 ++it;
10339         }
10340         return TeAttribute();
10341 }

TeAttribute TeDatabasePortal::getAttribute ( int i )

Definition at line 10317 of file TeDatabase.cpp.

References attList_.

Referenced by TeQtGrid::isDateTimeRegistered(), TeQtGrid::isIndex(), TeQtGrid::isSortBy(), TeQtGrid::swapColumns(), and updateDB310To311().

10318 {
10319         TeAttributeList::iterator it = attList_.begin();
10320         int j = 0;
10321         while ( it != attList_.end() )
10322         {
10323                 if (i == j)
10324                         return (*it);
10325                 ++it;
10326                 j++;
10327         }
10328         return TeAttribute();
10329 }

TeAttributeList& TeDatabasePortal::getAttributeList ( ) [inline]

bool TeDatabasePortal::getAttrTable	(	TeTable &	table,
		const unsigned int &	initIndex = `0`
	)			`[virtual]`

Definition at line 10840 of file TeDatabase.cpp.

References TeTable::attFinalTime(), TeTable::attInitialTime(), TeTable::attTimeUnit(), getData(), TeTable::name(), TeTable::setId(), TeTable::setLinkName(), TeTable::setTableType(), and TeTable::setUniqueName().

Referenced by TeDatabase::getAttrTables(), TeDatabase::loadLayer(), TeDatabase::loadLayerSet(), TeDatabase::loadLayerTable(), TeDatabase::loadTableInfo(), and TeDatabase::loadThemeTable().

10841 {
10842         string tableName = this->getData(initIndex+2);
10843         if(tableName.empty())
10844                 return false;
10845 
10846         table.name (tableName);
10847         table.setId(this->getInt(initIndex+0));
10848         table.setLinkName(this->getData(initIndex+4));
10849         table.setUniqueName(this->getData(initIndex+3));
10850         table.attInitialTime(this->getData(initIndex+5));
10851         table.attFinalTime(this->getData(initIndex+6));
10852         table.attTimeUnit(TeChronon(this->getInt(initIndex+7)));
10853         table.setTableType((TeAttrTableType)this->getInt(initIndex+8));
10854         return true;
10855 }

virtual bool TeDatabasePortal::getBlob	(	const string &	s,
		unsigned char *&	data,
		long &	size
	)			`[pure virtual]`

Implemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TePostgreSQLPortal, and TeSQLitePortal.

Referenced by getInfoBlob2TemporaryFile(), TeBlockLoader::getSpatialData(), and TeDatabase::loadTable().

virtual bool TeDatabasePortal::getBool ( int i ) [pure virtual]

Implemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TePostgreSQLPortal, and TeSQLitePortal.

virtual bool TeDatabasePortal::getBool ( const string & s ) [pure virtual]

Implemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TePostgreSQLPortal, and TeSQLitePortal.

Referenced by TeSQLite::getAttributeList(), TeBlockLoader::getBool(), getView(), getVisual(), and loadAppTheme().

TeColor TeDatabasePortal::getColor ( ) [virtual]

Definition at line 10612 of file TeDatabase.cpp.

References getData().

Referenced by loadChartParams().

10613 {
10614         TeColor c(atoi(getData("red")), atoi(getData("green")), atoi(getData("blue")));
10615         return c;
10616 }

int TeDatabasePortal::getColumnIndex ( const string & s )

Reimplemented in TeSQLitePortal.

Definition at line 10344 of file TeDatabase.cpp.

References attList_, and TeConvertToUpperCase().

Referenced by TeOCIOraclePortal::getBool(), TeSQLitePortal::getColumnIndex(), TeOCIOraclePortal::getData(), TeOCIOraclePortal::getDate(), and TeFirebirdPortal::getRasterBlock().

10345 {
10346         TeAttributeList::iterator it = attList_.begin();
10347         int j = 0;
10348         while ( it != attList_.end() )
10349         {
10350                 if (TeConvertToUpperCase(s) == TeConvertToUpperCase((*it).rep_.name_))
10351                         return j;
10352                 ++it;
10353                 j++;
10354         }
10355         return -1;
10356 }

string TeDatabasePortal::getColumnName ( int i )

Definition at line 10359 of file TeDatabase.cpp.

References attList_.

10360 {
10361         TeAttributeList::iterator it = attList_.begin();
10362         int j=0;
10363         while ( it != attList_.end() )
10364         {
10365                 if (j==i)
10366                         return (*it).rep_.name_;
10367                 ++it;
10368                 j++;
10369         }
10370         return "";
10371 }

virtual char* TeDatabasePortal::getData ( const string & s ) [pure virtual]

Implemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TePostgreSQLPortal, and TeSQLitePortal.

virtual char* TeDatabasePortal::getData ( int i ) [pure virtual]

Implemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TePostgreSQLPortal, and TeSQLitePortal.

Examples:: createTable.cpp.

TeDatabase* TeDatabasePortal::getDatabase ( ) [inline]

Definition at line 1634 of file TeDatabase.h.

Referenced by TeQtGridSource::changePortalQuery(), getGrouping(), getProjection(), getRasterVisual(), mountSelect(), TeQtGridSource::reloadPortal(), TeQtGridSource::setPortal(), TeGetArea(), TeGetBuffer(), TeGetCentroid(), TeGetConvexHull(), TeGetDistance(), TeGetLength(), TeGetOverlay(), TeGetWithinDistance(), TeKeepStatistics(), TePlotTexts(), and TeTopologicalRelation().

01635         { return db_; }

virtual TeTime TeDatabasePortal::getDate ( const string & s ) [pure virtual]

Implemented in TeAdoPortal, TeOraclePortal, TeSqlServerPortal, TeSqlServerSpatialPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TePostgreSQLPortal, and TeSQLitePortal.

virtual TeTime TeDatabasePortal::getDate ( int i ) [pure virtual]

virtual string TeDatabasePortal::getDateAsString ( const string & s ) [pure virtual]

Implemented in TeAdoPortal, TeOraclePortal, TeSqlServerPortal, TeSqlServerSpatialPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TePostgreSQLPortal, and TeSQLitePortal.

virtual string TeDatabasePortal::getDateAsString ( int i ) [pure virtual]

Implemented in TeAdoPortal, TeOraclePortal, TeSqlServerPortal, TeSqlServerSpatialPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TePostgreSQLPortal, and TeSQLitePortal.

Referenced by TeBlockLoader::getDateAsString().

void TeDatabasePortal::getDatum	(	TeDatum &	datum,
		const unsigned int &	initIndex = `0`
	)			`[virtual]`

Definition at line 10636 of file TeDatabase.cpp.

References getData(), and getDouble().

Referenced by TeDatabase::loadDatum(), and TeDatabase::loadDatumSet().

10637 {
10638         std::string name = getData(initIndex);
10639         double radius = getDouble(initIndex + 1);
10640         double flattening = getDouble(initIndex + 2);
10641         double dx = getDouble(initIndex + 3);
10642         double dy = getDouble(initIndex + 4);
10643         double dz = getDouble(initIndex + 5);
10644         datum = TeDatum(name, radius, flattening, dx, dy, dz);
10645 }

double TeDatabasePortal::getDouble ( const string & s ) [virtual]

Reimplemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, and TePostgreSQLPortal.

Definition at line 10245 of file TeDatabase.cpp.

References getData().

10246 {  
10247         char* val = getData(s); 
10248         return atof(val); 
10249 }

double TeDatabasePortal::getDouble ( int i ) [virtual]

Reimplemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, and TePostgreSQLPortal.

Examples:: createTable.cpp.

Definition at line 10238 of file TeDatabase.cpp.

References getData().

Referenced by TeSqlServerSpatial::createSpatialIndex(), deletePointedObjects(), TeSQLitePortal::fetchGeometry(), fetchGeometry(), TeFirebird::generateLabelPositions(), generateLablesForPolygonal(), getDatum(), TeBlockLoader::getDouble(), getGrouping(), getLayer(), TePostgreSQL::getMBRGeom(), TeDatabase::getMBRGeom(), TePostgreSQL::getMBRSelectedObjects(), getProjection(), getRepresentation(), TeDecoderDatabase::getSelectedRasterBlock(), getTheme(), getView(), getVisual(), TePieBar::load(), loadAppTheme(), TeDatabase::loadCellSet(), loadDefaultGPM(), loadKernelParams(), TeDatabase::loadLayerRaster(), TeTin::loadTIN(), main(), TeDatabase::selectCellSet(), TeRetrieveCoverageBox(), TeLayer::updateLayerBox(), TeFirebird::updateRasterRepresentation(), and TeDatabase::updateRasterRepresentation().

10239 {  
10240         char* val = getData(i); 
10241         return atof(val); 
10242 }

bool TeDatabasePortal::getGrouping	(	TeGrouping &	group,
		const unsigned int &	initIndex = `0`
	)			`[virtual]`

Definition at line 10766 of file TeDatabase.cpp.

References getData(), getDatabase(), getDouble(), getInt(), TeGrouping::groupAttribute_, TeGrouping::groupChronon_, TeGrouping::groupFunction_, TeGrouping::groupMode_, TeGrouping::groupNormAttribute_, TeGrouping::groupNumSlices_, TeGrouping::groupPrecision_, TeGrouping::groupStdDev_, TeDatabase::mapThemeAlias(), TeAttributeRep::name_, and TeAttributeRep::type_.

Referenced by TeDatabase::loadTheme(), TeDatabase::loadThemes(), TeDatabase::loadView(), TeDatabase::loadViewSet(), and loadViewSetAndThemeGroups().

10767 {
10768         string groupThemeId = getData(initIndex);
10769         if(groupThemeId.empty())
10770                 return false;
10771 
10772         TeAttributeRep atRep;
10773         string attname = getData (initIndex+2);
10774         string norname = getData (initIndex+5);
10775         int f = attname.find("(");
10776         if(f >= 0)
10777         {
10778                 string alias = attname;
10779                 attname = attname.substr(0, f);
10780                 alias = alias.substr(f+1);
10781                 alias = alias.substr(0, alias.size()-1);
10782                 map<string, string>& m = this->getDatabase()->mapThemeAlias()[atoi(groupThemeId.c_str())];
10783                 m[attname] = alias;
10784         }
10785         f = norname.find("(");
10786         if(f >= 0)
10787         {
10788                 string alias = norname;
10789                 norname = norname.substr(0, f);
10790                 alias = alias.substr(f+1);
10791                 alias = alias.substr(0, alias.size()-1);
10792                 map<string, string>& m = this->getDatabase()->mapThemeAlias()[atoi(groupThemeId.c_str())];
10793                 m[norname] = alias;
10794         }
10795 
10796         if(attname=="NONE")
10797                 attname = "";
10798         
10799         if(norname=="NONE")
10800                 norname = "";
10801                 
10802         atRep.name_ = attname;
10803         atRep.type_ = TeAttrDataType(atoi(getData(initIndex+3)));
10804         group.groupAttribute_ = atRep;
10805         group.groupNormAttribute_ = norname;
10806         group.groupMode_ = TeGroupingMode(getInt(initIndex+4));
10807         group.groupNumSlices_ = getInt(initIndex+1);
10808         group.groupPrecision_ = getInt(initIndex+7);
10809         group.groupStdDev_ = getDouble(initIndex+6);
10810         group.groupFunction_ = getData(initIndex+8);
10811         group.groupChronon_ = TeChronon(getInt(initIndex+9));
10812         return true;
10813 }

int TeDatabasePortal::getInt ( const string & s ) [virtual]

Reimplemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TePostgreSQLPortal, and TeSQLitePortal.

Definition at line 10259 of file TeDatabase.cpp.

References getData().

10260 {  
10261         char* val = getData(s); 
10262         return atoi(val); 
10263 }

int TeDatabasePortal::getInt ( int i ) [virtual]

Reimplemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TePostgreSQLPortal, and TeSQLitePortal.

Definition at line 10252 of file TeDatabase.cpp.

References getData().

10253 {  
10254         char* val = getData(i); 
10255         return atoi(val); 
10256 }

bool TeDatabasePortal::getLayer	(	TeLayer &	layer,
		const unsigned int &	initIndex = `0`
	)			`[virtual]`

Definition at line 10858 of file TeDatabase.cpp.

References getData(), getDouble(), TeLayer::id(), TeLayer::name(), TeLayer::setEditionTime(), and TeLayer::setLayerBox().

Referenced by TeDatabase::loadLayer(), and TeDatabase::loadLayerSet().

10859 {
10860         string layerId = this->getData(initIndex);
10861         if(layerId.empty())
10862                 return false;
10863 
10864     layer.id(atoi(layerId.c_str()));
10865         layer.name(string (this->getData(initIndex+2)));
10866 
10867         layer.setLayerBox(TeBox(this->getDouble(initIndex+3),
10868                                                 this->getDouble(initIndex+4),
10869                                                 this->getDouble(initIndex+5),
10870                                                 this->getDouble(initIndex+6)));
10871 
10872         layer.setEditionTime(this->getDate(initIndex+9));
10873 
10874         return true;
10875 }

bool TeDatabasePortal::getLegend	(	TeLegendEntry &	leg,
		const unsigned int &	initIndex = `0`
	)			`[virtual]`

Definition at line 10816 of file TeDatabase.cpp.

References TeLegendEntry::count(), TeLegendEntry::from(), getData(), TeLegendEntry::group(), TeLegendEntry::id(), TeLegendEntry::label(), TeLegendEntry::theme(), and TeLegendEntry::to().

10817 {
10818         string legId = getData(initIndex);
10819         if(legId.empty())
10820                 return false;
10821 
10822         leg.id(atoi(getData(initIndex)));
10823         leg.theme (atoi(getData(initIndex+1)));
10824         leg.group (atoi(getData(initIndex+2)));
10825         leg.count (atoi(getData(initIndex+3)));
10826 
10827   std::string lower_value_str( getData(initIndex+4) );
10828   leg.from( lower_value_str );
10829   
10830   std::string upper_value_str( getData(initIndex+5) );
10831   leg.to( upper_value_str );
10832   
10833   std::string label_str( getData(initIndex+6) );
10834   leg.label( label_str );
10835     
10836         return true;
10837 }

TeLegendEntry TeDatabasePortal::getLegend ( ) [virtual]

Definition at line 10389 of file TeDatabase.cpp.

References TeLegendEntry::count(), TeLegendEntry::from(), getData(), TeLegendEntry::group(), TeLegendEntry::id(), TeLegendEntry::label(), TeLegendEntry::theme(), and TeLegendEntry::to().

Referenced by TeDatabase::loadLegend(), TeDatabase::loadTheme(), TeDatabase::loadThemes(), TeDatabase::loadView(), TeDatabase::loadViewSet(), and loadViewSetAndThemeGroups().

10390 {
10391         TeLegendEntry leg;
10392         leg.id (atoi(getData("legend_id")));
10393         leg.theme (atoi(getData("theme_id")));
10394         leg.group (atoi(getData("group_id")));
10395 
10396         string data;
10397         data = getData("num_objs");
10398         leg.count(atoi(data.c_str()));
10399         data = getData("lower_value");
10400         leg.from(data);
10401         data = getData("upper_value");
10402         leg.to(data);
10403         data = getData("label");
10404         leg.label(data);
10405         return leg;
10406 }

bool TeDatabasePortal::getProjection	(	TeProjection **	proj,
		const unsigned int &	initIndex = `0`
	)			`[virtual]`

Definition at line 10648 of file TeDatabase.cpp.

References TeProjectionParams::datum, fetchRow(), getData(), getDatabase(), getDouble(), getInt(), TeDatabase::getPortal(), TeProjectionParams::hemisphere, TeProjectionParams::lat0, TeProjectionParams::lon0, TeProjectionFactory::make(), TeProjectionParams::name, TeProjectionParams::offx, TeProjectionParams::offy, query(), TeProjectionParams::scale, TeProjectionParams::stlat1, TeProjectionParams::stlat2, TeCDR, and TeProjectionParams::units.

Referenced by TeDatabase::loadLayer(), TeDatabase::loadLayerRaster(), TeDatabase::loadLayerSet(), TeFileTheme::loadMetadata(), TeDatabase::loadProjection(), TeDatabase::loadProjectionFromSRSId(), TeDatabase::loadView(), TeDatabase::loadViewSet(), loadViewSetAndThemeGroups(), and updateDB400To412().

10649 {
10650         string projId = getData(initIndex);
10651         if(projId.empty())
10652                 return false;
10653 
10654         TeDatum datum ( getData(initIndex+11),
10655                                         getDouble(initIndex+12),
10656                                         getDouble(initIndex+13),
10657                                         getDouble(initIndex+14),
10658                                         getDouble(initIndex+15),
10659                                         getDouble(initIndex+16));
10660 
10661         TeProjectionParams mProjPars;
10662         mProjPars.datum = datum;
10663         mProjPars.name = getData(initIndex+1);
10664         mProjPars.lat0 = getDouble(initIndex+3)*TeCDR;
10665         mProjPars.lon0 = getDouble(initIndex+2)*TeCDR;
10666         mProjPars.offx = getDouble(initIndex+4);
10667         mProjPars.offy = getDouble(initIndex+5);
10668         mProjPars.stlat1 = getDouble(initIndex+6)*TeCDR;
10669         mProjPars.stlat2 = getDouble(initIndex+7)*TeCDR;
10670         mProjPars.units = getData(initIndex+8);
10671         mProjPars.scale = getDouble(initIndex+9);
10672         mProjPars.hemisphere = (TeHemisphere)getInt(initIndex+10);
10673 
10674         *proj = TeProjectionFactory::make(mProjPars);
10675         if(!*proj)
10676                 return false;
10677 
10678         (*proj)->id(atoi(projId.c_str()));
10679 
10680         /* Will be revised! */
10681         // To get projection srs_id
10682         TeDatabasePortal* portal = this->getDatabase()->getPortal();
10683         if(portal == 0)
10684                 return false;
10685 
10686         std::string sql = "SELECT srs_id FROM te_srs WHERE projection_id = ";
10687                                 sql += projId.c_str();
10688 
10689         if(!portal->query(sql))
10690         {
10691                 delete portal;
10692                 return false;
10693         }
10694 
10695         if(!portal->fetchRow())
10696         {
10697                 delete portal;
10698                 return false;
10699         }
10700 
10701         int srsid = portal->getInt(0);
10702         (*proj)->epsgCode(srsid);
10703 
10704         delete portal;
10705         /* Will be revised! */ //-- end
10706 
10707         return true;
10708 }

virtual bool TeDatabasePortal::getRasterBlock	(	unsigned long &	size,
		unsigned char *	ptData
	)			`[pure virtual]`

Implemented in TeAdoPortal, TeFirebirdPortal, TeMySQLPortal, TeOCIOraclePortal, TePostgreSQLPortal, and TeSQLitePortal.

Referenced by TeDecoderDatabase::getRasterBlock(), and TeDecoderDatabase::getSelectedRasterBlock().

bool TeDatabasePortal::getRasterVisual	(	TeRasterVisual &	vis,
		const unsigned int &	initIndex = `0`
	)			`[virtual]`

Definition at line 10556 of file TeDatabase.cpp.

Referenced by TeDatabase::loadTheme(), TeDatabase::loadThemes(), TeDatabase::loadView(), TeDatabase::loadViewSet(), and loadViewSetAndThemeGroups().

10557 {
10558         string themeId = getData(initIndex);
10559         if(themeId.empty())
10560                 return false;
10561 
10562         vis.setSrcBand(getInt(initIndex+1));
10563         vis.setDestBand(getInt(initIndex+2));
10564         vis.setTransfFunction(static_cast<TeRasterTransform::TeRasterTransfFunctions>(getInt(initIndex+3)));
10565         if (vis.getTransfFunction() == TeRasterTransform::TeExtractRGB || 
10566                 vis.getTransfFunction() == TeRasterTransform::TeExtractBands)
10567         {
10568                 vis.setBChannelMapping(getInt(initIndex+1),static_cast<TeRasterTransform::TeRGBChannels>(getInt(initIndex+2)));
10569         }
10570 
10571         if (vis.getTransfFunction() == TeRasterTransform::TeMono2LUTMonoBand ||
10572                 vis.getTransfFunction() == TeRasterTransform::TeThree2LUTThreeBand)
10573         {
10574                 vis.setBChannelMapping(getInt(initIndex+1),static_cast<TeRasterTransform::TeRGBChannels>(getInt(initIndex+2)));
10575 
10576                 std::string lutName = getData(initIndex+6);
10577 
10578                 if(lutName != vis.getLutTableName())
10579                 {
10580                         vis.setLutTableName(lutName);
10581 
10582                         TeDatabasePortal* portal = this->getDatabase()->getPortal();
10583                         if (!portal)
10584                                 return false;
10585 
10586                         std::string get = "SELECT * FROM " + lutName + " ORDER BY index_id ASC ";
10587 
10588                         if (!portal->query(get) || !portal->fetchRow())  // if there is no table, or table is empty
10589                         {
10590                                 delete portal;
10591                                 return false;
10592                         }
10593 
10594                         do
10595                         {
10596                                 vis.lutr_.push_back(atoi(portal->getData(1)));
10597                                 vis.lutg_.push_back(atoi(portal->getData(2)));
10598                                 vis.lutb_.push_back(atoi(portal->getData(3)));
10599                         }while (portal->fetchRow());
10600 
10601                         vis.setLutSize(vis.lutr_.size());
10602 
10603                         delete portal;
10604                 }
10605         }
10606         
10607         return true;
10608 }

bool TeDatabasePortal::getRepresentation	(	TeRepresentation &	rep,
		const unsigned int &	initIndex = `0`
	)			`[virtual]`

Definition at line 10878 of file TeDatabase.cpp.

References TeRepresentation::box_, TeRepresentation::description_, TeRepresentation::geomRep_, getData(), getDouble(), getInt(), TeRepresentation::id_, TeRepresentation::nCols_, TeRepresentation::nLins_, TeRepresentation::resX_, TeRepresentation::resY_, and TeRepresentation::tableName_.

Referenced by TeDatabase::loadLayer(), and TeDatabase::loadLayerSet().

10879 {
10880         string repId = this->getData(initIndex);
10881         if(repId.empty())
10882                 return false;
10883 
10884         rep.id_ = atoi(repId.c_str());
10885         TeGeomRep g = (TeGeomRep)atoi(this->getData(initIndex+2));
10886         rep.geomRep_ = g;
10887         rep.tableName_ = this->getData(initIndex+3);
10888         rep.description_ = this->getData(initIndex+4);
10889         rep.box_ = TeBox(this->getDouble(initIndex+5),
10890                                 this->getDouble(initIndex+6),
10891                                 this->getDouble(initIndex+7),
10892                                 this->getDouble(initIndex+8));
10893         rep.resX_ = this->getDouble(initIndex+9);
10894         rep.resY_ = this->getDouble(initIndex+10);
10895         rep.nCols_ = this->getInt(initIndex+11);
10896         rep.nLins_ = this->getInt(initIndex+12);
10897         return true;
10898 }

bool TeDatabasePortal::getTheme	(	TeAbstractTheme &	theme,
		const unsigned int &	initIndex = `0`
	)			`[virtual]`

Definition at line 10722 of file TeDatabase.cpp.

References TeAbstractTheme::attributeRest(), getData(), getDouble(), TeViewNode::id(), TeAbstractTheme::maxScale(), TeAbstractTheme::minScale(), TeViewNode::name(), TeViewNode::parentId(), TeViewNode::priority(), TeAbstractTheme::setCreationTime(), TeAbstractTheme::setThemeBox(), TeAbstractTheme::spatialRest(), TeEXTERNALTHEME, TeAbstractTheme::temporalRest(), TeTHEME, TeViewNode::type(), TeViewNode::view(), TeAbstractTheme::visibility(), and TeAbstractTheme::visibleRep().

Referenced by TeDatabase::loadTheme(), TeDatabase::loadThemes(), TeDatabase::loadView(), TeDatabase::loadViewSet(), and loadViewSetAndThemeGroups().

10723 {
10724         string themeId = getData(initIndex);
10725         if(themeId.empty())
10726                 return false;
10727                 
10728         theme.id(atoi(themeId.c_str()));
10729         theme.view (atoi(this->getData (initIndex+2)));
10730         theme.name(string (this->getData(initIndex+3)));
10731         theme.parentId( atoi(this->getData (initIndex+4)));
10732         theme.type ((TeViewNodeType)this->getInt(initIndex+6));
10733         theme.priority(this->getInt(initIndex+5));
10734         theme.minScale (this->getDouble (initIndex+7));
10735         theme.maxScale (this->getDouble (initIndex+8));
10736         theme.attributeRest(string(this->getData (initIndex+9)));
10737         theme.spatialRest(string(this->getData (initIndex+10)));
10738         theme.temporalRest(string(this->getData (initIndex+11)));
10739         theme.visibleRep(atoi(this->getData (initIndex+13)));
10740         theme.visibility(atoi(this->getData (initIndex+14)));
10741         theme.setThemeBox(TeBox(getDouble(initIndex+15), getDouble(initIndex+16), getDouble(initIndex+17), getDouble(initIndex+18)));
10742 
10743         if(theme.type()==TeTHEME)
10744         {
10745                 static_cast<TeTheme&>(theme).collectionTable(string(this->getData (initIndex+12)));
10746                 static_cast<TeTheme&>(theme).collectionAuxTable(static_cast<TeTheme&>(theme).collectionTable() + "_aux");
10747                 static_cast<TeTheme&>(theme).layerId (atoi(this->getData(initIndex+1)));
10748         }
10749         else if(theme.type()==TeEXTERNALTHEME)
10750         {
10751                 static_cast<TeExternalTheme&>(theme).collectionTable(string(this->getData (initIndex+12)));
10752                 static_cast<TeExternalTheme&>(theme).collectionAuxTable(static_cast<TeExternalTheme&>(theme).collectionTable() + "_aux");
10753         }
10754         else if(theme.type()==TeEXTERNALTHEME)
10755         {
10756                 static_cast<TeTheme&>(theme).collectionTable(string(this->getData (initIndex+12)));
10757                 static_cast<TeTheme&>(theme).collectionAuxTable(static_cast<TeTheme&>(theme).collectionTable() + "_aux");
10758         }
10759 
10760         theme.setCreationTime(this->getDate(initIndex+19));
10761 
10762         return true;
10763 }

bool TeDatabasePortal::getView	(	TeView &	view,
		const unsigned int &	initIndex = `0`
	)			`[virtual]`

Definition at line 10619 of file TeDatabase.cpp.

References getBool(), getData(), getDouble(), getInt(), TeView::id(), TeView::isVisible(), TeView::name(), TeView::setCurrentBox(), TeView::setCurrentTheme(), and TeView::user().

Referenced by TeDatabase::loadView(), TeDatabase::loadViewSet(), and loadViewSetAndThemeGroups().

10620 {
10621         string viewId = getData(initIndex);
10622         if(viewId.empty())
10623                 return false;
10624         view.id(atoi(viewId.c_str()));
10625         view.name(getData(initIndex+2));
10626         view.user(getData(initIndex+3));
10627         view.isVisible(getBool(initIndex+4));
10628         view.setCurrentBox(TeBox(getDouble(initIndex+5), getDouble(initIndex+6), getDouble(initIndex+7), getDouble(initIndex+8)));
10629         if( strlen( getData(initIndex+9) ) == 0 )
10630                 view.setCurrentTheme(-1);
10631         else
10632                 view.setCurrentTheme(getInt(initIndex+9));
10633         return true;
10634 }

void TeDatabasePortal::getViewNodeParams	(	TeViewNodeParams &	params,
		const unsigned int &	initIndex = `0`
	)			`[virtual]`

Definition at line 10711 of file TeDatabase.cpp.

References getInt(), TeViewNodeParams::id_, TeViewNodeParams::myParentId_, TeViewNodeParams::name_, TeViewNodeParams::nodeType_, TeViewNodeParams::priority_, and TeViewNodeParams::viewId_.

Referenced by TeDatabase::loadTheme(), and TeDatabase::loadThemes().

10712 {
10713         params.name_ = string (this->getData(initIndex+3));     //name
10714         params.id_ = this->getInt(initIndex);                           // id
10715         params.viewId_ = this->getInt(initIndex+2);                     //view id
10716         params.nodeType_ =      this->getInt(initIndex+6);              //node type
10717         params.priority_ =      this->getInt(initIndex+5);              //priority  
10718         params.myParentId_ = this->getInt(initIndex+4); //parent id
10719 }

TeViewTree * TeDatabasePortal::getViewTree ( ) [virtual]

Definition at line 10375 of file TeDatabase.cpp.

References getData(), TeViewNode::id(), TeViewNode::name(), TeViewNode::parentId(), TeViewNode::priority(), and TeViewNode::type().

Referenced by TeDatabase::loadViewTree().

10376 {
10377         TeViewTree *tree = new TeViewTree();
10378         tree->id (atoi(getData("theme_id")));
10379         tree->name (getData("name"));
10380         tree->priority(atoi(getData("priority")));
10381         //Update the tree also with parent_id and node_type from te_theme table
10382         tree->parentId(atoi(getData("parent_id")));
10383         tree->type(atoi(getData("node_type"))); 
10384         //Is it necessary to set parent??
10385         return tree;
10386 }

bool TeDatabasePortal::getVisual	(	TeVisual *	vis,
		TeGeomRep &	rep,
		const unsigned int &	initIndex
	)			`[virtual]`

Definition at line 10506 of file TeDatabase.cpp.

References TeVisual::alignmentHoriz(), TeVisual::alignmentVert(), TeVisual::bold(), TeVisual::color(), TeVisual::contourColor(), TeVisual::contourStyle(), TeVisual::contourTransparency(), TeVisual::contourWidth(), TeVisual::family(), TeVisual::fixedSize(), getBool(), getData(), getDouble(), TeVisual::italic(), TeVisual::lineSpace(), TeVisual::size(), TeVisual::style(), TeVisual::tabSize(), TeCELLS, TeLINES, TePOINTS, TePOLYGONS, TeTEXT, TeVisual::transparency(), and TeVisual::width().

10507 {
10508         string legendId = this->getData(initIndex);
10509         if(legendId.empty())
10510                 return false;
10511 
10512         rep = (TeGeomRep)atoi (getData(initIndex+1)); //geom_type = 1
10513 
10514         TeColor cor(atoi(getData(initIndex+3)),atoi(getData(initIndex+4)),atoi(getData(initIndex+5)));
10515         vis->color(cor);
10516         vis->transparency(atoi(getData(initIndex+6)));
10517 
10518         TeColor ccor(atoi(getData(initIndex+9)),atoi(getData(initIndex+10)),atoi(getData(initIndex+11)));
10519         vis->contourColor(ccor);
10520         vis->contourWidth(atoi(getData(initIndex+13)));
10521         vis->contourTransparency(atoi(getData(initIndex+12)));
10522 
10523         if(rep == TePOLYGONS || rep == TeCELLS)
10524         {
10525                 vis->contourWidth(atoi(getData(initIndex+13)));
10526                 vis->contourStyle(atoi(getData(initIndex+8)));
10527                 vis->style(atoi(getData(initIndex+2)));
10528         }
10529         else if(rep == TeLINES)
10530         {
10531                 vis->width(atoi(getData(initIndex+7)));
10532                 vis->style(atoi(getData(initIndex+2)));
10533         }
10534         else if(rep == TePOINTS)
10535         {
10536                 vis->size(atoi(getData(initIndex+14)));
10537                 vis->style(atoi(getData(initIndex+2)));
10538         }
10539         else if(rep == TeTEXT)
10540                 vis->size(atoi(getData(initIndex+14)));
10541 
10542         vis->family(getData(initIndex+16));
10543         vis->bold (getBool(initIndex+17));
10544         vis->italic (getBool(initIndex+18));
10545         vis->fixedSize (getBool(initIndex+23));
10546 
10547         vis->alignmentVert(getDouble(initIndex+19));
10548         vis->alignmentHoriz(getDouble(initIndex+20));
10549 
10550         vis->tabSize(atoi(getData(initIndex+21)));
10551         vis->lineSpace(atoi(getData(initIndex+22)));
10552         return true;
10553 }

void TeDatabasePortal::getVisual ( TeVisual * vis ) [virtual]

Definition at line 10409 of file TeDatabase.cpp.

Referenced by TeDatabase::loadLegend(), TeDatabase::loadTheme(), TeDatabase::loadThemes(), TeDatabase::loadView(), TeDatabase::loadViewSet(), and loadViewSetAndThemeGroups().

10410 {
10411         TeGeomRep rep = (TeGeomRep)atoi (getData("geom_type"));
10412 
10413         TeColor cor(atoi(getData("red")),atoi(getData("green")),atoi(getData("blue")));
10414         vis->color(cor);
10415         vis->transparency(atoi(getData("transparency")));
10416 
10417         TeColor ccor(atoi(getData("contour_red")),atoi(getData("contour_green")),atoi(getData("contour_blue")));
10418         vis->contourColor(ccor);
10419         vis->contourWidth(atoi(getData("contour_width")));
10420         vis->contourTransparency(atoi(getData("contour_transp")));
10421 
10422         if(rep == TePOLYGONS || rep == TeCELLS)
10423         {
10424                 vis->contourWidth(atoi(getData("width")));
10425                 vis->contourStyle(atoi(getData("contour_symb_id")));
10426                 vis->style(atoi(getData("symb_id")));
10427         }
10428         else if(rep == TeLINES)
10429         {
10430                 vis->width(atoi(getData("width")));
10431                 vis->style(atoi(getData("symb_id")));
10432         }
10433         else if(rep == TePOINTS)
10434         {
10435                 vis->size(atoi(getData("size_value")));
10436                 vis->style(atoi(getData("symb_id")));
10437         }
10438         else if(rep == TeTEXT)
10439                 vis->size(atoi(getData("size_value")));
10440 
10441         vis->family(getData("family"));
10442         vis->bold (getBool("bold"));
10443         vis->italic (getBool("italic"));
10444         vis->fixedSize (getBool("fixed_size"));
10445 
10446         vis->alignmentVert(getDouble("alignment_vert"));
10447         vis->alignmentHoriz(getDouble("alignment_horiz"));
10448 
10449         vis->tabSize(atoi(getData("tab_size")));
10450         vis->lineSpace(atoi(getData("line_space")));
10451 }

int TeDatabasePortal::numFields ( ) [inline]

Definition at line 1670 of file TeDatabase.h.

Referenced by TeDatabase::loadTable(), TeQtGridSource::reloadPortal(), TeDatabase::selectTable(), TeQtGridSource::setPortal(), TeCopyDatabase(), TeCopyExternThemeToLayer(), TeCopyLayerToLayer(), TeCopyThemeToLayer(), TeExportShapefile(), and updateDB310To311().

01671         { return numFields_; }

int TeDatabasePortal::numRows ( void ) [inline]

Definition at line 1666 of file TeDatabase.h.

Referenced by TeTin::loadTIN(), TeQuerierDBStr3::numElemInstances(), TeQtTable::openSql(), TeQtGridSource::reloadPortal(), TeDecoderDatabase::selectBlocks(), TeQtGridSource::setPortal(), TeCopyDatabase(), TeCopyPortalGeometriesToLayer(), and TeCopyThemeToLayer().

01667         { return numRows_;}

virtual bool TeDatabasePortal::query	(	const string &	qry,
		TeCursorLocation	l = `TeSERVERSIDE`,
		TeCursorType	t = `TeUNIDIRECTIONAL`,
		TeCursorEditType	e = `TeREADONLY`,
		TeCursorDataType	dt = `TeTEXTCURSOR`
	)			`[pure virtual]`