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
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
|
require "friendly_id/migration"
module FriendlyId
module Test
migration_class =
if ActiveRecord::VERSION::MAJOR >= 5
ActiveRecord::Migration[4.2]
else
ActiveRecord::Migration
end
class Schema < migration_class
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.migrate :up
tables.each do |table_name|
create_table table_name do |t|
t.string :name
t.boolean :active
end
end
tables_with_uuid_primary_key.each do |table_name|
create_table table_name, primary_key: :uuid_key, id: false do |t|
t.string :name
t.string :uuid_key, null: false
t.string :slug
end
add_index table_name, :slug, unique: true
end
slugged_tables.each do |table_name|
add_column table_name, :slug, :string
add_index table_name, :slug, unique: true if table_name != "novels"
end
scoped_tables.each do |table_name|
add_column table_name, :slug, :string
end
paranoid_tables.each do |table_name|
add_column table_name, :slug, :string
add_column table_name, :deleted_at, :datetime
add_index table_name, :deleted_at
end
# This will be used to test scopes
add_column :novels, :novelist_id, :integer
add_column :novels, :publisher_id, :integer
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
add_column :journalists, "slug_fr_ca", :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
# Used to test candidates
add_column :cities, :code, :string, limit: 3
# Used as a non-default slug_column
add_column :authors, :subdomain, :string
@done = true
end
private
def slugged_tables
%w[journalists articles novelists novels manuals cities]
end
def paranoid_tables
["paranoid_records"]
end
def tables_with_uuid_primary_key
["menu_items"]
end
def scoped_tables
["restaurants"]
end
def simple_tables
%w[authors books publishers]
end
def tables
simple_tables + slugged_tables + scoped_tables + paranoid_tables
end
end
end
end
end
|
