Module: SCAnalytics

Included in:
Connections::Credentials
Defined in:
lib/sc_analytics.rb,
lib/sc_analytics/query.rb,
lib/sc_analytics/version.rb,
lib/sc_analytics/exceptions.rb,
lib/sc_analytics/connections.rb,
lib/sc_analytics/connections/oracle.rb,
lib/sc_analytics/connections/connection.rb,
lib/sc_analytics/connections/credentials.rb,
lib/sc_analytics/connections/connection_pool.rb

Defined Under Namespace

Modules: Connections Classes: Query, QueryError

Constant Summary collapse

VERSION = 
"0.3.0"

Instance Method Summary collapse

Instance Method Details

#alert(status) ⇒ Object 



39
40
41
42
43
44
 
# File 'lib/sc_analytics.rb', line 39

def alert(status)
	curr_time = Time.now
  puts "#{curr_time.strftime("%m/%d/%Y %H:%M:%S")} #{status}"
  puts
  return curr_time
end

#open_excel_file(file_name) ⇒ Object 



46
47
48
49
 
# File 'lib/sc_analytics.rb', line 46

def open_excel_file(file_name)
  excel_instance.Workbooks.open("#{Dir.pwd}/#{file_name}")
  nil
end

#quit_excel ⇒ Object 



61
62
63
64
 
# File 'lib/sc_analytics.rb', line 61

def quit_excel
  excel_instance.quit
  nil
end

#run_excel_macro(macro_name, arg = nil) ⇒ Object 



51
52
53
54
55
56
57
58
59
 
# File 'lib/sc_analytics.rb', line 51

def run_excel_macro(macro_name, arg = nil)
  if arg
    excel_instance.run(macro_name, arg)
  else
    excel_instance.run(macro_name)
  end

  nil
end

#run_in_parallel(*queries) ⇒ Object 



26
27
28
29
30
31
32
33
34
35
36
37
 
# File 'lib/sc_analytics.rb', line 26

def run_in_parallel(*queries)
  queries.each { |query| raise "cannot run forked query #{qry.name} in parallel with other queries" if query.forked? && queries.length > 1 }

  threads = []
  queries.each do |query|
    threads << Thread.new(query) do |qry|
      qry.run
    end
  end

  threads.each{|thread| thread.join }
end

#run_query(*queries) ⇒ Object Also known as: run_queries, run_in_sequence 



20
21
22
 
# File 'lib/sc_analytics.rb', line 20

def run_query(*queries)
queries.each{|qry| qry.run }
end