id is default for autoincrease : Assumption from ActiveRecord « ActiveRecord « Ruby






id is default for autoincrease


=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"
end

class Department < ActiveRecord::Base
   set_table_name "department"
end

account = Employee.new
account.save

account = Employee.find(1)
puts account.destroy

 








Related examples in the same category

1.ActiveRecord infers database table names based on class names.
2.If you want table names to be singular instead of plural, you can set the configuration parameter pluralize_table_names: