forked from norman/friendly_id
-
Notifications
You must be signed in to change notification settings - Fork 1
/
schema.rb
81 lines (64 loc) · 2.14 KB
/
schema.rb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
require "friendly_id/migration"
module FriendlyId
module Test
class Schema < ActiveRecord::Migration
class << self
def down
CreateFriendlyIdSlugs.down
tables.each do |name|
drop_table name
end
end
def up
# TODO: use schema version to avoid ugly hacks like this
return if @done
CreateFriendlyIdSlugs.up
tables.each do |table_name|
create_table table_name do |t|
t.string :name
t.boolean :active
end
end
slugged_tables.each do |table_name|
add_column table_name, :slug, :string
add_index table_name, :slug, :unique => true
end
scoped_tables.each do |table_name|
add_column table_name, :slug, :string
end
# This will be used to test scopes
add_column :novels, :novelist_id, :integer
add_column :novels, :publisher_id, :integer
remove_index :novels, :slug
add_index :novels, [:slug, :publisher_id, :novelist_id], :unique => true
# This will be used to test column name quoting
add_column :journalists, "strange name", :string
# This will be used to test STI
add_column :journalists, "type", :string
# These will be used to test i18n
add_column :journalists, "slug_en", :string
add_column :journalists, "slug_es", :string
add_column :journalists, "slug_de", :string
# This will be used to test relationships
add_column :books, :author_id, :integer
# Used to test :scoped and :history together
add_column :restaurants, :city_id, :integer
@done = true
end
private
def slugged_tables
%w[journalists articles novelists novels manuals]
end
def scoped_tables
["restaurants"]
end
def simple_tables
%w[authors books publishers cities]
end
def tables
simple_tables + slugged_tables + scoped_tables
end
end
end
end
end