#!/usr/bin/env ruby

require 'rubygems'
require 'active_record'

ActiveRecord::Base.establish_connection(
  :adapter  => 'mysql',
  :database => 'wp_moments',
  :username => 'lograde',
  :password => 'l33t$p34k',
  :host     => 'mysql.lograde.com')

class WpPostmeta < ActiveRecord::Base
  set_table_name "wp_postmeta"
end

#class WpPosts < ActiveRecord::Base
#  set_table_name "wp_posts"
#end

old_local_path = '/home/books/public_html/moments/wp-content/uploads/'
new_local_path = '/home/lograde/momentsbyana.com/wp-content/uploads/'

@search_query = WpPostmeta.find(:all, :conditions => "meta_value LIKE '%#{old_local_path}%'")

@search_query.each do |row|
  old_data = row.meta_value
  puts "#{old_data}\n"

  new_data = old_data.gsub(old_local_path, new_local_path)
  puts "IS CHANGING TO\n"

  row.meta_value = new_data
  puts "#{new_data}\n\n"
end

@search_query.save

puts "Made #{@search_query.size} changes to the database."