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
|
@refinerycms_blog_tables = [{
:table_name => 'blog_posts',
:attributes => [
Rails::Generators::GeneratedAttribute.new('title', 'string'),
Rails::Generators::GeneratedAttribute.new('body', 'text'),
Rails::Generators::GeneratedAttribute.new('draft', 'boolean'),
Rails::Generators::GeneratedAttribute.new('published_at', 'datetime')
], :id => true
},{
:table_name => 'blog_comments',
:attributes => [
Rails::Generators::GeneratedAttribute.new('blog_post_id', 'integer'),
Rails::Generators::GeneratedAttribute.new('spam', 'boolean'),
Rails::Generators::GeneratedAttribute.new('name', 'string'),
Rails::Generators::GeneratedAttribute.new('email', 'string'),
Rails::Generators::GeneratedAttribute.new('body', 'text'),
Rails::Generators::GeneratedAttribute.new('state', 'string')
], :id => true
},{
:table_name => 'blog_categories',
:attributes => [
Rails::Generators::GeneratedAttribute.new('title', 'string')
], :id => true
},{
:table_name => 'blog_categories_blog_posts',
:attributes => [
Rails::Generators::GeneratedAttribute.new('blog_category_id', 'integer'),
Rails::Generators::GeneratedAttribute.new('blog_post_id', 'integer')
], :id => false
}]
class Create<%= singular_name.camelize %> < ActiveRecord::Migration
def self.up<% @refinerycms_blog_tables.each do |table| %>
create_table :<%= table[:table_name] %>, :id => <%= table[:id].to_s %> do |t|
<% table[:attributes].each do |attribute| -%>
t.<%= attribute.type %> :<%= attribute.name %>
<% end -%>
<%= 't.timestamps' if table[:id] %>
end
<%= "add_index :#{table[:table_name]}, :id" if table[:id] %>
<% end -%>
load(Rails.root.join('db', 'seeds', 'refinerycms_blog.rb').to_s)
end
def self.down
UserPlugin.destroy_all({:name => "refinerycms_blog"})
Page.delete_all({:link_url => "/blog"})
<% @refinerycms_blog_tables.each do |table| -%>
drop_table :<%= table[:table_name] %>
<% end -%>
end
end
|