gistfile1.txt

require 'net/http'
require 'uri'
require 'cgi'
require "mysql"


db = Mysql.real_connect("<MYSQL SERVER>", "<MYSQL USER>", "<MYSQL PASSWORD>", "<MYSQL TABLE>")

rows = db.query("SELECT * FROM posts")
while (row = rows.fetch_row)
  title = row[4]
  body = row[6]
  date = row[2]
  
  url = URI.parse('http://posterous.com/api/newpost')
  req = Net::HTTP::Post.new(url.path)
  req.basic_auth '<POSTEROUSEMAIL>', '<POSTEROUSPASSWORD>'
  req.set_form_data({'site_id'=>'<POSTEROUS SITE_ID>', 'title'=>title, 'body'=>body, 'date'=>date})
  res = Net::HTTP.new(url.host, url.port).start {|http| http.request(req) }
  case res
  when Net::HTTPSuccess, Net::HTTPRedirection
    puts res.body
    puts '-----------------------------------------------------------------------'
  else
    res.error!
  end
end