Search code examples
sqlruby-on-railsrecord

Ruby on rails get last record from result set


@connection = ActiveRecord::Base.establish_connection(
            :adapter => "mysql2",
            :host => "localhost",
            :database => "siteconfig_development",
            :username => "root",
            :password => "root123"
)

sql = 'SELECT * from users'

@success_data = @connection.connection.execute(sql);

How to get last record from @success_data without iterating it?


Solution

  • Update

      @success_data = @connection.connection.select_all(sql);
      @success_data.class  
      => Array
    

    you could use any array method on @success_data

      @success_data.last  # will return the last element   
    

    or

      @success_data[-1]   # will return the last element