require 'rubygems'
require 'active_record'
require 'rss/1.0'
require 'rss/2.0'
require 'open-uri'
require 'pp'

class Item < ActiveRecord::Base
end

puts "Connecting to database..."
ActiveRecord::Base.establish_connection(
  :adapter  => 'mysql',
  :host     => "server",
  :database => "database",
  :username => "root",
  :password => "pass",
  :reconnect => true)

RSS_FEED_URI = ""

def check_rss_feed
  puts "Checking RSS feed..."
  content = ""
  begin
    open(RSS_FEED_URI) { |s| content = s.read }
  rescue
    puts "Error fetching RSS feed data. bailing...".red
    return
  end

  puts "Bytes read from RSS feed: #{content.length}".green

  rss = RSS::Parser.parse(content, false)

  rss.items.each do |item|
    Item.create :title => item.title, :text => item.text
  end
end