#include <ossimGpkgNsgTileMatrixExtentRecord.h>

Inheritance diagram for ossimGpkgNsgTileMatrixExtentRecord:

Public Member Functions
	ossimGpkgNsgTileMatrixExtentRecord ()
	default constructor More...

	ossimGpkgNsgTileMatrixExtentRecord (const ossimGpkgNsgTileMatrixExtentRecord &obj)

const ossimGpkgNsgTileMatrixExtentRecord &	operator= (const ossimGpkgNsgTileMatrixExtentRecord &obj)

virtual	~ossimGpkgNsgTileMatrixExtentRecord ()
	destructor More...

virtual bool	init (sqlite3_stmt *pStmt)
	Initialize from database. More...

bool	init (const std::string &tableName, ossim_int32 zoom_level, const ossimIrect &imageRect, const ossimDrect &projectionRect)
	Initialize from projection. More...

bool	insert (sqlite3 *db)
	Inserst this record into gpkg_spatial_ref_sys table. More...

virtual void	saveState (ossimKeywordlist &kwl, const std::string &prefix) const
	Saves the state of object. More...

Public Member Functions inherited from ossimGpkgDatabaseRecordBase
	ossimGpkgDatabaseRecordBase ()
	default constructor More...

virtual	~ossimGpkgDatabaseRecordBase ()
	virtual destructor. More...

virtual std::ostream &	print (std::ostream &out) const
	Print method. More...

Public Member Functions inherited from ossimReferenced
	ossimReferenced ()

	ossimReferenced (const ossimReferenced &)

ossimReferenced &	operator= (const ossimReferenced &)

void	ref () const
	increment the reference count by one, indicating that this object has another pointer which is referencing it. More...

void	unref () const
	decrement the reference count by one, indicating that a pointer to this object is referencing it. More...

void	unref_nodelete () const
	decrement the reference count by one, indicating that a pointer to this object is referencing it. More...

int	referenceCount () const

Static Public Member Functions
static const std::string &	getTableName ()
	Get the table name "nsg_tile_matrix_extent". More...

static bool	createTable (sqlite3 *db)
	Creates table in database. More...

Public Attributes
std::string	m_table_name

ossim_int32	m_zoom_level

std::string	m_extent_type
	“complete”,”missing”,“present”,”absent”,”mixed” More...

ossim_int32	m_min_column

ossim_int32	m_min_row

ossim_int32	m_max_column

ossim_int32	m_max_row

ossim_float64	m_min_x

ossim_float64	m_min_y

ossim_float64	m_max_x

ossim_float64	m_max_y

Additional Inherited Members
Protected Member Functions inherited from ossimReferenced
virtual	~ossimReferenced ()

Detailed Description

Definition at line 24 of file ossimGpkgNsgTileMatrixExtentRecord.h.

Constructor & Destructor Documentation

◆ ossimGpkgNsgTileMatrixExtentRecord() [1/2]

ossimGpkgNsgTileMatrixExtentRecord::ossimGpkgNsgTileMatrixExtentRecord ( )

default constructor

Definition at line 27 of file ossimGpkgNsgTileMatrixExtentRecord.cpp.

    :
    ossimGpkgDatabaseRecordBase(),   
    m_table_name(),
    m_zoom_level(0),
    m_extent_type(),
    m_min_column(0),
    m_min_row(0),
    m_max_column(0),
    m_max_row(0),
    m_min_x(ossim::nan()),
    m_min_y(ossim::nan()),
    m_max_x(ossim::nan()),
    m_max_y(ossim::nan())
 {
 }

◆ ossimGpkgNsgTileMatrixExtentRecord() [2/2]

ossimGpkgNsgTileMatrixExtentRecord::ossimGpkgNsgTileMatrixExtentRecord ( const ossimGpkgNsgTileMatrixExtentRecord & obj )

Definition at line 44 of file ossimGpkgNsgTileMatrixExtentRecord.cpp.

    :
    ossimGpkgDatabaseRecordBase(),
    m_table_name(obj.m_table_name),
    m_zoom_level(obj.m_zoom_level),
    m_extent_type(obj.m_extent_type),
    m_min_column(obj.m_min_column),
    m_min_row(obj.m_min_row),
    m_max_column(obj.m_max_column),
    m_max_row(obj.m_max_row),   
    m_min_x(obj.m_min_x),
    m_min_y(obj.m_min_y),
    m_max_x(obj.m_max_x),
    m_max_y(obj.m_max_y)
 {
 }

