ActiveRecord and sequences, a bit of a twist

Howdy,

I’m very new with Ruby and ActiveRecord.

I’ve got a table in postgres that looks something like

create table test
test_id not null default nextval(‘test_id_seq’)
test_parent int not null
test_name varchar(20) not null

For the parent record: test_parent = test_id.

What’s the best way to handle that situation in ActiveRecord?

It seems like i should do something like:
SEQ = <code to select nextval(‘test_id_seq’)>
Test.new(:test_id => SEQ, :test_parent => SEQ, :test_name => ‘woohoo’ );

I’m not sure how to active the <code to select nextval()> portion with
ActiveRecord.

I tried:
seq =
ActiveRecord::Base.connection.execute(“SELECTnextval(‘test_id_seq’)”)

And that seems to be doable, but the PG:Result class is a little weird,
so
I was hoping there was a better way.

Thanks.

Dave

bump. Just want to validate that going this route is the right way to
go.

Thanks

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs