#!/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