activerecord — codestacker

you are in: codestacker → codes [RSS] → tag: activerecord [RSS]

activerecord without rails

show/hide lines

   1  require 'active_record'
   2  
   3  ActiveRecord::Base.establish_connection(:adapter => 'mysql2', :host => 'localhost', :user => 'root', :password => 'mypass', :database => 'mydatabase')
   4  
   5  class User < ActiveRecord::Base ; end
   6  
   7  puts User.count
   8  #=> 9

require 'active_record'

ActiveRecord::Base.establish_connection(:adapter => 'mysql2', :host => 'localhost', :user => 'root', :password => 'mypass', :database => 'mydatabase')

class User < ActiveRecord::Base ; end

puts User.count
#=> 9

created by leozera — 11 February 2011 — get a short url — tags: activerecord rails — embed

finding duplicates entries

having example in rails. from: http://blog.grayproductions.net/articles/five_activerecord_tips

show/hide lines

   1  duplicates = User.find( :all,
   2    :select     => "email, COUNT(email) AS duplicate_count",
   3    :conditions => "email IS NOT NULL AND email != ''",
   4    :group      => "email HAVING duplicate_count > 1"
   5  )

duplicates = User.find( :all,
  :select     => "email, COUNT(email) AS duplicate_count",
  :conditions => "email IS NOT NULL AND email != ''",
  :group      => "email HAVING duplicate_count > 1"
)

created by leozera — 18 July 2009 — get a short url — tags: activerecord rails sql — embed