From: "Stéphane Wirtel" <stephane.wirtel@...>
Date: 2008-02-22T05:14:56+09:00
Subject: Re: beginner's problem with sqlite3

Hi,

Can I give you a piece of advice ?

Check about ActiveRecord without Rails, because if you are novice with SQL, it can help you.

Example:

require "rubygems"
require "active_record"
require "logger"
require "yaml"

ActiveRecord::Base.establish_connection( YAML::load_file( 'database.yml' ) )
ActiveRecord::Base.logger = Logger.new( File.open( 'database.log', 'w' ) )
ActiveRecord::Base.colorize_logging = false

ActiveRecord::Schema.define do
	create_table :tests, :force => true do |t|
		t.column :text, :string, :limit => 32
	end
end

class Test < ActiveRecord::Base
end

newTest = Test.new
newTest.text = "first test :d"
newTest.save!

count = Test.count
if count == 0
	puts "The table 'Test' is empty"
elsif count == 1
	puts "There is one element"
else
	puts "There are #{count} elements"
end


Good luck

Stephane