Test Oracle Database Views with Rails

Testing Rails with a legacy oracle schema as a backend is always a challenge (fun?). Rails relies no schema.rb to create its test database. The problem is that using the latest activerecord-oracle_enhanced-adapter (1.4.0), the application is unaware of the database views. So, I’ve decided to create those DB views (development) as DB tables (test).

#names of views I'd like created
views = %W(VIEW1 VIEW2 VIEW2)
dev_schema = Rails.configuration.database_configuration["development"]["username"].upcase
test_schema = Rails.configuration.database_configuration["test"]["username"].upcase
views.each do |view|
  #for each of the views I need created
  # establish a connection first to development database
  ActiveRecord::Base.establish_connection(:development)
  # grant select on the view to the test user
  ActiveRecord::Base.connection.execute  "GRANT SELECT ON #{dev_schema}.#{view} TO #{test_schema}"
  # establish a connection to the test database
  ActiveRecord::Base.establish_connection(:test)
  # create the view as a table in the test database - 'where 1=0' discards importing data
  ActiveRecord::Base.connection.execute "CREATE TABLE #{test_schema}.#{view} AS SELECT * FROM #{dev_schema}.#{view} where 1=0"
end

#names of views I'd like created

views = %W(VIEW1 VIEW2 VIEW2)

dev_schema = Rails.configuration.database_configuration["development"]["username"].upcase

test_schema = Rails.configuration.database_configuration["test"]["username"].upcase

views.each do |view|

#for each of the views I need created

# establish a connection first to development database

ActiveRecord::Base.establish_connection(:development)

# grant select on the view to the test user

ActiveRecord::Base.connection.execute "GRANT SELECT ON #{dev_schema}.#{view} TO #{test_schema}"

# establish a connection to the test database

ActiveRecord::Base.establish_connection(:test)

# create the view as a table in the test database - 'where 1=0' discards importing data

ActiveRecord::Base.connection.execute "CREATE TABLE #{test_schema}.#{view} AS SELECT * FROM #{dev_schema}.#{view} where 1=0"

end

The script can run as a db:test:prepare rake task or as being explicitly required somewhere at the beginning of the test_helper. And of course, this is just the initial working concept – it can be greatly improved. JRuby 1.6.3 Rails 3.1 activerecord-oracle_enhanced-adapter 1.4.0

Posted in Ruby.

By Tamer

October 17, 2011

No comments

Twitter: tamersalama

RT @supersillyness: sad to hear another killing where man believes it holy. no where in Bible or Quran is it justified #Woolwich #endreligi… about 6 hours ago

RT @con_agius: #Woolwich attack: "Ingrid Loyau-Kennett spoke to the two men who have since been arrested over the attack" http://t.co/DD6AZ… about 6 hours ago

Driving across the Canadian Rockies is such a humbling experience. It's God's wonderful creations combined with man's marvelous achievements about 17 hours ago

RT @ChicGeekYYC: Looking for WordPress geeks to mentor at our June 1st workshop! http://t.co/Ie5BgMA8G1 #ladieslearningcode #yyc

RT @ChicGeekYYC: Interested in WordPress? Be sure to check out @WordCampYYC! May 25 & 26 http://t.co/bhpfKU2Mi7

Spending a full day struggling w Spring/Hibernate/Oracle project AND STILL being able to be friendly, is a modern-day miracle. Hallelujah

RT @EricaGlasier: True story—just placed an order on Amazon for a $6 book. It'll be here in 42 days for $75 shipping. SOMEONE PLS FIX ECOMM…

@bigthingist check out Adnan Ibrahim. You might find him a bit intriguing. in reply to bigthingist

@EvanRasputin @Douuu المغرب 10:00PM - الفجر 4:00AM Anyone can beat that? :) in reply to EvanRasputin

“@astrogeo: @CalgaryRASC @Cmdr_Hadfield [Cmdr Hadfield] is the parade Marshall for the stampede parade in downtown Calgary.” #yyc

Test Oracle Database Views with Rails

0 Responses

About The Learning Journey

The Past

Twitter: tamersalama

Test Oracle Database Views with Rails

0 Responses

Subscribe

About The Learning Journey

The Past

Twitter: tamersalama