Sending Emails from CSV/TSV Formatted Data through Gmail SMTP by Ruby

A Japanese version of this document is in TechRacho. I want to send e-mails to my students from my Excel-formatted list. I don't have any SMTP servers so that I use Gmail SMTP. The advantage of this program is:

• Email from your tabular data (Excel, CSV, TSV, etc.)
• Using Gmail SMTP (you don't worry whether your server is in spam blacklists)
• Customizable mail template, no Ads

This program is verified on Ruby 1.8.7 + ActionMailer 3.0.3 + fastercsv 1.5.4 + tlsmail 0.0.1.

[Rails]: Generate Complex OR Query on Rails 3 with Arel

On the Rails 3, ActiveRecord generate QSL through DSL "Arel". There are many simple query sample codes are available, but complex one is a little. This post shows how to generate complex "OR" query.

[Rails]: Generate Ajax remote link for Rails 3 + will_paginate 3.0.pre2

The will_paginate 3.0.pre2 Gem does not support remote tag (like :remote => true).
You need to create custom renderer but currently available posts do not work well.

• Rails3 and will_paginate, Doing easy remote links – Rails3 Tricks #02
• Roll your own pagination links with will_paginate

I have solved this problem.

[Rails]: Rails3のActiveRecordで複雑なOR文生成

Rails 3のActiveRecordはArelというDSLを使ってクエリを生成するのだが，単純なクエリであればともかく，複雑なクエリを実行しようと思うと色々と四苦八苦しないといけなくなる．
# この辺はどのORMでも同じだけど 今回，複雑なSQL文を作る必要が出たのでその方法をまとめておく．

[Rails]: Deviseで二段階パスワード認証

RailsのDeviseはメールアドレス認証などの便利機能が付いていて非常に便利なのだが，オールインワン過ぎてちょっと挙動を弄ろうとするとどこから手をつけていいのか分からなくなる．
例えば，Amazonなんかでやられているような二段階のパスワード認証をやろうとしたのだが，イマイチ事例が見つからなかったので色々とやってみた．