ついけし把握

memo.txt

SET these value
  config.consumer_key
  config.consumer_secret
  config.oauth_token
  config.oauth_token_secret

$ gem install tweetstream
$ gem install sqlite3-ruby
$ sqlite3 data.db 'create table  tweets(id int, name text, dt datetime, text text)'
$ sqlite3 data.db 'create table deletes(id int, name text, dt datetime, text text)'

$ ruby TDgrasp.rb > output
$ sqlite3 data.db 'select * from deletes'

TDgrasp.rb

require 'tweetstream'
require 'sqlite3'

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

TweetStream.configure do |config|
  config.consumer_key       = ''
  config.consumer_secret    = ''
  config.oauth_token        = ''
  config.oauth_token_secret = ''
  config.auth_method        = :oauth
end

client = TweetStream::Client.new

sql_ins = "insert into tweets values(?, ?, datetime(?, 'localtime'), ?)"
sql_del = "insert into deletes values(?, ?, datetime(?), ?)"
sql_sel = "select * from tweets where id = ?"

client.on_timeline_status do |status|
  begin
    db.execute(sql_ins, status.id, status.user.screen_name, status.created_at.strftime('%Y-%m-%d %X'), status.text)
  rescue => e
    p e
  end
end

client.on_delete do |status_id, user_id|
  begin
    db.execute(sql_sel, status_id) do |col|
      p col
      db.execute(sql_del, col[0], col[1], col[2], col[3])
    end
  rescue => e
    p e
  end
end

begin
  client.userstream
rescue => e
  p e
end

db.close