Class: TeradataExtractor::Query

Inherits:
Object
  • Object
show all
Defined in:
lib/teradata-extractor/query.rb

Instance Method Summary collapse

Constructor Details

#initialize(server_name, username, password) ⇒ Query

Returns a new instance of Query.

Parameters:

  • Teradata (com.teradata.jdbc.jdk6.JDK6_SQL_Connection) —

    connection

  • sql (#to_s) —

    Sql query to execute



8
9
10
11
12
 
# File 'lib/teradata-extractor/query.rb', line 8

def initialize(server_name, username, password)

  @connection = TeradataExtractor::Connection.instance.connection(server_name, username, password)
  @statement ||= @connection.create_statement
end

Instance Method Details

#to_csv(sql) ⇒ Object 



30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
 
# File 'lib/teradata-extractor/query.rb', line 30

def to_csv(sql)
  results = @statement.execute_query(sql)
  #results = conn.execute_query("select TOP 10 country_id, sf_account_id, country_name from emea_analytics.eu_deal_flat")
  CSV.generate do |csv|
    column_count = results.getMetaData.getColumnCount;
    csv << 1.upto(column_count).map{|i| results.getMetaData.getColumnName(i)}

    while(results.next) do
      row = []
      1.upto(column_count) do |i|
        row << to_ruby_type(results.getObject(i))
      end
      csv << row
    end
  end
end

#to_enumerable(sql) ⇒ Object 



14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
# File 'lib/teradata-extractor/query.rb', line 14

def to_enumerable(sql) 
  results = @statement.execute_query(sql)
  #results = conn.execute_query("select TOP 10 country_id, sf_account_id, country_name from emea_analytics.eu_deal_flat")
  e = Enumerator.new do |y|
    column_count = results.getMetaData.getColumnCount;
    while(results.next) do
      row = {}
      1.upto(column_count) do |i|
        column_name = results.getMetaData.getColumnName(i).to_sym
        row[column_name] = to_ruby_type(results.getObject(i))
      end
      y << row
    end
  end
end