Clearing out old Rails session records from a MySQL database

To delete sessions based on a hard coded cut-off date:

DELETE FROM sessions WHERE updated_at < STR_TO_DATE('23.05.2013',GET_FORMAT(DATE,'EUR'));

Replacing cut-off date with period of inactivity

DELETE FROM sessions WHERE updated_at < DATE_SUB(CURDATE(), INTERVAL 30 DAY);

You can as well create a rake task and set up a cron job for automatic clearing

SomeModel.connection.execute 'DELETE FROM sessions WHERE updated_at < DATE_SUB(NOW(), INTERVAL 24 HOUR)'

sandheepg.wordpress.com

Sandheep

Say thanks

Abstract classes in rails

class AbstractModel < ActiveRecord::Base  
  self.abstract_class = true
end

class Foo < AbstractModel
end

class Bar < AbstractModel
end

Foo and Bar both inherit properties and methods of the Abstract Model while being in separate tables...

difference between attr_accessor and initialize

attr_accessor is used to create setter and getter methods for instance variables so that they can be accessed outside the class. initialize is the special method in ruby that gets called when an object is instantiated.

class Birthday
 attr_ac...

Adobe flash player installation in ubuntu chromium browser

For Chromium browser versions greater than 34, to use flash one must install Pepper flash.

For Ubuntu 14.04 or newer, run

sudo apt-get install pepperflashplugin-nonfree
sudo update-pepperflashplugin-nonfree --status 
# to see what version of...

Prepend filters in rails

prepend_before_filter and append_before_filter are almost the same.

They differ only in precedence. Prepend filters have higher precedence over append filters.

before_filter is an alias to append_before_filter

class MyController < ActionCon...

Fixing "uninitialized constant ActiveSupport::Dependencies::Mutex (NameError)"

If you have to work with older versions of Rails, there might be discrepancy between the versions of Rails and Rubygems. Theats when you likely see the below message when you try to boot your rails app.

/home/lt-pc-528/.rvm/gems/ruby-1.8.7-p...

listing methods of class and object (instance)

class Myclass
  def one
    puts "one is called"
  end
end    

ss = Myclass.new

puts Myclass.methods 
# returns array of methods for the class. Includes both class and instance methods and methods inherited from parents.
puts Myclass.instanc...

Posted by Sandheep to Sandheep's deck (2013-05-10 18:03)

Clearing out old Rails session records from a MySQL database

Related cards: