OCI8 Auto binder
This library changes the query to parameterized query automatically.
Installation
Add this line to your application's Gemfile:
gem 'oci8-auto-binder'And then execute:
$ bundle
Or install it yourself as:
$ gem install oci8-auto-binder
Usage
OCI8AutoBinder.replace_original_class!
conn = OCI8.new(username, password, ident)
conn.exec("select * from table1 where column1 = 1") do |r|
# change to prarameterized query automatically in exec method
# query = "select * from table1 where column1 = :a0", params = {:a0 => 1}
puts r.join(',')
end
conn.logofflogging parameterized query and parameters
OCI8AutoBinder.replace_original_class!
OCI8AutoBinder.logger = Logger.new(log_file_name)
OCI8AutoBinder.logger.level = Logger::INFO # save all log(FOUND_BINDVARS, PARSE_ERROR, NO_PARAMS, PARSE_SUCCESS)
OCI8AutoBinder.logger.level = Logger::ERROR # save parse error log(PARSE_ERROR)
OCI8AutoBinder.logger = nil # do not save loggingContributing
Bug reports and pull requests and PARSE_ERROR query are welcome on GitHub at https://github.com/jksy/oci8-auto-binder.