amberframework/amber

class Configuration < Granite::Base
  extend ModelProfile
  connection sqlite
  table configurations

  column id : Int64, primary: true
  column profile : String
  column path : String
  column value : String
  column ftype : String
  column unit : String
  column options : String

  def self.enabled(path : String)
    rec = for_path(path)
    rec && (rec.value == "Yes" || rec.value == "yes")
  end
end

module ModelProfile
  def for_profile(profile : String, query ="", params = [] of DB::Any)
    if /where/i =~ query
      query = query.gsub(/where/i, " where profile = ? and ")
      res = self.all(query, [profile] + params)
    else
      res = self.all("where profile = ? "+query, [profile] )
    end
    res
  end

  def current(clause = "", params = [] of DB::Any)
    profile = SmartBox::Lib::Configuration.current_profile
    for_profile(profile, clause, params)
  end

  def for_path(path : String)
    profile = SmartBox::Lib::Configuration.current_profile
    self.first("where profile = ? and path = ?",[profile, path])  # this line here is where the exception is raised
  end

  def is_enabled?(path : String)
    rec = for_path(path)
    rec && rec.enabled
  end

  def where(clause = "", params = [] of DB::Any)
    current(clause, params)
  end
end