gistfile1.txt

#!/usr/bin/ruby

require 'rubygems'
require 'twitter'
require 'sqlite3'

client = Twitter::Streaming::Client.new do |config|
  config.consumer_key        = "..."
  config.consumer_secret     = "..."
  config.access_token        = "..."
  config.access_token_secret = "..."
end

db = SQLite3::Database.new "republicants.db"
db.execute <<-SQL
create table tweets (
	tweet_id integer primary key,
	username varchar(15),
	display_name varchar(30),
	tweet_text varchar(140),
	posted_date integer
);
SQL


keywords = ['trump', 'debate', '#GOPDebate']
client.filter(track: keywords.join(",")) do |tweet|
  tweet_details = {
    "tweet_id"      => tweet.id,
    "username"      => tweet.user.screen_name,
    "display_name"  => tweet.user.name,
    "posted_date"   => tweet.created_at.to_i
  }
  
  if tweet.is_a?(Twitter::Tweet)
    puts tweet.user.name + ": " + tweet.text 
    db.execute( "INSERT INTO tweets VALUES (?, ?, ?, ?, ?)", tweet_details.values )
  end
  
end