◆ ~ossimGpkgNsgTileMatrixExtentRecord()

ossimGpkgNsgTileMatrixExtentRecord::~ossimGpkgNsgTileMatrixExtentRecord ( )

virtual

destructor

Definition at line 82 of file ossimGpkgNsgTileMatrixExtentRecord.cpp.

83 {

84 }

Member Function Documentation

◆ createTable()

bool ossimGpkgNsgTileMatrixExtentRecord::createTable ( sqlite3 * db )

static

Creates table in database.

Parameters

db

Returns: true on success, false on error.

Definition at line 230 of file ossimGpkgNsgTileMatrixExtentRecord.cpp.

References status, and ossim_sqlite::tableExists().

Referenced by ossimGpkgWriter::createTables().

 {
    bool status = false;
    if ( db )
    {
       status = ossim_sqlite::tableExists( db, TABLE_NAME );
       if ( !status )
       {
          std::ostringstream sql;
          sql << "CREATE TABLE " << TABLE_NAME << " ( "
              << "table_name TEXT NOT NULL, "
              << "zoom_level INTEGER NOT NULL, "
              << "extent_type TEXT NOT NULL, "
              << "min_column INTEGER NOT NULL, "
              << "min_row INTEGER NOT NULL, "         
              << "max_column INTEGER NOT NULL, "
              << "max_row INTEGER NOT NULL, "         
              << "min_x DOUBLE NOT NULL, "
              << "min_y DOUBLE NOT NULL, "
              << "max_x DOUBLE NOT NULL, "
              << "max_y DOUBLE NOT NULL, "
              << "CONSTRAINT pk_ntme PRIMARY KEY (table_name, zoom_level, extent_type, min_column, min_row, max_column, max_row), "
              << "CONSTRAINT fk_ntme FOREIGN KEY (table_name, zoom_level) "
              << "REFERENCES gpkg_tile_matrix(table_name, zoom_level)"
              << ")";
          
          if ( ossim_sqlite::exec( db, sql.str() ) == SQLITE_DONE )
          {
             status = true;
          }
       }
    }
    return status;
 }

◆ getTableName()

const std::string & ossimGpkgNsgTileMatrixExtentRecord::getTableName ( )

static

Get the table name "nsg_tile_matrix_extent".

Returns: table name

Definition at line 86 of file ossimGpkgNsgTileMatrixExtentRecord.cpp.

Referenced by ossim_gpkg::getNewTableRecord(), ossim_gpkg::getTileEntries(), and ossim_gpkg::getTileEntry().

 {
    return TABLE_NAME;
 }

◆ init() [1/2]

bool ossimGpkgNsgTileMatrixExtentRecord::init ( sqlite3_stmt * pStmt )

virtual

Initialize from database.

Parameters

pStmt SQL statement, i.e. result of sqlite3_prepare_v2(...) call.

Implements ossimGpkgDatabaseRecordBase.

Definition at line 91 of file ossimGpkgNsgTileMatrixExtentRecord.cpp.

