2 files changed, 23 insertions, 4 deletions

diff --git a/lib/tasks/development_init.rake b/lib/tasks/development_init.rake
index 2ac9a83..94f323c 100644
--- a/lib/tasks/development_init.rake
+++ b/lib/tasks/development_init.rake
@@ -25,19 +25,19 @@ namespace :cccms do
   
   desc "Import the authors"
   task :import_authors  => :environment do |t|
-    importer = AuthorsImporter.new("#{RAILS_ROOT}/db/authors.csv")
+    importer = AuthorsImporter.new(Rails.root.join('db', 'authors.csv').to_s)
     importer.import_authors
   end  
   
   desc "Update authors on pages"
   task :update_authors_on_pages => :environment do |t|
-    i = ChaosImporter.new("#{RAILS_ROOT}/db/updates")
+    i = ChaosImporter.new(Rails.root.join('db', 'updates').to_s)
     i.update_authors_on_pages
   end
   
   desc "Import the old XML Files"
   task :import_updates  => :environment do |t|
-    i = ChaosImporter.new("#{RAILS_ROOT}/db/updates")
+    i = ChaosImporter.new(Rails.root.join('db', 'updates').to_s)
     i.import_updates
   end
   
@@ -134,4 +134,4 @@ namespace :cccms do
     orphans.each { |page| page.destroy }
   end
   
-end
\ No newline at end of file
+end
diff --git a/lib/tasks/test_db.rake b/lib/tasks/test_db.rake
new file mode 100644
index 0000000..0a7a17d
--- /dev/null
+++ b/lib/tasks/test_db.rake
@@ -0,0 +1,19 @@
+namespace :db do
+  namespace :test do
+    task :load_schema do
+      ActiveRecord::Base.establish_connection(:test)
+      ActiveRecord::Schema.verbose = false
+      load "#{Rails.root}/db/schema.rb"
+    end
+
+    task :prepare => :environment do
+      begin
+        ActiveRecord::Base.establish_connection(:test)
+        ActiveRecord::Base.connection
+      rescue
+        system("psql -U postgres postgres -c \"CREATE DATABASE psql_test OWNER psql ENCODING 'UTF8';\"")
+      end
+      Rake::Task['db:test:load_schema'].invoke
+    end
+  end
+end