#include <ossimGpkgContentsRecord.h>

Inheritance diagram for ossimGpkgContentsRecord:

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

	ossimGpkgContentsRecord (const ossimGpkgContentsRecord &obj)

const ossimGpkgContentsRecord &	operator= (const ossimGpkgContentsRecord &copy_this)

virtual	~ossimGpkgContentsRecord ()
	destructor More...

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

bool	init (const std::string &tableName, ossim_int32 srs_id, const ossimDpt &minPt, const ossimDpt &maxPt)
	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 to keyword list. 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 "gpkg_contents". More...

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

Public Attributes
std::string	m_table_name

std::string	m_data_type

std::string	m_identifier

std::string	m_description

std::string	m_last_change

ossim_float64	m_min_x

ossim_float64	m_min_y

ossim_float64	m_max_x

ossim_float64	m_max_y

ossim_int32	m_srs_id

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

Detailed Description

Definition at line 24 of file ossimGpkgContentsRecord.h.

Constructor & Destructor Documentation

◆ ossimGpkgContentsRecord() [1/2]

ossimGpkgContentsRecord::ossimGpkgContentsRecord ( )

default constructor

Definition at line 25 of file ossimGpkgContentsRecord.cpp.

    :
    ossimGpkgDatabaseRecordBase(),
    m_table_name(),
    m_data_type(),
    m_identifier(),
    m_description(),
    m_last_change(),
    m_min_x(ossim::nan()),
    m_min_y(ossim::nan()),
    m_max_x(ossim::nan()),
    m_max_y(ossim::nan()),
    m_srs_id(0)
 {
 }

◆ ossimGpkgContentsRecord() [2/2]

ossimGpkgContentsRecord::ossimGpkgContentsRecord ( const ossimGpkgContentsRecord & obj )

Definition at line 41 of file ossimGpkgContentsRecord.cpp.

    :
    ossimGpkgDatabaseRecordBase(),
    m_table_name(obj.m_table_name),
    m_data_type(obj.m_data_type),
    m_identifier(obj.m_identifier),
    m_description(obj.m_description),
    m_last_change(obj.m_last_change),
    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),
    m_srs_id(obj.m_srs_id)
 {
 }

◆ ~ossimGpkgContentsRecord()

ossimGpkgContentsRecord::~ossimGpkgContentsRecord ( )

virtual

destructor

Definition at line 76 of file ossimGpkgContentsRecord.cpp.

77 {

78 }

Member Function Documentation

◆ createTable()

bool ossimGpkgContentsRecord::createTable ( sqlite3 * db )

static

Creates table in database.

Parameters

db

Returns: true on success, false on error.

Definition at line 219 of file ossimGpkgContentsRecord.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 PRIMARY KEY, "
              << "data_type TEXT NOT NULL, "
              << "identifier TEXT UNIQUE, "
              << "description TEXT DEFAULT \"\", "
 
             //---
             // Requirement 13:
             // Note: Spec changed to %fZ.  No %f on linux but sqlite library handles.
             // << "last_change DATETIME NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ','now')), "
             //---
              << "last_change DATETIME NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')), "
              << "min_x DOUBLE, "
              << "min_y DOUBLE, "
              << "max_x DOUBLE, "
              << "max_y DOUBLE, "
              << "srs_id INTEGER, "
              << "CONSTRAINT fk_gc_r_srs_id FOREIGN KEY (srs_id) "
              << "REFERENCES gpkg_spatial_ref_sys(srs_id)"
              << ")";
          
          if ( ossim_sqlite::exec( db, sql.str() ) == SQLITE_DONE )
          {
             status = true;
          }
       }
    }
    return status;
 }

◆ getTableName()

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

static

Get the table name "gpkg_contents".

Returns: table name

Definition at line 80 of file ossimGpkgContentsRecord.cpp.

Referenced by ossim_gpkg::getNewTableRecord().

 {
    return TABLE_NAME;
 }

◆ init() [1/2]

bool ossimGpkgContentsRecord::init ( sqlite3_stmt * pStmt )

