Sequel and macruby
Hi, in my first experience with sequel, i installer sqlite3 and sequel gems without problem, then i tried to run the simple example in readme.doc of sequel 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)}" without any error the output is: Item count: 0 The average price is: someone has info to get it work. Thanks
Greetings, You can check out an old thread on this subject: http://lists.macosforge.org/pipermail/macruby-devel/2011-April/007547.html I lost the plot somewhere in there, and never got back to it. :( -- Morgan On Wed, Sep 7, 2011 at 9:15 AM, Wladjmir Godioz <wladjmir@gmail.com> wrote:
Hi,
in my first experience with sequel, i installer sqlite3 and sequel gems without problem, then i tried to run the simple example in readme.doc of sequel
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)}"
without any error the output is:
Item count: 0 The average price is:
someone has info to get it work. Thanks
_______________________________________________ MacRuby-devel mailing list MacRuby-devel@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macruby-devel
participants (2)
-
Morgan Schweers
-
Wladjmir Godioz