References m_extent_type, m_max_column, m_max_row, m_max_x, m_max_y, m_min_column, m_min_row, m_min_x, m_min_y, m_table_name, m_zoom_level, ossimNotify(), ossimNotifyLevel_WARN, and status.

 {
    static const char M[] = "ossimGpkgNsgTileMatrixExtentRecord::init";
    
    bool status = false;
 
    if ( pStmt )
    {
       const ossim_int32 EXPECTED_COLUMNS = 11;
       ossim_int32 nCol = sqlite3_column_count( pStmt );
       
       if ( nCol != EXPECTED_COLUMNS )
       {
          ossimNotify(ossimNotifyLevel_WARN)
             << M << " WARNING:\nUnexpected number of columns: " << nCol
             << "Expected column count: " << EXPECTED_COLUMNS
             << std::endl;
       }
       
       if ( nCol >= EXPECTED_COLUMNS )
       {
          ossim_int32 columnsFound = 0;
          std::string colName;
          ossim_int32 type;
          
          const char* c = 0; // To catch null so not to pass to string.
          
          for ( ossim_int32 i = 0; i < nCol; ++i )
          {
             colName = sqlite3_column_name(pStmt, i);
             type    = sqlite3_column_type(pStmt, i);
             if ( colName.size() )
             {
                if ( colName == "table_name" )
                {
                   c = (const char*)sqlite3_column_text(pStmt, i);
                   m_table_name = (c ? c : "");
                   ++columnsFound;
                }
                else if ( ( colName == "zoom_level" ) && ( type == SQLITE_INTEGER ) )
                {
                   m_zoom_level = sqlite3_column_int(pStmt, i);
                   ++columnsFound;
                }
                else if ( colName == "extent_type" )
                {
                   c = (const char*)sqlite3_column_text(pStmt, i);
                   m_extent_type = (c ? c : "");
                   ++columnsFound;
                }
                else if ( ( colName == "min_column" ) && ( type == SQLITE_INTEGER ) )
                {
                   m_min_column = sqlite3_column_int(pStmt, i);
                   ++columnsFound;
                }
                else if ( ( colName == "min_row" ) && ( type == SQLITE_INTEGER ) )
                {
                   m_min_row = sqlite3_column_int(pStmt, i);
                   ++columnsFound;
                }
                else if ( ( colName == "max_column" ) && ( type == SQLITE_INTEGER ) )
                {
                   m_max_column = sqlite3_column_int(pStmt, i);
                   ++columnsFound;
                }
                else if ( ( colName == "max_row" ) && ( type == SQLITE_INTEGER ) )
                {
                   m_max_row = sqlite3_column_int(pStmt, i);
                   ++columnsFound;
                }
                else if ( ( colName == "min_x" ) && ( type == SQLITE_FLOAT ) )
                {
                   m_min_x = sqlite3_column_double(pStmt, i);
                   ++columnsFound;
                }
                else if ( ( colName == "min_y" ) && ( type == SQLITE_FLOAT ) )
                {
                   m_min_y = sqlite3_column_double(pStmt, i);
                   ++columnsFound;
                }
                else if ( ( colName == "max_x" ) && ( type == SQLITE_FLOAT ) ) 
                {
                   m_max_x = sqlite3_column_double(pStmt, i);
                   ++columnsFound;
                }
                else if ( colName == "max_y" )
                {
                   m_max_y = sqlite3_column_double(pStmt, i);
                   ++columnsFound;
                }
                else
                {
                   ossimNotify(ossimNotifyLevel_WARN)
                      << M << " Unhandled column name["
                      << i << "]: " << colName << std::endl;
                }
                
             } // Matches: if ( colName.size() )
             
             if ( columnsFound == EXPECTED_COLUMNS )
             {
                status = true;
                break;
             }
             
          } // Matches: for ( int i = 0; i < nCol; ++i )  
       }
       
    } // Matches: if ( pStmt )
    
    return status;
    
 } // End:  ossimGpkgNsgTileMatrixExtentRecord::init( pStmt )

◆ init() [2/2]

bool ossimGpkgNsgTileMatrixExtentRecord::init	(	const std::string &	tableName,
		ossim_int32	zoom_level,
		const ossimIrect &	imageRect,
		const ossimDrect &	projectionRect
	)

Initialize from projection.

Parameters

tableName	e.g. "tiles"
zoom_level
imageRect
projectionRect	Edge to edge either Easting Northin or lat lon.

Returns: true on success, false on error.

Definition at line 205 of file ossimGpkgNsgTileMatrixExtentRecord.cpp.

References ossimIrect::hasNans(), ossimDrect::hasNans(), ossimDrect::ll(), ossimIrect::lr(), m_extent_type, m_max_column, m_max_row, m_max_x, m_max_y, m_min_column, m_min_row, m_min_x, m_min_y, m_table_name, m_zoom_level, status, ossimIrect::ul(), ossimDrect::ur(), ossimIpt::x, ossimDpt::x, ossimIpt::y, and ossimDpt::y.

 {
    bool status = false;
    if ( (imageRect.hasNans() == false) && (projectionRect.hasNans() == false) )
    {
       m_table_name  = tableName;
       m_zoom_level  = zoom_level;
       m_extent_type = "complete";
       m_min_column  = imageRect.ul().x;
       m_min_row     = imageRect.ul().y;
       m_max_column  = imageRect.lr().x;
       m_max_row     = imageRect.lr().y;
       m_min_x       = projectionRect.ll().x;
       m_min_y       = projectionRect.ll().y;
       m_max_x       = projectionRect.ur().x;
       m_max_y       = projectionRect.ur().y;
 
       status = true;
    }
    return status;
 }

◆ insert()

bool ossimGpkgNsgTileMatrixExtentRecord::insert ( sqlite3 * db )

Inserst this record into gpkg_spatial_ref_sys table.

