Skip to content

Instantly share code, notes, and snippets.

#!/usr/local/bin/ruby19
class Team
attr_reader :name
attr_accessor :points, :noGames
def initialize(name)
@name = name
@points = 0.to_f
@total = 0.to_f
/usr/local/lib/ruby/gems/1.9/gems/sqlite3-1.3.6/lib/sqlite3/statement.rb:41:in `bind_param': can't prepare Nokogiri::XML::Element (RuntimeError)
from /usr/local/lib/ruby/gems/1.9/gems/sqlite3-1.3.6/lib/sqlite3/statement.rb:41:in `block in bind_params'
from /usr/local/lib/ruby/gems/1.9/gems/sqlite3-1.3.6/lib/sqlite3/statement.rb:37:in `each'
from /usr/local/lib/ruby/gems/1.9/gems/sqlite3-1.3.6/lib/sqlite3/statement.rb:37:in `bind_params'
from /usr/local/lib/ruby/gems/1.9/gems/sqlite3-1.3.6/lib/sqlite3/database.rb:135:in `block in execute'
from /usr/local/lib/ruby/gems/1.9/gems/sqlite3-1.3.6/lib/sqlite3/database.rb:95:in `prepare'
from /usr/local/lib/ruby/gems/1.9/gems/sqlite3-1.3.6/lib/sqlite3/database.rb:134:in `execute'
from ./trawl1.rb:59:in `block in <main>'
from ./trawl1.rb:20:in `each'
from ./trawl1.rb:20:in `<main>'
#!/usr/local/bin/ruby19 -w
require 'sqlite3'
require 'nokogiri'
# create a database
db = SQLite3::Database.new "raw_article.db"
rows = db.execute <<-SQL
CREATE TABLE raw_articles (
filename VARCHAR(256),
heading TEXT,