DatabaseSpatialite.h

Go to the documentation of this file.

#ifndef DATABASESPATIALITE_H
#define DATABASESPATIALITE_H

#include <memory>
#include <vector>
#include <unordered_map>
#include <map>
#include <string>
#include <regex>

#include <sqlite3.h>
#include <spatialite.h>

#include "Callback.h"
#include "DatabaseErrors.h"
#include "Raster.h"
#include "DatabaseTable.h"
#include "DatabaseStatements.h"
#include "SegmentationParameters.h"


namespace {
    int exec_callback(void* data, int columns, char** values, char** names);
}

namespace agroeye {
namespace handlers {

using SqliteCallback = std::function<int(int, char**, char**)>;
using agroeye::general::CallbackFunction;
using agroeye::general::CallbackTypes;
using agroeye::handlers::Raster;
using agroeye::operations::Parameters;  
using agroeye::operations::StatisticsTypes;
using agroeye::operations::BandsList;

class Spatialite {
public:
    Spatialite(); 
    Spatialite(const char* path, bool create = false);
    Spatialite(const char* path, CallbackFunction callbackFunc, bool create = false);             
    Spatialite(const Spatialite& other);
    Spatialite(Spatialite&& other);
    Spatialite& operator=(const Spatialite& other);
    Spatialite& operator=(Spatialite&& other);
    virtual ~Spatialite();
    
    void exec(const char* query);  
    
    void exec(const char* query, bool silent);  
    
    void exec(const char* query, SqliteCallback callback);
    std::string getPath() const {return path;}; 
    void optimize(); 
    PreparedStatement createTables(std::string name, Raster raster, Parameters parameters);
    
    std::string proj4ToSrid(std::string proj4);
        
private:
    std::string path;
    CallbackFunction callbackFunc;
    std::shared_ptr<sqlite3> ptrSql3 {nullptr};
    
    void checkResult(const int returnCode) const;    
    DbTable createGeometryTable(Raster raster, std::string name);
    std::vector<std::pair<StatisticsTypes, DbTable>> createParametersTables(Parameters parameters, std::string prefix);
    DbTable createTotalView(DbTable source, std::vector<DbTable> joins);
    void createIndex(const DbTable& table);
};

} // namespace handlers
} // namespace agroeye

#endif