ossim_sqlite Namespace Reference

Functions
int	exec (sqlite3 *db, const std::string &sql)
	Preforms sqlite3_prepare_v2, sqlite3_step and sqlite3_finalize. More...
bool	tableExists (sqlite3 *db, const std::string &tableName)
	Checks for existance of table. More...
void	warn (const std::string &module, const std::string &columnName, ossim_int32 columnIndex, ossim_int32 type)
	Outputs formated warning message. More...
void	getTime (std::string &result)
	Gets time in the form of "%Y-%m-%dT%H:%M:%S.000Z". More...

Function Documentation

exec()

int ossim_sqlite::exec	(	sqlite3 *	db,
		const std::string &	sql
	)

Preforms sqlite3_prepare_v2, sqlite3_step and sqlite3_finalize.

Parameters

db
sql

Returns

return code of last command executed. Typically this is the return of sqlite3_step but could be return of sqlite3_prepare_v2 if it had an error, i.e. return is not SQLITE_OK.

Definition at line 22 of file ossimSqliteUtil.cpp.

Referenced by ossimGpkgTileRecord::createTable(), ossimGpkgNsgTileMatrixExtentRecord::insert(), ossimGpkgTileMatrixSetRecord::insert(), ossimGpkgContentsRecord::insert(), ossimGpkgSpatialRefSysRecord::insert(), and ossimGpkgTileMatrixRecord::insert().

{
   int rc = SQLITE_ERROR;
   if ( db && sql.size() )
   {
      if (traceDebug())
      {
         ossimNotify(ossimNotifyLevel_DEBUG)
            << "sql:\n" << sql << "\n";
      }

      sqlite3_stmt* pStmt = 0; // The current SQL statement

      rc = sqlite3_prepare_v2(db,          // Database handle
                              sql.c_str(), // SQL statement, UTF-8 encoded
                              -1,          // Maximum length of zSql in bytes.
                              &pStmt,      // OUT: Statement handle
                              NULL);
      if ( rc == SQLITE_OK )
      {
         rc = sqlite3_step(pStmt);
      }
      else
      {
         ossimNotify(ossimNotifyLevel_WARN)
            << "ossim_sqlite::exec error: " << sqlite3_errmsg(db) << std::endl;
      }
      
      sqlite3_finalize(pStmt);
   }
   return rc;
}

getTime()

void ossim_sqlite::getTime

(

std::string &

result

)

Gets time in the form of "%Y-%m-%dT%H:%M:%S.000Z".

e.g. 2015-02-10T19:32:15.000Z

Parameters

result

Initialized by this.

Definition at line 96 of file ossimSqliteUtil.cpp.

Referenced by ossimGpkgContentsRecord::init().

{
   timeMutex.lock();
   
   time_t rawTime;
   time(&rawTime);
   
   struct tm* timeInfo = gmtime(&rawTime);

   size_t size = 0;
   if ( timeInfo )
   {
      const size_t STRING_SIZE = 25;
      char outStr[STRING_SIZE];

      size = strftime(outStr, STRING_SIZE, "%Y-%m-%dT%H:%M:%S.000Z", timeInfo );
      if ( size )
      {
         // Per strftime spec not needed but null terminating anyway.
         outStr[STRING_SIZE-1] = '\0';
         result = outStr;
      }
   }
   if ( !size )
   {
      result.clear();
   }

   timeMutex.unlock();
}

tableExists()

bool ossim_sqlite::tableExists	(	sqlite3 *	db,
		const std::string &	tableName
	)

Checks for existance of table.

Parameters

db	An open database.
tableName	e.g. "gpkg_contents"

Returns

true on success, false on error.

Definition at line 55 of file ossimSqliteUtil.cpp.

References status.

Referenced by ossimGpkgTileRecord::createTable(), ossimGpkgNsgTileMatrixExtentRecord::createTable(), ossimGpkgTileMatrixSetRecord::createTable(), ossimGpkgContentsRecord::createTable(), ossimGpkgSpatialRefSysRecord::createTable(), and ossimGpkgTileMatrixRecord::createTable().

{
   bool status = false;
   
   if ( db && tableName.size() )
   {
      const char *zLeftover;      /* Tail of unprocessed SQL */
      sqlite3_stmt *pStmt = 0;    /* The current SQL statement */
      std::string sql = "SELECT * from ";
      sql += tableName;

      int rc = sqlite3_prepare_v2(db,           // Database handle
                                  sql.c_str(),  // SQL statement, UTF-8 encoded
                                  -1,           // Maximum length of zSql in bytes.
                                  &pStmt,       // OUT: Statement handle
                                  &zLeftover);  // OUT: Pointer to unused portion of zSql
      if ( rc == SQLITE_OK )
      {
         int nCol = sqlite3_column_count( pStmt );
         if ( nCol )
         {
            status = true;
         }
      }
      sqlite3_finalize(pStmt);
   }
   
   return status;
   
} // End: ossim_sqlite::tableExists(...)

warn()

void ossim_sqlite::warn	(	const std::string &	module,
		const std::string &	columnName,
		ossim_int32	columnIndex,
		ossim_int32	type
	)

Outputs formated warning message.

Parameters

module	e.g. "ossimGpkgNsgTileMatrixSetRecord::init"
columnName	e.g. "zoom_level", from sqlite3_column_name(...)
columnIndex	zero based column index.
type	Type from sqlite3_column_type(...)

Definition at line 86 of file ossimSqliteUtil.cpp.

References ossimNotify(), and ossimNotifyLevel_WARN.

{
   ossimNotify(ossimNotifyLevel_WARN)
      << module << " Unexpected column name or type[" << columnIndex << "]: "
      << "name: " << columnName << " type: " << type << std::endl;
}