uc_card

2012-02-10 · 🪦 retired

A Ruby library that fetches your unpaid credit card transaction history (usage statements) from the UC Card (www.uccard.co.jp) member site. It logs in to the member site with Mechanize, opens the statement page, parses the HTML with Nokogiri, and returns the results as Ruby objects.

Published as a gem, with a command-line tool of the same name bundled in.

gem install uc_card
uc_card   # 未払いの取引を一覧表示(オプションは一切ない)

Sample output from the README (merchant names are masked).

2012/01/28: ****** 500 １回払い 1回
2012/01/26: ****** 5940 １回払い 1回
2012/01/22: ****** 3357 １回払い 1回
Total: 11722

Used as a library, it looks like this. Instead of hard-coding the ID and password, it reads them from pit, a credential-management library.

require 'uc_card'
UCCard.start_with_pit("uccard.co.jp") do |card|
  puts card
end

Internals

UCCard.start takes care of the whole lifecycle from login through statement retrieval to logout, and the block receives a fully parsed instance.

Sequence diagram of the uc_card processing flow

UCCard.start — proceeds as login → go_recent (statement retrieval) → block execution, and always calls logout in an ensure — even if an exception is raised along the way, the logout still runs
UCCard.start_with_pit — a shortcut that fetches credentials from pit and passes them to start. The bundled bin/uc_card command is just 5 lines that call this and puts card
login — opens the login page with Mechanize (whose User-Agent claims to be “Windows IE 7”), fills in the ID and password form fields, and submits
go_recent — fetches the “recent usage statement” page and uses Nokogiri to parse the rows of the statement table into an array of ShoppingData (8 fields: date, klass, name, value, usecase, times, note, payment). In the README’s sample output, “１回払い” is usecase and “1回” is times
ShoppingData#money — strips non-digits from the amount string and converts it to an integer. reserved_payment is the sum of these, which becomes the Total: line (there is also a reserved_payment_this_month method, but it was left as an empty implementation)
The gem dependencies are three: mechanize, nokogiri, and pit

The README includes a note that if you get SSL certificate errors, you should locate the certificate path with ruby -ropenssl -e "p OpenSSL::X509::DEFAULT_CERT_FILE" and install an appropriate certificate.

github.com/kimoto/uc_card