#user_emails = LER_DO_CSV
# ex:
user_emails = [" milene.sempre@hotmail.com"," mileniumsp@yahoo.com.br"]
user_emails.each do |user_email|

  correct_user_email = user_email.lstrip

  # busca o usuario
  correct_user = SellerAggregator::Evmain::UsuarioRecord.find_by_email(correct_user_email)

  conn = SellerAggregator::Evmain::UsuarioRecord.connection

  if correct_user
    puts "usuario encontrado"

    wrong_user = SellerAggregator::Evmain::UsuarioRecord.find_by_email(user_email)

    if wrong_user
      #move todos os pedidos de user_email pra ca.
      conn.execute("update vendas set comprador=#{correct_user.user_id} where comprador=#{wrong_user.user_id}")

      # apaga user_email
      conn.execute("delete from usuarios where user_id = #{wrong_user.user_id}")
    end

  else
    puts "usuario nao encontrado"

    #atualiza o email de user_email para correct_user_email
    conn.execute("update usuarios set email='#{correct_user_email}' where email='#{user_email}'")
  end

end