This post originated from an RSS feed registered with Ruby Buzz by Jay Fields. Original Post: Rails: Generating an Oracle DDL without Oracle installed Feed Title: Jay Fields Thoughts Feed URL: http://feeds.feedburner.com/jayfields/mjKQ Feed Description: Blog about Ruby, Agile, Testing and other topics related to software development. Latest Ruby Buzz Posts Latest Ruby Buzz Posts by Jay Fields Latest Posts From Jay Fields Thoughts

ActiveRecord::Schema.define(:version => 1) do

  create_table :accounts, :force => true do |t|
    t.column :first_name, :string
    t.column :last_name, :string
    t.column :username, :string
    t.column :password, :string
    t.column :email, :string
    t.column :company, :string
  end

  ...
end

task :migrate => :environment do
  ActiveRecord::Base.establish_connection(environment)
  require File.dirname(__FILE__) + '/../../db/schema/release_1.rb'
end

namespace :db do
  namespace :generate do
    namespace :oracle do
      desc "generate sql ddl"
      task :ddl do
      $:.unshift File.dirname(__FILE__) + "../../../tools/fake_oci8"
      Rake::Task[:environment].execute
      file = File.open(RAILS_ROOT + "/db/oracle_shinobi_ddl.sql", 'w')

      ActiveRecord::Base.instance_eval do
        def connection 
          ActiveRecord::ConnectionAdapters::OracleAdapter.new nil
        end
      end

      class ActiveRecord::Schema < ActiveRecord::Migration
        def self.define (info={}, &block)
          instance_eval(&block)
        end
      end

      ActiveRecord::Base.connection.class.class_eval do
        define_method :execute do |*args| 
          file << "#{args.first};\n"
        end
      end

      Rake::Task[:"db:migrate"].execute
      file.close
    end
  end
end