employees_repo_with_db

employees_repository.rb

require "sqlite3"
require_relative "../models/employee"

class EmployeesRepository
  def initialize
    @db = SQLite3::Database.new('food_delivery.db')
    @db.results_as_hash = true
    @employees = []
    load_from_db
  end

  def all
    @employees
  end

  def find(employee_id)
    @employees.find { |employee| employee.id == employee_id }
  end

  private

  def load_from_db
    results = @db.execute('SELECT * FROM employees')
    results.each do |row|
      # {"id"=>1, "username"=>"john", "password"=>"1234", "manager"=>"true", 0=>1, 1=>"john", 2=>"1234", 3=>"true"}
      symbolized_hash = {}
      row.each do |key, value|
        symbolized_hash[key.to_sym] = value if key.is_a?(String)
      end
      @employees << Employee.new(symbolized_hash)
    end
  end
end