virtual

Initialize from database.

Parameters

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

Returns: true on success, false on error.

Implements ossimGpkgDatabaseRecordBase.

Definition at line 85 of file ossimGpkgContentsRecord.cpp.

References m_data_type, m_description, m_identifier, m_last_change, m_max_x, m_max_y, m_min_x, m_min_y, m_srs_id, m_table_name, ossimNotify(), ossimNotifyLevel_WARN, and status.

Referenced by ossimGpkgWriter::writeGpkgContentsTable().

 {
    static const char M[] = "ossimGpkgContentsRecord::init";
    
    bool status = false;
 
    if ( pStmt )
    {
       const ossim_int32 EXPECTED_COLUMNS = 10;
       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;
          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);
             if ( colName.size() )
             {
                if ( colName == "table_name" )
                {
                   c = (const char*)sqlite3_column_text(pStmt, i);
                   m_table_name = (c ? c : "");
                   ++columnsFound;
                }
                else if ( colName == "data_type" )
                {
                   c = (const char*)sqlite3_column_text(pStmt, i);
                   m_data_type = (c ? c : "");
                   ++columnsFound;
                }
                else if ( colName == "identifier" )
                {
                   c = (const char*)sqlite3_column_text(pStmt, i);
                   m_identifier = (c ? c : "");
                   ++columnsFound;
                }
                else if ( colName == "description" )
                {
                   c = (const char*)sqlite3_column_text(pStmt, i);
                   m_description = (c ? c : "");
                   ++columnsFound;
                }
                else if ( colName == "last_change" )
                {
                   c = (const char*)sqlite3_column_text(pStmt, i);
                   m_last_change = (c ? c : "");
                   ++columnsFound;
                }
                else if ( colName == "min_x" )
                {
                   m_min_x = sqlite3_column_double(pStmt, i);
                   ++columnsFound;
                }
                else if ( colName == "min_y" )
                {
                   m_min_y = sqlite3_column_double(pStmt, i);
                   ++columnsFound;
                }
                else if ( colName == "max_x" )
                {
                   m_max_x = sqlite3_column_double(pStmt, i);
                   ++columnsFound;
                }
                else if ( colName == "max_y" )
                {
                   m_max_y = sqlite3_column_double(pStmt, i);
                   ++columnsFound;
                }
                else if ( colName == "srs_id" )
                {
                   m_srs_id = sqlite3_column_int(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 ( ossim_int32 i = 0; i < nCol; ++i )  
       }
       
    } // Matches: if ( pStmt )
    
    return status;
    
 } // End: ossimGpkgContentsRecord::init( sqlite3_stmt* pStmt )

◆ init() [2/2]

bool ossimGpkgContentsRecord::init	(	const std::string &	tableName,
		ossim_int32	srs_id,
		const ossimDpt &	minPt,
		const ossimDpt &	maxPt
	)

Initialize from projection.

Parameters

tableName	e.g. "tiles"
srs_id	ID of gpkg_spatial_ref_sys record our projection is relative to.
minPt	Minimum bounds in either Easting Northin or lat lon.
maxPt	Maximum bounds in either Easting Northin or lat lon. *

Returns: true on success, false on error.

Definition at line 194 of file ossimGpkgContentsRecord.cpp.

References ossim_sqlite::getTime(), ossimDpt::hasNans(), m_data_type, m_description, m_identifier, m_last_change, m_max_x, m_max_y, m_min_x, m_min_y, m_srs_id, m_table_name, status, ossimDpt::x, and ossimDpt::y.

 {
    bool status = false;
    if ( (minPt.hasNans() == false) && (maxPt.hasNans() == false) )
    {
       m_table_name  = tableName;
       m_data_type   = "tiles";
       m_identifier  = "Raster Tiles for ";
       m_identifier  += tableName;
       m_description = "Create by ossim gpkg writer.";
       
       ossim_sqlite::getTime( m_last_change );
 
       m_min_x  = minPt.x;
       m_min_y  = minPt.y;
       m_max_x  = maxPt.x;
       m_max_y  = maxPt.y;
       m_srs_id = srs_id;
       status   = true;
    }
    return status;
 }

◆ insert()

bool ossimGpkgContentsRecord::insert ( sqlite3 * db )

Inserst this record into gpkg_spatial_ref_sys table.

Parameters

db

Returns: true on success, false on error.

Definition at line 259 of file ossimGpkgContentsRecord.cpp.

References ossim_sqlite::exec(), m_data_type, m_description, m_identifier, m_last_change, m_max_x, m_max_y, m_min_x, m_min_y, m_srs_id, m_table_name, and status.

Referenced by ossimGpkgWriter::writeGpkgContentsTable().

 {
    bool status = false;
    if ( db )
    {
       std::ostringstream sql;
       sql << "INSERT INTO gpkg_contents VALUES ( "
           <<  "'" << m_table_name << "', "
           <<  "'" << m_data_type << "', "
           <<  "'" << m_identifier << "', "
           <<  "'" << m_description << "', "
           <<  "'" << m_last_change << "', "
           << std::setprecision(16)
           << m_min_x << ", "
           << m_min_y << ", "
           << m_max_x << ", "
           << m_max_y << ", "
           << m_srs_id
           << " )";
 
       if ( ossim_sqlite::exec( db, sql.str() ) == SQLITE_DONE )
       {
          status = true;
       }    
    }
    return status;
 }

◆ operator=()

const ossimGpkgContentsRecord & ossimGpkgContentsRecord::operator= ( const ossimGpkgContentsRecord & copy_this )

Definition at line 57 of file ossimGpkgContentsRecord.cpp.

References m_data_type, m_description, m_identifier, m_last_change, m_max_x, m_max_y, m_min_x, m_min_y, m_srs_id, and m_table_name.

 {
    if ( this != &copy_this )
    {
       m_table_name = copy_this.m_table_name;
       m_data_type = copy_this.m_data_type;
       m_identifier = copy_this.m_identifier;
       m_description = copy_this.m_description;
       m_last_change = copy_this.m_last_change;
       m_min_x = copy_this.m_min_x;
       m_min_y = copy_this.m_min_y;
       m_max_x = copy_this.m_max_x;
       m_max_y = copy_this.m_max_y;
       m_srs_id = copy_this.m_srs_id;
    }
    return *this;
 }

◆ saveState()

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

virtual

Saves the state of object to keyword list.

Parameters

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

Implements ossimGpkgDatabaseRecordBase.

Definition at line 287 of file ossimGpkgContentsRecord.cpp.

References ossimKeywordlist::addPair(), m_data_type, m_description, m_identifier, m_last_change, m_max_x, m_max_y, m_min_x, m_min_y, m_srs_id, m_table_name, ossimString::string(), and ossimString::toString().

 {
    std::string myPref = prefix.size() ? prefix : std::string("gpkg_contents.");
    std::string value;
    
    std::string key = "table_name";
    kwl.addPair(myPref, key, m_table_name, true);
 
    key = "data_type";
    kwl.addPair(myPref, key, m_data_type, true);
    
    key = "identifier";
    kwl.addPair(myPref, key, m_identifier, true);
    
    key = "description";
    kwl.addPair(myPref, key, m_description, true);
 
    key = "last_change";
    kwl.addPair(myPref, key, m_last_change, true);
 
    key = "min_x";
    value = ossimString::toString(m_min_x, 15).string();
    kwl.addPair(myPref, key, value, true);
 
    key = "min_y";
    value = ossimString::toString(m_min_y, 15).string();
    kwl.addPair(myPref, key, value, true);
 
    key = "max_x";
    value = ossimString::toString(m_max_x, 15).string();
    kwl.addPair(myPref, key, value, true);
 
    key = "max_y";
    value = ossimString::toString(m_max_y, 15).string();
    kwl.addPair(myPref, key, value, true);
 
    key = "srs_id";
    value = ossimString::toString(m_srs_id).string();
    kwl.addPair(myPref, key, value, true);
 }