aboutsummaryrefslogtreecommitdiffstats
path: root/db/migrate/20110803223522_create_blog_structure.rb
diff options
context:
space:
mode:
authorJamie Winsor <jamie@enmasse.com>2011-08-01 11:27:28 -0700
committerJamie Winsor <jamie@enmasse.com>2011-08-03 18:01:32 -0700
commit21b19db5a30fcb6db83f4ac9302cc94c6320a0db (patch)
tree62a3b89d0f4c9b239bfd76ec77cfc3269ac041ef /db/migrate/20110803223522_create_blog_structure.rb
parent3454a9c3007a4bfd10ccd0ff39dc594ebb2a0184 (diff)
downloadrefinerycms-blog-21b19db5a30fcb6db83f4ac9302cc94c6320a0db.tar.gz
refinerycms-blog-21b19db5a30fcb6db83f4ac9302cc94c6320a0db.tar.bz2
refinerycms-blog-21b19db5a30fcb6db83f4ac9302cc94c6320a0db.zip
refactor engine testing scenario
Engine is now tested standalone by leveraging a dummy rails app Enable Guard for speedy testing Move factories to the more standard location `spec/factories/*` Update README with a Testing section Rename migrations to contain datetimestamps for their version to fix migration order issues when migrating the dummy application
Diffstat (limited to 'db/migrate/20110803223522_create_blog_structure.rb')
-rw-r--r--db/migrate/20110803223522_create_blog_structure.rb54
1 files changed, 54 insertions, 0 deletions
diff --git a/db/migrate/20110803223522_create_blog_structure.rb b/db/migrate/20110803223522_create_blog_structure.rb
new file mode 100644
index 0000000..f6f5b2d
--- /dev/null
+++ b/db/migrate/20110803223522_create_blog_structure.rb
@@ -0,0 +1,54 @@
+class CreateBlogStructure < ActiveRecord::Migration
+
+ def up
+ create_table Refinery::BlogPost.table_name, :id => true do |t|
+ t.string :title
+ t.text :body
+ t.boolean :draft
+ t.datetime :published_at
+ t.timestamps
+ end
+
+ add_index Refinery::BlogPost.table_name, :id
+
+ create_table Refinery::BlogComment.table_name, :id => true do |t|
+ t.integer :blog_post_id
+ t.boolean :spam
+ t.string :name
+ t.string :email
+ t.text :body
+ t.string :state
+ t.timestamps
+ end
+
+ add_index Refinery::BlogComment.table_name, :id
+
+ create_table Refinery::BlogCategory.table_name, :id => true do |t|
+ t.string :title
+ t.timestamps
+ end
+
+ add_index Refinery::BlogCategory.table_name, :id
+
+ create_table Refinery::Categorization.table_name, :id => true do |t|
+ t.integer :blog_category_id
+ t.integer :blog_post_id
+ end
+
+ add_index Refinery::Categorization.table_name, [:blog_category_id, :blog_post_id], :name => 'index_blog_categories_blog_posts_on_bc_and_bp'
+
+ load(File.expand_path('../../seeds/refinerycms_blog.rb', __FILE__))
+ end
+
+ def down
+ Refinery::UserPlugin.destroy_all({:name => "refinerycms_blog"})
+
+ Refinery::Page.delete_all({:link_url => "/blog"})
+
+ drop_table Refinery::BlogPost.table_name
+ drop_table Refinery::BlogComment.table_name
+ drop_table Refinery::Category.table_name
+ drop_table Refinery::Categorization.table_name
+ end
+
+end