require 'rubygems'
require_gem 'activerecord'
require '/var/www/hoosier/app/models/payment_method'

#Connect to the database
ActiveRecord::Base.establish_connection(
    :adapter  => "postgresql",
    :host     => "localhost",
    :username => "****",
    :password => "****",
    :database => "****"
)

#turn on AR logging
ActiveRecord::Base.logger = Logger.new('/var/www/hoosier/log/payment_method_clean_up.log')

last_week = Date.today - 8
PaymentMethod.update_all("card_number = ''", ["updated_at < ?", last_week] )