[Ruby] Sequel example won't run

Question

Hi, I've just installed "sequel" gem for Ruby. I wanted to try example from Sequel website and it won't work :( test.rb:

require 'rubygems'
require 'sequel'

DB = Sequel.sqlite # memory database

DB.create_table :items do
    primary_key :id
    String :name
    Float :price
end

items = DB[:items] # Create a dataset

# Populate the table
items.insert(:name => 'abc', :price => rand * 100)
items.insert(:name => 'def', :price => rand * 100)
items.insert(:name => 'ghi', :price => rand * 100)

# Print out the number of records
puts "Item count: #{items.count}"

# Print out the average price
puts "The average price is: #{items.avg(:price)}"

Console:

$ sequel test.rb
Error: ArgumentError: syntax error on line 11, col 37: `i'/usr/lib/ruby/1.8/yaml.rb:133:in `load'

Answer 1

You need to run this with ruby not sequel

$ ruby test.rb