class Guff::RoleModel < Guff::Model
  SQL = TemplateCache.new({
    get_roles: "
      SELECT role_id,
             role_name,
             role_desc

        FROM roles

       -- FIXME
       ORDER BY role_id
    ",
  })

  def initialize(models : Models)
    super(models, SQL)
  end

  def get_roles
    r = [] of Hash(String, SQLite3::Value)

    all(:get_roles, nil, nil) do |row|
      r << row
    end

    r
  end
end