#!/usr/bin/env ruby

require 'rubygems'

require 'rss/1.0'
require 'rss/2.0'
require 'open-uri'

require 'twitter'

require 'sqlite3'

db = SQLite3::Database.new( "favorites.db" )

source = "http://twitter.com/favorites/FAVUSER.rss"
content = ""
open(source) { |s| content = s.read }
rss = RSS::Parser.parse(content, false)

twitter = Twitter::Base.new('POSTUSER', 'PASS')

count = 1

rss.items.reverse.each do |i|
  unless db.get_first_row("select * from favorites where guid = '#{i.guid.content}'")
    db.execute "insert into favorites values ('#{i.guid.content}')"
    twitter.update("RT @" + i.title)
    count += 1
    sleep 1
  end
  exit if count > 5
end