require 'tiny_tds'
def client
client = TinyTds::Client.new username: 'user', password: 'pass', host: '192.168.4.4'
client.execute('use database').do
client
end
def services(id)
out = []
client.execute('exec GetServiceByServiceGroup @ServiceGroup = %s' % id).each(:symbolize_keys => true) do |s|
out << {:value => s[:ServiceName] + ' <i>(' + s[:ServiceID].to_s + ')</i>',
:child => operational_services(s[:ServiceID])}
end
out
end
def operational_services(id)
out = []
client.execute('exec GetOperationalServiceByService @Service = %s' % id).each(:symbolize_keys => true) do |os|
out << {:value => os[:OperationalServiceName] + ' <i>(' + os[:OperationalServiceID].to_s + ')<i>'}
end
out
end
out = []
client.execute('exec GetServiceGroupByDirection @Direction = 50').each(:symbolize_keys => true) do |service_group|
out << {:value => service_group[:ServiceGroupName] + ' <i>(' + service_group[:ServiceGroupID].to_s + ')</i>',
:child => services(service_group[:ServiceGroupID])}
end
out
我认为错误:
test.irb:28: [BUG] Segmentation fault at 0x0000000000000e
ruby 2.1.5p273 (2014-11-13 revision 48405) [x86_64-linux]
我想从数据库中用树级别构建树,但是tiny_tds向我返回sg =(为什么?我编写函数“ client”以在当前返回值时建立其他连接。其他tiny_tds说'试图启动新的Adaptive Server操作,并等待结果(TinyTds :: Error)'
我哪里错了?
我不知道为什么,但是这些工作
def client
if @client.nil?
@client = TinyTds::Client.new username: 'user', password: 'pass', host: '192.168.4.4'
@client.execute('use database').do
def @client.execute(sql)
puts sql
super(sql).each(:symbolize_keys => true)
end
end
@client
end
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句