ATND Search API

gistfile1.rb

require 'pp'
require 'net/http'
require 'json'
require 'sqlite3'

db = SQLite3::Database.new("data.db")

url = {
  :scheme => 'http',
  :server => 'api.atnd.org',
  :port => '80',
  :path => '/events',
  :query => 'keyword=Heroku&format=json'
}

Net::HTTP.start(url[:server],url[:port]) do |http|
  response = http.get(url[:path] + '?' + url[:query]);
  json = JSON.parse(response.body)
  json["events"].each do |event|
    title = event["title"]
    event_url = event["event_url"]
    puts title
    puts event_url
    db.execute("select count(*) from event where url = ?", event_url) do |row|
      if row[0].to_i < 1
        db.execute("insert into event values(?,?)", title, event_url)
      end
    end
  end
end