Sparkwire

pge.rb

require 'mechanize'
require 'logger'
require 'uri'

agent = Mechanize.new
agent.follow_meta_refresh = :always
agent.log = Logger.new 'mech.log'
agent.user_agent_alias = 'Mac FireFox'

puts 'Initialize the session by loading the login form'
agent.get 'https://www.pge.com/myenergyweb/appmanager/pge/customer'

puts 'Log in to PG&E'
page = agent.post 'https://www.pge.com/eum/login', 'USER' => 'foo', 'PASSWORD' => 'bar'

puts 'Click the link to Opower'
page = page.link_with(:text => 'My Usage').click

puts 'Continue the PG&E-side SSO process'
page = agent.submit page.forms.first, page.forms.first.buttons.first

puts 'Continue the Opower-side SSO process'
page = agent.submit page.forms.first, page.forms.first.buttons.first

puts 'Downloading all data'
page = page.link_with(:href => %r{export-dialog}).click

form = page.forms.first

form.radiobuttons_with(:name => 'exportFormat').last.check
form.from = '04/11/2012'
form.to = '05/11/2012'
agent.submit(form, form.buttons.first).save 'powa.zip'