Using Insert statement in active record?

ruby-talk
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

···

--
Posted via http://www.ruby-forum.com/.

2

Anukul Singhal 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?

Thanks,
Anukul

Maybe post to the rails group?
=R

···

--
Posted via http://www.ruby-forum.com/\.

3

Try:

class TestTable < ActiveRecord::Base
set_table_name 'testTable'
end

TestTable.new(:name=>'stuff').save

···

On Saturday 19 July 2008 21:55:53 Anukul Singhal wrote:

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