module NSSQL
NSSQL
module.
Constants
- VERSION
Public Class Methods
configure()
click to toggle source
# File lib/nssql.rb, line 31 def configure NSSQL::Settings.configure end
select_array(query)
click to toggle source
# File lib/nssql.rb, line 16 def select_array(query) execute(query, &:fetch_all) end
select_to_file(query)
click to toggle source
# File lib/nssql.rb, line 20 def select_to_file(query) query = one_line_query(query) isql_command = "isql -v Netsuite #{NSSQL::Settings.user} '#{NSSQL::Settings.password}' -b -q -d," iconv_command = 'iconv -f iso-8859-1 -t utf-8' Tempfile.new.tap do |file| system_call("echo \"#{query}\" | #{isql_command} | #{iconv_command} > #{file.path}") end end
Private Class Methods
execute(query) { |statement| ... }
click to toggle source
# File lib/nssql.rb, line 37 def execute(query) statement = netsuite_connection.prepare(query).execute result = yield statement statement.drop result end
netsuite_connection()
click to toggle source
# File lib/nssql.rb, line 54 def netsuite_connection ODBC.connect('NetSuite', NSSQL::Settings.user, NSSQL::Settings.password) end
one_line_query(query)
click to toggle source
# File lib/nssql.rb, line 50 def one_line_query(query) query.tr("\n", ' ').gsub(/\s+/, ' ').strip end
system_call(command)
click to toggle source
# File lib/nssql.rb, line 46 def system_call(command) `#{command}` end