require 'resolv'
require 'rubygems'
require 'sequel'
def validate_email_domain(email)
  domain = email.match(/\@(.+)/)[1]
  Resolv::DNS.open do |dns|
    @mx = dns.getresources(domain, Resolv::DNS::Resource::IN::MX)
  end
  @mx.size > 0 ? true : false
end

DB = Sequel.mysql(:host => 'localhost', :user => 'user', :password => 'password', :database => 'database')
subscribers = DB[:previous_email_list_table]
validated = DB[:validated]

subscribers.each do |sub|
  puts "Validating email number #{sub[:id]}"
  validator = validate_email_domain(sub[:email])
  if validator == true
    validated.insert(:id => nil, :email => sub[:email], :firstname => sub[:first_name], :lastname => sub[:last_name])
  end
end