is there an option on Ruby like mysql_insert_id() for PHP??

Question

Hi Guys!!

I would like to know if can be an option on Ruby like mysql_insert_id() for PHP.

Thanks a lot

Answer 1

you can always use SELECT last_insert_id() query instead.

Answer 2

Why would you need that? Chances are that you're not using ActiveRecord to its full power. However, you can access the id of a created record by just accessing @record.id.

I would recommend to not use plain SQL syntax in Rails...

Update: Sorry, just realized you may in fact NOT be using ActiveRecord. Of course it's feasible to use the suggested SELECT syntax then (and it's the right way to obtain this value). Personally, I'd still prefer to use ActiveRecord.

Answer 3

It's pretty much the same in ruby, except that the mysql connection is wrapped by an object and that the library is available trough rubygems ( gem install mysql )

require 'mysql'
db = Mysql.connect(hostname, username, password, databasename)
db.execute("INSERT INTO mytable VALUES 1,2,3");
db.insert_id
# => last inserted id

see http://www.tmtm.org/en/mysql/ruby/

Usually you don't do that and rely on a sql abstraction library like ActieRecord, DataMapper, Sequel, DBI, ... all of them have this method available but under different modules.