8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
# File 'lib/vertica_history.rb', line 8
def self.make_query(query)
connection_configurations = {
host: Rails.configuration.vertica_host,
user: Rails.configuration.vertica_user,
password: Rails.configuration.vertica_password,
ssl: Rails.configuration.vertica_ssl || true,
port: Rails.configuration.vertica_port || 5433,
database: Rails.configuration.vertica_database,
role: Rails.configuration.vertica_role,
search_path: Rails.configuration.vertica_search_path || nil,
row_style: Rails.configuration.vertica_row_style || :hash
}
connection = Vertica.connect(connection_configurations)
result = connection.query("#{query}")
@q = query
@columns = result.columns.map { |x| x.name }
@rows = result.rows
connection.close
{columns: @columns, rows: @rows}
rescue => e
Rails.logger.info("Unable to submit query to Vertica: #{e}")
raise Vertica::Error
end
|