mechanize example with login and saved cookie

gistfile1.txt

require 'rubygems'
require 'mechanize'

require 'mysql'


    
  agent = Mechanize.new { |agent|
    agent.user_agent_alias = 'Mac Safari'
  }
  
  cookie = agent.cookie_jar.load('cookies.yml') rescue false

  unless cookie
    page = agent.get('http://www.facebook.com')

    form = page.forms.first
    form.email = 'xxxxx'
    form.pass = 'xxxxxxx'

    page = agent.submit(form)

    agent.cookie_jar.save_as('cookies.yml')
  end

  page = agent.get('http://www.facebook.com/event.php?eid=199027383467114')

  count =  page.parser.xpath("//h4[@class='uiHeaderTitle']").first.content.match(/\d+/)[0]



  con = Mysql.new('xxxxx', 'xxxx', 'xxxx', 'xxxxx')
  rs = con.query("update text_content_translations set content = '#{count}' where id=928")
  con.close
  
  puts "updated with #{count} at: #{Time.now}"