src/SQLDriver.h

Go to the documentation of this file.

/*
 *   MetriVis - Metrics Visualization Application
 *
 *
 *   License notice:
 *
 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU General Public License for more details.
 *
 *   You should have received a copy of the GNU General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 */


#ifndef _SQLDRIVER_H
#define _SQLDRIVER_H

#include <boost/thread/mutex.hpp>
#include "lib/lru_cache/lru_cache.h"
#include "container/MultiType.h"
#include "pattern/Singleton.h"
#include "BaseClass.h"

#define METRIVIS_DEFAULT_CACHE_SIZE 1<<29

namespace metrivis {

class SQLDriver : public BaseClass {

public:


  SQLDriver(unsigned int max_cache_size = METRIVIS_DEFAULT_CACHE_SIZE);


  ~SQLDriver();

  MultiTypePtr Insert(std::string table_name, std::string values);


  MultiTypePtr Insert(std::string table_name, std::string columns,
                      std::string values);


  MultiTypePtr Delete(std::string table_name, std::string where);


  MultiTypePtr Select(std::vector<std::string> columns, std::string table_name);


  MultiTypePtr SelectString(std::vector<std::string> columns,
                            std::string table_name);

  MultiTypePtr SelectString(std::vector<std::string> columns,
                            std::string table_name, std::string where);

  MultiTypePtr Select(std::vector<std::string> columns, std::string table_name,
                      std::string where);


  MultiTypePtr SelectCached(std::vector<std::string> columns,
                            std::string table_name);


  MultiTypePtr SelectStringCached(std::vector<std::string> columns,
                                  std::string table_name);


  void PreCacheSelectString(std::vector<std::string> columns,
                            std::string table_name);



  void PreCacheSelect(std::vector<std::string> columns, std::string table_name);


  inline void set_max_cache_size(long max_cache_size) {
    max_cache_size_ = max_cache_size;
    cache_.clear();
    cache_.set_max_size(max_cache_size);
  }


  inline long max_cache_size() const {
    return max_cache_size_;
  }

  inline long cache_size() const {
    return cache_size_;
  }

  inline void set_db_file_name(const std::string& db_file_name) {
    db_file_name_ = db_file_name;
  }


private:

  SQLDriver(const SQLDriver& sql_driver);


private:

  LRUCache<std::string, MultiTypePtr> cache_; 
  boost::mutex cache_mutex_;  

  long cache_size_;           
  long max_cache_size_;       

  std::string db_file_name_;  
};


typedef Singleton<SQLDriver> SQL;

} // namespace metrivis
#endif

---