waterlow

バッチ改善案

モチベーション

• SendGridのように、既存の仕組みを使いながら問題点を改善していきたい

どうするか

• configでどのバッチを動かすかを管理する
• configはデプロイ時に配布する。
• configはサーバによって異なる。
• どのサーバにどのconfigを置くかはipアドレスから引く（AMIから起動するようになるかもしれない。その場合は環境変数？）

waterlow

%ul
  %li
    %span
  %li
    %a

waterlow

SELECT 
    (167000 / AVG(c)) / 3600 AS HOUR
FROM
    (SELECT 
        DATE_FORMAT(sent_at, '%Y/%m/%d %H:%i%s') AS sent,
            COUNT(*) AS c
    FROM
        `mail_magazine_sent_histories`
    WHERE
        mail_magazine_type_id = 66

waterlow

SELECT 
    (167000 / AVG(c)) / 3600 AS HOUR
FROM
    (SELECT 
        DATE_FORMAT(sent_at, '%Y/%m/%d %H:%i%s') AS sent,
            COUNT(*) AS c
    FROM
        `mail_magazine_sent_histories`
    WHERE
        mail_magazine_type_id = 66

waterlow

SET @v = (SELECT id 
	FROM users
	WHERE email LIKE 'ohta%' 
		AND email LIKE '%careerindex.co.jp'
		ORDER BY id DESC LIMIT 1);
		
SELECT @v;
		
DELETE FROM registered_agents WHERE user_id = @v;
DELETE FROM agent_entries WHERE user_id = @v;

waterlow

redis-server &
mysql.server start

waterlow

fsdfasdfasdfasdfs

waterlow

    def select_favorite_job_offers(user_ids)
      Hash[
        ActiveRecord::Base.connection.select_all(
          <<-SQL
            SELECT
              favorites.user_id,
              favorites.job_offer_id
              FROM favorites
                LEFT JOIN job_offer_entries

waterlow

### コメントは簡潔に
# bad
# keyはcategory_type
# valueの1つ目は'score'
# 2つめは'weight'
score_map = {
  math: [90, 1.0],
  eng:  [70, 0.75]
}

waterlow

group:development,:test do
  gem "rspec-rails", "~> 3.1.0"
  gem "factory_girl_rails", "~> 4.4.1"
end

group:test do
  gem "faker", "~> 1.4.3"
  gem "capybara", "~> 2.4.3"
  gem "database_cleaner", "~> 1.3.0"
  gem "launchy", "~> 2.4.2"