Guest User

Untitled

a guest
Mar 9th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. ## MySQL
  2. # require AR
  3. require 'rubygems'
  4. require 'active_record'
  5.  
  6. # connect to the database
  7. ActiveRecord::Base.establish_connection(
  8. :adapter => "mysql",
  9. :host => "localhost",
  10. :database => "echi_records",
  11. :username => "root",
  12. :password => "",
  13. :port => 3306
  14. )
  15.  
  16. # define a simple model
  17. class EchiRecord < ActiveRecord::Base
  18. #set_table_name "PCO_ECHIRECORD" #COMMENT ME OUT TO TEST WITH ORACLE/PRESENCE
  19. end
  20.  
  21. record = EchiRecord.find(:first)
  22. puts record.inspect
  23.  
  24. ## Oracle
  25. # require AR
  26. require 'rubygems'
  27. require 'active_record'
  28.  
  29. # connect to the database
  30. ActiveRecord::Base.establish_connection(
  31. :adapter => "oci",
  32. :host => "localhost",
  33. #:database => "echi_records",
  34. :username => "root",
  35. :password => "",
  36. #:port => 3306
  37. )
  38.  
  39. # define a simple model
  40. class EchiRecord < ActiveRecord::Base
  41. set_table_name "PCO_ECHIRECORD" #COMMENT ME OUT TO TEST WITH ORACLE/PRESENCE
  42. end
  43.  
  44. record = EchiRecord.find(:first)
  45. puts record.inspect
Add Comment
Please, Sign In to add comment