Class Sequel::TinyTDS::Dataset
In: lib/sequel/adapters/tinytds.rb
Parent: Sequel::Dataset

Methods

Included Modules

Sequel::MSSQL::DatasetMethods

Classes and Modules

Module Sequel::TinyTDS::Dataset::ArgumentMapper
Module Sequel::TinyTDS::Dataset::PreparedStatementMethods

Constants

DatasetClass = self

Public Instance methods

Yield hashes with symbol keys, attempting to optimize for various cases.

[Source]

     # File lib/sequel/adapters/tinytds.rb, line 204
204:       def fetch_rows(sql)
205:         execute(sql) do |result|
206:           each_opts = {:cache_rows=>false}
207:           each_opts[:timezone] = :utc if db.timezone == :utc
208:           rn = row_number_column if offset = @opts[:offset]
209:           columns = cols = result.fields.map{|c| output_identifier(c)}
210:           if offset
211:             rn = row_number_column
212:             columns = columns.dup
213:             columns.delete(rn)
214:           end
215:           @columns = columns
216:           #if identifier_output_method
217:             each_opts[:as] = :array
218:             result.each(each_opts) do |r|
219:               h = {}
220:               cols.zip(r).each{|k, v| h[k] = v}
221:               h.delete(rn) if rn
222:               yield h
223:             end
224: ??
225:         end
226:         self
227:       end

Create a named prepared statement that is stored in the database (and connection) for reuse.

[Source]

     # File lib/sequel/adapters/tinytds.rb, line 246
246:       def prepare(type, name=nil, *values)
247:         ps = to_prepared_statement(type, values)
248:         ps.extend(PreparedStatementMethods)
249:         if name
250:           ps.prepared_statement_name = name
251:           db.set_prepared_statement(name, ps)
252:         end
253:         ps
254:       end

[Validate]