Rails:Using Insert statement in active record?

Rails
#1

Hi,

I know this would be a simple solution to provide for any one of you. I
am new to active record and this is what I have currently done:

require ‘rubygems’
require ‘active_record’

puts “connecting to db…”

ActiveRecord::Base.establish_connection(
:adapter => “mysql”,
:host => “localhost”,

:username => “myuser”,

:password => "schumi58",
:database => "test"

)

puts “connection established”

ActiveRecord::Schema.define do

drop_table(:testTable)

create_table(:testTable) do |t|
t.column :name, :string
end
end

I am also referring to Active Record’s rdoc but am not able to make out
how to use the insert statement in the above code. Can anyone help me in
using INSERT statement in my code above?

Thanks,
Anukul

#2

On 19 Jul 2008, at 22:02, Anukul S. wrote:

I am also referring to Active Record’s rdoc but am not able to make
out
how to use the insert statement in the above code. Can anyone help
me in
using INSERT statement in my code above?

Well if you’ve got activerecord model classes then you’d just create
instances of those.
If not ActiveRecord::Base.connection.insert will execute the chunk of
sql you give it.

Fred