# Create ActiveRecord schemas on the fly for AR extensions testing\n<\/div>
#\n<\/div>
ActiveRecord::Base.establish_connection(\n<\/div>
:adapter=>\'sqlite3\',\n<\/div>
:dbfile=> File.join(File.dirname(__FILE__),\'..\',\'spec\',\'db\',\'test.db\')\n<\/div>
)\n<\/div>
# define a migration\n<\/div>
class TestSchema < ActiveRecord::Migration\n<\/div>
def self.up\n<\/div>
create_table :items do |t|\n<\/div>
t.string :title\n<\/div>
t.string :slug\n<\/div>
t.string :permalink\n<\/div>
t.boolean :published\n<\/div>
t.integer :category_id\n<\/div>
t.timestamps\n<\/div>
end\n<\/div>
end\n<\/div>
<\/div>
def self.down\n<\/div>
drop_table :items\n<\/div>
end\n<\/div>
end\n<\/div>
<\/div>
<\/div>
namespace :db do\n<\/div>
desc "Create test schema"\n<\/div>
task :create => :destroy do\n<\/div>
# run the migration\n<\/div>
TestSchema.migrate(:up)\n<\/div>
end\n<\/div>
\n<\/div>
desc "Destroy test schema"\n<\/div>
task :destroy do\n<\/div>
TestSchema.migrate(:down)\n<\/div>
end\n<\/div>
end\n<\/div>
<\/div><\/pre><\/div>\n \n <\/div>\n\n