操作Yaml文件

#yaml文件：
test_obj:  
     host: 192.168.5.93
     port: 1521
     user: test3
     password: srttest3
     server: SERVICE_NAME=mcrm
     
     
test_obj1:  
     host: 192.168.5.93
     port: 1521
     user: test3
     password: srttest3
     server: SERVICE_NAME=mcrm

#操作函数：

require "yaml"
require 'pathname'
require 'DatebaseOs'

#yaml.yml文件的地址
file_path=File.join(Pathname.new(File.dirname(__FILE__)).realpath,'yaml.yml')

open_file =File.open(file_path)                 
ruby_obj = YAML::load(open_file)

host = ruby_obj['test_obj']['host']
port = ruby_obj['test_obj']['port']
user = ruby_obj['test_obj']['user']
password  = ruby_obj['test_obj']['password']
server = ruby_obj['test_obj']['server']

@query = "select right_id from tab_xn_adminright t where t.admin_id=613"
@tablename="tab_xn_adminright"
puts query_db_single(host,port,user,password,server)