Class Sequel::Oracle::Dataset
In: lib/sequel/adapters/oracle.rb
Parent: Sequel::Dataset

Methods

call   fetch_rows   prepare   requires_placeholder_type_specifiers?  

Included Modules

DatasetMethods

Classes and Modules

Module Sequel::Oracle::Dataset::ArgumentMapper
Module Sequel::Oracle::Dataset::BindArgumentMethods
Module Sequel::Oracle::Dataset::PreparedStatementMethods

Constants

DatasetClass = self
PREPARED_ARG_PLACEHOLDER = ':'.freeze

Public Instance methods

call(type, bind_vars={}, *values, &block)

Execute the given type of statement with the hash of values.

[Source]

     # File lib/sequel/adapters/oracle.rb, line 400
400:       def call(type, bind_vars={}, *values, &block)
401:         ps = to_prepared_statement(type, values)
402:         ps.extend(BindArgumentMethods)
403:         ps.call(bind_vars, &block)
404:       end
fetch_rows(sql) {|row| ...}

[Source]

     # File lib/sequel/adapters/oracle.rb, line 406
406:       def fetch_rows(sql)
407:         execute(sql) do |cursor|
408:           cps = db.conversion_procs
409:           cols = columns = cursor.get_col_names.map{|c| output_identifier(c)}
410:           metadata = cursor.column_metadata
411:           cm = cols.zip(metadata).map{|c, m| [c, cps[m.data_type]]}
412:           @columns = columns
413:           while r = cursor.fetch
414:             row = {}
415:             r.zip(cm).each{|v, (c, cp)| row[c] = ((v && cp) ? cp.call(v) : v)}
416:             yield row
417:           end
418:         end
419:         self
420:       end
prepare(type, name=nil, *values)

Prepare the given type of query with the given name and store it in the database. Note that a new native prepared statement is created on each call to this prepared statement.

[Source]

     # File lib/sequel/adapters/oracle.rb, line 425
425:       def prepare(type, name=nil, *values)
426:         ps = to_prepared_statement(type, values)
427:         ps.extend(PreparedStatementMethods)
428:         if name
429:           ps.prepared_statement_name = name
430:           db.set_prepared_statement(name, ps)
431:         end
432:         ps
433:       end
requires_placeholder_type_specifiers?()

Oracle requires type specifiers for placeholders, at least if you ever want to use a nil/NULL value as the value for the placeholder.

[Source]

     # File lib/sequel/adapters/oracle.rb, line 438
438:       def requires_placeholder_type_specifiers?
439:         true
440:       end

[Validate]