Ruby (without rails) using activerecord, insert into does not work

Question

I need to insert a new record into an existing table in a databse. I tried both approaches below:

  class UserDetail < ActiveRecord::Base

 def self.add_new_user
   new_user = UserDetail.new
   new_user.first_name = 'Joe'
   new_user.last_name = 'Smith'
   new_user.user_id = 'TEST'
   new_user.save
 end

 def self.add_new_user_2

UserDetail.create(user_id: 'TEST', first_name: 'Joe', 
                  last_name: 'Smith')
 end

However, both approaches give me the error below:

    ActiveRecord::StatementInvalid: OCIError: ORA-00926: 
    missing VALUES keyword: INSERT INTO "USER_DETAIL" DEFAULT VALUES

What am I missing? Please share your solutions.

(Using Ruby 1.9.3, ActiveRecord 4.2.4)

I am using: gem 'activerecord-oracle_enhanced-adapter', '1.6.7' — fongfong
– fongfong, Commented Nov 11, 2016 at 18:21

dsn raghavendra rao · Accepted Answer · 2016-11-11 18:07:24Z

2

ActiveRecord makes assumptions about primary keys. It is expecting to find a primary key on your UserDetail table called "ID". Should look something like.

class UserDetail < ActiveRecord::Base
    self.table_name = :user_detail
    self.primary_key = :user_id

    def self.add_new_user
       new_user = UserDetail.new
       new_user.first_name = 'Joe'
       new_user.last_name = 'Smith'
       new_user.user_id = 1
       new_user.save
    end
end

answered Nov 11, 2016 at 18:07

dsn raghavendra rao

1961 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

fongfong Over a year ago

Thanks for your reply! However, the USER_DETAIL table does not have a primary key, what it has is a constraint called **USER_EXPIRE_DT_UK **(USER_ID and EXPIRE_DT two columns in the USER_DETAIL table). How do I define this in ActiveRecord model class?

Dave Newton Over a year ago

@user3314970 Changing the ID column is detailed in the AR docs: guides.rubyonrails.org/…

Collectives™ on Stack Overflow

Ruby (without rails) using activerecord, insert into does not work

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related