ModelFromTable

Rails generator for generating model from exsistent tables

• Automatically generate model files from existent tables
• Set table_name and primary_key if not following Rails conventions
• Set belongs_to :foo if table has foo_id column

Usage

gem 'model_from_table'

$ bundle

$ rails generate model_from_table

Example

if your existent tables is below

CREATE TABLE "users" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  "name" varchar(255)
);

CREATE TABLE "company" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  "name" varchar(255)
);

CREATE TABLE "legacy_table" (
  "code" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  "name" varchar(255)
);

CREATE TABLE "song" (
  "song_code" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  "user_id" integer
);

run command

$ rails generate model_from_table

then, these model files will be generated

# app/models/user.rb
class User < ActiveRecord::Base
end

# app/models/company.rb
class Company < ActiveRecord::Base
  self.table_name = "company"
end

# app/models/legacy_table.rb
class LegacyTable < ActiveRecord::Base
  self.table_name = "legacy_table"
  self.primary_key = "code"
end

# app/models/song.rb
class Song < ActiveRecord::Base
  self.table_name = "song"
  self.primary_key = "song_code"
  belongs_to :user
end

Options

specify parent class

$ rails generate model_from_table --parent MyClass::Base

# app/models/user.rb
class User < MyClass::Base 
end