Parameters

db

Returns: true on success, false on error.

Definition at line 265 of file ossimGpkgNsgTileMatrixExtentRecord.cpp.

References ossim_sqlite::exec(), m_extent_type, m_max_column, m_max_row, m_max_x, m_max_y, m_min_column, m_min_row, m_min_x, m_min_y, m_table_name, m_zoom_level, and status.

 {
    bool status = false;
    if ( db )
    {
       std::ostringstream sql;
       sql << "INSERT INTO nsg_tile_matrix_extent VALUES ( "
           <<  "'" << m_table_name  << "', "
           << m_zoom_level  << ", "
           <<  "'" << m_extent_type << "', "
           << m_min_column  << ", "
           << m_min_row     << ", "
           << m_max_column  << ", "
           << m_max_row     << ", "
           << std::setprecision(16)
           << m_min_x << ", "
           << m_min_y << ", " 
           << m_max_x << ", "
           << m_max_y
           << " )";
 
       if ( ossim_sqlite::exec( db, sql.str() ) == SQLITE_DONE )
       {
          status = true;
       }
    }
    return status;
 }

◆ operator=()

const ossimGpkgNsgTileMatrixExtentRecord & ossimGpkgNsgTileMatrixExtentRecord::operator= ( const ossimGpkgNsgTileMatrixExtentRecord & obj )

Definition at line 62 of file ossimGpkgNsgTileMatrixExtentRecord.cpp.

References m_extent_type, m_max_column, m_max_row, m_max_x, m_max_y, m_min_column, m_min_row, m_min_x, m_min_y, m_table_name, and m_zoom_level.

 {
    if ( this != &obj )
    {
       m_table_name  = obj.m_table_name;
       m_zoom_level  = obj.m_zoom_level;
       m_extent_type = obj.m_extent_type;
       m_min_column  = obj.m_min_column;
       m_min_row     = obj.m_min_row;      
       m_max_column  = obj.m_max_column;
       m_max_row     = obj.m_max_row;
       m_min_x       = obj.m_min_x;
       m_min_y       = obj.m_min_y;
       m_max_x       = obj.m_max_x;
       m_max_y       = obj.m_max_y;
    }
    return *this;
 }

◆ saveState()

void ossimGpkgNsgTileMatrixExtentRecord::saveState	(	ossimKeywordlist &	kwl,
		const std::string &	prefix
	)		const

virtual

Saves the state of object.

Parameters

kwl	Initialized by this.
prefix	e.g. "image0.". Can be empty.

Implements ossimGpkgDatabaseRecordBase.

Definition at line 294 of file ossimGpkgNsgTileMatrixExtentRecord.cpp.

References ossimKeywordlist::addPair(), m_extent_type, m_max_column, m_max_row, m_max_x, m_max_y, m_min_column, m_min_row, m_min_x, m_min_y, m_table_name, m_zoom_level, ossimString::string(), and ossimString::toString().

 {
    std::string myPref = prefix.size() ? prefix : std::string("nsg_tile_matrix_extent.");
    std::string value;
    
    std::string key = "table_name";
    kwl.addPair(myPref, key, m_table_name, true);
 
    key = "zoom_level";
    value = ossimString::toString(m_zoom_level).string();
    kwl.addPair(myPref, key, value, true);
 
    key = "extent_type";
    kwl.addPair(myPref, key, m_extent_type, true);
    
    key = "min_column";
    value = ossimString::toString(m_min_column).string();
    kwl.addPair(myPref, key, value, true);
 
    key = "min_row";
    value = ossimString::toString(m_min_row).string();
    kwl.addPair(myPref, key, value, true);
 
    key = "max_column";
    value = ossimString::toString(m_max_column).string();
    kwl.addPair(myPref, key, value, true);
 
    key = "max_row";
    value = ossimString::toString(m_max_row).string();
    kwl.addPair(myPref, key, value, true);
 
    key = "min_x";
    value = ossimString::toString(m_min_x, 20).string();
    kwl.addPair(myPref, key, value, true);
 
    key = "min_y";
    value = ossimString::toString(m_min_y, 20).string();
    kwl.addPair(myPref, key, value, true);
 
    key = "max_x";
    value = ossimString::toString(m_max_x, 20).string();
    kwl.addPair(myPref, key, value, true);
 
    key = "max_y";
    value = ossimString::toString(m_max_y, 20).string();
    kwl.addPair(myPref, key, value, true);
 }