employees_repository.rb

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

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

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

  def find_by_username(username)
    @employees.find {|employee| employee.login == username}
  end

  private

  def load_employees_from_db
    results = @db.execute "SELECT * FROM employees"
    results.each do |row|
      other_row = {}
      row.each do |key, value|
        other_row[key.to_sym] = value if key.is_a?(String)
      end
      @employees << Employee.new(other_row)
    end
  end
end