1. 链接mysql数据库读数据
- 建个mysql.rb文件,models下也可以,app下新建个文件夹放进去也行
module Mysql
class Rffc < ActiveRecord::Base
self.abstract_class = true
establish_connection :qxj_mysql # ActiveRecord::Base.establish_connection
self.table_name = "sevp_chn_wefc_rffc"
end
end
- 调用
# 项目里要读取sevp_chn_wefc_rffc表的第一个数据
Mysql::Rffc.first
2. 链接Oracle数据库读数据
-
安装oracle client
-
安装gem
# 用来使用ActiveRecord来读取数据库的
gem 'activerecord-oracle_enhanced-adapter', '~> 1.8.0' # 对应rails 5.1版本,不同rails版本不同gem
# 用来链接oracle数据库的
gem 'ruby-oci8'
安装过程中报错
Gem::Ext::BuildError: ERROR: Failed to build gem native extension
Error Message:
Set the environment variable DYLD_LIBRARY_PATH, DYLD_FALLBACK_LIBRARY_PATH or
OCI_DIR to point to the Instant client directory.
If DYLD_LIBRARY_PATH or DYLD_FALLBACK_LIBRARY_PATH is set, the environment
variable must be set at runtime also.
If OCI_DIR is set, dependent shared library paths are checked. If the checking
is passed, ruby-oci8 works without DYLD_LIBRARY_PATH or DYLD_FALLBACK_LIBRARY_PATH
根据提示
# 变量名看提示,不同版本变量名不同
export DYLD_LIBRARY_PATH=/opt