class OracleSqlParser::Util::ParameternizedQuery

Attributes

ast[R]
params[R]

Public Class Methods

new(original) click to toggle source
# File lib/oracle-sql-parser/util/parameterized_query.rb, line 4
def initialize(original)
  @index = 0
  @params = {}
  @ast = original.map_ast do |v|
    case v
    when OracleSqlParser::Ast::NumberLiteral, OracleSqlParser::Ast::TextLiteral
      assign_parameter(v)
    else 
      v
    end
  end
end

Public Instance Methods

assign_parameter(value) click to toggle source
# File lib/oracle-sql-parser/util/parameterized_query.rb, line 21
def assign_parameter(value)
  name = "a#{@index}"
  @index += 1
  @params[name] = value
  OracleSqlParser::Ast::Variable[:name =>name] 
end
to_sql() click to toggle source
# File lib/oracle-sql-parser/util/parameterized_query.rb, line 17
def to_sql
  ast.to_sql
end