<?php

  class sml_data_sources_cache_db extends mw_data{

    public function source_cache_db(){
      $sgbd = $this->sgbd();
      $source_cache = array();
      if($rst = $sgbd->open_data("sml_source_cache")){
        while($v_rst = $sgbd->fetch_data($rst)){
          if(isset($v_rst)){
            if(isset($v_rst["id"])) $source_cache[$v_rst["id"]] = $v_rst;
          }
          else{
            $source_cache = false;
            $break;
          }
        }
        $sgbd->close_data($rst);
      }
      else $source_cache = false;
      return $source_cache;
    }

    public function source_cache_infos_db($url){
      $sgbd = $this->sgbd();
      $cache_infos = array();
      if($rst = $sgbd->open_data("sml_source_cache")){
        while($v_rst = $sgbd->fetch_data($rst)){
          if(isset($v_rst)){
            if(isset($v_rst["id"]) && isset($v_rst["url"])){
              if($v_rst["url"] == $url){
                $cache_infos = $v_rst;
                $break;
              }
            }
          }
          else{
            $cache_infos = false;
            $break;
          }
        }
        $sgbd->close_data($rst);
      }
      else $cache_infos = false;
      return $cache_infos;
    }

    public function add_source_cache_db($url, $cache_index){
      $sgbd = $this->sgbd();
      return $sgbd->add_data(
        "sml_source_cache",
        array(
          "url" => $url,
          "id_source" => $cache_index,
          "last_update" => date("Y-m-d H:i:s")
        )
      ) ? true : false;
    }

    public function del_source_cache_db($id_cache_data){
      $sgbd = $this->sgbd();
      return $sgbd->del_data("sml_source_cache", $id_cache_data) ? true : false;
    }

  }