find_by_sql : Delete « ActiveRecord « Ruby

Home
Ruby
1.ActiveRecord
2.Array
3.CGI
4.Class
5.Collections
6.Database
7.Date
8.Design Patterns
9.Development
10.File Directory
11.GUI
12.Hash
13.Language Basics
14.Method
15.Network
16.Number
17.Rails
18.Range
19.Reflection
20.Statement
21.String
22.Threads
23.Time
24.Tk
25.Unit Test
26.Windows Platform
27.XML
Ruby » ActiveRecord » Delete 




find_by_sql


=begin

drop database Contact;

create database Contact;

use Contact;

CREATE TABLE Employee (
   id  int unsigned not null auto_increment primary key,
   Name VARCHAR(50),
   Phone VARCHAR(15),
   departmentId int
);


CREATE TABLE Department(
   id    int unsigned not null auto_increment primary key,
   Name VARCHAR(50),
   Phone VARCHAR(15)
   
);



=end

require "rubygems"
require "activerecord"

ActiveRecord::Base.establish_connection(
  :adapter => "mysql",
  :host => "localhost",
  :username => "root",
  :database => "Contact")

class Employee < ActiveRecord::Base
   set_table_name "employee"
   belongs_to :department
end

class Department < ActiveRecord::Base
   set_table_name "department"
   has_many :children, :class_name => "Employee", :foreign_key => :departmentId
end


Employee.find_by_sql("SELECT employee.* FROM employee")

 














Related examples in the same category
1.delete the associated record from the database
2.Delete a record with destroy
3.Account.destroy_all :artist => "Garth Brooks"
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.