maker_repository.rb

require_relative 'maker'
require 'bcrypt'

class MakerRepository
  
  def all
    result = DatabaseConnection.exec_params('SELECT * FROM makers;', [])
    makers = []
    result.each do |row|
      maker = Maker.new
      maker.id = row['id'].to_i
      maker.name = row['name']
      maker.username = row['username']
      maker.email_address = row['email_address']
      maker.password = row['password']
      makers << maker
    end
    makers
  end

  def find_by_username(username)
    sql = 'SELECT * FROM makers WHERE username = $1;'
    result = DatabaseConnection.exec_params(sql, [username])
    maker = Maker.new
    maker.id = result[0]['id'].to_i
    maker.name = result[0]['name']
    maker.username = result[0]['username']
    maker.email_address = result[0]['email_address']
    maker.password = result[0]['password']
    return maker
  end

  def find(id)
    sql = 'SELECT * FROM makers WHERE id = $1;'
    result = DatabaseConnection.exec_params(sql, [id])
    maker = Maker.new 
    maker.id = result[0]['id'].to_i
    maker.name = result[0]['name']
    maker.username = result[0]['username']
    maker.email_address = result[0]['email_address']
    maker.password = result[0]['password']
    return maker
  end

  def create(maker_obj)
    encrypted_password = BCrypt::Password.create(maker_obj.password)
    sql = 'INSERT INTO makers(name, username, email_address, password) VALUES($1, $2, $3, $4);'
    params = [maker_obj.name, maker_obj.username, maker_obj.email_address, encrypted_password]
    result = DatabaseConnection.exec_params(sql, params)
  end

  def update(maker)
    sql = 'UPDATE makers SET name = $1 WHERE id = $2;'
    params = [maker.name, maker.id]
    update = DatabaseConnection.exec_params(sql, params)
  end
end