Module: ActiveRecord::ConnectionAdapters::Materialize::DatabaseStatements

Included in:
ActiveRecord::ConnectionAdapters::MaterializeAdapter
Defined in:
lib/active_record/connection_adapters/materialize/database_statements.rb

Constant Summary collapse

MONEY_COLUMN_TYPE_OID =

The internal PostgreSQL identifier of the money data type.

790
BYTEA_COLUMN_TYPE_OID =

The internal PostgreSQL identifier of the BYTEA data type.

17

Instance Method Summary collapse

Instance Method Details

#begin_db_transaction ⇒ Object

Begins a transaction.



134
135
136
 
# File 'lib/active_record/connection_adapters/materialize/database_statements.rb', line 134

def begin_db_transaction
  execute "BEGIN"
end

#begin_isolated_db_transaction(isolation) ⇒ Object 



138
139
140
141
 
# File 'lib/active_record/connection_adapters/materialize/database_statements.rb', line 138

def begin_isolated_db_transaction(isolation)
  begin_db_transaction
  execute "SET TRANSACTION ISOLATION LEVEL #{transaction_isolation_levels.fetch(isolation)}"
end

#commit_db_transaction ⇒ Object

Commits a transaction.



144
145
146
 
# File 'lib/active_record/connection_adapters/materialize/database_statements.rb', line 144

def commit_db_transaction
  execute "COMMIT"
end

#exec_delete(sql, name = nil, binds = []) ⇒ Object Also known as: exec_update 



117
118
119
 
# File 'lib/active_record/connection_adapters/materialize/database_statements.rb', line 117

def exec_delete(sql, name = nil, binds = [])
  execute_and_clear(sql, name, binds) { |result| result.cmd_tuples }
end

#exec_query(sql, name = "SQL", binds = [], prepare: false) ⇒ Object 



103
104
105
106
107
108
109
110
111
112
113
114
115
 
# File 'lib/active_record/connection_adapters/materialize/database_statements.rb', line 103

def exec_query(sql, name = "SQL", binds = [], prepare: false)
  execute_and_clear(sql, name, binds, prepare: prepare) do |result|
    types = {}
    fields = result.fields
    fields.each_with_index do |fname, i|
      ftype = result.ftype i
      fmod  = result.fmod i

      types[fname] = get_oid_type(ftype, fmod, fname)
    end
    ActiveRecord::Result.new(fields, result.values, types)
  end
end

#exec_rollback_db_transaction ⇒ Object

Aborts a transaction.



149
150
151
 
# File 'lib/active_record/connection_adapters/materialize/database_statements.rb', line 149

def exec_rollback_db_transaction
  execute "ROLLBACK"
end

#execute(sql, name = nil) ⇒ Object

Executes an SQL statement, returning a PG::Result object on success or raising a PG::Error exception otherwise. Note: the PG::Result object is manually memory managed; if you don’t need it specifically, you may want consider the exec_query wrapper.



87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
 
# File 'lib/active_record/connection_adapters/materialize/database_statements.rb', line 87

def execute(sql, name = nil)
  if preventing_writes? && write_query?(sql)
    raise ActiveRecord::ReadOnlyError, "Write query attempted while in readonly mode: #{sql}"
  end

  materialize_transactions

  result = nil
  log(sql, name) do
    ActiveSupport::Dependencies.interlock.permit_concurrent_loads do
      result = execute_async_and_raise(sql)
    end
  end
  result
end

#explain(arel, binds = []) ⇒ Object 



9
10
11
12
 
# File 'lib/active_record/connection_adapters/materialize/database_statements.rb', line 9

def explain(arel, binds = [])
  sql = "EXPLAIN #{to_sql(arel, binds)}"
  Materialize::ExplainPrettyPrinter.new.pp(exec_query(sql, "EXPLAIN", binds))
end

#query(sql, name = nil) ⇒ Object

Queries the database and returns the results in an Array-like object



62
63
64
65
66
67
68
69
70
71
72
 
# File 'lib/active_record/connection_adapters/materialize/database_statements.rb', line 62

def query(sql, name = nil) #:nodoc:
  materialize_transactions

  result = nil
  log(sql, name) do
    ActiveSupport::Dependencies.interlock.permit_concurrent_loads do
      result = execute_async_and_raise(sql)
    end
  end
  result_as_array result
end

#result_as_array(res) ⇒ Object

create a 2D array representing the result set



20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
 
# File 'lib/active_record/connection_adapters/materialize/database_statements.rb', line 20

def result_as_array(res) #:nodoc:
  # check if we have any binary column and if they need escaping
  ftypes = Array.new(res.nfields) do |i|
    [i, res.ftype(i)]
  end

  rows = res.values
  return rows unless ftypes.any? { |_, x|
    x == BYTEA_COLUMN_TYPE_OID || x == MONEY_COLUMN_TYPE_OID
  }

  typehash = ftypes.group_by { |_, type| type }
  binaries = typehash[BYTEA_COLUMN_TYPE_OID] || []
  monies   = typehash[MONEY_COLUMN_TYPE_OID] || []

  rows.each do |row|
    # unescape string passed BYTEA field (OID == 17)
    binaries.each do |index, _|
      row[index] = unescape_bytea(row[index])
    end

    # If this is a money type column and there are any currency symbols,
    # then strip them off. Indeed it would be prettier to do this in
    # MaterializeColumn.string_to_decimal but would break form input
    # fields that call value_before_type_cast.
    monies.each do |index, _|
      data = row[index]
      # Because money output is formatted according to the locale, there are two
      # cases to consider (note the decimal separators):
      #  (1) $12,345,678.12
      #  (2) $12.345.678,12
      case data
      when /^-?\D+[\d,]+\.\d{2}$/  # (1)
        data.gsub!(/[^-\d.]/, "")
      when /^-?\D+[\d.]+,\d{2}$/  # (2)
        data.gsub!(/[^-\d,]/, "").sub!(/,/, ".")
      end
    end
  end
end

#write_query?(sql) ⇒ Boolean

:nodoc:

Returns:

  • (Boolean) 


79
80
81
 
# File 'lib/active_record/connection_adapters/materialize/database_statements.rb', line 79

def write_query?(sql) # :nodoc:
  !READ_QUERY.match?(sql)
end